
12-26-2004, 07:59 PM
|
|
|
Join Date: Dec 2004
Posts: 944
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Shy about 2,000 users and I got this error.
Quote:
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT postid, thread.title, post.dateline , IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.replycount, thread.votenum, thread.votetotal
FROM myvb3_post AS post
INNER JOIN myvb3_thread AS thread ON(thread.threadid = post.threadid)
LEFT JOIN myvb3_deletionlog AS delthread ON(delthread.primaryid = post.threadid AND delthread.type = 'thread')
LEFT JOIN myvb3_deletionlog AS delpost ON(delpost.primaryid = post.postid AND delpost.type = 'post')
WHERE (postid IN(151, 152, 167, 177, 182, 191, 196, 202, 206, 207, 208, 215, 216, 217, 218, 226, 229, 234, 239, 240, 242, 340, 342, 403, 472, 473, 477, 1488, 1490, 1908, 1910, 1917, 2200, 3048, 3140) OR postid IN()) AND post.dateline > 1104093229 AND thread.replycount >= 1
AND delthread.primaryid IS NULL
AND delpost.primaryid IS NULL
AND post.visible = 1
mysql error: You have an error in your SQL syntax near ')) AND post.dateline > 1104093229 AND thread.replycount >= 1
AND delthread.pr' at line 8
mysql error number: 1064
|
and I got this in email.
Quote:
Activation Reminder Script run on 12-26-2004 at 04:26 PM.
3 Day Reminder Sent To:
None
5 Day Reminder Sent To:
None
8 Day Reminder Sent To:
None
Deleted Users:
No one was deleted
|
I used the php version that was in the fourm here that had a more detailed output.
Please and thank you.
|