Hey Mokonzi,
I am not sure what this one is from but I found it while I was looking at the feedback error that members are having...
=====================================================
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT
l.*,
l.userid AS luserid,
li.listingitemid,
a.*,
f.*
FROM theforumprefix__dbtech_classifieds_listing AS l
LEFT JOIN theforumprefix__dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
LEFT JOIN theforumprefix__attachment AS a ON l.attachmentid = a.attachmentid
LEFT JOIN theforumprefix__filedata AS f ON a.filedataid = f.filedataid
WHERE l.userid IN ()
AND l.enddate > 1393274253
AND l.startdate < 1393274253
AND l.ended = 0
AND l.active = 1
AND l.listingid IN (79,71,70,72,80)
AND l.moderated = 0
GROUP BY l.listingid
LIMIT 0;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
AND l.enddate > 1393274253
AND l.startdate < 1393274253
AND l.ended =' at line 11
Error Number : 1064
Request Date : Monday, February 24th 2014 @ 08:37:33 PM
Error Date : Monday, February 24th 2014 @ 08:37:33 PM
Script : http://www.digitalworldz.co.uk/showthread.php?t=289618&page=2
Referrer :
IP Address : 66.249.76.24
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
=====================================================
Cheers
Mick
I am not sure what this one is from but I found it while I was looking at the feedback error that members are having...
=====================================================
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT
l.*,
l.userid AS luserid,
li.listingitemid,
a.*,
f.*
FROM theforumprefix__dbtech_classifieds_listing AS l
LEFT JOIN theforumprefix__dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
LEFT JOIN theforumprefix__attachment AS a ON l.attachmentid = a.attachmentid
LEFT JOIN theforumprefix__filedata AS f ON a.filedataid = f.filedataid
WHERE l.userid IN ()
AND l.enddate > 1393274253
AND l.startdate < 1393274253
AND l.ended = 0
AND l.active = 1
AND l.listingid IN (79,71,70,72,80)
AND l.moderated = 0
GROUP BY l.listingid
LIMIT 0;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
AND l.enddate > 1393274253
AND l.startdate < 1393274253
AND l.ended =' at line 11
Error Number : 1064
Request Date : Monday, February 24th 2014 @ 08:37:33 PM
Error Date : Monday, February 24th 2014 @ 08:37:33 PM
Script : http://www.digitalworldz.co.uk/showthread.php?t=289618&page=2
Referrer :
IP Address : 66.249.76.24
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
=====================================================
Cheers
Mick
