MyBB Community Forums

What is the error?? Is your table prefix correct??

My prefix upon a fresh install was mybb_

The error is

Quote:SQL query: Documentation

SELECT *
FROM mybb_users
WHERE 1
UPDATE mybb_users SET password = '098f6bcd4621d373cade4e832627b4f6',
salt = '' WHERE uid = '1' LIMIT 0 ,
30

MySQL said: Documentation
#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 'UPDATE mybb_users SET password = '098f6bcd4621d373cade4e832627b4f6', salt ' at line 2

UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = '1'

Try that. Just tested that and it worked ok for me.

If not:

UPDATE mybb_users SET password='098f6bcd4621d373cade4e832627b4f6', salt='' WHERE uid='1'

Quote:SQL query: Documentation

SELECT *
FROM mybb_users
WHERE 1
UPDATE mybb_users SET password = '098f6bcd4621d373cade4e832627b4f6',
salt = '' WHERE uid = '1' LIMIT 0 ,
30

MySQL said: Documentation
#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 'UPDATE mybb_users SET password = '098f6bcd4621d373cade4e832627b4f6', salt ' at line 2

Same message.

What about the second one I edited in??

Still says theres an error in the SQL syntax.

If you want, I could give you access to this, I do trust you.

EDIT:Besides, what could you get out of a yaoi forum? //Sarcasm

That's very weird... ok, PM me.

Pm sent.
I hope you can fix this.
If you can, will you please let me know what went wrong?

Ok, I managed to get past the SQL problem by typing it manually - not really sure whay that would make a difference but there we go.

However, there's a bit of a problem in the way your URLs are set. Your portal and ACP etc are located at yaoiland.co.cc, however the forum index itself is at yaoiland.site90.net. It seems as if the .co.cc isn't covering everything properly. It's only the index and forums etc that appears to be like this, the memebrlist, calendar etc is .co.cc. For example:

http://yaoiland.site90.net/forumdisplay.php?fid=2
and
http://yaoiland.co.cc/memberlist.php

Not sure quite why this is happening but you'll probably have to change your .co.cc settings.

Uhm... is mySQL in strict mode??... I'm not brushed up on mySQL but I'm sure you can't enter a blank value (salt) if it's running in strict mode.

Try

UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6' WHERE `uid` = '1'

Edit: I see Matt's already covered it... o.O