Problems after 2.0.18.2 update

dodgerid

Hi experiencing database query problems after update with users, role and registration details below

Users:
Fatal Error in Gdn_DatabaseDebug.Query();

Unknown column 'Name' in 'where clause'
select *
from GDN_Role Role
where Name = :Name
The error occurred on or near: /home/starpeac/public_html/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:

/home/starpeac/public_html/library/database/class.database.phpPHP::Gdn_ErrorHandler(); [/home/starpeac/public_html/library/database/class.database.php:280] PHP::trigger_error(); [/home/starpeac/public_html/plugins/Debugger/class.databasedebug.php:105] Gdn_Database->Query(); [/home/starpeac/public_html/library/database/class.sqldriver.php:1650] Gdn_DatabaseDebug->Query(); [/home/starpeac/public_html/library/database/class.sqldriver.php:934] Gdn_SQLDriver->Query(); [/home/starpeac/public_html/applications/dashboard/models/class.usermodel.php:1157] Gdn_SQLDriver->GetWhere(); [/home/starpeac/public_html/applications/dashboard/controllers/class.usercontroller.php:89] UserModel->SearchCount(); [/home/starpeac/public_html/applications/dashboard/controllers/class.usercontroller.php:89] UserController->Index(); [/home/starpeac/public_html/library/core/class.dispatcher.php:322] PHP::call_user_func_array(); [/home/starpeac/public_html/index.php:53] Gdn_Dispatcher->Dispatch();
Queries:

