Best Download Sites Login
Site Login
Welcome, Guest
Please Login or Register.    Lost Password?
Export Content Support
Export Content Forums
Bug Reports for older versions here

Error: DB function failed with error number 1064
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Error: DB function failed with error number 1064
#1054
Re: Error: DB function failed with error number 1064 2 Years, 11 Months ago Karma: 0
Hi Steve,

I'm running Mambo 4.5.2 and get the same error, however the patch did not seem to work for me.

This is the error I get after uploading the patch:
Code:
DB function failed with error number 106 4
You have an error in your SQL syntax;  check the manual that corresponds to yo ur MySQL server version for the right sy ntax to use near 'LEFT JOIN #__content A S 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 edit or FROM #__sections AS c LEFT JOIN #__co ntent AS cc ON c.id = cc.sectionid LEFT  JOIN #__users AS u ON u.id = c.checked_o ut LEFT JOIN #__groups AS g ON g.id = c. access GROUP BY c.id ORDER BY c.ordering , c.nameansfered'; mosRedirect(  'index2.php? option=com_export_content& task=sections',$msg ); } ?>


Any ideas what it could be?

Thanks Steve!
Dev-X
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1056
Re: Error: DB function failed with error number 1064 2 Years, 11 Months ago Karma: 9
I'm running Mambo 4.5.2 and get the same error, however the patch did not seem to work for me.

This is the error I get after uploading the patch:

Can you make sure the old file was writable and that the patch went over ok.

Note: It will still be buggy but you should be able to still compile and download the data.

Also you may want to have a look here which may help.
http://bestdownloadsites.com/export/ viewtopic.php?t=706

I have the latest release of Export content for Joomla is just about ready.
And will be starting on the Mambo version shortly but it want be ready for a while as it will need a lot of changes to get it working smoothly with different Mambo versions.

If you have no luck with it please post back here and we will see what we can come up with.
Steve
Admin
Posts: 465
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
Regards Steve.
http://www.bestdownloadsites.com/joomla/ export-content
  
#1223
Re:Error: DB function failed with error number 106 2 Years, 4 Months ago Karma: 0
Ciao,
can somebody send me the patch mentioned in this post oe publish a valid link?


mambo_patch/admin.export_content.zip


Thanks in advance...
vectordez
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1226
Re:Error: DB function failed with error number 1064 2 Years, 4 Months ago Karma: 9
can somebody send me the patch mentioned in this post oe publish a valid _link_?


mambo_patch/admin.export_content.zip


Thanks in advance...
This thread is old and there have been new releases to fix this error.
You need to install Export Content 1.0.0 on the Mambo site.
And Export Content version 1.7.0 on the Joomla 1.0.15 site.
Or if moving to Joomla 1.5+ series Export Content version 2.0.0 should be installed on the Joomla 1.5+ site.

To be clear all Export Content versions should only ever be installed on the Mambo-Joomla version it was made for.
Steve
Admin
Posts: 465
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
Regards Steve.
http://www.bestdownloadsites.com/joomla/ export-content
  
Go to topPage: 12
Export Content Support
Export Content Forums
Bug Reports for older versions here
Powered by Kunenaget the latest posts directly to your desktop

Business Proposal If you have a Business Proposal that you think may be of interest to us here at Best Download Sites please contact us to discuss the matter in further detail