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.
Options

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.