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 :