[Solved] Anyone have any insight into the error message?

abrown

Vanilla install for seemingly no reason pops up the install interface. I've reinstalled the program, restored my database from backup and only have default plugins. Don't have a clue what to do next. This error pops up when I submit the install credentials.


225:

226: if (!is_object($PDOStatement)) {

227: trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);

228: } else if ($PDOStatement->execute($InputParameters) === FALSE) {

229: trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);

230: }

231: } else {

232: $PDOStatement = $this->Connection()->query($Sql);

233: }

Linc

Do you have a backup of your conf/config.php file from before the problem? If so, restoring that should solve your issue.

Linc

Can we get the rest of the error page contents?

abrown

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: /home/###/public_html/vanilla/library/database/class.database.php

225:

226: if (!is_object($PDOStatement)) {

227: trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);

228: } else if ($PDOStatement->execute($InputParameters) === FALSE) {

229: trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);

230: }

231: } else {

232: $PDOStatement = $this->Connection()->query($Sql);

233: }

Backtrace:

/home/###/public_html/vanilla/library/database/class.database.phpPHP::Gdn_ErrorHandler();

[/home/###/public_html/vanilla/library/database/class.database.php:229] PHP::trigger_error();

[/home/###/public_html/vanilla/library/database/class.sqldriver.php:1584] Gdn_Database->Query();

[/home/###/public_html/vanilla/library/database/class.sqldriver.php:1562] Gdn_SQLDriver->Query();

[/home/###/public_html/vanilla/applications/dashboard/models/class.usermodel.php:484] Gdn_SQLDriver->Put();

[/home/###/public_html/vanilla/applications/dashboard/controllers/class.setupcontroller.php:189] UserModel->SaveAdminUser();

[/home/###/public_html/vanilla/applications/dashboard/controllers/class.setupcontroller.php:51] SetupController->Configure();

[/home/###/public_html/vanilla/applications/dashboard/controllers/class.setupcontroller.php:51] SetupController->Index();

[/home/###/public_html/vanilla/library/core/class.dispatcher.php:299] PHP::call_user_func_array();

[/home/###/public_html/vanilla/index.php:38] Gdn_Dispatcher->Dispatch();

Variables in local scope:

[Sql] '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'

[InputParameters] array (
':Name' => '###',
':Password' => '###',
':Email' => '###',
':ShowEmail' => '0',
':Gender' => 'm',
':DateOfBirth' => '1975-09-16',
':DateFirstVisit' => '2011-09-18 14:49:32',
':DateLastActive' => '2011-09-18 14:49:32',
':DateInserted' => '2011-09-18 14:49:32',
':DateUpdated' => '2011-09-18 14:49:32',
':Admin' => '1',
':UserID' => 1,
)

[Options] array (
'ReturnType' => 'DataSet',
)

[PDOStatement] array (
'queryString' => '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',
)

Need Help?

If you are a user of this website, you can report this message to a website administrator.

If you are an administrator of this website, you can get help at the Vanilla Community Forums.
Additional information for support personnel:

Application: Vanilla
Application Version: 2.0.17.10
PHP Version: 5.2.17
Operating System: Linux
Server Software: Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/1.0.0-fips mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Referer: http://###/vanilla/index.php?p=/dashboard/setup
User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:6.0.2) Gecko/20100101 Firefox/6.0.2
Request Uri: /vanilla/index.php?p=/dashboard/setup
Controller: Gdn_Database
Method: Query

Linc

Do you have a backup of your conf/config.php file from before the problem? If so, restoring that should solve your issue.

abrown

Awesome. Thanks. Time to change my host.