MyBB Community Forums

Full Version: changing host problem
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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???????
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
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.
(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?
not solved.....

i install mybb and import user only


but sad thing is my all post is deleted.