Błąd przy instalacji 4images

Błąd przy instalacji 4images

Postprzez asterix » Wt paź 09, 12 17:00

4images 1.7.10

Po wpisaniu wszystkich danych i kliknięciu w START INSTALACJI otrzymuję:

Kod: Zaznacz cały
DB Error: Bad SQL Query: CREATE TABLE 4images_categories (cat_id int(10) unsigned NOT NULL auto_increment,cat_name varchar(255) NOT NULL default '',cat_description text NOT NULL,cat_parent_id int(10) unsigned NOT NULL default '0',cat_hits int(10) unsigned NOT NULL default '0',cat_order int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(2) NOT NULL default '0',auth_viewimage tinyint(2) NOT NULL default '0',auth_download tinyint(2) NOT NULL default '0',auth_upload tinyint(2) NOT NULL default '0',auth_directupload tinyint(2) NOT NULL default '0',auth_vote tinyint(2) NOT NULL default '0',auth_sendpostcard tinyint(2) NOT NULL default '0',auth_readcomment tinyint(2) NOT NULL default '0',auth_postcomment tinyint(2) NOT NULL default '0',PRIMARY KEY (cat_id),KEY cat_parent_id (cat_parent_id),KEY cat_order (cat_order)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_comments (comment_id int(10) unsigned NOT NULL auto_increment,image_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',user_name varchar(100) NOT NULL default '',comment_headline varchar(255) NOT NULL default '',comment_text text NOT NULL,comment_ip varchar(20) NOT NULL default '',comment_date int(11) unsigned NOT NULL default '0',PRIMARY KEY (comment_id),KEY image_id (image_id),KEY user_id (user_id),KEY comment_date (comment_date)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_groupaccess (group_id int(10) unsigned NOT NULL default '0',cat_id int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(1) NOT NULL default '0',auth_viewimage tinyint(1) NOT NULL default '0',auth_download tinyint(1) NOT NULL default '0',auth_upload tinyint(1) NOT NULL default '0',auth_directupload tinyint(1) NOT NULL default '0',auth_vote tinyint(1) NOT NULL default '0',auth_sendpostcard tinyint(1) NOT NULL default '0',auth_readcomment tinyint(1) NOT NULL default '0',auth_postcomment tinyint(1) NOT NULL default '0',KEY group_id (group_id),KEY cat_id (cat_id)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_groupmatch (group_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',groupmatch_startdate int(11) unsigned NOT NULL default '0',groupmatch_enddate int(11) unsigned NOT NULL default '0',KEY group_id (group_id),KEY user_id (user_id)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_groups (group_id int(10) unsigned NOT NULL auto_increment,group_name varchar(100) NOT NULL default '',group_type tinyint(2) NOT NULL default '1',PRIMARY KEY (group_id)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_images (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_active tinyint(1) NOT NULL default '1',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',image_allow_comments tinyint(1) NOT NULL default '1',image_comments int(10) unsigned NOT NULL default '0',image_downloads int(10) unsigned NOT NULL default '0',image_votes int(10) unsigned NOT NULL default '0',image_rating decimal(4,2) NOT NULL default '0.00',image_hits int(10) unsigned NOT NULL default '0',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id),KEY image_date (image_date),KEY image_active (image_active)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_images_temp (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_lightboxes (lightbox_id varchar(32) NOT NULL default '',user_id int(11) NOT NULL default '0',lightbox_lastaction int(11) unsigned NOT NULL default '0',lightbox_image_ids text,KEY lightbox_id (lightbox_id),KEY user_id (user_id)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_postcards (postcard_id varchar(32) NOT NULL default '',image_id int(10) unsigned NOT NULL default '0',postcard_date int(11) unsigned NOT NULL default '0',postcard_bg_color varchar(100) NOT NULL default '',postcard_border_color varchar(100) NOT NULL default '',postcard_font_color varchar(100) NOT NULL default '',postcard_font_face varchar(100) NOT NULL default '',postcard_sender_name varchar(255) NOT NULL default '',postcard_sender_email varchar(255) NOT NULL default '',postcard_recipient_name varchar(255) NOT NULL default '',postcard_recipient_email varchar(255) NOT NULL default '',postcard_headline varchar(255) NOT NULL default '',postcard_message text NOT NULL,PRIMARY KEY (postcard_id)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_sessions (session_id varchar(32) NOT NULL default '',session_user_id int(11) NOT NULL default '0',session_lastaction int(11) unsigned NOT NULL default '0',session_location varchar(255) NOT NULL default '',session_ip varchar(15) NOT NULL default '',PRIMARY KEY (session_id),KEY session_user_id (session_user_id),KEY session_id_ip_user_id (session_id,session_ip,session_user_id)) TYPE=HEAP
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=HEAP' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_sessionvars (session_id varchar(32) NOT NULL default '',sessionvars_name varchar(30) NOT NULL default '',sessionvars_value text,KEY session_id (session_id)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_settings (setting_name varchar(255) NOT NULL default '',setting_value mediumtext NOT NULL,PRIMARY KEY (setting_name)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('site_name', '4images - Image Gallery Management System')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('site_email', 'admin@yourdomain.com')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('use_smtp', '0')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('smtp_host', '')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('smtp_username', '')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('smtp_password', '')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('template_dir', 'default')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('language_dir', 'deutsch')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('date_format', 'd.m.Y')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('time_format', 'H:i')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('convert_tool', 'gd')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('convert_tool_path', '')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('gz_compress', '0')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('gz_compress_level', '6')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_cells', '2')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_table_width', '100%')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_table_cellspacing', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_table_cellpadding', '3')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('num_subcats', '3')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_order', 'image_name')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_sort', 'ASC')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('new_cutoff', '10')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_border', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_cells', '3')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('default_image_rows', '3')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('custom_row_steps', '10')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_table_width', '100%')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_table_cellspacing', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_table_cellpadding', '3')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('upload_mode', '2')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('allowed_mediatypes', 'jpg,gif,png,aif,au,avi,mid,mov,mp3,mpg,swf,wav,ra,rm,zip,pdf')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_thumb_width', '300')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_thumb_height', '300')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_thumb_size', '100')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_image_width', '1024')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_image_height', '1024')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_media_size', '2000')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('upload_notify', '0')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('upload_emails', '')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail_dimension', '100')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail_resize_type', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail_quality', '75')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('badword_list', 'fuck {fuck}')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('badword_replace_char', '*')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('wordwrap_comments', '50')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('html_comments', '0')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('bb_comments', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('bb_img_comments', '0')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('category_separator', ' / ')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('paging_range', '5')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_edit_image', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_delete_image', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_edit_comments', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_delete_comments', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('account_activation', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('activation_time', '14')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('session_timeout', '15')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('display_whosonline', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('highlight_admin', '1')
Table 'db623629.4images_settings' doesn't exist

