Re: SQL Problems during import: #1064 - You have an error in your SQL syntax
Posted by:
ChrisUCLA
(---.socal.res.rr.com)
Date: August 13, 2013 03:58AM
I thought about dropped off code, and thought Id look match that first part with the engine code that fell off with a line that looked just like it:
) ENGINE = M-- MySQL dump 10.11
--
And changed it to:
) ENGINE=MyISAM DEFAULT CHARSET=utf8; <--added this, let the rest follow on next
-- MySQL dump 10.11
--
-- Host: localhost Database: fra1301704504244
-- ------------------------------------------------------
-- Server version 5.0.96-log
Re-iported that one and now it moved past that first error, and I now have 5 tables instead of 4, and a new
error:
SQL query:
INSERT INTO wp_commentmeta VALUES (1,2,'akismet_result','false'),(2,2,'akismet_history','a:4:{s:4:\"time\";d:1359068264.60383892059326171875;s:7:\"message\";s:28:\"Akismet cleared this comment\";s:5:\"event\";s:9:\"check-ham\";s:4:\"user\";s:0:\"\";}'),(4,2,'akismet_history','a:4:{s:4:\"time\";d:1359071391.7405779361724853515625;s:7:\"message\";s:47:\"fran9635 changed the comment status to approved\";s:5:\"event\";s:15:\"status-approved\";s:4:\"user\";s:8:\"fran9635\";}'),(5,3,'akismet_result','false'),(6,3,'akismet_history','a:4:{s:4:\"time\";d:1359071974.7687320709228515625;s:7:\"message\";s:28:\"Akismet cleared this comment\";s:5:\"event\";s:9:\"check-ham\";s:4:\"user\";s:8:\"fran9635\";}'),(83,30,'akismet_result','false'),(84,30,'akismet_history','a:4:{s:4:\"time\";d:1360971420.6763589382171630859375;s:7:\"message\";s:28:\"Akismet cleared this comment\";s:5:\"event\";s:9:\"check-ham\";s:4:\"user\";s:0:\"\";}'),(86,30,'akismet_history','a:4:{s:4:\"time\";d:1360971460.042884111404[...]
MySQL said:
#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 '0',
usage int(10) unsigned NOT NULL default '1',
PRIMARY KEY (refID)
) ' at line 1
Edited 1 time(s). Last edit at 08/13/2013 05:56AM by ChrisUCLA.