hallo,
ich wollte den shop installieren, bekomme aber folgende fehlermeldung
achso, ich habe den legacy mode aktivieren müssen, wiel ich 1.5 joomla verwende.
hier der fehler.
JInstaller::install: SQL-Fehler DB function failed with error number 1064
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 'ENGINE=MyISAM' at line 61 SQL=CREATE TABLE IF NOT EXISTS `jos_jshopping_config` ( `id` tinyint(4) NOT NULL default '0', `count_products_to_page` int(11) NOT NULL default '0', `count_products_to_row` int(11) NOT NULL default '0', `count_category_to_row` int(11) NOT NULL default '0', `image_category_width` int(11) NOT NULL default '0', `image_category_height` int(11) NOT NULL default '0', `image_product_width` int(11) NOT NULL default '0', `image_product_height` int(11) NOT NULL default '0', `image_product_full_width` int(11) NOT NULL default '0', `image_product_full_height` int(11) NOT NULL default '0', `image_category_path` varchar(255) NOT NULL default '', `image_product_path` varchar(255) NOT NULL default '', `video_product_path` varchar(200) NOT NULL default '', `image_manufs_path` varchar(200) NOT NULL default '', `mainLanguage` varchar(50) NOT NULL default '', `defaultLanguage` varchar(50) NOT NULL default '', `mainCurrency` varchar(10) NOT NULL default '', `decimal_count` TINYINT( 1 ) NOT NULL , `decimal_symbol` VARCHAR( 5 ) NOT NULL , `thousand_separator` VARCHAR( 5 ) NOT NULL , `currency_format` TINYINT( 1 ) NOT NULL, `use_rabatt_code` TINYINT( 1 ) NOT NULL, `enable_wishlist` TINYINT( 1 ) NOT NULL, `remove_prod_f_wishlist` TINYINT( 1 ) DEFAULT '1' NOT NULL, `default_status_order` TINYINT( 1 ) NOT NULL, `isJoomFish` TINYINT ( 1 ) NOT NULL, `order_number_type` varchar(50) NOT NULL, `store_name` VARCHAR( 255 ) NOT NULL , `store_company_name` VARCHAR( 255 ) NOT NULL , `store_url` VARCHAR( 255 ) NOT NULL , `store_address` VARCHAR( 255 ) NOT NULL , `store_city` VARCHAR( 255 ) NOT NULL , `store_country` int(11) NOT NULL , `store_state` VARCHAR( 255 ) NOT NULL , `store_zip` VARCHAR( 12 ) NOT NULL , `store_address_format` VARCHAR( 255 ) NOT NULL , `store_date_format` VARCHAR( 255 ) NOT NULL , `contact_firstname` VARCHAR( 255 ) NOT NULL , `contact_lastname` VARCHAR( 255 ) NOT NULL , `contact_middlename` VARCHAR( 255 ) NOT NULL , `contact_phone` VARCHAR( 255 ) NOT NULL , `contact_fax` VARCHAR( 255 ) NOT NULL , `contact_email` VARCHAR( 255 ) NOT NULL, `benef_bank_name` VARCHAR( 255 ) NOT NULL , `benef_bank_info` VARCHAR( 255 ) NOT NULL , `benef_bic` VARCHAR( 255 ) NOT NULL , `benef_conto` VARCHAR( 255 ) NOT NULL , `benef_iban` VARCHAR( 255 ) NOT NULL , `benef_swift` VARCHAR( 255 ) NOT NULL , `interm_name` VARCHAR( 255 ) NOT NULL , `interm_swift` VARCHAR( 255 ) NOT NULL , `allow_reviews_prod` TINYINT( 1 ) NOT NULL , `allow_reviews_only_registered` TINYINT( 1 ) NOT NULL, `allow_reviews_manuf` TINYINT( 1 ) NOT NULL, `max_mark` INT NOT NULL, `summ_null_shipping` FLOAT( 8, 2 ) NOT NULL, `without_shipping` TINYINT( 1 ) NOT NULL, `shop_special_type` VARCHAR( 255) NOT NULL, `pdf_parameters` VARCHAR( 255) NOT NULL ) ENGINE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_jshopping_config` (
`id` tinyint(4) NOT NULL default '0',
`count_products_to_page` int(11) NOT NULL default '0',
`count_products_to_row` int(11) NOT NULL default '0',
`count_category_to_row` int(11) NOT NULL default '0',
`image_category_width` int(11) NOT NULL default '0',
`image_category_height` int(11) NOT NULL default '0',
`image_product_width` int(11) NOT NULL default '0',
`image_product_height` int(11) NOT NULL default '0',
`image_product_full_width` int(11) NOT NULL default '0',
`image_product_full_height` int(11) NOT NULL default '0',
`image_category_path` varchar(255) NOT NULL default '',
`image_product_path` varchar(255) NOT NULL default '',
`video_product_path` varchar(200) NOT NULL default '',
`image_manufs_path` varchar(200) NOT NULL default '',
`mainLanguage` varchar(50) NOT NULL default '',
`defaultLanguage` varchar(50) NOT NULL default '',
`mainCurrency` varchar(10) NOT NULL default '',
`decimal_count` TINYINT( 1 ) NOT NULL ,
`decimal_symbol` VARCHAR( 5 ) NOT NULL ,
`thousand_separator` VARCHAR( 5 ) NOT NULL ,
`currency_format` TINYINT( 1 ) NOT NULL,
`use_rabatt_code` TINYINT( 1 ) NOT NULL,
`enable_wishlist` TINYINT( 1 ) NOT NULL,
`remove_prod_f_wishlist` TINYINT( 1 ) DEFAULT '1' NOT NULL,
`default_status_order` TINYINT( 1 ) NOT NULL,
`isJoomFish` TINYINT ( 1 ) NOT NULL,
`order_number_type` varchar(50) NOT NULL,
`store_name` VARCHAR( 255 ) NOT NULL ,
`store_company_name` VARCHAR( 255 ) NOT NULL ,
`store_url` VARCHAR( 255 ) NOT NULL ,
`store_address` VARCHAR( 255 ) NOT NULL ,
`store_city` VARCHAR( 255 ) NOT NULL ,
`store_country` int(11) NOT NULL ,
`store_state` VARCHAR( 255 ) NOT NULL ,
`store_zip` VARCHAR( 12 ) NOT NULL ,
`store_address_format` VARCHAR( 255 ) NOT NULL ,
`store_date_format` VARCHAR( 255 ) NOT NULL ,
`contact_firstname` VARCHAR( 255 ) NOT NULL ,
`contact_lastname` VARCHAR( 255 ) NOT NULL ,
`contact_middlename` VARCHAR( 255 ) NOT NULL ,
`contact_phone` VARCHAR( 255 ) NOT NULL ,
`contact_fax` VARCHAR( 255 ) NOT NULL ,
`contact_email` VARCHAR( 255 ) NOT NULL,
`benef_bank_name` VARCHAR( 255 ) NOT NULL ,
`benef_bank_info` VARCHAR( 255 ) NOT NULL ,
`benef_bic` VARCHAR( 255 ) NOT NULL ,
`benef_conto` VARCHAR( 255 ) NOT NULL ,
`benef_iban` VARCHAR( 255 ) NOT NULL ,
`benef_swift` VARCHAR( 255 ) NOT NULL ,
`interm_name` VARCHAR( 255 ) NOT NULL ,
`interm_swift` VARCHAR( 255 ) NOT NULL ,
`allow_reviews_prod` TINYINT( 1 ) NOT NULL ,
`allow_reviews_only_registered` TINYINT( 1 ) NOT NULL,
`allow_reviews_manuf` TINYINT( 1 ) NOT NULL,
`max_mark` INT NOT NULL,
`summ_null_shipping` FLOAT( 8, 2 ) NOT NULL,
`without_shipping` TINYINT( 1 ) NOT NULL,
`shop_special_type` VARCHAR( 255) NOT NULL,
`pdf_parameters` VARCHAR( 255) NOT NULL
) ENGINE=MyISAM;
könnt ihr mir bitte helfen?
danke
tilley