Elxis CMS Forum

Support => General => Topic started by: armpouniotis on March 31, 2009, 22:20:30

Title: About Archive Manager
Post by: armpouniotis on March 31, 2009, 22:20:30

Hi all !

before using Elxis, I used Mambo... I have one site biuld in Mambo, and every time I go to Archive Manager in administrator's zone, the following error appears:

DB function failed with error number 1064
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 ' mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups' at line 2 SQL=SELECT c.*, g.name AS groupname, cc.name, v.name AS author FROM , mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS v ON v.id = c.created_by WHERE c.state = -1 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' ORDER BY c.catid, c.ordering LIMIT 0,50

Can someone give me some information on how to solve this ???

Thank you in advance

Christos