My forum is messed up bad

ytadvisors

I just recently logged in to the forums to find that everything was messed up. I suppose another admin messed with applications and this was the turn out. I added debug to the config file and when you log in here is what you get.

forums.yourtechadvisors.com
Login Username: test
Login Password: test123

Thanks for any help you are able to provide.

ytadvisors

`
Fatal Error in Gdn_Database.Query();
PDO Statement failed to prepare
Unknown column 'd.Resolved' in 'where clause'
The error occurred on or near: /home2/ytadvise/public_html/forums/library/database/class.database.php

289: if (!is_null($InputParameters) && count($InputParameters) > 0) {

290: $PDOStatement = $this->Connection()->prepare($Sql);

291:

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

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

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

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

296: }

297: } else {

Backtrace:

/home2/ytadvise/public_html/forums/library/database/class.database.phpPHP::Gdn_ErrorHandler();

[/home2/ytadvise/public_html/forums/library/database/class.database.php:293] PHP::trigger_error();

[/home2/ytadvise/public_html/forums/library/database/class.sqldriver.php:1630] Gdn_Database->Query();

[/home2/ytadvise/public_html/forums/library/database/class.sqldriver.php:654] Gdn_SQLDriver->Query();

[/home2/ytadvise/public_html/forums/plugins/Resolved/class.resolved.plugin.php:167] Gdn_SQLDriver->Get();

[/home2/ytadvise/public_html/forums/plugins/Resolved/class.resolved.plugin.php:152] ResolvedPlugin::CountUnresolved();

[/home2/ytadvise/public_html/forums/library/core/class.pluginmanager.php:705] ResolvedPlugin->Base_AfterDiscussionFilters_Handler();

[/home2/ytadvise/public_html/forums/library/core/class.pluginmanager.php:642] Gdn_PluginManager->CallEventHandler();

[/home2/ytadvise/public_html/forums/library/core/class.pluggable.php:144] Gdn_PluginManager->CallEventHandlers();

[/home2/ytadvise/public_html/forums/applications/vanilla/views/modules/discussionfilter.php:64] Gdn_Pluggable->FireEvent();

[/home2/ytadvise/public_html/forums/library/core/class.module.php:114] PHP::include();

[/home2/ytadvise/public_html/forums/library/core/class.module.php:225] Gdn_Module->FetchView();

[/home2/ytadvise/public_html/forums/applications/vanilla/modules/class.discussionfiltermodule.php:25] Gdn_Module->ToString();

[/home2/ytadvise/public_html/forums/library/core/class.module.php:209] DiscussionFilterModule->ToString();

[/home2/ytadvise/public_html/forums/library/core/class.modulecollection.php:36] Gdn_Module->Render();

[/home2/ytadvise/public_html/forums/library/core/class.modulecollection.php:53] Gdn_ModuleCollection->Render();

[/home2/ytadvise/public_html/forums/library/vendors/SmartyPlugins/function.asset.php:46] Gdn_ModuleCollection->ToString();

[/home2/ytadvise/public_html/forums/cache/Smarty/compile/vanilla^%%44^443^443A4C91%%default.master.tpl.php:47] PHP::smarty_function_asset();

[/home2/ytadvise/public_html/forums/library/vendors/Smarty-2.6.25/libs/Smarty.class.php:1276] PHP::include();

[/home2/ytadvise/public_html/forums/library/vendors/Smarty-2.6.25/libs/Smarty.class.php:1126] Smarty->fetch();

[/home2/ytadvise/public_html/forums/library/core/class.smarty.php:124] Smarty->display();

[/home2/ytadvise/public_html/forums/library/core/class.controller.php:1875] Gdn_Smarty->Render();

[/home2/ytadvise/public_html/forums/library/core/class.controller.php:1352] Gdn_Controller->RenderMaster();

[/home2/ytadvise/public_html/forums/library/core/class.pluggable.php:210] Gdn_Controller->xRender();

[/home2/ytadvise/public_html/forums/applications/vanilla/controllers/class.discussionscontroller.php:166] Gdn_Pluggable->__call();

[/home2/ytadvise/public_html/forums/applications/vanilla/controllers/class.discussionscontroller.php:166] DiscussionsController->Render();

[/home2/ytadvise/public_html/forums/applications/vanilla/controllers/class.discussionscontroller.php:166] DiscussionsController->Index();

[/home2/ytadvise/public_html/forums/library/core/class.dispatcher.php:350] PHP::call_user_func_array();

[/home2/ytadvise/public_html/forums/index.php:46] Gdn_Dispatcher->Dispatch();

Variables in local scope:

[Sql] 'select count(DISTINCT d.DiscussionID) as NumUnresolved
from GDN_Discussion d
where d.Resolved = :dResolved'

[InputParameters] array (
':dResolved' => 0,
)

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

[ReturnType] 'DataSet'

[PDOStatement] false

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.1.11
PHP Version: 5.5.27
Operating System: Linux
Server Software: Apache
Referer: http://forums.yourtechadvisors.com/entry/signin
User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:40.0) Gecko/20100101 Firefox/40.0
Request Uri: /discussions
Controller: Gdn_Database
Method: Query

`

peregrine

are you using the resolved plugin?

try disabling it.

see if it fixes problem.

then if it does enable the plugin from the dashboard (NOT by changing config statement).

ytadvisors

@peregrine said:
are you using the resolved plugin?

try disabling it.

see if it fixes problem.

then if it does enable the plugin from the dashboard (NOT by changing config statement).

It is fixed, thank you.

mtschirs

You just came across an instance of this unresolved problem.

(get it? because all his resolved flags have been dropped )

peregrine

@mtschirs said:
You just came across an instance of this unresolved problem.

(get it? because all his resolved flags have been dropped )

maybe they were dropped. who knows what people do

but he didn't even have the column in the table, yet he had the resolved plugin enabled. So he may have copied a config from somewhere that had it enabled.
Stranger things have happened.

many people think they can enable plugins by just changing the config, but don't realize routing and database set up might also take place which doesn't happen if enabling via config file.