MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Lost Password Recovery gives SQL Error 1364
Full Version: Lost Password Recovery gives SQL Error 1364
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Rimille

2014-08-04, 05:48 PM
When a user forgets their password and uses the “Lost Password Recovery” option they now get the following SQL error:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error: 1364 - Field 'aid' doesn't have a default value
Query: INSERT INTO mybb_awaitingactivation (uid,dateline,code,type) VALUES ('81','1407173974','QW8TJzfr','p')

I am running MyBB 1.6.10 right now.

Anyone know if there is a fix?
Thank you for your time and thoughts in advance. Smile

dragonexpert

2014-08-04, 07:43 PM
First update to 1.6.15, which was just released earlier today or at least 1.6.14. Check to be certain the table mybb_awaitingactivation has the Auto Increment value on the column aid. I think this is probably the case. You can check this by logging into your hosting panel then going into PHPMyAdmin. Select your forum's database. Then click on the structure link on the table mybb_awaitingactivation.
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Lost Password Recovery gives SQL Error 1364