Bug Emails Errors

Status
Not open for further replies.

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.
 
Last edited:
This has been fixed in the latest version of the Advanced Post Thanks / Like product :)
 
Hello markoroots,

This ticket has now been closed with the status Not A Bug.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!
 
Status
Not open for further replies.

Legacy DragonByte Reviews

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