Bug Database error after upgrade

[angeljs]

When trying to view a post I'm receiving the following error message:

Database error in vBulletin 4.2.3:


Invalid SQL:
(
                SELECT COUNT(*) AS count, varname
                FROM dbtech_thanks_entry AS entry,
                   (
                       SELECT postid
                    FROM post
                    WHERE threadid = 2563
                        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 dbtech_thanks_entry AS entry,
                   (
                       SELECT postid
                    FROM post
                    WHERE threadid = 2563
                        AND visible IN (1,2,0)
                   ) AS tmp
                WHERE entry.contenttype = 'post'
                    AND entry.varname = 'likes'
                    AND contentid = tmp.postid
            ) UNION ALL (
                SELECT COUNT(*) AS count, varname
                FROM dbtech_thanks_entry AS entry,
                   (
                       SELECT postid
                    FROM post
                    WHERE threadid = 2563
                        AND visible IN (1,2,0)
                   ) AS tmp
                WHERE entry.contenttype = 'post'
                    AND entry.varname = 'dislikes'
                    AND contentid = tmp.postid
            );


MySQL Error   : Column 'varname' cannot be null
Error Number  : 1048
Request Date  : Saturday, June 18th 2016 @ 07:41:08 PM
Error Date    : Saturday, June 18th 2016 @ 07:41:09 PM
Script        : http://www.simfansuk.com/sims/threads/2563-Impossible-to-Install-or-quot-Doesn-t-Work-quot-questions
Referrer      : http://www.simfansuk.com/sims/forums/194-Sims-2
IP Address    : 86.175.82.36
Username      : LadyAngel
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.96-community-log

 

[Fillip H.]

Your version of MySQL is too old, could you please upgrade to a more modern version of MySQL?

If this is not an option for you, please turn off the Display Button Click Count - Threads and Display Button Click Count - Forums settings in the vBulletin Options for this mod.

 

[angeljs]

Okay, thank you for your fast response.

 

[DragonByte Technologies]

Hello angeljs,

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!