
09-07-2006, 02:23 AM
|
|
|
Join Date: Mar 2006
Location: Turkey
Posts: 67
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Code:
Database error in vBulletin 3.6.0:
Invalid SQL:
SELECT post.*
FROM uzakdurpost AS post
LEFT JOIN uzakdurdeletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE threadid = 5503
AND dateline > 1157509558
AND visible = 1 AND deletionlog.primaryid IS NULL
ORDER BY dateline DESC
LIMIT 1;
MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Date : Thursday, September 7th 2006 @ 05:25:58 AM
Script : http://www.hitportal.net/newreply.php
Referrer : http://www.hitportal.net/showthread.php?t=5503
IP Address : xx.xx.xx.xxx
Username : Cagonni
Classname : vb_database
This is the mail i read.Your sql code includes
WHERE threadid = 8
AND post.dateline > 1155014895
should i do this for all threadid an post datelines?For example
WHERE threadid = 5503
AND dateline > 1157509558
because this error valid for all my forum categories.
|