Originally Posted by Dankness
(Post 1132663)
This is a execellent mod but lately iv been getting some weird DB errors maild to me from using this? Does anyone know why these errors are appearing all of a sudden?
Im usign VB 3.6.4 also
Code:
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT thread.*, post.pagetext AS preview, post.userid AS lastpuserid
FROM vb3thread AS thread
LEFT JOIN vb3deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN vb3post AS post ON(post.postid = thread.lastpostid)
WHERE open <> 10 AND thread.lastpostid > 43469
AND forumid NOT IN (0,49,50,51,22,40,136,163,32,23,31,38,43,48,56,112,134,113,114,115,116,117,118,119,122,123,124,125,126,127,128,129,130,120,131,132,133,)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 10;
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 thread.visible = '1'
AND deletionlog.primaryid
Error Number : 1064
Date : Tuesday, December 5th 2006 @ 01:46:44 PM
Script : http://www.villu-reborn.com/vaispy.php?do=xml&last=43469&r=0.0840441166388669&_=
Referrer : http://www.villu-reborn.com/vaispy.php
IP Address : 67.126.202.236
Username : TOB
Classname : vB_Database
=====================================================
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT *
FROM vb3session
WHERE sessionhash = 'bdce42f7e1d317b047a3dc7e49429ded'
AND lastactivity > 1165344136
AND idhash = '7b36de2b030fce6f3b1a836591791a87';
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Tuesday, December 5th 2006 @ 01:58:20 PM
Script : http://www.villu-reborn.com/vaispy.php?do=xml&last=43471&r=0.49022190606534977&_=
Referrer : http://www.villu-reborn.com/vaispy.php
IP Address :
Username :
Classname : vB_Database
=====================================================
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT *
FROM vb3session
WHERE sessionhash = '9d818bc112fde35ebc591b04907f1765'
AND lastactivity > 1165346474
AND idhash = 'ce5f7ee9179f6b9722a5610947e86ed5';
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Tuesday, December 5th 2006 @ 02:36:33 PM
Script : http://www.villu-reborn.com/vaispy.php?do=xml&last=43474&r=0.8675544199068099&_=
Referrer : http://www.villu-reborn.com/vaispy.php
IP Address :
Username :
Classname : vB_Database
=====================================================
Thank you for your time.
|
More Information