Author Topic: SQL Error on every page, photos not showing up.  (Read 3300 times)

0 Members and 1 Guest are viewing this topic.

Offline ndw

  • Pre-Newbie
  • Posts: 1
    • View Profile
SQL Error on every page, photos not showing up.
« on: April 03, 2003, 10:28:41 PM »
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 4images_categories c LEFT JOIN 4images_images i ON (i.cat_id = c.cat_id AND i.image_date >= 1048105380 AND i.image_active = 1) GROUP BY c.cat_id ORDER BY c.cat_order, c.cat_name ASC
Can't open file: '4images_images.MYD'. (errno: 145)

DB Error: Bad SQL Query: SELECT cat_id, COUNT(*) AS num_images FROM 4images_images WHERE image_active = 1 GROUP BY cat_id
Can't open file: '4images_images.MYD'. (errno: 145)

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
SQL Error on every page, photos not showing up.
« Reply #1 on: April 03, 2003, 10:34:25 PM »
I belive this is your host's problem. ask them about that. (unless u didnt install 4images properly)
if u know how to use any MySQL managers (i.e. phpmyadmin) then check that 4images_images table is installed.
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)