+- Support Forums (https://www.supportforums.net)
+-- Forum: Categories (https://www.supportforums.net/forumdisplay.php?fid=87)
+--- Forum: Computer Support Topics (https://www.supportforums.net/forumdisplay.php?fid=4)
+---- Forum: Networking, Wifi, and Internet Connection Help (https://www.supportforums.net/forumdisplay.php?fid=29)
+----- Forum: Web Browser Help (https://www.supportforums.net/forumdisplay.php?fid=45)
+------ Forum: Firefox Browser (https://www.supportforums.net/forumdisplay.php?fid=65)
+------ Thread: SQL error again. :( (/showthread.php?tid=8767)
SQL error again. :( - Cool_Guy - 08-11-2006
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
RE: SQL error again. :( - FirefoxWiz - 08-11-2006
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)
RE: SQL error again. :( - Protoman - 08-20-2006
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!
RE: SQL error again. :( - BETA_mybb_import3230 - 08-23-2006
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
RE: SQL error again. :( - Protoman - 08-23-2006
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.
RE: SQL error again. :( - CraKteR - 08-23-2006
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.php?tid=7695&pid=47565#pid47565
RE: SQL error again. :( - FirefoxDownload - 09-07-2006
I've never seen that happen before