| madness85 |
03-20-2015 07:57 PM |
Quote:
Originally Posted by TheLastSuperman
(Post 2541051)
Such as? Example? Copy/Paste the error... screenshot...
Anything other than "database error" will help us in-turn help you so if you can share, we'll be glad to offer suggestions.
|
sorry bit lazy of me
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT COUNT(*) AS threads,
(
SELECT COUNT(*) AS newthread
FROM thread AS thread
WHERE forumid =
AND lastpost > 1426871722
AND open <> 10
AND sticky = 0
AND thread.visible IN (0,1,2)
AND (thread.postuserid = 1
OR thread.forumid IN(3,205,204,236,196,2,235,7,52,22,71,228,156,157,171,172,173,227,185,72,8,240,177,169,224,10,13,11,97,64,16,15,217,94,17,18,19,184,136,21,32,178,202,215,46,150,152,230,175,239,221,222,223,195,154,176,231,232,155,101,141,140,143,219,220,23,197,206,207,208,209,210,211,212,213,214,25,191,28,119,29,226,199,9,233,148,182,50,51,90,170,216,192,194,91,165,168,92,163,164,161,225,162,167,166,36,37,65,144,145,198,93,187,188,190,67,68,189,229,234))
) AS newthread
FROM thread AS thread
WHERE forumid =
AND sticky = 0
AND thread.visible IN (0,1,2)
AND (thread.postuserid = 1
OR thread.forumid IN(3,205,204,236,196,2,235,7,52,22,71,228,156,157,171,172,173,227,185,72,8,240,177,169,224,10,13,11,97,64,16,15,217,94,17,18,19,184,136,21,32,178,202,215,46,150,152,230,175,239,221,222,223,195,154,176,231,232,155,101,141,140,143,219,220,23,197,206,207,208,209,210,211,212,213,214,25,191,28,119,29,226,199,9,233,148,182,50,51,90,170,216,192,194,91,165,168,92,163,164,161,225,162,167,166,36,37,65,144,145,198,93,187,188,190,67,68,189,229,234));
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 lastpost > 1426871722
AND open <> 10
AND sticky = 0
AND thread.vis' at line 6
Error Number : 1064
Request Date : Friday, March 20th 2015 @ 06:22:50 PM
Error Date : Friday, March 20th 2015 @ 06:22:50 PM
Classname : vB_Database
MySQL Version : 5.1.73
|
More Information