4images Forum & Community
4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: Zhra on July 21, 2006, 06:50:27 PM
-
After Upgrade to 1.7.3
Every thing is good
I'm shower that I upload all files!
But?
After modifying files (index.php) to show more than (1) random image
And also
After installing (Today's picture) Hack by modifying un function.php , constants.php , page_header.php
I get this problem and 4images script becomes very slow
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 i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY DESC LIMIT 1
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 'DESC LIMIT 1' at line 5
-
This is a problem with the modification, not with 1.7.3 itself. You should post at the apropriate MOD thread.