select *
from GDN_User User
where UserID = '1'; 0.001311sselect *
from GDN_Permission Permission
limit 1; 0.004761sselect MAX(p.PermissionID) as PermissionID, MAX(p.Garden.Email.Manage) as Garden.Email.Manage, MAX(p.Garden.Settings.Manage) as Garden.Settings.Manage, MAX(p.Garden.Settings.View) as Garden.Settings.View, MAX(p.Garden.Routes.Manage) as Garden.Routes.Manage, MAX(p.Garden.Messages.Manage) as Garden.Messages.Manage, MAX(p.Garden.Applications.Manage) as Garden.Applications.Manage, MAX(p.Garden.Plugins.Manage) as Garden.Plugins.Manage, MAX(p.Garden.Themes.Manage) as Garden.Themes.Manage, MAX(p.Garden.SignIn.Allow) as Garden.SignIn.Allow, MAX(p.Garden.Registration.Manage) as Garden.Registration.Manage, MAX(p.Garden.Applicants.Manage) as Garden.Applicants.Manage, MAX(p.Garden.Roles.Manage) as Garden.Roles.Manage, MAX(p.Garden.Users.Add) as Garden.Users.Add, MAX(p.Garden.Users.Edit) as Garden.Users.Edit, MAX(p.Garden.Users.Delete) as Garden.Users.Delete, MAX(p.Garden.Users.Approve) as Garden.Users.Approve, MAX(p.Garden.Activity.Delete) as Garden.Activity.Delete, MAX(p.Garden.Activity.View) as Garden.Activity.View, MAX(p.Garden.Profiles.View) as Garden.Profiles.View, MAX(p.Garden.Profiles.Edit) as Garden.Profiles.Edit, MAX(p.Garden.Moderation.Manage) as Garden.Moderation.Manage, MAX(p.Garden.AdvancedNotifications.Allow) as Garden.AdvancedNotifications.Allow, MAX(p.Vanilla.Settings.Manage) as Vanilla.Settings.Manage, MAX(p.Vanilla.Categories.Manage) as Vanilla.Categories.Manage, MAX(p.Vanilla.Spam.Manage) as Vanilla.Spam.Manage, MAX(p.Vanilla.Discussions.View) as Vanilla.Discussions.View, MAX(p.Vanilla.Discussions.Add) as Vanilla.Discussions.Add, MAX(p.Vanilla.Discussions.Edit) as Vanilla.Discussions.Edit, MAX(p.Vanilla.Discussions.Announce) as Vanilla.Discussions.Announce, MAX(p.Vanilla.Discussions.Sink) as Vanilla.Discussions.Sink, MAX(p.Vanilla.Discussions.Close) as Vanilla.Discussions.Close, MAX(p.Vanilla.Discussions.Delete) as Vanilla.Discussions.Delete, MAX(p.Vanilla.Comments.Add) as Vanilla.Comments.Add, MAX(p.Vanilla.Comments.Edit) as Vanilla.Comments.Edit, MAX(p.Vanilla.Comments.Delete) as Vanilla.Comments.Delete, MAX(p.Plugins.WhosOnline.ViewHidden) as Plugins.WhosOnline.ViewHidden, MAX(p.Plugins.WhosOnline.Manage) as Plugins.WhosOnline.Manage, MAX(p.Conversations.Moderation.Manage) as Conversations.Moderation.Manage, MAX(p.Plugins.Flagging.Notify) as Plugins.Flagging.Notify, MAX(p.Plugins.kPoll.Manage) as Plugins.kPoll.Manage, MAX(p.Plugins.Debugger.View) as Plugins.Debugger.View, MAX(p.Plugins.Debugger.Manage) as Plugins.Debugger.Manage, MAX(p.Faq.Settings.Manage) as Faq.Settings.Manage, MAX(p.Faq.Questions.Edit) as Faq.Questions.Edit, MAX(p.Faq.Questions.Delete) as Faq.Questions.Delete, MAX(p.Faq.Questions.Browse) as Faq.Questions.Browse, MAX(p.Faq.Categories.Browse) as Faq.Categories.Browse, MAX(p.Faq.Categories.Edit) as Faq.Categories.Edit, MAX(p.Faq.Categories.Delete) as Faq.Categories.Delete, MAX(p.PollManager.Settings.Manage) as PollManager.Settings.Manage, MAX(p.PollManager.Manager.Manage) as PollManager.Manager.Manage, MAX(p.PollManager.Manager.Edit) as PollManager.Manager.Edit, MAX(p.PollManager.Manager.Delete) as PollManager.Manager.Delete, p.JunctionTable as JunctionTable, p.JunctionColumn as JunctionColumn, p.JunctionID as JunctionID
from GDN_Permission p
join GDN_UserRole ur on p.RoleID = ur.RoleID
where ur.UserID = '1'
group by p.JunctionTable, p.JunctionColumn, p.JunctionID; 0.000200sselect *
from GDN_Role Role
where Name = ''; 0.000217s
Variables in local scope:

[Sql] 'select *
from GDN_Role Role
where Name = :Name' [InputParameters] array (
':Name' => '',
) [Options] array (
'ReturnType' => 'DataSet',
) [ReturnType] 'DataSet' [PDOStatement] array (
'queryString' => 'select *
from GDN_Role Role
where Name = :Name',
)

dodgerid

Rather pleased with myself, pulled out the GDN_Role table and data from old backup, dropped existing table, run the copied Sql and hey presto, fully functioning site, ooh I am proud.

You can close this now Mr Moderator, thanks.

Todd

Good stuff working through the issue. There is certainly not something that would have removed the role table in the update. Not sure what happened, but I'm glad you got things sorted.

dodgerid

Ok so after a little decifering and delving and comparisons to backup sql it looks as though the GDN_Role table has managed to lose all fields except session and its lost all data, hmm, I dont think this IS linked to the update, although god knows whats happened, was fine yesterday, will try fix

dodgerid

Rather pleased with myself, pulled out the GDN_Role table and data from old backup, dropped existing table, run the copied Sql and hey presto, fully functioning site, ooh I am proud.

You can close this now Mr Moderator, thanks.

Todd

Good stuff working through the issue. There is certainly not something that would have removed the role table in the update. Not sure what happened, but I'm glad you got things sorted.