MyBB Community Forums

Full Version: SQL Problem!
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,

Im getting the following error when trying to log into my forums (http://www.rcoclub.com):


MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'loginattempts' in 'field list'
Query:
UPDATE mybb_sessions SET loginattempts=loginattempts+1 WHERE sid = ''


I can log into the admin section just fine, but it seems that theres no way i can log into the forums itself without getting this error!

Anyone know what is causing this error and how to fix?

All help much appreciated!

Thanks,

Edward Tobia
Just found out its to do with the SideBoxes plugin...

Any fix for this?

I tried the supposed fix @ http://community.mybboard.net/thread-41669-page-1.html

This fix works when logging in when you try to reply to a thread, but it doesnt work for the login link on the main forum page...
The fix will work, as tested with other 1.4.4 installations.

"Loginattempts" was added into 1.4.4, and you needed to run the upgrader to put it into your database. Have you recently upgraded, and not run the upgrader (gone to myboard/install/upgrade.php)??...
Yeah that fix for that plugin will work if you upgraded your forum properly.
I installed 1.4.4 from scratch...

I didnt say the fix didnt work because it does, if you try to reply to a thread then it attempts you to log in and that works, but if you try logging in from the main page by clicking the login link, it says something like "No such username" or something along them lines, when the details are correct as they work when logging in when replying to a thread, get what i mean?
This must be something you've maybe set up wrong as I've tested that updated sideboxes plugin a lot and it was fine, I never had any login problems of any kind anywhere. Can we have a link to your forum and a test account??
Yep here ya go:

http://www.rcoclub.com

username: testing
password: testing

i have re-enabled the sidebox plugin and the problem still exists, if you try to login using the link on the main forum page you will get an incorrect username error, yet if you try reply to a post THEN login when it requests you to, it works Confused

Test it out and get back to me Smile
And it works ok when the sidebox is disabled??
Yes works perfectly when sideboxes is disabled!

I have just disabled it, test it out now and ull see that it works!
Hmm... also the friendly redirect page is just plain HTML when logging in on the sidebox, and it's also plain HTML when it says invalid username... ok I'll add it to the plugin thread. For some reason it worked fine on my localhost yesterday.