what is this error

[a m i r .]

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

[Jan]

This means that the table 4images_settings does not exists. You can create the table from the dump in data/database/default.

Jan

[a m i r .]

i don't know how to create a table what i do with my sql bcz i don't sql settings please someone help me out how i configure this please

[a m i r .]

please help me out  

[Jan]

Run this queries, i.e. with phpMyAdmin

Code: [Select]

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

#
# Dumping data for table `4images_settings`
#

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

[a m i r .]

i told you i just new to sql i just don't know how to enter and where i enter this all code which you written above

[a m i r .]

please check this link

http://acnova.com/~stringsclub/gallery/

[Jan]

Did you run the install.php? See docs/Installation.php for detailed instructions.

Jan

[a m i r .]

yes i did but what the hell this error admin please help me out i can give you my accopunt password and you please set this for me please

[Jan]

Import the database dump you find in data/database/default with phpMyAdmin.

Jan

[a m i r .]

i just told you already i don't know much about sql and phpmyadmin please can u give me step by step instructions ......??? please i really need this wonderful scriopt ......please      

[a m i r .]

please help me someone

[Chris]

You can download and install phpMyAdmin from www.phpmyadmin.net  Once installed, you can use it's online documentation to learn how to copy and paste the sql code posted by Jan into phpMyAdmin to apply it to your database.

[a m i r .]

oh my god dear friends i alreadyt installed phpamyadmin i m running some other php forum and that is goinng gppd only this 4images script not working ggood on my site

[BerKay]

Re-upload them all with WS_FTP , the 4images file on your server , click on it , and change the CHMOD to 777 . Make sure you got the file on your server .

4images\data\database\default\mysql_default.sql

go to that file , and go to your servers control panel , than phpmyadmin , than your user name - password , and upload the file.

it should work