4images Datenbank Problem

UBF · 30. Mai 2011 um 11:10

Servus!

Bin grad am Umbau meiner kleinen Seite und ich wollte dazu noch eine 4images Galerie installieren. Soweit so gut, habe das auf einem anderen Server schon mal gemacht also hatte ich wenig Probleme mit den Angaben die gefordert wurden bei der Installation.

Kurz zur Übersicht:
Datenbank: mysql
Datenbankserver: localhost
Nutzername: mein Nutzername
Passwort: mein Passwort

Soweit so gut. Drücke ich auf Installieren bekomme ich eine riesen liste, wo mein Latein auch schon am Ende ist.

[code]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 ‚undergroundberli.4images_settings‘ doesn’t exist

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

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚use_smtp‘, ‚0‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚smtp_host‘, ‚‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚smtp_username‘, ‚‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚smtp_password‘, ‚‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚template_dir‘, ‚default‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚language_dir‘, ‚deutsch‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚date_format‘, ‚d.m.Y‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚time_format‘, ‚H:i‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚convert_tool‘, ‚gd‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚convert_tool_path‘, ‚‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚gz_compress‘, ‚0‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚gz_compress_level‘, ‚6‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚cat_cells‘, ‚2‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚cat_table_width‘, ‚100%‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚cat_table_cellspacing‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚cat_table_cellpadding‘, ‚3‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚num_subcats‘, ‚3‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚image_order‘, ‚image_name‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚image_sort‘, ‚ASC‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚new_cutoff‘, ‚10‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚image_border‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚image_cells‘, ‚3‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚default_image_rows‘, ‚3‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚custom_row_steps‘, ‚10‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚image_table_width‘, ‚100%‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚image_table_cellspacing‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚image_table_cellpadding‘, ‚3‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚upload_mode‘, ‚2‘)
Table ‚undergroundberli.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 ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚max_thumb_width‘, ‚300‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚max_thumb_height‘, ‚300‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚max_thumb_size‘, ‚100‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚max_image_width‘, ‚1024‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚max_image_height‘, ‚1024‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚max_media_size‘, ‚2000‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚upload_notify‘, ‚0‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚upload_emails‘, ‚‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚auto_thumbnail‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚auto_thumbnail_dimension‘, ‚100‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚auto_thumbnail_resize_type‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚auto_thumbnail_quality‘, ‚75‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚badword_list‘, ‚fuck {fuck}‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚badword_replace_char‘, ‚*‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚wordwrap_comments‘, ‚50‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚html_comments‘, ‚0‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚bb_comments‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚bb_img_comments‘, ‚0‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

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

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚paging_range‘, ‚5‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚user_edit_image‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚user_delete_image‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚user_edit_comments‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚user_delete_comments‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚account_activation‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚activation_time‘, ‚14‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚session_timeout‘, ‚15‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚display_whosonline‘, ‚1‘)
Table ‚undergroundberli.4images_settings‘ doesn’t exist

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES (‚highlight_admin‘, ‚1‘)
Table ‚undergroundberli.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 ‚undergroundberli.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 ‚undergroundberli.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 = ‚Chris‘, user_password = ‚54094d50b:9c7af921390f05b073050bcc12c87a3e‘, user_joindate = 1306753505, user_lastaction = 1306753505, user_lastvisit = 1306753505 WHERE user_name = ‚admin‘
Table ‚undergroundberli.4images_users‘ doesn’t exist

DB Error: Bad SQL Query: UPDATE 4images_settings SET setting_value = ‚deutsch‘ WHERE setting_name = ‚language_dir‘
Table ‚undergroundberli.4images_settings‘ doesn’t exist

Es sind Fehler bei der Erstellung der Datenbankeinträge aufgetreten:

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 = 'Chris', user_password = '54094d50b:9c7af921390f05b073050bcc12c87a3e', user_joindate = 1306753505, user_lastaction = 1306753505, user_lastvisit = 1306753505 WHERE user_name = 'admin'
UPDATE 4images_settings SET setting_value = 'deutsch' WHERE setting_name = 'language_dir'[/code]

Ich hoffe da kann was mit angefangen werden.

Danke schon mal im Voraus!

Grüße

Chris · 30. Mai 2011 um 11:16

Hi,

gibt es ggf. eine neuere Version nutze bitte diese. Ansonsten musst du im Script einiges abändern…

UBF · 30. Mai 2011 um 11:22

Hi!

Das ist die neuste Version von 4images. Habe es vorhin mal auf einem privaten Server versucht zu installieren und es funktionierte wunderbar.
Was genau müsste man denn da am Skript machen um es auf bplaced zum laufen zu bekommen? Oder ist das eher ein allgemeines Problem? Gibt ja auch mehere weitere, die 4images auf bplaced laufen haben.

Grüße

emil · 30. Mai 2011 um 11:32

zb wird statt TYPE=MYISAM seit einigen versionen ENGINE=MYISAM verwendet… das script ist also vllt das neueste das verfügbar ist, aber alles andere als aktuell. du solltest den hersteller darauf aufmerksam machen
gruß

UBF · 30. Mai 2011 um 11:38

Okay, werde ich machen.
Danke für die schnelle Hilfe!

Grüße

UBF · 31. Mai 2011 um 19:06

Sorry für Doppelpost … Ich nochmal.

Ich habe mich im Supportforum bei 4images gemeldet und viel Hilfe habe ich bisher nicht bekommen. Jedenfalls habe ich mitlerweile immer wieder erneut versucht die Installation durchzuführen. Jetzt möchte ich nochmal nachfragen, ob ich vielleicht irgendwas machen muss, damit der Installer halt Zugriff auf die Datenbank bekommt. Muss ich vielleicht die install.php mit den Rechten hochsetzen?
Und sind folgende Angaben richtig:
Datenbankserver: localhost
Datenbankname: der im Usermenü in bplaced genannte Name.
Datenbankbenutzer: der im Usermenü in bplaced genannte Benutzername.
Datenbankpasswort: mein Passwort.
??

Denn die Installation funktioniert sonst überall wunderbar. Habe leider nur bei bplaced das Problem. Habe es probeweise auch bei Square7 mal ausprobiert, doch es kommt exact der selbe Fehler.

Grüße

bibissims2stuff · 31. Mai 2011 um 19:39

ich kanns mir nur so erklären, wie emil schon schrieb, dass die anderen hoster …ältere datenbankversionen haben…und es deshalb dort zu installieren geht…bplaced ist immer up to date …und vll kommt 4images deshalb damit nicht klar…
oder 4images benötigt irgendwas, was es bei bplaced nur auf nem pro-account gibt??
musst wirklich abwarten, was die dir dort erzählen…wird dir wohl leider nix anderes übrig bleiben

UBF · 31. Mai 2011 um 19:42

Nuja, es gibt ja mehrere 4images Galerien auf bplaced die scheinbar wunderbar funktionieren. Ich warte mal weiter ab, was die sagen.
Danke nochmal !!

(Ist natürlich super, dass bplaced immer up-to-date ist. )

Ryon · 1. Juni 2011 um 12:21

Hi,

habs auch mal interliert ( vor dem mysql update) und das geht wunderbar OHNE pro auf bplaced … musst halt nur den code anpassen da die sql strings veraltet sind …

lg flo

zvn · 1. Juni 2011 um 13:52

Im einfachsten Fall reicht es per Suchen und Ersetzen folgendes auszutauschen:

gegen