4images Forum & Community

4images Issues / Ausgaben => Installation, Update & Configuration => Topic started by: masterred on March 16, 2012, 10:33:06 PM

Title: fatal error install 4images local
Post by: masterred on March 16, 2012, 10:33:06 PM

hi this is the error

Quote

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

new install
Apache/2.2.21 (Win32) PHP/5.3.5
Mysql Server Version 5.5.19
what  :(

PD:  - MySQL version 3.23 or higher (we recommend MySQL version 3.23.33)


thanks

Title: Re: fatal error install 4images local
Post by: V@no on March 17, 2012, 01:44:28 AM

What 4images version you are trying to install?

Installation Solution >> DB Error: Bad SQL Query [TYPE=MyISAM] [MySQL 5.5] (http://www.4homepages.de/forum/index.php?topic=29971.0)
Download attached to that post 4images.sql.txt file, rename it to mysql_default.sql and copy it to data/database/default/ overwriting the old file. Start installation again.

Title: Re: fatal error install 4images local
Post by: masterred on March 17, 2012, 06:37:50 AM

ok

thanks V@no