markoroots
Customer
Hi Fillip,
are still arriving to me those errors emails relative to the Review plugin.
Here one of these messages:
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT
entry.*,
user.username,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid,
receiveduser.username AS receivedusername,
receiveduser.usergroupid AS receivedusergroupid,
receiveduser.membergroupids AS receivedmembergroupids,
receiveduser.infractiongroupid AS receivedinfractiongroupid,
receiveduser.displaygroupid AS receiveddisplaygroupid
FROM (
(
SELECT
post.postid,
post.title AS posttitle,
post.pagetext AS pagetext,
thread.title AS threadtitle,
thread.title AS title,
thread.threadid,
thread.forumid,
entry_post.*
FROM dbtech_thanks_entry AS entry_post
LEFT JOIN post AS post ON (post.postid = entry_post.contentid)
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
WHERE entry_post.entryid IN(2718, 2717, 2716, 2715, 2714, 2713, 2710, 2702, 2701, 2700, 2699, 2698, 2697, 2696, 2695, 2694, 2693, 2692, 2691)
AND post.visible = 1
) UNION ALL (
SELECT
review.reviewid AS postid,
review.title_clean AS posttitle,
review.short_text AS pagetext,
review.title_clean AS threadtitle,
review.title_clean AS title,
review_instance.shortname AS threadid,
0 AS forumid,
entry_dbreview_review.*
FROM dbtech_thanks_entry AS entry_dbreview_review
LEFT JOIN dbtech_review_reviews AS review ON (review.reviewid = entry_dbreview_review.contentid)
LEFT JOIN dbtech_review_instances AS review_instance ON (review_instance.instanceid = review.instanceid)
WHERE entry_dbreview_review.entryid IN(2719)
)
) AS entry
LEFT JOIN user AS user ON(user.userid = entry.userid)
LEFT JOIN user AS receiveduser ON(receiveduser.userid = entry.receiveduserid)
ORDER BY entryid DESC
LIMIT 20;
MySQL Error : Unknown column 'review.short_text' in 'field list'
Error Number : 1054
Request Date : Monday, July 20th 2015 @ 07:06:33 PM
Error Date : Monday, July 20th 2015 @ 07:06:33 PM
Script : Vaporizer Forum Database Error
Referrer : Vaporizer Forum
IP Address : 93.58.31.180
Username : Admin
Classname : vB_Database_MySQLi
MySQL Version : 5.5.43-37.2-log
What to do?
And also from when I have load the last fix for this problem all the profiles are inaccessible.
Vaporizer Forum (for all the users) go in error.
are still arriving to me those errors emails relative to the Review plugin.
Here one of these messages:
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT
entry.*,
user.username,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid,
receiveduser.username AS receivedusername,
receiveduser.usergroupid AS receivedusergroupid,
receiveduser.membergroupids AS receivedmembergroupids,
receiveduser.infractiongroupid AS receivedinfractiongroupid,
receiveduser.displaygroupid AS receiveddisplaygroupid
FROM (
(
SELECT
post.postid,
post.title AS posttitle,
post.pagetext AS pagetext,
thread.title AS threadtitle,
thread.title AS title,
thread.threadid,
thread.forumid,
entry_post.*
FROM dbtech_thanks_entry AS entry_post
LEFT JOIN post AS post ON (post.postid = entry_post.contentid)
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
WHERE entry_post.entryid IN(2718, 2717, 2716, 2715, 2714, 2713, 2710, 2702, 2701, 2700, 2699, 2698, 2697, 2696, 2695, 2694, 2693, 2692, 2691)
AND post.visible = 1
) UNION ALL (
SELECT
review.reviewid AS postid,
review.title_clean AS posttitle,
review.short_text AS pagetext,
review.title_clean AS threadtitle,
review.title_clean AS title,
review_instance.shortname AS threadid,
0 AS forumid,
entry_dbreview_review.*
FROM dbtech_thanks_entry AS entry_dbreview_review
LEFT JOIN dbtech_review_reviews AS review ON (review.reviewid = entry_dbreview_review.contentid)
LEFT JOIN dbtech_review_instances AS review_instance ON (review_instance.instanceid = review.instanceid)
WHERE entry_dbreview_review.entryid IN(2719)
)
) AS entry
LEFT JOIN user AS user ON(user.userid = entry.userid)
LEFT JOIN user AS receiveduser ON(receiveduser.userid = entry.receiveduserid)
ORDER BY entryid DESC
LIMIT 20;
MySQL Error : Unknown column 'review.short_text' in 'field list'
Error Number : 1054
Request Date : Monday, July 20th 2015 @ 07:06:33 PM
Error Date : Monday, July 20th 2015 @ 07:06:33 PM
Script : Vaporizer Forum Database Error
Referrer : Vaporizer Forum
IP Address : 93.58.31.180
Username : Admin
Classname : vB_Database_MySQLi
MySQL Version : 5.5.43-37.2-log
What to do?
And also from when I have load the last fix for this problem all the profiles are inaccessible.
Vaporizer Forum (for all the users) go in error.
Last edited: