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.

My forum is messed up bad

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.

Comments

  • `
    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
    

    `

  • 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).

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • @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.

  • mtschirsmtschirs ✭✭✭
    edited September 2015

    You just came across an instance of this unresolved :glasses: problem.

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

  • peregrineperegrine MVP
    edited September 2015

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

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

    maybe they were dropped. who knows what people do :wink:

    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.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

Sign In or Register to comment.