Author Topic: DB Error: Bad SQL Query / Got error 127 from storage engine  (Read 3244 times)

0 Members and 1 Guest are viewing this topic.

Offline ent

  • Pre-Newbie
  • Posts: 2
    • View Profile
Well I'm not sure exactly whats up it was fine this morning and now its all weird umm some weird things: it claims some folders have no photos but when you click them the photos are there, it claims to upload the photos but when i go to check on them they don't appear to be uploaded this is what my main page says:


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 3
Got error 127 from storage engine

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

^Has anybody ever had this problem or have any idea on how to fix it, and by the way I'm using version 1.7.2 my host says its probably somethign on my part but idk  :? and this is the link to my gallery if you want to take a first hand look http://www.no-saint.net/ent/

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: DB Error: Bad SQL Query / Got error 127 from storage engine
« Reply #1 on: April 02, 2006, 12:34:37 AM »
FAQ
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline ent

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: DB Error: Bad SQL Query / Got error 127 from storage engine
« Reply #2 on: April 02, 2006, 12:59:18 AM »
I'm sorry maybe i'm just being stupid (that happensi guess) but i saw a subject very similar to this one but it wasn't the same problem  :? :(

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: DB Error: Bad SQL Query / Got error 127 from storage engine
« Reply #3 on: April 02, 2006, 01:22:08 AM »
http://www.4homepages.de/forum/index.php?topic=11799.msg62748#msg62748

Quote
[user@linux ~]$ perror 127
MySQL error code 127: Record-file is crashed
[user@linux ~]$
try repair the database via phpmyadmin or something simular.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)