Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product

Plugin throwing out a bunch of errors

This discussion is related to the Voting addon.
jhayes88jhayes88 New
edited January 25 in Vanilla 2.6 Help

Hi, I'm having big problems trying to get this plugin to work. This seems like a plugin that could be really useful on my forums. After activating this plugin, I receive the following errors when I open up any discussion https://pastebin.com/nm42gDbr

Another bug possible off topic -- After deactivating the plugin, it didn't properly deactivate it so I had to edit config.php and change $Configuration['EnabledPlugins']['Voting'] = true; to false. I was worried it was a bigger problem than that but luckily that's all it took to repair it.

I deleted cache and got a different error below when trying the plugin again

Unknown column 'coalesce(c.Score' in 'order clause'
The error occurred on or near: /home/foxholeforums/public_html/library/database/class.database.php
403: // If we get here then the pdo statement prepared properly.
404: break;
405:
406: } catch (Gdn_UserException $uex) {
407: trigger_error($uex->getMessage(), E_USER_ERROR);
408: } catch (Exception $ex) {
409: list($state, $code, $message) = $pDO->errorInfo();
410:
411: // If the error code is consistent with a disconnect, attempt to retry
Backtrace:
/home/foxholeforums/public_html/library/database/class.database.phpPHP::gdn_ErrorHandler();
[/home/foxholeforums/public_html/library/database/class.database.php:407] PHP::trigger_error();
[/home/foxholeforums/public_html/library/database/class.sqldriver.php:1707] Gdn_Database->query();
[/home/foxholeforums/public_html/library/database/class.sqldriver.php:664] Gdn_SQLDriver->query();
[/home/foxholeforums/public_html/applications/vanilla/models/class.commentmodel.php:300] Gdn_SQLDriver->get();
[/home/foxholeforums/public_html/applications/vanilla/controllers/class.discussioncontroller.php:162] CommentModel->getByDiscussion();
[/home/foxholeforums/public_html/library/core/class.dispatcher.php:845] DiscussionController->index();
[/home/foxholeforums/public_html/library/core/class.dispatcher.php:274] Gdn_Dispatcher->dispatchController();
[/home/foxholeforums/public_html/index.php:29] Gdn_Dispatcher->dispatch();
Variables in local scope:
[sql] 'select c.*
from GDN_Comment c
join (select CommentID
from GDN_Comment c
where c.DiscussionID = 28
order by coalesce(c.Score asc, 0) desc, c.CommentID asc
limit 20) c2 on c.CommentID = c2.CommentID'
[inputParameters] array (
)
[options] array (
'Type' => 'select',
'Slave' => NULL,
'ReturnType' => 'DataSet',
)
[returnType] 'DataSet'
[tries] 2
[try] 0
[pDO] array (
)
[pDOStatement] false
[state] '42S22'
[code] 1054
[message] 'Unknown column \'coalesce(c.Score\' in \'order clause\''
[uex] array (
)

Additional information for support personnel:
Application: Vanilla
Application Version: 2.6.4
PHP Version: 7.0.33
Operating System: Linux
Server Software: Apache
Referer: categories/forum-announcements
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36
Request Uri: /discussion/28/forum-icons-and-other-tweaks
Controller: PHP
Method: gdn_ErrorHandler

If you have any idea as to what I should do, I'd much appreciate it. I don't know how to get this plugin to work :( Deactivating other plugins and applications didn't help either. Thanks

Comments

  • Update:

    Installed brand new fresh copy of vanilla forums on a subdomain and enabled this plugin. Still gave me issues.

    Fatal Error in PHP.gdn_ErrorHandler();
    Unknown column 'coalesce(c.Score' in 'order clause'
    The error occurred on or near: /home/foxholeforums/dev/library/database/class.database.php
    403: // If we get here then the pdo statement prepared properly.
    404: break;
    405:
    406: } catch (Gdn_UserException $uex) {
    407: trigger_error($uex->getMessage(), E_USER_ERROR);
    408: } catch (Exception $ex) {
    409: list($state, $code, $message) = $pDO->errorInfo();
    410:
    411: // If the error code is consistent with a disconnect, attempt to retry
    Backtrace:
    /home/foxholeforums/dev/library/database/class.database.phpPHP::gdn_ErrorHandler();
    [/home/foxholeforums/dev/library/database/class.database.php:407] PHP::trigger_error();
    [/home/foxholeforums/dev/library/database/class.sqldriver.php:1707] Gdn_Database->query();
    [/home/foxholeforums/dev/library/database/class.sqldriver.php:664] Gdn_SQLDriver->query();
    [/home/foxholeforums/dev/applications/vanilla/models/class.commentmodel.php:300] Gdn_SQLDriver->get();
    [/home/foxholeforums/dev/applications/vanilla/controllers/class.discussioncontroller.php:162] CommentModel->getByDiscussion();
    [/home/foxholeforums/dev/library/core/class.dispatcher.php:845] DiscussionController->index();
    [/home/foxholeforums/dev/library/core/class.dispatcher.php:274] Gdn_Dispatcher->dispatchController();
    [/home/foxholeforums/dev/index.php:29] Gdn_Dispatcher->dispatch();
    Variables in local scope:
    [sql] 'select c.*
    from GDN_Comment c
    join (select CommentID
    from GDN_Comment c
    where c.DiscussionID = 1
    order by coalesce(c.Score asc, 0) desc, c.CommentID asc
    limit 30) c2 on c.CommentID = c2.CommentID'
    [inputParameters] array (
    )
    [options] array (
    'Type' => 'select',
    'Slave' => NULL,
    'ReturnType' => 'DataSet',
    )
    [returnType] 'DataSet'
    [tries] 2
    [try] 0
    [pDO] array (
    )
    [pDOStatement] false
    [state] '42S22'
    [code] 1054
    [message] 'Unknown column \'coalesce(c.Score\' in \'order clause\''
    [uex] array (
    )

  • I use it on 2.6.4 (and 2 previous versions).
    Recall having some issue at first.
    Pretty sure I found a solution in the comments on the plugin.

    Sorry, can't test or search for it now. At work.

  • jhayes88jhayes88 New
    edited January 25

    @Kaspar said:
    I use it on 2.6.4 (and 2 previous versions).
    Recall having some issue at first.
    Pretty sure I found a solution in the comments on the plugin.

    Sorry, can't test or search for it now. At work.

    Hmm. I think I found the comment you're talking about. Looking into it now.

    Edit: My PHP knowledge is limited and their explanation is a little advanced. hmm

  • Ah, sorry man.
    I might recall correct about having issue.
    But I was totally off regarding the actual plugin.
    I use this
    https://open.vanillaforums.com/addon/discussionpolls-plugin

Sign In or Register to comment.