SQL error again. :(

[Cool_Guy]

I mas spliting a thread, and got this

error:

mySQL error: 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 's your Occupation?' WHERE pid='3939' LIMIT 1' at line 1
Query: UPDATE mybb_posts SET subject='What's your Occupation?'

WHERE pid='3939' LIMIT 1

[FirefoxWiz]

Well, I'll try to find out how to fix it,

but NO ONE is replying with help on my Can't Copy Thread post :'(

(http://community.mybboard.net/showthread.php?tid=11179)

[Protoman]

I've worked out how to fix SQL errors with MyBB, but it's a time consuming task.

Delete your installation and create a new DB, then, Install MyBB to the place it was before. Once installed, change the config file back to point at the old database.

Delete the new database and start installing your mods again.

And SQL problems are fixed!

[BETA_mybb_import3230]

Uhh, I don't think FW's gonna delete the

database and reinstall MyBB, that takes like WAY too much work!

Plus, we'd lose all our posts and members :o

-Beta

[Protoman]

I didn't say delete the existing

one.

You create a temporary DB for the NEW installation, then once install is complete, change the config file to point at the real one and delete the

temporary one.

Worked for me, kept all my posts, etc.

[CraKteR]

This is an error of MyBB there is no

need to reinstall, the problem will still occur, probably an missing addslashes some place in the code.

And there is even an fix


http://community.mybboard.net/showthread...5#pid47565

[FirefoxDownload]

I've never seen that happen before