Bug:
DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 25, 1, 15, 3, 19, 27, 12, 9, 24, 26, 5, 4, 6, 22, 10, 17, 28, 11, 13, 21, 29, 14, 16, 18, 8, 23) ORDER BY i.image_rating DESC, i.image_votes DESC
Unknown column 'i.user_id' in 'on clause'
mini_top.php
line 27:
FROM ".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c
Replace:
FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
Thx - a lot!
2 questions:
1) I see most voted, most rated and most viewed.. what about most downloaded and commented?!
2) What should I modify in mini_top.php or elsewhere to act like this:
I want to see that most ... images like those from new images - reffering to style.. on mouseover ..
See the attached pic and u will understand.