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
After February 6, this site will no longer have Facebook, Twitter, or OpenID sign-in options. Read our announcement about social media SSO support in 2.8 for more info.

Make sure you have a current, valid email address set in your profile and set a password so you can login without it. If you get locked out after that time, you can choose "Forgot Password" to fix it as long as a valid email is on your account.

I am Getting " Something has gone wrong" error after instaliing some plugins. Can some one help ?

Fatal Error in PHP.gdn_ErrorHandler();
Unknown column 'coalesce(c.Score' in 'order clause'
The error occurred on or near: /home/natnitne/talk.natnit.net/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/natnitne/talk.natnit.net/library/database/class.database.phpPHP::gdn_ErrorHandler();
[/home/natnitne/talk.natnit.net/library/database/class.database.php:407] PHP::trigger_error();
[/home/natnitne/talk.natnit.net/library/database/class.sqldriver.php:1707] Gdn_Database->query();
[/home/natnitne/talk.natnit.net/library/database/class.sqldriver.php:664] Gdn_SQLDriver->query();
[/home/natnitne/talk.natnit.net/applications/vanilla/models/class.commentmodel.php:300] Gdn_SQLDriver->get();
[/home/natnitne/talk.natnit.net/applications/vanilla/controllers/class.discussioncontroller.php:162] CommentModel->getByDiscussion();
[/home/natnitne/talk.natnit.net/library/core/class.dispatcher.php:845] DiscussionController->index();
[/home/natnitne/talk.natnit.net/library/core/class.dispatcher.php:274] Gdn_Dispatcher->dispatchController();
[/home/natnitne/talk.natnit.net/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 = 2
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 (
)
Need Help?

Here is the message I am getting . Let me know what Iam doing wrong.

Comments

Sign In or Register to comment.