Bug Database Error

Status
Not open for further replies.

CharlieDelta

Customer
When I click on a notification I get this database error using my admin account on Firefox.
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.
 
Open the dbtech_review_reviews table and check if the column short_text exists :)
 
Try opening /dbtech/thanks/includes/sql/profileblock.php and find review.short_text AS pagetext, and replace with review.short_desc AS pagetext, and let me know if this resolves it for you.
 
Status
Not open for further replies.

Legacy vBNotifications

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
518
Customer rating
0.00 star(s) 0 ratings
Back
Top