Bug Invaild SQL

[Grumpy]

Matt,

Encountered this error since 1.1.6 install. Don't know if it something that needs looking into or not?

Database error in vBulletin 4.2.2:

Invalid SQL:

                SELECT
                        COUNT(*) AS count
                FROM (
                        SELECT
                                COUNT(*) AS count
                        FROM dbtech_classifieds_listing AS l
                        LEFT JOIN dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
                        LEFT JOIN attachment AS a ON l.attachmentid = a.attachmentid
                        LEFT JOIN filedata AS f ON a.filedataid = f.filedataid
                        LEFT JOIN user AS u ON u.userid = l.userid
                        WHERE  AND l.enddate > 1401314268
                        AND l.ended = 0
                        AND l.moderated = 0
            AND l.enddate > 1401227868
            AND l.cancelled = 0
            GROUP BY l.listingid
    ) AS total;

MySQL Error   : You have an error in your SQL syntax; check the manual  that corresponds to your MySQL server version for the right syntax to  use near 'AND l.enddate > 1401314268
                        AND l.ended = 0
                        AND l.moderated = 0
            AND l.' at line 11
Error Number  : 1064
Request Date  : Tuesday, May 27th 2014 @ 04:57:48 PM
Error Date    : Tuesday, May 27th 2014 @ 04:57:48 PM
Script        : [URL]http://www.mysite.com/classifieds/[/URL][]=-1&categorychild=1&do=search&dosearch=Search&exactname=1&keywords=1&keywordstype=1&listingtypes[]=-1&orderby=descending&searchdate=1&searchscope=1&securitytoken=guest&sortby=dateline&username=1

 

[Mokonzi]

Interesting one. Thanks for the report.

 

[Grumpy]

I got the same error message again today around the same time but with a different end date (14013140050) which is about a day different.

Something is definitely going on here. I wasn't getting any errors when running 1.1.5

 

[Mokonzi]

Someone is running a type of search that wasn't run before, perhaps one they've not got saved. Or it might be a search engine making the searches.

Whatever is the case, I've got a fix sorted for the next update. The error has been there for a while, but it looks like no one tried that specific combination before which is why it's not showed up.

 

[Grumpy]

Thanks Matt I appreciate you looking into this.