SQL ERROR

[__G__]

Hi im getting this error but site is working fine it just pop up

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, 54, 175, 29, 173, 158, 143, 63, 27, 163, 147, 197, 157, 199, 153, 166, 1, 146, 36, 47, 49, 24, 19, 152, 10, 176, 141, 25, 64, 144, 38, 31, 52, 14, 198, 194, 155, 45, 200, 201, 177, 11, 162, 65, 20, 203, 32, 156, 40, 46, 145, 178, 164, 66, 33, 9, 202, 179, 159, 67, 142, 13, 3, 34, 180, 39, 55, 68, 170, 4, 181, 69, 160, 204, 2, 35, 182, 92, 161, 41, 5, 37, 183, 70, 59, 6, 44, 71, 184, 28, 48, 168, 23, 72, 50, 185, 165, 7, 73, 186, 56, 8, 61, 74, 17, 187, 57, 75, 18, 188, 53, 76, 21, 189, 58, 77, 154, 190, 60, 78, 191, 22, 79, 192, 30, 81, 51, 193, 80, 62, 82, 151, 83, 42, 84, 43, 85, 169, 86, 171, 174, 87, 88, 195, 89, 196, 90, 91, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140) ORDER BY i.image_rating DESC, i.image_votes DESC
Got error 28 from storage engine


Im using 4images 1.7.4 is there any exploit which i m not aware off ?

[V@no]

No, your database server ran out of free space on hard drive (not your database ).

Error code 28: No space left on device

Reference

 Contact your server administrator, they should fix it. Nothing you can do about it.

[__G__]

aha ok thanks a lot V@no

[djith]

I have something similar... did i also ran out of diskspace ? i'm using 1.7.1


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 LIMIT 3083, 1
Unknown column 'i.user_id' in 'on clause'

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 NOT IN (0) ORDER BY i.image_date DESC LIMIT 8
Unknown column 'i.user_id' in 'on clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/avata5/public_html/includes/db_mysql.php on line 116


But info at my server shows this ;
Hosting package default
Shared Ip Address ************
Subdomains  2 / 999
Parked Domains 0 / 2997
Addon Domains 1 / 1
MySQL Databases 5 / 999
Postgresql Databases 0 / 999
Disk Space Usage 1623.11 Megabytes
MySQL Disk Space 4.95 Megabytes
Disk space available 248376.89 Megabytes
Bandwidth (this month) 3799.47 Megabytes
Email Accounts 1 / 999
Email Forwarders 0
Auto-responders 0
Mailing Lists 0 / 1
Email Filters 0
Ftp Accounts 1 / 999

So i don't think i ran out of space, something else is going on...

[V@no]

No, your error is not "similar" and has nothing to do with disk space...
Most likely this will help:
query problems with MySQL 5.0.x