DB Error: Bad SQL Query: CREATE TABLE 4images_users (user_id int(11) NOT NULL auto_increment,user_level int(11) NOT NULL default '1',user_name varchar(255) NOT NULL default '',user_password varchar(255) NOT NULL default '',user_email varchar(255) NOT NULL default '',user_showemail tinyint(1) NOT NULL default '0',user_allowemails tinyint(1) NOT NULL default '1',user_invisible tinyint(1) NOT NULL default '0',user_joindate int(11) unsigned NOT NULL default '0',user_activationkey varchar(32) NOT NULL default '',user_lastaction int(11) unsigned NOT NULL default '0',user_location varchar(255) NOT NULL default '',user_lastvisit int(11) unsigned NOT NULL default '0',user_comments int(10) unsigned NOT NULL default '0',user_homepage varchar(255) NOT NULL default '',user_icq varchar(20) NOT NULL default '',PRIMARY KEY (user_id),KEY user_lastaction (user_lastaction),KEY user_name (user_name)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: INSERT INTO 4images_users VALUES (-1, -1, 'Guest', '0493984f537120be0b8d96bc9b69cdd2', '', 0, 0, 0, 0, '', 0, '', 0, 0, '', '')
Table 'db623629.4images_users' doesn't exist

DB Error: Bad SQL Query: INSERT INTO 4images_users VALUES (1, 9, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 1, 1, 0, 1016023608, '1e3457c0b2052a9633b886fd75ef91e0', 1016023608, '', 0, 0, '', '')
Table 'db623629.4images_users' doesn't exist

DB Error: Bad SQL Query: CREATE TABLE 4images_wordlist (word_text varchar(50) NOT NULL default '',word_id int(10) unsigned NOT NULL auto_increment,PRIMARY KEY (word_id),UNIQUE KEY word_text (word_text)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_wordmatch (image_id int(10) unsigned NOT NULL default '0',word_id int(10) unsigned NOT NULL default '0',name_match tinyint(1) NOT NULL default '0',desc_match tinyint(1) NOT NULL default '0',keys_match tinyint(1) NOT NULL default '0',UNIQUE KEY image_word_id (image_id,word_id)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: UPDATE 4images_users SET user_name = 'admin', user_password = '0eca1022f:9bd14a383edf6c713bb7239ade33b65f', user_joindate = 1349794609, user_lastaction = 1349794609, user_lastvisit = 1349794609 WHERE user_name = 'admin'
Table 'db623629.4images_users' doesn't exist

DB Error: Bad SQL Query: UPDATE 4images_settings SET setting_value = 'polish' WHERE setting_name = 'language_dir'
Table 'db623629.4images_settings' doesn't exist

Wyst±pi³y b³êdy podczas aktualizacji bazy danych:

    CREATE TABLE 4images_categories (cat_id int(10) unsigned NOT NULL auto_increment,cat_name varchar(255) NOT NULL default '',cat_description text NOT NULL,cat_parent_id int(10) unsigned NOT NULL default '0',cat_hits int(10) unsigned NOT NULL default '0',cat_order int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(2) NOT NULL default '0',auth_viewimage tinyint(2) NOT NULL default '0',auth_download tinyint(2) NOT NULL default '0',auth_upload tinyint(2) NOT NULL default '0',auth_directupload tinyint(2) NOT NULL default '0',auth_vote tinyint(2) NOT NULL default '0',auth_sendpostcard tinyint(2) NOT NULL default '0',auth_readcomment tinyint(2) NOT NULL default '0',auth_postcomment tinyint(2) NOT NULL default '0',PRIMARY KEY (cat_id),KEY cat_parent_id (cat_parent_id),KEY cat_order (cat_order)) TYPE=MyISAM
    CREATE TABLE 4images_comments (comment_id int(10) unsigned NOT NULL auto_increment,image_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',user_name varchar(100) NOT NULL default '',comment_headline varchar(255) NOT NULL default '',comment_text text NOT NULL,comment_ip varchar(20) NOT NULL default '',comment_date int(11) unsigned NOT NULL default '0',PRIMARY KEY (comment_id),KEY image_id (image_id),KEY user_id (user_id),KEY comment_date (comment_date)) TYPE=MyISAM
    CREATE TABLE 4images_groupaccess (group_id int(10) unsigned NOT NULL default '0',cat_id int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(1) NOT NULL default '0',auth_viewimage tinyint(1) NOT NULL default '0',auth_download tinyint(1) NOT NULL default '0',auth_upload tinyint(1) NOT NULL default '0',auth_directupload tinyint(1) NOT NULL default '0',auth_vote tinyint(1) NOT NULL default '0',auth_sendpostcard tinyint(1) NOT NULL default '0',auth_readcomment tinyint(1) NOT NULL default '0',auth_postcomment tinyint(1) NOT NULL default '0',KEY group_id (group_id),KEY cat_id (cat_id)) TYPE=MyISAM
    CREATE TABLE 4images_groupmatch (group_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',groupmatch_startdate int(11) unsigned NOT NULL default '0',groupmatch_enddate int(11) unsigned NOT NULL default '0',KEY group_id (group_id),KEY user_id (user_id)) TYPE=MyISAM
    CREATE TABLE 4images_groups (group_id int(10) unsigned NOT NULL auto_increment,group_name varchar(100) NOT NULL default '',group_type tinyint(2) NOT NULL default '1',PRIMARY KEY (group_id)) TYPE=MyISAM
    CREATE TABLE 4images_images (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_active tinyint(1) NOT NULL default '1',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',image_allow_comments tinyint(1) NOT NULL default '1',image_comments int(10) unsigned NOT NULL default '0',image_downloads int(10) unsigned NOT NULL default '0',image_votes int(10) unsigned NOT NULL default '0',image_rating decimal(4,2) NOT NULL default '0.00',image_hits int(10) unsigned NOT NULL default '0',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id),KEY image_date (image_date),KEY image_active (image_active)) TYPE=MyISAM
    CREATE TABLE 4images_images_temp (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id)) TYPE=MyISAM
    CREATE TABLE 4images_lightboxes (lightbox_id varchar(32) NOT NULL default '',user_id int(11) NOT NULL default '0',lightbox_lastaction int(11) unsigned NOT NULL default '0',lightbox_image_ids text,KEY lightbox_id (lightbox_id),KEY user_id (user_id)) TYPE=MyISAM
    CREATE TABLE 4images_postcards (postcard_id varchar(32) NOT NULL default '',image_id int(10) unsigned NOT NULL default '0',postcard_date int(11) unsigned NOT NULL default '0',postcard_bg_color varchar(100) NOT NULL default '',postcard_border_color varchar(100) NOT NULL default '',postcard_font_color varchar(100) NOT NULL default '',postcard_font_face varchar(100) NOT NULL default '',postcard_sender_name varchar(255) NOT NULL default '',postcard_sender_email varchar(255) NOT NULL default '',postcard_recipient_name varchar(255) NOT NULL default '',postcard_recipient_email varchar(255) NOT NULL default '',postcard_headline varchar(255) NOT NULL default '',postcard_message text NOT NULL,PRIMARY KEY (postcard_id)) TYPE=MyISAM
    CREATE TABLE 4images_sessions (session_id varchar(32) NOT NULL default '',session_user_id int(11) NOT NULL default '0',session_lastaction int(11) unsigned NOT NULL default '0',session_location varchar(255) NOT NULL default '',session_ip varchar(15) NOT NULL default '',PRIMARY KEY (session_id),KEY session_user_id (session_user_id),KEY session_id_ip_user_id (session_id,session_ip,session_user_id)) TYPE=HEAP
    CREATE TABLE 4images_sessionvars (session_id varchar(32) NOT NULL default '',sessionvars_name varchar(30) NOT NULL default '',sessionvars_value text,KEY session_id (session_id)) TYPE=MyISAM
    CREATE TABLE 4images_settings (setting_name varchar(255) NOT NULL default '',setting_value mediumtext NOT NULL,PRIMARY KEY (setting_name)) TYPE=MyISAM
    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', 'gd')
    INSERT INTO 4images_settings VALUES ('convert_tool_path', '')
    INSERT INTO 4images_settings VALUES ('gz_compress', '0')
    INSERT INTO 4images_settings VALUES ('gz_compress_level', '6')
    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', '1')
    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', 'fuck {fuck}')
    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')
    CREATE TABLE 4images_users (user_id int(11) NOT NULL auto_increment,user_level int(11) NOT NULL default '1',user_name varchar(255) NOT NULL default '',user_password varchar(255) NOT NULL default '',user_email varchar(255) NOT NULL default '',user_showemail tinyint(1) NOT NULL default '0',user_allowemails tinyint(1) NOT NULL default '1',user_invisible tinyint(1) NOT NULL default '0',user_joindate int(11) unsigned NOT NULL default '0',user_activationkey varchar(32) NOT NULL default '',user_lastaction int(11) unsigned NOT NULL default '0',user_location varchar(255) NOT NULL default '',user_lastvisit int(11) unsigned NOT NULL default '0',user_comments int(10) unsigned NOT NULL default '0',user_homepage varchar(255) NOT NULL default '',user_icq varchar(20) NOT NULL default '',PRIMARY KEY (user_id),KEY user_lastaction (user_lastaction),KEY user_name (user_name)) TYPE=MyISAM
    INSERT INTO 4images_users VALUES (-1, -1, 'Guest', '0493984f537120be0b8d96bc9b69cdd2', '', 0, 0, 0, 0, '', 0, '', 0, 0, '', '')
    INSERT INTO 4images_users VALUES (1, 9, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 1, 1, 0, 1016023608, '1e3457c0b2052a9633b886fd75ef91e0', 1016023608, '', 0, 0, '', '')
    CREATE TABLE 4images_wordlist (word_text varchar(50) NOT NULL default '',word_id int(10) unsigned NOT NULL auto_increment,PRIMARY KEY (word_id),UNIQUE KEY word_text (word_text)) TYPE=MyISAM
    CREATE TABLE 4images_wordmatch (image_id int(10) unsigned NOT NULL default '0',word_id int(10) unsigned NOT NULL default '0',name_match tinyint(1) NOT NULL default '0',desc_match tinyint(1) NOT NULL default '0',keys_match tinyint(1) NOT NULL default '0',UNIQUE KEY image_word_id (image_id,word_id)) TYPE=MyISAM
    UPDATE 4images_users SET user_name = 'admin', user_password = '0eca1022f:9bd14a383edf6c713bb7239ade33b65f', user_joindate = 1349794609, user_lastaction = 1349794609, user_lastvisit = 1349794609 WHERE user_name = 'admin'
    UPDATE 4images_settings SET setting_value = 'polish' WHERE setting_name = 'language_dir'


O co tu chodzi?
asterix
 
Posty: 4
Dołączył(a): N lip 05, 09 19:43

Re: Błąd przy instalacji 4images

Postprzez percoz » Pn paź 15, 12 12:57

Prawdopodobnie skrypt nie jest kompatybilny z wersją MySQL, która jest używana na naszych serwerach.

Należy w pliku, który odpowiada za wprowadzanie danych do bazy zmienić wszystkie wpisy "TYPE=MyISAM" na: "ENGINE=MyISAM"
percoz
 
Posty: 612
Dołączył(a): Wt paź 11, 11 13:47


Powrót do Ogólne

Copyright © 2007-2011 ugu.pl
Wszelkie prawa zastrzeżone.
Polityka prywatności