Hello,
I recently had an issue with the last ModX site I created when I had a harddrive failure and the databases became corrupt. I’ve now recreated all the work that I lost and am trying to upload the database, but to no avail.
I am running MySQL 5.0.51 and the system I want to upload to is running 4.1.20.
I am getting the following error:
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 61
STR: />
SQL:
#
# Dumping data for table `wymondham_keyword_xref`
#
<br />
<b>Warning</b>: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in <b>C:\xampp\htdocs\modx\manager\actions\bkmanager.static.php</b> on line <b>314</b><br />
<br />
<b>Warning</b>: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in <b>C:\xampp\htdocs\modx\manager\actions\bkmanager.static.php</b> on line <b>356</b><br />
<br />
<b>Warning</b>: mysql_free_result(): supplied argument is not a valid MySQL result resource in <b>C:\xampp\htdocs\modx\manager\actions\bkmanager.static.php</b> on line <b>362</b><br />
# --------------------------------------------------------
#
# Table structure for table `wymondham_manager_log`
#
CREATE TABLE `wymondham_manager_log` (
`id` int(10) NOT NULL auto_increment,
`timestamp` int(20) NOT NULL default '0',
`internalKey` int(10) NOT NULL default '0',
`username` varchar(255) default NULL,
`action` int(10) NOT NULL default '0',
`itemid` varchar(10) default '0',
`itemname` varchar(255) default NULL,
`message` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1968 DEFAULT CHARSET=utf8 COMMENT='Contains a record of user interaction.';
SQL query:
# # Dumping data for table `wymondham_keyword_xref` #
Warning: mysql_query() [function.mysql-query]: Unable to save result set in C:\xampp\htdocs\modx\manager\actions\bkmanager.static.php on line 314
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\modx\manager\actions\bkmanager.static.php on line 356
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\modx\manager\actions\bkmanager.static.php on line 362
# -------------------------------------------------------- # # Table structure for table `wymondham_manager_log` # CREATE TABLE `wymondham_manager_log` ( `id` int(10) NOT NULL auto_increment, `timestamp` int(20) NOT NULL default '0', `internalKey` int(10) NOT NULL default '0', `username` varchar(255) default NULL, `action` int(10) NOT NULL default '0', `itemid` varchar(10) default '0', `itemname` varchar(255) default NULL, `message` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1968 DEFAULT CHARSET=utf8 COMMENT='Contains a record of user interaction.';
MySQL said: Documentation
#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 '<br />
<b>Warning</b>: mysql_query() [<a href='function.mysql-query'>function.' at line 1
I’m guessing this is an incompatibility issue?
Any ideas what I should do?
MODX Staff