Greenguy's Board


Go Back   Greenguy's Board > Programming & Scripting
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 2014-11-10, 02:06 PM   #1
housekeeper
Oh! I haven't changed since high school and suddenly I am uncool
 
housekeeper's Avatar
 
Join Date: Sep 2009
Location: New York City
Posts: 250
Send a message via ICQ to housekeeper
SQL Error Help - Migration

I've been transferring some site from server to server, of the bulk I've done I'm at 80% success, there's two pesky DB's that are giving me errors, importing from back up sql files

My error code is here: http://pastebin.com/yvKEfCif

I've tried it with plugins disabled, but to know avail. The wp_statpress for example is related to one of the plugins, my security plug in I think. I didn't have to turn off the plugins on all the sites, but I'm guessing that going into the existing table on the new server and editing, modifying, adding, subtracting, repairing the tables will solve my ills, I just am not clear on the procedure.

Hopefully someone here can either give me insight into the correct fix, or point me in the right direction for the solution.

Much appreciated,
__________________
Trans-Glam Productions
photography - design - video production
twitter
housekeeper is offline   Reply With Quote
Old 2014-11-14, 06:51 PM   #2
Useless
Certified Nice Person
 
Useless's Avatar
 
Join Date: Oct 2003
Location: Dirty Undies, NY
Posts: 11,268
Send a message via ICQ to Useless
It's impossible for me to say without seeing the lines that caused the error. Sometimes it's a matter of a comma or apostrophe missing, or the piece of data within the apostrophes contains characters that anger mySQL.
__________________
Click here to purchase a bridge I'm selling.
Useless is offline   Reply With Quote
Old 2014-11-17, 04:49 PM   #3
housekeeper
Oh! I haven't changed since high school and suddenly I am uncool
 
housekeeper's Avatar
 
Join Date: Sep 2009
Location: New York City
Posts: 250
Send a message via ICQ to housekeeper
Thanks for the reply UW, it's returning syntax related errors. I'll try to provide better examples as I'm really looking to have this fixed versus scrapping it.

Here was the last error message: (I've replaced my root directory with 'user' just for posting purposes)

root@q3 [/home/user]# mysql user_wp11 < user_wp1.sql
ERROR 1064 (42000) at line 19180: 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 '(12645, 20130324, '02:27:19', '86.151.37.157', '/danni-daniels/', 'Mozilla/5.0 (' at line 121
root@q3 [/home/user]#
__________________
Trans-Glam Productions
photography - design - video production
twitter
housekeeper is offline   Reply With Quote
Old 2014-11-17, 08:30 PM   #4
Useless
Certified Nice Person
 
Useless's Avatar
 
Join Date: Oct 2003
Location: Dirty Undies, NY
Posts: 11,268
Send a message via ICQ to Useless
It would be most helpful to see the the line before for the error-causing line (12645), the error-causing line, and the line after it for comparison reasons.

It is possible that the line which angers mySQL was fine when it was originally added to the table, but an updated of mySQL version may no longer tolerate something within it.
__________________
Click here to purchase a bridge I'm selling.
Useless is offline   Reply With Quote
Old 2014-11-20, 12:03 PM   #5
housekeeper
Oh! I haven't changed since high school and suddenly I am uncool
 
housekeeper's Avatar
 
Join Date: Sep 2009
Location: New York City
Posts: 250
Send a message via ICQ to housekeeper
Quote:
Originally Posted by Useless Warrior View Post
It would be most helpful to see the the line before for the error-causing line (12645), the error-causing line, and the line after it for comparison reasons.

It is possible that the line which angers mySQL was fine when it was originally added to the table, but an updated of mySQL version may no longer tolerate something within it.
That is my thinking, I have to pull out those strings and take a look, I will post them. It is certainly syntax related, I have gotten behind with but definitely need to repair it. I appreciate your input, will get back shortly.
__________________
Trans-Glam Productions
photography - design - video production
twitter
housekeeper is offline   Reply With Quote
Old 2014-11-20, 09:44 PM   #6
housekeeper
Oh! I haven't changed since high school and suddenly I am uncool
 
housekeeper's Avatar
 
Join Date: Sep 2009
Location: New York City
Posts: 250
Send a message via ICQ to housekeeper
Quote:
Originally Posted by Useless Warrior View Post
It would be most helpful to see the the line before for the error-causing line (12645), the error-causing line, and the line after it for comparison reasons.

It is possible that the line which angers mySQL was fine when it was originally added to the table, but an updated of mySQL version may no longer tolerate something within it.
12644 (6022, 20130308, '00:23:36', '64.6.101.67', '/wp-content/uploads/2013/03/sheeba/sheeba_starr_pic3/2.jpg', 'WordPress/3.5.1; http://strokingqueens.com', '', '', '', '', '', '', 'WordPress', '', '', '2013-03-08 08:23:36'),

12645 (6023, 20130308, '00:23:36', '64.6.101.67', '/wp-content/uploads/2013/03/sheeba/3.jpg', 'WordPress/3.5.1; http://strokingqueens.com', '', '', '', '', '', '', 'WordPress', '', '', '2013-03-08 08:23:36'),

12646 (6024, 20130308, '00:23:36', '67.101.133.165', '/wp-content/uploads/2013/03/sheeba/3.jpg', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0 SeaMonkey/2.16', 'http://strokingqueens.com/sheeba-starr/', '', 'en', 'Windows 7', 'Firefox 19', '', '', '', '', '2013-03-08 08:23:36'),

Here are the three lines successively, I don't know well enough to see any difference or where the error is related
__________________
Trans-Glam Productions
photography - design - video production
twitter
housekeeper is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 03:52 AM.


Mark Read
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc