Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Vanilla fails after update to 2.18.4

edited September 2012 in Vanilla 2.0 - 2.8

I today attempted to update from Vanilla 2.18.1 to 2.18.4. When attempting to run the update page, I get this:

Fatal Error in Gdn_Database.Query();

Duplicate entry '1' for key 1
update GDN_User User set
Name = :Name,
Password = :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: /var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/library/database/class.database.php
276:
277: if (!is_object($PDOStatement)) {
278: trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);
279: } else if ($PDOStatement->execute($InputParameters) === FALSE) {
280: trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
281: }
282: } else {
283: $PDOStatement = $this->Connection()->query($Sql);
284: }
Backtrace:
/var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/library/database/class.database.phpPHP::Gdn_ErrorHandler();
[/var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/library/database/class.database.php:280] PHP::trigger_error();
[/var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/library/database/class.sqldriver.php:1650] Gdn_Database->Query();
[/var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/library/database/class.sqldriver.php:1619] Gdn_SQLDriver->Query();
[/var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/applications/dashboard/models/class.usermodel.php:968] Gdn_SQLDriver->Put();
[/var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/applications/dashboard/controllers/class.setupcontroller.php:214] UserModel->SaveAdminUser();
[/var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/applications/dashboard/controllers/class.setupcontroller.php:71] SetupController->Configure();
[/var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/applications/dashboard/controllers/class.setupcontroller.php:71] SetupController->Index();
[/var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/library/core/class.dispatcher.php:322] PHP::call_user_func_array();
[/var/www/vhosts/theturninggate.net/subdomains/community/httpdocs/index.php:53] Gdn_Dispatcher->Dispatch();
Variables in local scope:
[Sql] 'update GDN_User User set
Name = :Name,
Password = :Password,
Email = :Email,
ShowEmail = :ShowEmail,
Gender = :Gender,
DateOfBirth = :DateOfBirth,
DateFirstVisit = :DateFirstVisit,
DateLastActive = :DateLastActive,
DateInserted = :DateInserted,
DateUpdated = :DateUpdated,
Admin = :Admin,
UserID = :UserID'
[InputParameters] array (
':Name' => 'deleted',
':Password' => 'deleted',
':Email' => 'deleted',
':ShowEmail' => '0',
':Gender' => 'm',
':DateOfBirth' => '1975-09-16',
':DateFirstVisit' => '2012-09-24 04:48:53',
':DateLastActive' => '2012-09-24 04:48:53',
':DateInserted' => '2012-09-24 04:48:53',
':DateUpdated' => '2012-09-24 04:48:53',
':Admin' => '1',
':UserID' => 1,
)
[Options] array (
'ReturnType' => NULL,
)
[ReturnType] NULL
[PDOStatement] array (
'queryString' => 'update GDN_User User set
Name = :Name,
Password = :Password,
Email = :Email,
ShowEmail = :ShowEmail,
Gender = :Gender,
DateOfBirth = :DateOfBirth,
DateFirstVisit = :DateFirstVisit,
DateLastActive = :DateLastActive,
DateInserted = :DateInserted,
DateUpdated = :DateUpdated,
Admin = :Admin,
UserID = :UserID',
)

Sign In or Register to comment.