Installation Oxid Open Source bei All-Inkl klappt nicht

e-commerce-blogger · December 15, 2008, 10:13am

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

marco.steinhaeuser · December 15, 2008, 6:14pm

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

marco.steinhaeuser · December 16, 2008, 12:38pm

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

e-commerce-blogger · December 16, 2008, 7:37pm

Hallo Marco,

klaro, hier die Infos:

DB= MySQL 5.5.51a

www.myshop.de/infophp.php

Gruss Knut Barth www.e-commerce-blogger.de

marco.steinhaeuser · December 16, 2008, 8:40pm

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

marco.steinhaeuser · December 16, 2008, 8:42pm

Ach - und ich war so frei, den Thread mal ins Deutsche Forum zu verschieben.

Marco Steinhäuser
Community Operator
OXID eSales AG

e-commerce-blogger · December 17, 2008, 4:21pm

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

simmsen · December 17, 2008, 4:23pm

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…

marco.steinhaeuser · December 18, 2008, 4:32pm

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

e-commerce-blogger · December 18, 2008, 7:45pm

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;

SQL-Befehl:

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

MySQL meldet:

#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

www.e-commerce-blogger.de

marco.steinhaeuser · December 18, 2008, 10:01pm

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

e-commerce-blogger · December 19, 2008, 4:10pm

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

Sven39 · December 19, 2008, 7:25pm

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

marco.steinhaeuser · December 20, 2008, 1:11pm

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

simmsen · December 22, 2008, 12:55pm

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…

marco.steinhaeuser · December 22, 2008, 10:51pm

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