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 2.1a41upgrade2.2.4,Unknown column 'IsDefault' in 'where clause'*
wrwjkill
New
I use git pull Vanilla 2.1a41 upgrade to 2.2.4. There is a problem
Fatal Error in Gdn_Database.Query(); PDO Statement failed to prepare Unknown column 'IsDefault' in 'where clause' The error occurred on or near: /home/wwwroot/library/database/class.database.php 324: if (!is_null($InputParameters) && count($InputParameters) > 0) { 325: $PDOStatement = $PDO->prepare($Sql); 326: 327: if (!is_object($PDOStatement)) { 328: trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($PDO->errorInfo())), E_USER_ERROR); 329: } else if ($PDOStatement->execute($InputParameters) === FALSE) { 330: trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR); 331: } 332: } else { Backtrace: /home/wwwroot/library/database/class.database.phpPHP::Gdn_ErrorHandler(); [/home/wwwroot/library/database/class.database.php:328] PHP::trigger_error(); [/home/wwwroot/library/database/class.sqldriver.php:1657] Gdn_Database->Query(); [/home/wwwroot/library/database/class.sqldriver.php:927] Gdn_SQLDriver->Query(); [/home/wwwroot/library/core/class.authenticationprovidermodel.php:114] Gdn_SQLDriver->GetWhere(); [/home/wwwroot/library/core/class.authenticationprovidermodel.php:41] Gdn_AuthenticationProviderModel::GetWhereStatic(); [/home/wwwroot/applications/dashboard/controllers/class.entrycontroller.php:289] Gdn_AuthenticationProviderModel::GetDefault(); [/home/wwwroot/applications/dashboard/controllers/class.entrycontroller.php:1175] EntryController->CheckOverride(); [/home/wwwroot/applications/dashboard/controllers/class.entrycontroller.php:1175] EntryController->Register(); [/home/wwwroot/library/core/class.dispatcher.php:355] PHP::call_user_func_array(); [/home/wwwroot/index.php:46] Gdn_Dispatcher->Dispatch();
Variables in local scope:
[ Sql] 'select *
from GDN_UserAuthenticationProvider UserAuthenticationProvider
where IsDefault = :IsDefault'
[InputParameters] array (
':IsDefault' => 1,
)
[Options] array (
'Type' => 'select',
'Slave' => NULL,
'ReturnType' => 'DataSet',
)
[ReturnType] 'DataSet'
[PDO] array (
)
[PDOStatement] false
Additional information for support personnel: Application: Vanilla Application Version: 2.2.4 PHP Version: 5.3.17 Operating System: Linux Server Software: nginx/1.2.7 Referer: http://mysite.com/ User Agent: Opera/9.80 (Windows NT 6.2; WOW64) Presto/2.12.388 Version/12.16 Request Uri: /entry/register?Target=discussions Controller: Gdn_Database Method: Query
0
This discussion has been closed.
Comments
if you are going to use something more cutting edge than 2.0.18.9 then you should probably use 2.1b2
edited: see shadowdare's solution below.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
Try running the scripts at the URLs
http://example.com/index.php?p=/utility/structure
andhttp://example.com/index.php?p=/utility/update
.Add Pages to Vanilla with the Basic Pages app
You're great. Vanilla2.2.4 has been successfully upgraded, just have one problem, however. Register a new user,
Input error:. Invalid referer
What is the reason?The
Input error: Invalid referrer
is from reCAPTCHA, which is used to determine if a bot or human is trying to register.You can go to the
http://example.com/index.php?p=/dashboard/settings/registration
page and input the reCAPTCHA public and private keys that you can get from here:http://www.google.com/recaptcha/whyrecaptcha
Add Pages to Vanilla with the Basic Pages app
How to display user avatar on a mobile phone? Vanilla2.2.4
if it is plugin related:
http://vanillaforums.org/discussion/comment/196078/#Comment_196078
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
display user avatar on a mobile .not Signature
Please see the other discussion you made for that question: http://vanillaforums.org/discussion/comment/198318/#Comment_198318
Add Pages to Vanilla with the Basic Pages app