4images Forum & Community
4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: JOBS on May 06, 2006, 09:29:56 AM
-
hi
I have a problem whit my site :? i dont know how to explane it so please take a look at
http://www.audiohagel.dk/index/index.php
?
DB Error: Bad SQL Query: SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images FROM new4_categories c LEFT JOIN new4_images i ON (i.cat_id = c.cat_id AND i.image_date >= 1144308138 AND i.image_active = 1) GROUP BY c.cat_id ORDER BY c.cat_order, c.cat_name ASC
Got error 28 from table handler
DB Error: Bad SQL Query: SELECT DISTINCT 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 new4_images i, new4_categories c LEFT JOIN new4_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0, 2, 3, 4, 5, 6, 7, 11, 12, 13, 16, 17, 18, 19, 20, 21, 23, 24, 26, 28, 29, 30, 31, 32, 33, 34, 35, 36, 38, 40, 41, 42, 43) AND c.cat_id = i.cat_id ORDER BY RAND()
Got error 28 from table handler
DB Error: Bad SQL Query: SELECT IF(i.image_date >= 1144308138,RAND()+1,1) as random_no, 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 new4_images i, new4_categories c LEFT JOIN new4_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) ORDER BY random_no DESC, RAND(), i.image_date DESC LIMIT 4
Got error 28 from table handler
-
Sorry, your site runs perfect for me - i can't see any problem.
-
and its covered in our FAQ :roll: