Por favor, si alguien puede subir esta modificacion que es para que funcione el Doubleposting en el 3.6

http://www.vbulletin.org/forum/showp...&postcount=538

Search for:
Code:




**************************

Change to:
Code:



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



Regards, Stoebi

***********


Quote:
Originally Posted by Yorixz
Code:

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.

Gracias, te pasaste.. Muchas gracias.