[M.C.]

strange but straight after changing The ID number of news forum i`ve got MySQL error:

PHP Code:

Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
              , avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline  
              ,thread.iconid 
               ,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize 
                FROM thread AS thread
                LEFT JOIN post AS post ON (post.postid = thread.firstpostid) 
                LEFT JOIN user AS user ON (user.userid = post.userid) 
                LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
                LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)  
                LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
                WHERE forumid IN(3)
                GROUP BY post.postid
                ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous

mysql error number: 1052

Date: Sunday 25th of January 2004 08:58:22 PM
Script: http://localhost/adv_index.php?styleid=2
Referer: 
Username: M.C.
IP Address: 127.0.0.1 


I was testing on localhost that hack when i got that...

What i did wrong?

Ok i got it, I disabled "show attachements" and it`s work fine, BUT i want it work fine with "show attachements" enabled

And one more strange thing - in installation a gave right icons path (http://localhost/forum/images/icons/icon1.gif), but it show path like that: http://localhost/images/icons/icon1.gif

And for emprovement of hack i`d love to have option to change blocks position (left, right, center and up and down)

Thanks!