Hallo, ich habe mir bei all-inkl eine DB MySQL5 angelegt und bei er Installation wird in Schritt 3 dann mit jeder Menge SQL Fehler gemeckert. Wenn ich in die DB reinschaue, stehen aber schon eine Menge Oxid Tabellen drin, woraus ich schließe, dass die DB korrekt gefunden wird. Ich bekomme folgende Meldung, kann jemand etwas damit anfangen? FEHLER: (Tabellen)Probleme mit folgenden SQL Befehlen: 'SET @@session.sql_mode = ‘’; CREATE TABLE oxadminlog
( OXDATE
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, OXUSERID
char(32) NOT NULL default ‘’, OXSQL
text NOT NULL) TYPE=MyISAM; CREATE TABLE oxarticles
( OXID
varchar(32) NOT NULL default ‘’, OXSHOPID
varchar(32) NOT NULL default ‘’, OXPARENTID
char(32) NOT NULL default ‘’, OXACTIVE
tinyint(1) NOT NULL DEFAULT ‘1’, OXACTIVEFROM
datetime NOT NULL default ‘0000-00-00 00:00:00’, OXACTIVETO
datetime NOT NULL default ‘0000-00-00 00:00:00’, OXARTNUM
varchar(255) NOT NULL default ‘’, OXEAN
varchar(13) NOT NULL default ‘’, OXDISTEAN
varchar(13) NOT NULL default ‘’, OXTITLE
varchar(255) NOT NULL default ‘’, OXSHORTDESC
varchar(255) NOT NULL default ‘’, OXPRICE
double NOT NULL default ‘0’, OXBLFIXEDPRICE
tinyint(1) NOT NULL default ‘0’, OXPRICEA
double NOT NULL default ‘0’, OXPRICEB
double NOT NULL default ‘0’, OXPRICEC
double NOT NULL default ‘0’, OXBPRICE
double NOT NULL default ‘0’, OXTPRICE
double NOT NULL default ‘0’, OXUNITNAME
varchar(32) NOT NULL default ‘’, OXUNITQUANTITY
double NOT NULL default ‘0’, OXEXTURL
varchar(255) NOT NULL default ‘’, OXURLDESC
varchar(255) NOT NULL default ‘’, OXURLIMG
varchar(128) NOT NULL default ‘’, OXVAT
float default NULL, OXTHUMB
varchar(128) NOT NULL default ‘’, OXICON
varchar(128) NOT NULL default ‘’, OXPIC1
varchar(128) NOT NULL default ‘’, OXPIC2
varchar(128) NOT NULL default ‘’, OXPIC3
varchar(128) NOT NULL default ‘’, OXPIC4
varchar(128) NOT NULL default ‘’, OXPIC5
varchar(128) NOT NULL default ‘’, OXPIC6
varchar(128) NOT NULL default ‘’, OXPIC7
varchar(128) NOT NULL default ‘’, OXPIC8
varchar(128) NOT NULL default ‘’, OXPIC9
varchar(128) NOT NULL default ‘’, OXPIC10
varchar(128) NOT NULL default ‘’, OXPIC11
varchar(128) NOT NULL default ‘’, OXPIC12
varchar(128) NOT NULL default ‘’, OXZOOM1
varchar(128) NOT NULL default ‘’, OXZOOM2
varchar(128) NOT NULL default ‘’, OXZOOM3
varchar(128) NOT NULL default ‘’, OXZOOM4
varchar(128) NOT NULL default ‘’, OXWEIGHT
double NOT NULL default ‘0’, OXSTOCK
double NOT NULL default ‘-1’, OXSTOCKFLAG
tinyint(1) NOT NULL default ‘1’, OXSTOCKTEXT
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT
varchar(255) NOT NULL default ‘’, OXDELIVERY
date NOT NULL default ‘0000-00-00’, OXINSERT
date NOT NULL default ‘0000-00-00’, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, OXLENGTH
double NOT NULL default ‘0’, OXWIDTH
double NOT NULL default ‘0’, OXHEIGHT
double NOT NULL default ‘0’, OXFILE
varchar(128) NOT NULL default ‘’, OXSEARCHKEYS
varchar(255) NOT NULL default ‘’, OXTEMPLATE
varchar(128) NOT NULL default ‘’, OXQUESTIONEMAIL
varchar(255) NOT NULL default ‘’, OXISSEARCH
tinyint(1) NOT NULL default ‘1’, OXVARNAME
varchar(32) NOT NULL default ‘’, OXVARSTOCK
int(5) NOT NULL default ‘0’, OXVARCOUNT
int(1) NOT NULL default ‘0’, OXVARSELECT
varchar(32) NOT NULL default ‘’, OXVARMINPRICE
double NOT NULL default ‘0’, OXVARNAME_1
varchar(32) NOT NULL default ‘’, OXVARSELECT_1
varchar(32) NOT NULL default ‘’, OXVARNAME_2
varchar(32) NOT NULL default ‘’, OXVARSELECT_2
varchar(32) NOT NULL default ‘’, OXVARNAME_3
varchar(32) NOT NULL default ‘’, OXVARSELECT_3
varchar(32) NOT NULL default ‘’, OXTITLE_1
varchar(255) NOT NULL default ‘’, OXSHORTDESC_1
varchar(255) NOT NULL default ‘’, OXURLDESC_1
varchar(255) NOT NULL default ‘’, OXSEARCHKEYS_1
varchar(255) NOT NULL default ‘’, OXTITLE_2
varchar(255) NOT NULL default ‘’, OXSHORTDESC_2
varchar(255) NOT NULL default ‘’, OXURLDESC_2
varchar(255) NOT NULL default ‘’, OXSEARCHKEYS_2
varchar(255) NOT NULL default ‘’, OXTITLE_3
varchar(255) NOT NULL default ‘’, OXSHORTDESC_3
varchar(255) NOT NULL default ‘’, OXURLDESC_3
varchar(255) NOT NULL default ‘’, OXSEARCHKEYS_3
varchar(255) NOT NULL default ‘’, OXBUNDLEID
varchar(32) NOT NULL default ‘’, OXFOLDER
varchar(32) NOT NULL default ‘’, OXSUBCLASS
varchar(32) NOT NULL default ‘’, OXSTOCKTEXT_1
varchar(255) NOT NULL default ‘’, OXSTOCKTEXT_2
varchar(255) NOT NULL default ‘’, OXSTOCKTEXT_3
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT_1
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT_2
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT_3
varchar(255) NOT NULL default ‘’, OXSORT
int(5) NOT NULL default ‘0’, OXSOLDAMOUNT
double NOT NULL default ‘0’, OXNONMATERIAL
int(1) NOT NULL default ‘0’, OXFREESHIPPING
int(1) NOT NULL default ‘0’, OXREMINDACTIV
int(1) NOT NULL default ‘0’, OXREMINDAMOUNT
double NOT NULL default ‘0’, OXAMITEMID
varchar(32) NOT NULL default ‘’, OXAMTASKID
varchar(16) NOT NULL default ‘0’, OXVENDORID
varchar(32) NOT NULL default ‘’, OXSKIPDISCOUNTS
tinyint(1) NOT NULL default ‘0’, OXRATING
double NOT NULL default ‘0’, OXRATINGCNT
int(11) NOT NULL default ‘0’, PRIMARY KEY (OXID
), KEY OXCOUNT
(OXPARENTID
,OXSHOPID
), KEY OXSORT
(OXSORT
), KEY OXSHOPID
(OXSHOPID
), KEY OXISSEARCH
(OXISSEARCH
), KEY OXARTNUM
(OXARTNUM
), KEY OXPARENTID
(OXPARENTID
), KEY OXSTOCK
(OXSTOCK
), KEY OXSTOCKFLAG
(OXSTOCKFLAG
), KEY OXINSERT
(OXINSERT
), KEY OXVARNAME
(OXVARNAME
), KEY OXACTIVE
(OXACTIVE
), KEY OXACTIVEFROM
(OXACTIVEFROM
), KEY OXACTIVETO
(OXACTIVETO
))TYPE=InnoDB; CREATE TABLE oxobject2list
( OXID
char(32) NOT NULL default ‘’, OXOBJECTID
char(32) NOT NULL default ‘’, OXLISTID
char(32) NOT NULL default ‘’, OXDESC
text NOT NULL default ‘’, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXID
), KEY OXOBJECTID
(OXOBJECTID
), KEY OXLISTID
(OXLISTID
)) TYPE=MyISAM; CREATE TABLE oxratings
( OXID
char(32) NOT NULL default ‘’, OXSHOPID
char(32) NOT NULL default ‘’, OXUSERID
char(32) NOT NULL default ‘’, OXTYPE
enum(‘oxarticle’,‘oxrecommlist’) NOT NULL, OXOBJECTID
char(32) NOT NULL default ‘’, OXRATING
int(1) NOT NULL default ‘0’, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXID
), KEY oxobjectsearch
(OXTYPE
,OXOBJECTID
)) TYPE=MyISAM; CREATE TABLE oxseohistory
( OXOBJECTID
char(32) NOT NULL, OXIDENT
char(32) NOT NULL, OXSHOPID
char(32) NOT NULL default ‘’, OXLANG
int(2) NOT NULL default ‘0’, OXHITS
bigint(20) NOT NULL default ‘0’, OXINSERT
timestamp NULL default NULL, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXIDENT
,OXSHOPID
,OXLANG
), KEY search
(OXOBJECTID
,OXSHOPID
,OXLANG
)) ENGINE=InnoDB; CREATE TABLE IF NOT EXISTS oxseologs
( OXSTDURL
text NOT NULL, OXIDENT
char(32) NOT NULL, OXSHOPID
char(32) NOT NULL default ‘’, OXLANG
int(11) NOT NULL, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXIDENT
,OXSHOPID
,OXLANG
)) ENGINE=InnoDB; REPLACE oxconfig
(OXID
, OXSHOPID
, OXVARNAME
, OXVARTYPE
, OXVARVALUE
)SELECT CONCAT( ‘6c914914e95082ddc2’, oxshops.OXID), oxshops.OXID, ‘sPasswdSalt’, ‘str’, UUID() FROM oxshops; Vorab Danke und Gruss Knut Barth
Hallo Knut,
so etwas kommt mir bekannt vor. Lass mich mal suchen, ich meld mich dann wieder hier.
Gruß
Marco Steinhäuser
Community Operator
OXID eSales AG
Hallo Knut,
viel weiter bin ich leider noch nicht gekommen. Postest Du bitte mal Deine Datenbank-Version und schickst mir eine phpinfo per PN?
Danke und Gruß
Marco Steinhäuser
Community Operator
OXID eSales AG
Hallo Knut,
Du meinst 5.0.51a? Wie bist Du vorgegangen um das herauszubekommen?
Schau Dir bitte auch mal dringend die Systemvoraussetzungen an, mit PHP4 geht hier gor nix.
Und lösch bitte die phpinfo wieder von Deinem Server
Gruß
Marco Steinhäuser
Community Operator
OXID eSales AG
Ach - und ich war so frei, den Thread mal ins Deutsche Forum zu verschieben.
Marco Steinhäuser
Community Operator
OXID eSales AG
Hallo Marco,
die DB Version habe ich aus dem Tool für die Bearbeitung der DB ausgelesen.
Die PHP Version habe ich nun per htaccess umgestellt mit AddHandler php5-cgi .php
Es kommen leider immer noch die gleichen SQL Fehler.
Gruss Knut Barth www.e-commerce-blogger.de
Ich habe auch bei all-inkl installiert, ohne Probleme.
Alles was mir auffällt, ist ein etwas langsamer Shop. Kann man noch tunen?
____________ Christian Labrador Retriever, Bogenbau und Bogensport Fan…
Hallo Knuth,
pack doch mal bitte das komplette SQL statement von 'SET @@session.sql_mode = ‘’; CREATE… bis … ‘sPasswdSalt’, ‘str’, UUID() FROM oxshops; in phpMyAdmin (Tool für die Bearbeitung der DB). Wollen doch mal sehen, ob er uns da nicht einen verwertbaren Fehler ausspuckt.
@simmsen: Unter Grundeinstellungen im Admin gibt es einen Karteireiter namens “Perform.”, in dem man die Performance des Shops beeinflussen kann. Prinzipiell ist das bei Hosted Webspace immer so eine Sache: Du weißt nie, ob einer Deiner 200-300 Mitbenutzer auf dem Server nicht soeben eine hochfrequentierte Seite laufen haben…
Gruß
Marco Steinhäuser
Community Operator
OXID eSales AG
Hi Marco,
here it is:
Fehler
Es scheint einen Fehler in Ihrer MySQL-Abfrage zu geben. Die MySQL-Fehlerausgabe, falls vorhanden, kann Ihnen auch bei der Fehleranalyse helfen.
ERROR: Nicht geschlossene Anführungszeichen @ 7124
STR: '
SQL: 'SET @@session.sql_mode = ‘’; CREATE TABLE oxadminlog
( OXDATE
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, OXUSERID
char(32) NOT NULL default ‘’, OXSQL
text NOT NULL) TYPE=MyISAM; CREATE TABLE oxarticles
( OXID
varchar(32) NOT NULL default ‘’, OXSHOPID
varchar(32) NOT NULL default ‘’, OXPARENTID
char(32) NOT NULL default ‘’, OXACTIVE
tinyint(1) NOT NULL DEFAULT ‘1’, OXACTIVEFROM
datetime NOT NULL default ‘0000-00-00 00:00:00’, OXACTIVETO
datetime NOT NULL default ‘0000-00-00 00:00:00’, OXARTNUM
varchar(255) NOT NULL default ‘’, OXEAN
varchar(13) NOT NULL default ‘’, OXDISTEAN
varchar(13) NOT NULL default ‘’, OXTITLE
varchar(255) NOT NULL default ‘’, OXSHORTDESC
varchar(255) NOT NULL default ‘’, OXPRICE
double NOT NULL default ‘0’, OXBLFIXEDPRICE
tinyint(1) NOT NULL default ‘0’, OXPRICEA
double NOT NULL default ‘0’, OXPRICEB
double NOT NULL default ‘0’, OXPRICEC
double NOT NULL default ‘0’, OXBPRICE
double NOT NULL default ‘0’, OXTPRICE
double NOT NULL default ‘0’, OXUNITNAME
varchar(32) NOT NULL default ‘’, OXUNITQUANTITY
double NOT NULL default ‘0’, OXEXTURL
varchar(255) NOT NULL default ‘’, OXURLDESC
varchar(255) NOT NULL default ‘’, OXURLIMG
varchar(128) NOT NULL default ‘’, OXVAT
float default NULL, OXTHUMB
varchar(128) NOT NULL default ‘’, OXICON
varchar(128) NOT NULL default ‘’, OXPIC1
varchar(128) NOT NULL default ‘’, OXPIC2
varchar(128) NOT NULL default ‘’, OXPIC3
varchar(128) NOT NULL default ‘’, OXPIC4
varchar(128) NOT NULL default ‘’, OXPIC5
varchar(128) NOT NULL default ‘’, OXPIC6
varchar(128) NOT NULL default ‘’, OXPIC7
varchar(128) NOT NULL default ‘’, OXPIC8
varchar(128) NOT NULL default ‘’, OXPIC9
varchar(128) NOT NULL default ‘’, OXPIC10
varchar(128) NOT NULL default ‘’, OXPIC11
varchar(128) NOT NULL default ‘’, OXPIC12
varchar(128) NOT NULL default ‘’, OXZOOM1
varchar(128) NOT NULL default ‘’, OXZOOM2
varchar(128) NOT NULL default ‘’, OXZOOM3
varchar(128) NOT NULL default ‘’, OXZOOM4
varchar(128) NOT NULL default ‘’, OXWEIGHT
double NOT NULL default ‘0’, OXSTOCK
double NOT NULL default ‘-1’, OXSTOCKFLAG
tinyint(1) NOT NULL default ‘1’, OXSTOCKTEXT
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT
varchar(255) NOT NULL default ‘’, OXDELIVERY
date NOT NULL default ‘0000-00-00’, OXINSERT
date NOT NULL default ‘0000-00-00’, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, OXLENGTH
double NOT NULL default ‘0’, OXWIDTH
double NOT NULL default ‘0’, OXHEIGHT
double NOT NULL default ‘0’, OXFILE
varchar(128) NOT NULL default ‘’, OXSEARCHKEYS
varchar(255) NOT NULL default ‘’, OXTEMPLATE
varchar(128) NOT NULL default ‘’, OXQUESTIONEMAIL
varchar(255) NOT NULL default ‘’, OXISSEARCH
tinyint(1) NOT NULL default ‘1’, OXVARNAME
varchar(32) NOT NULL default ‘’, OXVARSTOCK
int(5) NOT NULL default ‘0’, OXVARCOUNT
int(1) NOT NULL default ‘0’, OXVARSELECT
varchar(32) NOT NULL default ‘’, OXVARMINPRICE
double NOT NULL default ‘0’, OXVARNAME_1
varchar(32) NOT NULL default ‘’, OXVARSELECT_1
varchar(32) NOT NULL default ‘’, OXVARNAME_2
varchar(32) NOT NULL default ‘’, OXVARSELECT_2
varchar(32) NOT NULL default ‘’, OXVARNAME_3
varchar(32) NOT NULL default ‘’, OXVARSELECT_3
varchar(32) NOT NULL default ‘’, OXTITLE_1
varchar(255) NOT NULL default ‘’, OXSHORTDESC_1
varchar(255) NOT NULL default ‘’, OXURLDESC_1
varchar(255) NOT NULL default ‘’, OXSEARCHKEYS_1
varchar(255) NOT NULL default ‘’, OXTITLE_2
varchar(255) NOT NULL default ‘’, OXSHORTDESC_2
varchar(255) NOT NULL default ‘’, OXURLDESC_2
varchar(255) NOT NULL default ‘’, OXSEARCHKEYS_2
varchar(255) NOT NULL default ‘’, OXTITLE_3
varchar(255) NOT NULL default ‘’, OXSHORTDESC_3
varchar(255) NOT NULL default ‘’, OXURLDESC_3
varchar(255) NOT NULL default ‘’, OXSEARCHKEYS_3
varchar(255) NOT NULL default ‘’, OXBUNDLEID
varchar(32) NOT NULL default ‘’, OXFOLDER
varchar(32) NOT NULL default ‘’, OXSUBCLASS
varchar(32) NOT NULL default ‘’, OXSTOCKTEXT_1
varchar(255) NOT NULL default ‘’, OXSTOCKTEXT_2
varchar(255) NOT NULL default ‘’, OXSTOCKTEXT_3
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT_1
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT_2
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT_3
varchar(255) NOT NULL default ‘’, OXSORT
int(5) NOT NULL default ‘0’, OXSOLDAMOUNT
double NOT NULL default ‘0’, OXNONMATERIAL
int(1) NOT NULL default ‘0’, OXFREESHIPPING
int(1) NOT NULL default ‘0’, OXREMINDACTIV
int(1) NOT NULL default ‘0’, OXREMINDAMOUNT
double NOT NULL default ‘0’, OXAMITEMID
varchar(32) NOT NULL default ‘’, OXAMTASKID
varchar(16) NOT NULL default ‘0’, OXVENDORID
varchar(32) NOT NULL default ‘’, OXSKIPDISCOUNTS
tinyint(1) NOT NULL default ‘0’, OXRATING
double NOT NULL default ‘0’, OXRATINGCNT
int(11) NOT NULL default ‘0’, PRIMARY KEY (OXID
), KEY OXCOUNT
(OXPARENTID
,OXSHOPID
), KEY OXSORT
(OXSORT
), KEY OXSHOPID
(OXSHOPID
), KEY OXISSEARCH
(OXISSEARCH
), KEY OXARTNUM
(OXARTNUM
), KEY OXPARENTID
(OXPARENTID
), KEY OXSTOCK
(OXSTOCK
), KEY OXSTOCKFLAG
(OXSTOCKFLAG
), KEY OXINSERT
(OXINSERT
), KEY OXVARNAME
(OXVARNAME
), KEY OXACTIVE
(OXACTIVE
), KEY OXACTIVEFROM
(OXACTIVEFROM
), KEY OXACTIVETO
(OXACTIVETO
))TYPE=InnoDB; CREATE TABLE oxobject2list
( OXID
char(32) NOT NULL default ‘’, OXOBJECTID
char(32) NOT NULL default ‘’, OXLISTID
char(32) NOT NULL default ‘’, OXDESC
text NOT NULL default ‘’, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXID
), KEY OXOBJECTID
(OXOBJECTID
), KEY OXLISTID
(OXLISTID
)) TYPE=MyISAM; CREATE TABLE oxratings
( OXID
char(32) NOT NULL default ‘’, OXSHOPID
char(32) NOT NULL default ‘’, OXUSERID
char(32) NOT NULL default ‘’, OXTYPE
enum(‘oxarticle’,‘oxrecommlist’) NOT NULL, OXOBJECTID
char(32) NOT NULL default ‘’, OXRATING
int(1) NOT NULL default ‘0’, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXID
), KEY oxobjectsearch
(OXTYPE
,OXOBJECTID
)) TYPE=MyISAM; CREATE TABLE oxseohistory
( OXOBJECTID
char(32) NOT NULL, OXIDENT
char(32) NOT NULL, OXSHOPID
char(32) NOT NULL default ‘’, OXLANG
int(2) NOT NULL default ‘0’, OXHITS
bigint(20) NOT NULL default ‘0’, OXINSERT
timestamp NULL default NULL, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXIDENT
,OXSHOPID
,OXLANG
), KEY search
(OXOBJECTID
,OXSHOPID
,OXLANG
)) ENGINE=InnoDB; CREATE TABLE IF NOT EXISTS oxseologs
( OXSTDURL
text NOT NULL, OXIDENT
char(32) NOT NULL, OXSHOPID
char(32) NOT NULL default ‘’, OXLANG
int(11) NOT NULL, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXIDENT
,OXSHOPID
,OXLANG
)) ENGINE=InnoDB; REPLACE oxconfig
(OXID
, OXSHOPID
, OXVARNAME
, OXVARTYPE
, OXVARVALUE
)SELECT CONCAT( ‘6c914914e95082ddc2’, oxshops.OXID), oxshops.OXID, ‘sPasswdSalt’, ‘str’, UUID() FROM oxshops;
'SET @@session.sql_mode = ‘’; CREATE TABLE oxadminlog
( OXDATE
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, OXUSERID
char(32) NOT NULL default ‘’, OXSQL
text NOT NULL) TYPE=MyISAM; CREATE TABLE oxarticles
( OXID
varchar(32) NOT NULL default ‘’, OXSHOPID
varchar(32) NOT NULL default ‘’, OXPARENTID
char(32) NOT NULL default ‘’, OXACTIVE
tinyint(1) NOT NULL DEFAULT ‘1’, OXACTIVEFROM
datetime NOT NULL default ‘0000-00-00 00:00:00’, OXACTIVETO
datetime NOT NULL default ‘0000-00-00 00:00:00’, OXARTNUM
varchar(255) NOT NULL default ‘’, OXEAN
varchar(13) NOT NULL default ‘’, OXDISTEAN
varchar(13) NOT NULL default ‘’, OXTITLE
varchar(255) NOT NULL default ‘’, OXSHORTDESC
varchar(255) NOT NULL default ‘’, OXPRICE
double NOT NULL default ‘0’, OXBLFIXEDPRICE
tinyint(1) NOT NULL default ‘0’, OXPRICEA
double NOT NULL default ‘0’, OXPRICEB
double NOT NULL default ‘0’, OXPRICEC
double NOT NULL default ‘0’, OXBPRICE
double NOT NULL default ‘0’, OXTPRICE
double NOT NULL default ‘0’, OXUNITNAME
varchar(32) NOT NULL default ‘’, OXUNITQUANTITY
double NOT NULL default ‘0’, OXEXTURL
varchar(255) NOT NULL default ‘’, OXURLDESC
varchar(255) NOT NULL default ‘’, OXURLIMG
varchar(128) NOT NULL default ‘’, OXVAT
float default NULL, OXTHUMB
varchar(128) NOT NULL default ‘’, OXICON
varchar(128) NOT NULL default ‘’, OXPIC1
varchar(128) NOT NULL default ‘’, OXPIC2
varchar(128) NOT NULL default ‘’, OXPIC3
varchar(128) NOT NULL default ‘’, OXPIC4
varchar(128) NOT NULL default ‘’, OXPIC5
varchar(128) NOT NULL default ‘’, OXPIC6
varchar(128) NOT NULL default ‘’, OXPIC7
varchar(128) NOT NULL default ‘’, OXPIC8
varchar(128) NOT NULL default ‘’, OXPIC9
varchar(128) NOT NULL default ‘’, OXPIC10
varchar(128) NOT NULL default ‘’, OXPIC11
varchar(128) NOT NULL default ‘’, OXPIC12
varchar(128) NOT NULL default ‘’, OXZOOM1
varchar(128) NOT NULL default ‘’, OXZOOM2
varchar(128) NOT NULL default ‘’, OXZOOM3
varchar(128) NOT NULL default ‘’, OXZOOM4
varchar(128) NOT NULL default ‘’, OXWEIGHT
double NOT NULL default ‘0’, OXSTOCK
double NOT NULL default ‘-1’, OXSTOCKFLAG
tinyint(1) NOT NULL default ‘1’, OXSTOCKTEXT
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT
varchar(255) NOT NULL default ‘’, OXDELIVERY
date NOT NULL default ‘0000-00-00’, OXINSERT
date NOT NULL default ‘0000-00-00’, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, OXLENGTH
double NOT NULL default ‘0’, OXWIDTH
double NOT NULL default ‘0’, OXHEIGHT
double NOT NULL default ‘0’, OXFILE
varchar(128) NOT NULL default ‘’, OXSEARCHKEYS
varchar(255) NOT NULL default ‘’, OXTEMPLATE
varchar(128) NOT NULL default ‘’, OXQUESTIONEMAIL
varchar(255) NOT NULL default ‘’, OXISSEARCH
tinyint(1) NOT NULL default ‘1’, OXVARNAME
varchar(32) NOT NULL default ‘’, OXVARSTOCK
int(5) NOT NULL default ‘0’, OXVARCOUNT
int(1) NOT NULL default ‘0’, OXVARSELECT
varchar(32) NOT NULL default ‘’, OXVARMINPRICE
double NOT NULL default ‘0’, OXVARNAME_1
varchar(32) NOT NULL default ‘’, OXVARSELECT_1
varchar(32) NOT NULL default ‘’, OXVARNAME_2
varchar(32) NOT NULL default ‘’, OXVARSELECT_2
varchar(32) NOT NULL default ‘’, OXVARNAME_3
varchar(32) NOT NULL default ‘’, OXVARSELECT_3
varchar(32) NOT NULL default ‘’, OXTITLE_1
varchar(255) NOT NULL default ‘’, OXSHORTDESC_1
varchar(255) NOT NULL default ‘’, OXURLDESC_1
varchar(255) NOT NULL default ‘’, OXSEARCHKEYS_1
varchar(255) NOT NULL default ‘’, OXTITLE_2
varchar(255) NOT NULL default ‘’, OXSHORTDESC_2
varchar(255) NOT NULL default ‘’, OXURLDESC_2
varchar(255) NOT NULL default ‘’, OXSEARCHKEYS_2
varchar(255) NOT NULL default ‘’, OXTITLE_3
varchar(255) NOT NULL default ‘’, OXSHORTDESC_3
varchar(255) NOT NULL default ‘’, OXURLDESC_3
varchar(255) NOT NULL default ‘’, OXSEARCHKEYS_3
varchar(255) NOT NULL default ‘’, OXBUNDLEID
varchar(32) NOT NULL default ‘’, OXFOLDER
varchar(32) NOT NULL default ‘’, OXSUBCLASS
varchar(32) NOT NULL default ‘’, OXSTOCKTEXT_1
varchar(255) NOT NULL default ‘’, OXSTOCKTEXT_2
varchar(255) NOT NULL default ‘’, OXSTOCKTEXT_3
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT_1
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT_2
varchar(255) NOT NULL default ‘’, OXNOSTOCKTEXT_3
varchar(255) NOT NULL default ‘’, OXSORT
int(5) NOT NULL default ‘0’, OXSOLDAMOUNT
double NOT NULL default ‘0’, OXNONMATERIAL
int(1) NOT NULL default ‘0’, OXFREESHIPPING
int(1) NOT NULL default ‘0’, OXREMINDACTIV
int(1) NOT NULL default ‘0’, OXREMINDAMOUNT
double NOT NULL default ‘0’, OXAMITEMID
varchar(32) NOT NULL default ‘’, OXAMTASKID
varchar(16) NOT NULL default ‘0’, OXVENDORID
varchar(32) NOT NULL default ‘’, OXSKIPDISCOUNTS
tinyint(1) NOT NULL default ‘0’, OXRATING
double NOT NULL default ‘0’, OXRATINGCNT
int(11) NOT NULL default ‘0’, PRIMARY KEY (OXID
), KEY OXCOUNT
(OXPARENTID
,OXSHOPID
), KEY OXSORT
(OXSORT
), KEY OXSHOPID
(OXSHOPID
), KEY OXISSEARCH
(OXISSEARCH
), KEY OXARTNUM
(OXARTNUM
), KEY OXPARENTID
(OXPARENTID
), KEY OXSTOCK
(OXSTOCK
), KEY OXSTOCKFLAG
(OXSTOCKFLAG
), KEY OXINSERT
(OXINSERT
), KEY OXVARNAME
(OXVARNAME
), KEY OXACTIVE
(OXACTIVE
), KEY OXACTIVEFROM
(OXACTIVEFROM
), KEY OXACTIVETO
(OXACTIVETO
))TYPE=InnoDB; CREATE TABLE oxobject2list
( OXID
char(32) NOT NULL default ‘’, OXOBJECTID
char(32) NOT NULL default ‘’, OXLISTID
char(32) NOT NULL default ‘’, OXDESC
text NOT NULL default ‘’, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXID
), KEY OXOBJECTID
(OXOBJECTID
), KEY OXLISTID
(OXLISTID
)) TYPE=MyISAM; CREATE TABLE oxratings
( OXID
char(32) NOT NULL default ‘’, OXSHOPID
char(32) NOT NULL default ‘’, OXUSERID
char(32) NOT NULL default ‘’, OXTYPE
enum(‘oxarticle’,‘oxrecommlist’) NOT NULL, OXOBJECTID
char(32) NOT NULL default ‘’, OXRATING
int(1) NOT NULL default ‘0’, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXID
), KEY oxobjectsearch
(OXTYPE
,OXOBJECTID
)) TYPE=MyISAM; CREATE TABLE oxseohistory
( OXOBJECTID
char(32) NOT NULL, OXIDENT
char(32) NOT NULL, OXSHOPID
char(32) NOT NULL default ‘’, OXLANG
int(2) NOT NULL default ‘0’, OXHITS
bigint(20) NOT NULL default ‘0’, OXINSERT
timestamp NULL default NULL, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXIDENT
,OXSHOPID
,OXLANG
), KEY search
(OXOBJECTID
,OXSHOPID
,OXLANG
)) ENGINE=InnoDB; CREATE TABLE IF NOT EXISTS oxseologs
( OXSTDURL
text NOT NULL, OXIDENT
char(32) NOT NULL, OXSHOPID
char(32) NOT NULL default ‘’, OXLANG
int(11) NOT NULL, OXTIMESTAMP
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (OXIDENT
,OXSHOPID
,OXLANG
)) ENGINE=InnoDB; REPLACE oxconfig
(OXID
, OXSHOPID
, OXVARNAME
, OXVARTYPE
, OXVARVALUE
)SELECT CONCAT( ‘6c914914e95082ddc2’, oxshops.OXID), oxshops.OXID, ‘sPasswdSalt’, ‘str’, UUID() FROM oxshops;
#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 ''SET @@session.sql_mode = ‘’; CREATE TABLE oxadminlog
( `OXDA
Gruss Knut Barth
Aha! Wir kommen der Sache näher. Bitte prüf mal folgendes:
-
Hast Du MySQL 5.5.51a auf Deinem Server, wie Du schreibst oder ist es tatsächlich die Version 5.0.51a? Meines Wissens ist die Version 5.1. gerade draussen (http://www.mysql.com)
-
Das Tool für die Bearbeitung der DB: Heißt es wirklich phpMyAdmin oder irgendwie anders?
-
Wurde die Dir vorliegende zip-Datei wirklich komplett und fehlerfrei herunter geladen? Ist die sql-Datei valid und nicht kaputt? Im Zweifelsfall bitte nochmal herunter laden.
Gruß
Marco Steinhäuser
Community Operator
OXID eSales AG
Hallo Marko,
das Tool nennt sich phpMyAdmin - 2.11.9.1.
Ich habe den Verdacht, die DB Version könnte doch einer 4er sein. Ich habe wohl die Client Version abgelesen und lasse das gerade nochmal umstellen.
Danke schon einmal.
Gruss Knut Barth www.e-commerce-blogger.de
Hi, Ich habe den Shop auch auf einen Server bei Allinkl.com Installiert habe eine neue Datenbank genommen und mußte die Dateiatribute von 755 auf 777 setzen dann ging es ohne problem. Mußt nur die config.inc.php wieder auf 755 zurückstellen so viel ich weiß.
vieleicht hilft dir meine Antwort ja !!
gruß Sven
Hallo Knut,
Deine phpinfo war noch immer auf dem Server erreichbar. Ich war deshalb so frei, den Link im Post zu verändern. Die Datei muss unbedingt von Deinem Server verschwinden!
Gruß
Marco Steinhäuser
Community Operator
OXID eSales AG
Hallo Marco,
was kann man denn schlimmes anfangen mit dieser Datei ausser sehen wie der Server aufgebaut ist?
____________ Christian Labrador Retriever, Bogenbau und Bogensport Fan…
Hallo Christian,
das poste ich ganz sicher nicht öffentlich
Ach, falls es interessiert: Ich fröne übrigens auch dem Bogensport, allerdings eher so der amerikanischen Sport-Variante.
mit sportlichen Grüßen
Marco Steinhäuser
Community Operator
OXID eSales AG