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'*

wrwjkillwrwjkill New
edited December 2013 in Vanilla 2.0 - 2.8

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

Comments

  • peregrineperegrine MVP
    edited December 2013

    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 and http://example.com/index.php?p=/utility/update.

    Add Pages to Vanilla with the Basic Pages app

  • wrwjkillwrwjkill New
    edited December 2013

    @Shadowdare said:
    Try running the scripts at the URLs http://example.com/index.php?p=/utility/structure and http://example.com/index.php?p=/utility/update.

    http://example.com/index.php?p=/utility/structure
    alter table `GDN_AnalyticsLocal`
     engine = innodb;
    
    alter table `GDN_Tag`
     engine = innodb;
    
    alter table `GDN_Log`
     engine = innodb;
    
    alter table `GDN_Regarding`
     engine = innodb;
    
    alter table `GDN_Ban`
     engine = innodb;
    
    alter table `GDN_TagDiscussion`
     engine = innodb;
    
    http://example.com/index.php?p=/utility/update
    Success
    

    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?

  • edited December 2013

    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

  • wrwjkillwrwjkill New
    edited December 2013

    @Shadowdare said:
    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

    How to display user avatar on a mobile phone? Vanilla2.2.4

  • peregrineperegrine MVP
    edited December 2013

    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

    image

  • edited December 2013

    @wrwjkill said:
    How to display user avatar on a mobile phone? Vanilla2.2.4

    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

This discussion has been closed.