DB Probleme

[dywoo]

hallo,

ich bekomme immer dieses Fehler, wenn ich den connector installieren in miene DB will:

You have an error in your SQL syntax near '; ' at line 5 Nr: 1064 in Zeile 4
CREATE TABLE eazysales_adminsession ( cSessionId varchar(255) default NULL, nSessionExpires int(10) unsigned default NULL, cSessionData text );

You have an error in your SQL syntax near '; ' at line 21 Nr: 1064 in Zeile 25
CREATE TABLE eazysales_einstellungen ( currencies_id smallint(6) default NULL, languages_id smallint(6) default NULL, mappingEndkunde varchar(255) default NULL, mappingHaendlerkunde varchar(255) default NULL, shopURL varchar(255) default NULL, tax_class_id int(11) default NULL, tax_zone_id int(11) default NULL, tax_priority int(11) default NULL, shipping_status_id int(11) default NULL, versandMwst float default NULL, cat_listing_template varchar(255) default NULL, cat_category_template varchar(255) default NULL, cat_sorting varchar(255) default NULL, cat_sorting2 varchar(255) default NULL, prod_product_template varchar(255) default NULL, prod_options_template varchar(255) default NULL, StatusAbgeholt tinyint(3) unsigned NOT NULL default '0', StatusVersendet tinyint(3) unsigned NOT NULL default '0' );

You have an error in your SQL syntax near '; ' at line 6 Nr: 1064 in Zeile 31
CREATE TABLE eazysales_mbestellpos ( kBestellPos int(10) unsigned NOT NULL auto_increment, orders_products_id int(10) unsigned default NULL, PRIMARY KEY (kBestellPos) );

You have an error in your SQL syntax near '; ' at line 6 Nr: 1064 in Zeile 37
CREATE TABLE eazysales_martikel ( products_id int(10) unsigned NOT NULL, kArtikel int(10) unsigned default NULL, PRIMARY KEY (products_id) );

You have an error in your SQL syntax near '; ' at line 6 Nr: 1064 in Zeile 43
CREATE TABLE eazysales_mkategorie ( categories_id int(10) unsigned NOT NULL, kKategorie int(10) unsigned default NULL, PRIMARY KEY (categories_id) );

You have an error in your SQL syntax near '; ' at line 7 Nr: 1064 in Zeile 50
CREATE TABLE eazysales_mvariation ( kEigenschaft int(10) unsigned NOT NULL, products_options_id int(10) unsigned default NULL, kArtikel int(11) default NULL, PRIMARY KEY (kEigenschaft) );

You have an error in your SQL syntax near '; ' at line 7 Nr: 1064 in Zeile 57
CREATE TABLE eazysales_mvariationswert ( products_attributes_id int(10) unsigned NOT NULL, kEigenschaftsWert int(10) unsigned default NULL, kArtikel int(11) default NULL, PRIMARY KEY (products_attributes_id) );

You have an error in your SQL syntax near '; ' at line 6 Nr: 1064 in Zeile 63
CREATE TABLE eazysales_sentorders ( orders_id int(10) unsigned NOT NULL, dGesendet datetime default NULL, PRIMARY KEY (orders_id) );

You have an error in your SQL syntax near '; ' at line 5 Nr: 1064 in Zeile 68
CREATE TABLE eazysales_sync ( cName varchar(255) default NULL, cPass varchar(255) default NULL );

Table 'db52271_116.eazysales_sync' doesn't exist Nr: 1146

Woran liegt das?? Ich hoffe ihr könnt mir helfen.

Danke
sagt Dywoo

 

[Thomas Lisson]

Hallo,

schaut nach einer älteren MySQL DB aus. Siehe hierzu den Workaround unter: http://jtl-software.de/forum/viewtopic.php?p=1969#1969