1
Support / problem creating store from translation
« on: July 07, 2016, 02:54:26 PM »
With any translation applied in the administrative panel, the fields does not appear. only with selected English language
2016-05-23 23:16:45 - database error: AbanteCart core v.1.2.7 SQL Error: 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 ')
ORDER BY rm.object_id ASC, rm.sort_order ASC, rl.resource_id ASC' at line 22
Error No: 1064
SQL:
SELECT
rm.object_id,
rl.resource_id,
COALESCE(rd.name,rdd.name) as name,
COALESCE(rd.title,rdd.title) as title,
COALESCE(rd.description,rdd.description) as description,
COALESCE(rd.resource_path,rdd.resource_path) as resource_path,
COALESCE(rd.resource_code,rdd.resource_code) as resource_code,
rm.default,
rm.sort_order
FROM abc_resource_library rl
LEFT JOIN abc_resource_map rm
ON rm.resource_id = rl.resource_id
LEFT JOIN abc_resource_descriptions rd
ON (rl.resource_id = rd.resource_id
AND rd.language_id = '2')
LEFT JOIN abc_resource_descriptions rdd
ON (rl.resource_id = rdd.resource_id
AND rdd.language_id = '1')
WHERE rm.object_name = 'products'
AND rl.type_id = 1
AND rm.object_id IN ()
ORDER BY rm.object_id ASC, rm.sort_order ASC, rl.resource_id ASC in <b>C:\Desenvolvimento\dev.abantecart.com\public_html\core\database\amysqli.php</b> on line <b>106</b>