The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Database Error
I have two database errorrs:
1 - Invalid SQL: SELECT postidFROM post AS postINNER JOIN thread AS thread ON(thread.threadid = post.threadid)WHERE post.userid = 5685AND post.post_thanks_amount != 0AND thread.forumid IN(1,2,3,13,95,96,97,31,22,90,33,34,36,83,84,12,32 ,10,81,91,37,11,6,26,4,23,71,75,74,80,73,54,98,5,2 9,55,57,56,58,87,60,63,62,64,65,66,67,68,69,70,24, 28,39,21,99,53,52,40,82,85,86,19,20)ORDER BY post.dateline DESCLIMIT 1000; MySQL Error : Unknown column 'post.post_thanks_amount' in 'where clause'Error Number : 1054Request Date : Wednesday, February 16th 2011 @ 05:42:07 PMError Date : Wednesday, February 16th 2011 @ 05:42:07 PMScript : http://www.stylers.com.ar/post_thank...dthanks&u=5685 2- And the most important SELECT album.*, > picture.pictureid, picture.extension, picture.idhash, > picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height, > user.* > FROM album AS album > LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0) > LEFT JOIN user AS user ON (album.userid = user.userid) > WHERE album.state IN ('public', 'private', 'profile') > ORDER BY > LIMIT 0, 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 'LIMIT 0, 10' at line 10 > Error Number : 1064 > Request Date : Sunday, February 13th 2011 @ 02:35:14 PM > Error Date : Sunday, February 13th 2011 @ 02:35:15 PM > Script : http://stylers.com.ar/all_albums.php > Referrer : |
#2
|
||||
|
||||
Those errors are from modifications. You will need to post in each modification for help with the error. We cannot help you out in the main forums.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|