4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: JOBS on May 06, 2006, 09:29:56 AM

Title: site is broken
Post 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

?

Code: [Select]
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
Title: Re: site is broken
Post by: ManniC on May 06, 2006, 04:38:08 PM
Sorry, your site runs perfect for me - i can't see any problem.
Title: Re: site is broken
Post by: V@no on May 06, 2006, 04:50:54 PM
and its covered in our FAQ :roll: