Bug DB Error

Big-Pete · Apr 23, 2016

Just updated the site from vB4.1.12PL4 to vB4.2.2pl4 and we're getting db errors on Thanks and user tagging..
Any pointers would be gratefully received

Regards
Pete

Fillip H. · Apr 23, 2016

Hi Pete,

Could you please provide more information? "An error" isn't really enough for me to assist you unfortunately

Big-Pete · Apr 23, 2016

Sorry Fillip H., I was trying to do multiple things at once and failed

Database error in vBulletin 4.2.2:

Invalid SQL:
(
SELECT COUNT(*) AS count, varname
FROM vb3_dbtech_thanks_entry AS entry,
(
SELECT postid
FROM vb3_post
WHERE threadid = 225020
AND visible IN (1,2,0)
) AS tmp
WHERE entry.contenttype = 'post'
AND entry.varname = 'thanks'
AND contentid = tmp.postid
) UNION ALL (
SELECT COUNT(*) AS count, varname
FROM vb3_dbtech_thanks_entry AS entry,
(
SELECT postid
FROM vb3_post
WHERE threadid = 225020
AND visible IN (1,2,0)
) AS tmp
WHERE entry.contenttype = 'post'
AND entry.varname = 'likes'
AND contentid = tmp.postid
);

Fillip H. · Apr 23, 2016

The bottom bit is missing, but it sounds like you are running a very old version of MySQL that does not support the syntax used in APTL. Could you please upgrade MySQL to 5.6?

DragonByte Technologies · May 7, 2016

Hello Big-Pete,

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!

Bug DB Error

Big-Pete

Fillip H.

Big-Pete

Fillip H.

DragonByte Technologies

Company Information

Similar threads

Legacy Advanced Post Thanks / Like

We value your privacy