Vanilla 2.1a41upgrade2.2.4,Unknown column 'IsDefault' in 'where clause'*

wrwjkill

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

peregrine

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.

Shadowdare

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

wrwjkill

@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?

Shadowdare

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

wrwjkill

@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

peregrine

if it is plugin related:

http://vanillaforums.org/discussion/comment/196078/#Comment_196078

wrwjkill

@peregrine said:
if it is plugin related:

http://vanillaforums.org/discussion/comment/196078/#Comment_196078

display user avatar on a mobile .not Signature

Shadowdare

@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