MOSUSER::Store Failed

Problem

mosuser:: store failed
Duplicate entry ‘0’ for key 1 SQL=INSERT INTO mos_users(‘name’, ‘username’, ’email’, ‘password,’gid’, ‘registerDate’) VALUES (‘Dave’, ‘Dave’, ‘xxxx@yourdomain.com’, ‘xkjojosjclkvjosjojxkc’, ’18’,’2004-08-05′)

Solution

• http://forum.joomla.org/index.php?topic=48197.msg259537
• If you are on a local server , turn the strict mode off. Joomla still has difficulty with this on mysql5.
• Turn off strict mode in mySQL by commenting the following line (with a #) (found here):

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

• Maybe this solution? http://moodle.org/mod/forum/discuss.php?d=32071