Fork me on GitHub
Current release is 2.1.6 (21 Nov 2014).

Users who have not yet upgraded to 2.1 should get security release (1 Nov 2014). We will stop providing these security releases to 2.0 at the end of this year.

Need Help Installing: Duplicate entry '1' for key 'PRIMARY'

edited November 2010 in Vanilla 2.0 Help
I installed Vanilla 2 successfully and imported my Vanilla 1 forum successfully. Everything was well and good until I accidentally changed the Vanilla 2 install root folder name. Ever since that happened I was unable to access my site. I tried naming it back but it just gave me errors.

I deleted everything on my server so I could start fresh. I put Vanilla 2 back on the server and tried a fresh reinstall. Now I receive this error every time after I access the installer on my browser and submit my info, trying to install it.

Here's the error. Please let me know if you have a solution.


Fatal Error in Gdn_Database.Query();
Duplicate entry '1' for key 'PRIMARY'
update GDN_User User set Name = :Name, Password = md5(:Password), Email = :Email, ShowEmail = :ShowEmail, Gender = :Gender, DateOfBirth = :DateOfBirth, DateFirstVisit = :DateFirstVisit, DateLastActive = :DateLastActive, DateInserted = :DateInserted, DateUpdated = :DateUpdated, Admin = :Admin, UserID = :UserID
The error occurred on or near: /usr/local/apache2/htdocs/wcom/vanilla/library/database/class.database.php

* Method: Query


Sign In or Register to comment.