[Stoebi]

Hi

Plugin 'Main Doublepost Prevent Engine' - Hook newpost_complete


Search for:

AND dateline > " . (TIMENOW - $vbulletin->options['xen_dp_timespan'] * 60) . "

Change to:

AND post.dateline > " . (TIMENOW - $vbulletin->options['xen_dp_timespan'] * 60) . "

Reason:
With vBulletin v3.6.x the row dateline exists in the tables post and deletionlog (ambiguous).



Regards, Stoebi

Originally Posted by Yorixz

Database error in vBulletin 3.6.0 Beta 3:

Invalid SQL:

               SELECT post.*
               FROM vb3_post AS post
               LEFT JOIN vb3_deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
               WHERE threadid = 47971
                       AND dateline > 1151567543
                       AND visible = 1 AND deletionlog.primaryid IS NULL
                       AND postid <> 409299
               ORDER BY dateline DESC
               LIMIT 1;

MySQL Error  : Column 'dateline' in where clause is ambiguous

I'm getting that error quite often, didn't manage to reproduce it but I suppose theres something wrong in the query it's using.