About arrow Support Forums Make Text BiggerMake Text SmallerReset Text Size
Export Content Support
Welcome, Guest
Please Login or Register.    Lost Password?
Error: DB function failed with error number 1064 (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Error: DB function failed with error number 1064
#1007
williamconifer (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Error: DB function failed with error number 1064 1 Year, 4 Months ago Karma: 0  
Greetings Steve,

I have one of my mambo site clients wanting me to migrate them over to Joomla. I am installing Joomla clean and using your Export Content comp. to export their content over.

The Mambo site is running 4.5.4 sp3

EC installs fine but when I go to the Export Content button in your comp I get this error:

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 'LEFT JOIN #__content AS cc ON c.id = cc.sectionid LEFT JOIN #__users AS u ON u.' at line 3 SQL=SELECT c.*, g.name AS groupname, u.name AS editor FROM #__sections AS c LEFT JOIN #__content AS cc ON c.id = cc.sectionid LEFT JOIN #__users AS u ON u.id = c.checked_out LEFT JOIN #__groups AS g ON g.id = c.access GROUP BY c.id ORDER BY c.ordering, c.name

Any idea what's going on here? if we can get this working I'll be more than happy to donate.

Thanks so much.

Jack
affinityav.com :!:
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
      Topics Author Date
    thread link
Error: DB function failed with error number 1064
williamconifer 2007/07/23 04:49
    thread link
thread linkthread link Re: Error: DB function failed with error number 1064
Steve 2007/07/23 14:31
    thread link
thread linkthread link Re: Error: DB function failed with error number 1064
williamconifer 2007/07/23 23:26
    thread link
thread linkthread link Another idea
williamconifer 2007/07/23 23:29
    thread link
thread linkthread link Re: Error: DB function failed with error number 1064
Steve 2007/07/24 07:17
    thread link
thread linkthread link Re: Error: DB function failed with error number 1064
Dev-X 2007/09/20 00:02
    thread link
thread linkthread link Re: Error: DB function failed with error number 1064
Steve 2007/09/20 08:22
    thread link
thread linkthread link Re:Error: DB function failed with error number 106
vectordez 2008/04/23 04:08
    thread link
thread linkthread link Re:Error: DB function failed with error number 1064
Steve 2008/04/23 17:21
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop