MySql-Datenbank plötzlich weg / MySql suddenly gone

[oliver4471]

hi,
beim aufruf meiner (bis dato fuktionierenden) Galerie, erhalte ich plötzlich die Fehlermeldung

DB Error: Bad SQL Query: SELECT setting_name, setting_value FROM 4images_settings
Table 'test.4images_settings' doesn't exist

Was ist da passiert? Wieso ist die Tabelle weg? Wie krieg ich sie wieder?

Gruß, Oliver
hi,
surfing to my (up to now working) gallery I receive the f ollowing error-msg:

DB Error: Bad SQL Query: SELECT setting_name, setting_value FROM 4images_settings
Table 'test.4images_settings' doesn't exist

What happened here? Where has the table gone ? How can I get it back??

Thanks,
Oliver

[V@no]

a few possabilities:
- 4images_settings table got corrupted
- someone deleted it (hacked?)

the first thing I would do is check the database with phpmyadmin or any other mysql managers.
If no lead found, contact the hoster. Then if the old table can not be restored execute this mysql query in phpmyadmin:

Code: [Select]

CREATE TABLE 4images_settings (
  setting_name varchar(255) NOT NULL default '',
  setting_value mediumtext NOT NULL,
  PRIMARY KEY  (setting_name)
) TYPE=MyISAM;

#
# Dumping data for table 4images_settings
#

INSERT INTO 4images_settings VALUES ('site_name', '4images - Image Gallery Management System');
INSERT INTO 4images_settings VALUES ('site_email', 'admin@yourdomain.com');
INSERT INTO 4images_settings VALUES ('use_smtp', '0');
INSERT INTO 4images_settings VALUES ('smtp_host', '');
INSERT INTO 4images_settings VALUES ('smtp_username', '');
INSERT INTO 4images_settings VALUES ('smtp_password', '');
INSERT INTO 4images_settings VALUES ('template_dir', 'default');
INSERT INTO 4images_settings VALUES ('language_dir', 'deutsch');
INSERT INTO 4images_settings VALUES ('date_format', 'd.m.Y');
INSERT INTO 4images_settings VALUES ('time_format', 'H:i');
INSERT INTO 4images_settings VALUES ('convert_tool', 'none');
INSERT INTO 4images_settings VALUES ('convert_tool_path', '');
INSERT INTO 4images_settings VALUES ('gz_compress', '0');
INSERT INTO 4images_settings VALUES ('gz_compress_level', '9');
INSERT INTO 4images_settings VALUES ('cat_cells', '2');
INSERT INTO 4images_settings VALUES ('cat_table_width', '100%');
INSERT INTO 4images_settings VALUES ('cat_table_cellspacing', '1');
INSERT INTO 4images_settings VALUES ('cat_table_cellpadding', '3');
INSERT INTO 4images_settings VALUES ('num_subcats', '3');
INSERT INTO 4images_settings VALUES ('image_order', 'image_name');
INSERT INTO 4images_settings VALUES ('image_sort', 'ASC');
INSERT INTO 4images_settings VALUES ('new_cutoff', '10');
INSERT INTO 4images_settings VALUES ('image_border', '1');
INSERT INTO 4images_settings VALUES ('image_cells', '3');
INSERT INTO 4images_settings VALUES ('default_image_rows', '3');
INSERT INTO 4images_settings VALUES ('custom_row_steps', '10');
INSERT INTO 4images_settings VALUES ('image_table_width', '100%');
INSERT INTO 4images_settings VALUES ('image_table_cellspacing', '1');
INSERT INTO 4images_settings VALUES ('image_table_cellpadding', '3');
INSERT INTO 4images_settings VALUES ('upload_mode', '2');
INSERT INTO 4images_settings VALUES ('allowed_mediatypes', 'jpg,gif,png,aif,au,avi,mid,mov,mp3,mpg,swf,wav,ra,rm,zip,pdf');
INSERT INTO 4images_settings VALUES ('max_thumb_width', '300');
INSERT INTO 4images_settings VALUES ('max_thumb_height', '300');
INSERT INTO 4images_settings VALUES ('max_thumb_size', '100');
INSERT INTO 4images_settings VALUES ('max_image_width', '1024');
INSERT INTO 4images_settings VALUES ('max_image_height', '1024');
INSERT INTO 4images_settings VALUES ('max_media_size', '2000');
INSERT INTO 4images_settings VALUES ('upload_notify', '0');
INSERT INTO 4images_settings VALUES ('upload_emails', '');
INSERT INTO 4images_settings VALUES ('auto_thumbnail', '0');
INSERT INTO 4images_settings VALUES ('auto_thumbnail_dimension', '100');
INSERT INTO 4images_settings VALUES ('auto_thumbnail_resize_type', '1');
INSERT INTO 4images_settings VALUES ('auto_thumbnail_quality', '75');
INSERT INTO 4images_settings VALUES ('badword_list', 'tra-la-la {tra-la-la}');
INSERT INTO 4images_settings VALUES ('badword_replace_char', '*');
INSERT INTO 4images_settings VALUES ('wordwrap_comments', '50');
INSERT INTO 4images_settings VALUES ('html_comments', '0');
INSERT INTO 4images_settings VALUES ('bb_comments', '1');
INSERT INTO 4images_settings VALUES ('bb_img_comments', '0');
INSERT INTO 4images_settings VALUES ('category_separator', ' / ');
INSERT INTO 4images_settings VALUES ('paging_range', '5');
INSERT INTO 4images_settings VALUES ('user_edit_image', '1');
INSERT INTO 4images_settings VALUES ('user_delete_image', '1');
INSERT INTO 4images_settings VALUES ('user_edit_comments', '1');
INSERT INTO 4images_settings VALUES ('user_delete_comments', '1');
INSERT INTO 4images_settings VALUES ('account_activation', '1');
INSERT INTO 4images_settings VALUES ('activation_time', '14');
INSERT INTO 4images_settings VALUES ('session_timeout', '15');
INSERT INTO 4images_settings VALUES ('display_whosonline', '1');
INSERT INTO 4images_settings VALUES ('highlight_admin', '1');It will create new 4images_settings table with default settings.

[oliver4471]

Thanx !!!!! I will try tomorrow because I first want to wait if thats a general provider's problem that is fixed tomorrow, tho it doesnt seem so, frankly.
In fear of having been hacked, I wonder :  Isnt the only way to delete a sql-table if you know the domain's control center pw??

Greetinx,
Oliver 

[V@no]

there are lost of way to delete a database or hack a computer...

but again, check the database yourself first.

[oliver4471]

There is the database, but its empty.
I executed your code and changed host,user,pw (except for 'use_smtp'=0; need t ochange this, too??) .
I also uploaded all files I had to delete after installation, e.g. 'install.php'.
there are now a lot of errors displayed...

[Vincent]

i also had this problem

this happen when the backup Softwar stopped the SQL server and after backup got problem to start it!

sincerly
vincent