MyBB Community Forums

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL 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 'b790f6a9a3128b63931f04b711068576','Usfx2SsK','bp47htU239Vi7bBQB9A8lnacORPOXnzVEt' at line 3
Query:
INSERT INTO mybb_users (username,password,salt,loginkey,email,avatar,usergroup,regdate,steam_id) VALUES ('[Lazy] /) Indigo Blaze (\','b790f6a9a3128b63931f04b711068576','Usfx2SsK','bp47htU239Vi7bBQB9A8lnacORPOXnzVEtaf1szdxKgYWvVEGJ','[email protected]','http://media.steampowered.com/steamcommunity/public/images/avatars/55/55c33a930247abadf80b1b959d7445b5317ce531_full.jpg','2','1361072234','76561198053064169')

Please contact the MyBB Group for support.



I try to register for the "Get Wrecked Kid!", but when I agree to the terms it sends me to a page that asks for me to login through steam. So, I do and I get this error. Please help!!!

Is it your forum? If it isn't, you can't do nothing about it. Try to contact the administrator of the forum.

That query is really messed up. That username seems to be breaking the database query. Let the board owner know, since I assume it's not your board.

(2013-02-17, 05:12 PM)Josh H. Wrote: [ -> ]That query is really messed up. That username seems to be breaking the database query. Let the board owner know, since I assume it's not your board.

So I change my username to something simpler? And if I were to contact the admin or board owner, I couldn't because it will not let me register because of the error and I cannot sign into with steam because of that error. :I

Remove your credentials from the error.

The problem with your username is that it has parentheses in it. Instead of

Quote:[Lazy] /) Indigo Blaze

, you should probably change it to something like

Quote:Lazy Indigo Blaze

MySQL queries use parentheses in them, and when you add a right parenthesis into your username, it ends the query early and irritates MySQL.