CharlieDelta
Customer
When I click on a notification I get this database error using my admin account on Firefox.
I tested with my alternate account on Chrome and I don't have any issues. Strange.
Code:
Database error in vBulletin 4.2.3 Beta 3:
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(1352, 1351, 1350, 1349, 1348, 1346, 1345, 1344, 1343, 1342, 1341, 1340, 1335)
AND post.visible = 1
) UNION ALL (
SELECT
image.imageid AS postid,
IF(image.title_clean, image.title_clean, image.title) AS posttitle,
image.text AS pagetext,
image.filename AS threadtitle,
image.filename AS title,
image_instance.shortname AS threadid,
0 AS forumid,
entry_dbgallery_image.*
FROM dbtech_thanks_entry AS entry_dbgallery_image
LEFT JOIN dbtech_gallery_images AS image ON (image.imageid = entry_dbgallery_image.contentid)
LEFT JOIN dbtech_gallery_instances AS image_instance ON (image_instance.instanceid = image.instanceid)
WHERE entry_dbgallery_image.entryid IN(1339, 1338, 1337, 1336)
) 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(1347)
)
) 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 : Wednesday, May 6th 2015 @ 10:20:07 AM
Error Date : Wednesday, May 6th 2015 @ 10:20:09 AM
Script : http://www.archerandangler.com/forums/member.php?u=1&tab=activitystream
Referrer : http://www.archerandangler.com/forums/forum.php
IP Address : 70.49.255.53
Username : Outdoorsman
Classname : vB_Database_MySQLi
MySQL Version : 5.5.42-cll
I tested with my alternate account on Chrome and I don't have any issues. Strange.