MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'loginattempts' in 'field list'
Query:
UPDATE mybb_users SET `loginattempts`='1' WHERE uid='1'
I had just registered a test account in the normal way. I went to log in, and got that. Also happens when I try to log in with my Admin account. My p/w is correct. Using MyBB 1.4.2.
www.learnmybb.com, log in with u/n Test, p/w password. Happens with the log in box in the welcomeblock and by using member.php?action=login. I can access the ACP fine.
Do you get that when you login with the correct password or incorrect password?
Correct. Which I thought was weird as it's saying about login attempts
It literally only started when I registered a test account.
Nothing to do with a plugin either, haven't installed any for a day or so and I've logged in and out fine a few times since then.
Ok when did you install this forum? and was it upgraded in any way?
It was a fresh 1.4.2 install and it's been running fine since it was started.
If push comes to shove I can just revert to a backup made about an hour before it happened, I wouldn't lose anything. I can post the table that has the error and the version from the backup if that would be of any use.
This probably isn't related but could anything be caused by the member.php patch you posted in another thread?? I posted that it fixed the star problem at 20:39 (my time) and my database was also backed up at 20:39 by a task, so I would have made the edit a matter of minutes before the database was backed up (what are the odds
).
Yeah labrocca confirmed it in the stars thread.
This was caused by the member.php file that dennis attached in your bug report thread. The file was designed for 1.4.3, not 1.4.2.
Sorry 