In addition to upgrading to the latest version -
The privatemessage table does not have fields named `hidemsg` or `newmsg`. The most likely cause of this error is an improperly installed or malfunctioning addon.
Announcement
Collapse
No announcement yet.
Database error
Collapse
X
-
Database error
Although the board appears to work well, I keep getting the following notification by email, it always refers to the same thing, the "unknown column".
Database error in vBulletin 5.4.4:
Invalid SQL:
SELECT count(node.nodeid) AS qty
FROM sentto AS s
INNER JOIN node AS node ON node.nodeid = s.nodeid
INNER JOIN privatemessage AS pm ON pm.nodeid = s.nodeid
WHERE s.folderid = 44 AND s.deleted = 0 AND pm.hidemsg = 0 AND pm.newmsg = 1 /**getNewNotificationRequestCount**/;
MySQL Error : Unknown column 'pm.hidemsg' in 'where clause'
Error Number : 1054
Request Date : Tuesday, March 19th 2019 @ 03:00:57 AM
Error Date : Tuesday, March 19th 2019 @ 03:00:57 AM
Script : https://www.forum.ukcen.com/ajax/api...AndAlertsCount
Referrer : https://www.forum.ukcen.com/articles
IP Address : 90.252.11.136
Username : Site Admin
Classname : vB_Database_MySQLi
MySQL Version : 5.6.40-84.0-log
Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 557
#3 vB_Database->query_read() called in [path]/vb/db/result.php on line 126
#4 vB_dB_Result->rewind() called in [path]/vb/db/result.php on line 63
#5 vB_dB_Result->__construct() called in [path]/vb/db/query/stored.php on line 104
#6 vB_dB_Query_Stored->execSQL() called in [path]/vb/db/assertor.php on line 301
#7 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 625
#8 vB_dB_Assertor->getRow() called in [path]/packages/livenotifications/include/notifications.php on line 50
#9 LiveNotifications_Include_Notifications->getNotificationCount() called in [path]/packages/livenotifications/include/notifications.php on line 87
#10 LiveNotifications_Include_Notifications->getNewNotificationRequestCount() called in [path]/packages/livenotifications/api/ln/ajax.php on line 146
#11 LiveNotifications_Api_Ln_Ajax->getMessageAndAlertsCount() called in on line
#12 ReflectionMethod->invokeArgs() called in [path]/vb/api.php on line 303
#13 vB_Api->callNamed() called in [path]/vb/api/extensions.php on line 581
#14 vB_Api_Extensions->callNamed() called in [path]/vb/api/wrapper.php on line 217
#15 vB_Api_Wrapper->__call() called in [path]/vb/api/wrapper.php on line 127
#16 vB_Api_Wrapper->callNamed() called in /home/ukcen979/public_html/forum/includes/api/interface/collapsed.php on line 97Tags: None
Related Topics
Collapse
-
by migratoriaError after upgrade 5.6.2 to 5.6.3
Can anyone help me investigate this error?
Database error in vBulletin 5.6.3:
Invalid SQL:
SELECT DISTINCT CASE WHEN starter.nodeid...-
Channel: Support Issues & Questions
Fri 11 Sep '20, 11:09am -
-
by holymannnHi, I am having the database error quite often after i upgraded my vb from 5.6.0 to 5.6.3 and also the vb5 database tools. The database error always on activity-stream-tab. Anyone can help?
...-
Channel: Support Issues & Questions
Sun 27 Sep '20, 7:05am -
-
hi
I'm receiving this errors weekly 2 or three times, please help in providing solutions.
PHP Code:Database error in vBulletin 5.4.1:
Invalid SQL:
INSERT
-
Channel: Support Issues & Questions
Sun 27 May '18, 1:17am -
-
by naponlineHi,
after several database errors - e.g. the last one:
I now have a fatal error if visiting my site at http://forum.napoleon-online.de
I'm really...-
Channel: Support Issues & Questions
Thu 10 Sep '20, 12:51am -
-
by elektro-kotHello!
Sometimes (several times a week, in the morning) I get several error reports on my eMail
Error numbers - 1270 and 1271
What could be the problem?
Add in more...-
Channel: Support Issues & Questions
Wed 6 May '20, 1:02am -
Leave a comment: