1
Install & Configure jDiction / Re: Loaging translations
« on: July 29, 2014, 10:51:07 am »
I noticed... Awesome, Thank you very much! Can you tell me what was the problem please?
jDiction 2.2.0 released. http://jdiction.org/downloads
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3 SQL=SELECT * FROM alvajoom_jd_store WHERE idLang='1' AND referenceTable='#__content' AND idReference in ()
##
# @package Joomla
# @copyright Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.
# @license GNU General Public License version 2 or later; see LICENSE.txt
##
##
# READ THIS COMPLETELY IF YOU CHOOSE TO USE THIS FILE!
#
# The line just below this section: 'Options +FollowSymLinks' may cause problems
# with some server configurations. It is required for use of mod_rewrite, but may already
# be set by your server administrator in a way that dissallows changing it in
# your .htaccess file. If using it causes your server to error out, comment it out (add # to
# beginning of line), reload your site in your browser and test your sef url's. If they work,
# it has been set by your server administrator and you do not need it set here.
##
## Can be commented out if causes errors, see notes above.
Options +FollowSymLinks
## Mod_rewrite in use.
RewriteEngine On
## Begin - Rewrite rules to block out some common exploits.
# If you experience problems on your site block out the operations listed below
# This attempts to block the most common type of exploit `attempts` to Joomla!
#
# Block out any script trying to base64_encode data within the URL.
RewriteCond %{QUERY_STRING} base64_encode[^(]*\([^)]*\) [OR]
# Block out any script that includes a <script> tag in URL.
RewriteCond %{QUERY_STRING} (<|%3C)([^s]*s)+cript.*(>|%3E) [NC,OR]
# Block out any script trying to set a PHP GLOBALS variable via URL.
RewriteCond %{QUERY_STRING} GLOBALS(=|\[|\%[0-9A-Z]{0,2}) [OR]
# Block out any script trying to modify a _REQUEST variable via URL.
RewriteCond %{QUERY_STRING} _REQUEST(=|\[|\%[0-9A-Z]{0,2})
# Return 403 Forbidden header and show the content of the root homepage
RewriteRule .* index.php [F]
#
## End - Rewrite rules to block out some common exploits.
## Begin - Custom redirects
#
# If you need to redirect some pages, or set a canonical non-www to
# www redirect (or vice versa), place that code here. Ensure those
# redirects use the correct RewriteRule syntax and the [R=301,L] flags.
#
## End - Custom redirects
##
# Uncomment following line if your webserver's URL
# is not directly related to physical file paths.
# Update Your Joomla! Directory (just / for root).
##
# RewriteBase /
## Begin - Joomla! core SEF Section.
#
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
#
# If the requested path and file is not /index.php and the request
# has not already been internally rewritten to the index.php script
RewriteCond %{REQUEST_URI} !^/index\.php
# and the requested path and file doesn't directly match a physical file
RewriteCond %{REQUEST_FILENAME} !-f
# and the requested path and file doesn't directly match a physical folder
RewriteCond %{REQUEST_FILENAME} !-d
# internally rewrite the request to the index.php script
RewriteRule .* index.php [L]
#
## End - Joomla! core SEF Section.
Test Result
Version
Library Version: 1.2.9.2
Joomla Version 3.3.1 is untested.
Plugin
JDiction Plugin is enabled
JDiction Plugin is loaded at position 0 should be 1
Languagefilter is enabled
Multiple Plugins have the same loading position (0)
Database
jDiction Database Driver is selected
Language
Seam to be good
Module
Module is enabled
Common mistakes
At least one menu item has the language set not to ALL.
At least one content item has the language set not to ALL.
At least one category has the language set not to ALL.
CREATE TABLE IF NOT EXISTS `alvajoom_jd_store` (
`idJdStore` int(11) NOT NULL AUTO_INCREMENT,
`idLang` tinyint(4) NOT NULL COMMENT 'language id alvajoom_languages',
`idReference` int(11) NOT NULL COMMENT 'Primary key for translation',
`referenceTable` varchar(67) NOT NULL COMMENT 'Table of the translation',
`referenceOption` varchar(50) NOT NULL,
`referenceView` varchar(50) NOT NULL,
`referenceLayout` varchar(50) NOT NULL,
`sourcehash` varchar(32) NOT NULL,
`value` longtext NOT NULL COMMENT 'serialized table value',
`modified` datetime NOT NULL,
`modified_by` int(11) NOT NULL,
`state` tinyint(4) NOT NULL,
PRIMARY KEY (`idJdStore`),
UNIQUE KEY `idLang` (`idLang`,`referenceTable`,`idReference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=72 ;
(16, 1, 107, '#__modules', 'com_modules', 'module', 'edit', '1068d420be94ad2c3619a712fc5c1c07', '<?xml version="1.0"?>\n<jDiction><title><![CDATA[JDLANG]]></title></jDiction>\n', '2014-07-28 08:57:18', 0, 1),
...
(19, 3, 14, '#__content', 'com_content', 'article', 'edit', '47ad67712c7151688be63cb79ec259e2', '<?xml version="1.0"?>\n<jDiction><title><![CDATA[Contact]]></title><alias><![CDATA[contact]]></alias></jDiction>\n', '2014-07-28 08:58:47', 0, 1),