hello please help.
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
(
SELECT COUNT(*) AS count, varname
FROM dbtech_thanks_entry AS entry,
(
SELECT postid
FROM post
WHERE threadid = 317911
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 = 317911
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 = 317911
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 : Monday, May 2nd 2016 @ 06:09:20 AM
Error Date : Monday, May 2nd 2016 @ 06:09:20 AM
Script : http://domain.net/showthread.php?317911
Referrer : http://domain.net/index.php
IP Address : ddd.11..222.
Username : Sparta
Classname : vB_Database
MySQL Version : 5.0.96-community-log