-gelöst- probleme bei der Installation

[mineralwasser]

bei der manuellen installation bekomme ich folgende fehlermeldung

#1064 - You have an error in your SQL syntax near 'install/jtlwawi_connector_DB.sql' at line 1

bei der automatischen diesen hier

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 'db144906.eazysales_sync' doesn't exist Nr: 1146

jemand ne ahnung wodran es liegen könnte?

 

[Thomas Lisson]

Hallo,

die manuelle sollte funktionieren. Wird phpmyadmin benutzt und welche mysql version läuft auf dem server?

 

[mineralwasser]

MySQL-Client-Version: 5.0.32
Server Version: 3.23.58- log

sollte klingt immer gut *g

hab ich nun was kaputt gemacht? *lacht (noch)

 

[Thomas Lisson]

Hi,

führe den Inhalt direkt als SQL-Befehl aus:

CREATE TABLE eazysales_adminsession (
  cSessionId varchar(255)  default NULL,
  nSessionExpires int(10) unsigned default NULL,
  cSessionData text 
);

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'
);

CREATE TABLE eazysales_mbestellpos (
  kBestellPos int(10) unsigned NOT NULL auto_increment,
  orders_products_id int(10) unsigned default NULL,
  PRIMARY KEY  (kBestellPos)
);

CREATE TABLE eazysales_martikel (
  products_id int(10) unsigned NOT NULL,
  kArtikel int(10) unsigned default NULL,
  PRIMARY KEY  (products_id)
);

CREATE TABLE eazysales_mkategorie (
  categories_id int(10) unsigned NOT NULL,
  kKategorie int(10) unsigned default NULL,
  PRIMARY KEY  (categories_id)
);

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)
);

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)
);

CREATE TABLE eazysales_sentorders (
  orders_id int(10) unsigned NOT NULL,
  dGesendet datetime default NULL,
  PRIMARY KEY  (orders_id)
);

CREATE TABLE eazysales_sync (
  cName varchar(255)  default NULL,
  cPass varchar(255)  default NULL
);

 

[mineralwasser]

Ihr SQL-Befehl wurde erfolgreich ausgeführt.

und nun? :roll:

vergebe ich nun einen benutzernamen und das passwort?

 

[mineralwasser]

PROBLEM GELÖST