Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved changing host problem
#1
Not Solved Thumbs Down 
when i important sql to new database ....... say error

(06-09-2011, 08:20 PM)MattRogowski Wrote: 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: Unclosed quote @ 136
STR: `
SQL:
INSERT INTO mybb_posts (pid,tid,replyto,fid,subject,icon,uid,username,dateline,message,ipaddress,longipaddress,`

SQL query:

INSERT INTO mybb_posts (pid,tid,replyto,fid,subject,icon,uid,username,dateline,message,ipaddress,longipaddress,`

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 '' at line 1

What to do???????
#2
Not Solved
You've posted this in the forum called 'MyBB.com Community & Site Issues' which is quite clearly for issues with this forum, not yours, as is explained here: http://community.mybb.com/announcement-18.html
[Image: banner.png]
#3
Not Solved
Your SQL seems to be truncated or something so my guess is that there went something wrong with the export. If you can, try doing the export again.

If you can't, search that line in your SQL dump and see if the SQL continues on the next line.
#4
Not Solved
(06-14-2011, 06:35 AM)StefanT Wrote: You've posted this in the forum called 'MyBB.com Community & Site Issues' which is quite clearly for issues with this forum, not yours, as is explained here: http://community.mybb.com/announcement-18.html

any mod move this topic to right caterogry.


Any give me solution?
#5
Not Solved
not solved.....

i install mybb and import user only


but sad thing is my all post is deleted.


Forum Jump:


Users browsing this thread: 1 Guest(s)