Author Topic: Help With My Gallery  (Read 3497 times)

0 Members and 1 Guest are viewing this topic.

Offline AndreaKay

  • Pre-Newbie
  • Posts: 2
    • View Profile
Help With My Gallery
« on: November 29, 2007, 05:40:28 PM »
First off my gallery was hacked into and screwed up. I can't get into my control panel. This is the error message I get when I go to my control panel page:
Quote
Parse error: parse error, unexpected $ in /home/www/barlowgirl/NOT_gallery/admin/index.php on line 161
So I have no idea how to fix my problem. All my images are still on my server but it's like they are invisible in my gallery. Here's my error message:
Quote
DB Error: Bad SQL Query: SELECT cat_id, COUNT(image_id) AS new_images FROM 4images_images WHERE image_active = 1 AND image_date >= 1195748681 GROUP BY cat_id
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)

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/www/barlowgirl/NOT_gallery/includes/db_mysql.php:188) in /home/www/barlowgirl/NOT_gallery/includes/sessions.php on line 84

DB Error: Bad SQL Query: SELECT COUNT(*) as total_images FROM 4images_images WHERE image_active = 1 AND cat_id NOT IN (0)
Can't open file: '4images_images.MYD'. (errno: 145)

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
Can't open file: '4images_images.MYD'. (errno: 145)

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

It would save me a whole lot of trouble if someone can help me fix this so I don't have to start from scratch. I had about over 3,000 pictures and I'd hate to re up everything. Please help! If needed here's my gallery: http://barlowgirl.org/NOT_gallery/

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Help With My Gallery
« Reply #1 on: November 29, 2007, 08:51:18 PM »
hi,

your mysql table is corrupt

http://dev.mysql.com/doc/refman/5.0/en/repair-table.html

try to repair table over phpmyadmin
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline AndreaKay

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: Help With My Gallery
« Reply #2 on: November 30, 2007, 06:42:33 PM »
Explain that to me.  :?:

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Help With My Gallery
« Reply #3 on: December 01, 2007, 07:49:43 AM »
hi,

phpmyadmin DEMO
http://pma.cihar.com/TESTING/index.php?db=Hautausmaa
user is root
leave password empty

you will se there 4 tables:
click on "Check All" then an from dropdown menu "Repair Table".
some you have to do on your mysql server.

that's it
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi