Greenguy's Board


Go Back   Greenguy's Board > Programming & Scripting
Register FAQ Calendar Today's Posts

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 2014-11-14, 06:51 PM   #1
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   #2
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
Reply


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 08:13 AM.


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