I get this error after update
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 = 11569
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 = 11569
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 = 11569
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, April 30th 2016 @ 11:03:18 AM
Error Date : Saturday, April 30th 2016 @ 11:03:19 AM
Script :
http://---------------/showthread.php?t=11569&p=228792
Referrer :
http://------------------/index.php
IP Address : 94.164.34.84
Username : Paolo
Classname : vB_Database_MySQLi
MySQL Version : 5.0.92-enterprise-gpl-log