Shop offline nach DB-Restore

Deutsches Forum
1

Hallöchen allerseits,

bisher erstelle ich meine OXID-Testumgebung mit einem kleinen Script, welches die Original-Shop-DB kopiert und in die Testumgebung wieder einspielt. Funktioniert auch bisher wunderbar.

Es wird hier im Forum jedoch immer empfohlen, die oxv_-Tabellen nicht mitzusichern.
Ich habe das Script also dahingehend geändert, das die Views nicht mitgedumpt werden.

Wenn ich diesen Dump jedoch in die Testumgebung einspiele, komme ich nur noch auf die Offline-Page. Auch der Admin ist nicht erreichbar und wird auf die Offline-Page umgeleitet. /tmp wird im Script automatisch geleert.

Übersehe ich da evtl. irgendwas?

Gruß, tronico

2

Version: PE 4.8.6

Auszug aus dem EXCEPTION_LOG:

oxConnectionException-oxException (time: 2014-06-22 22:35:19): [1146]: mysql:EXECUTE error: [1146: Table ‘c1_oxid_test.oxv_oxshops_de’ doesn’t exist] in EXECUTE with parameters select oxv_oxshops_de.oxid, oxv_oxshops_de.oxactive, oxv_oxshops_de.oxproductive, oxv_oxshops_de.oxdefcurrency, oxv_oxshops_de.oxdeflanguage, oxv_oxshops_de.oxname, oxv_oxshops_de.oxtitleprefix, oxv_oxshops_de.oxtitlesuffix, oxv_oxshops_de.oxstarttitle, oxv_oxshops_de.oxinfoemail, oxv_oxshops_de.oxorderemail, oxv_oxshops_de.oxowneremail, oxv_oxshops_de.oxordersubject, oxv_oxshops_de.oxregistersubject, oxv_oxshops_de.oxforgotpwdsubject, oxv_oxshops_de.oxsendednowsubject, oxv_oxshops_de.oxsmtp, oxv_oxshops_de.oxsmtpuser, oxv_oxshops_de.oxsmtppwd, oxv_oxshops_de.oxserial, oxv_oxshops_de.oxcompany, oxv_oxshops_de.oxstreet, oxv_oxshops_de.oxzip, oxv_oxshops_de.oxcity, oxv_oxshops_de.oxcountry, oxv_oxshops_de.oxbankname, oxv_oxshops_de.oxbanknumber, oxv_oxshops_de.oxbankcode, oxv_oxshops_de.oxvatnumber, oxv_oxshops_de.oxbiccode, oxv_oxshops_de.oxibannumber, oxv_oxshops_de.oxfname, oxv_oxshops_de.oxlname, oxv_oxshops_de.oxtelefon, oxv_oxshops_de.oxtelefax, oxv_oxshops_de.oxurl, oxv_oxshops_de.oxdefcat, oxv_oxshops_de.oxhrbnr, oxv_oxshops_de.oxcourt, oxv_oxshops_de.oxadbutlerid, oxv_oxshops_de.oxaffilinetid, oxv_oxshops_de.oxsuperclicksid, oxv_oxshops_de.oxaffiliweltid, oxv_oxshops_de.oxaffili24id, oxv_oxshops_de.oxedition, oxv_oxshops_de.oxversion, oxv_oxshops_de.oxseoactive, oxv_oxshops_de.oxtimestamp, oxv_oxshops_de.pwcdtrschmeid from oxv_oxshops_de where 1 and oxv_oxshops_de.oxid = ‘oxbaseshop’, for user c1eshop

Stack Trace: #0 /var/www/clients/client1/web27/web/core/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc(369): adodb_throw(‘mysql’, ‘EXECUTE’, 1146, 'Table ‘c1_oxid_…’, ‘select oxv_oxs...', false, Object(object_ADOConnection)) #1 /var/www/clients/client1/web27/web/core/adodblite/adodb.inc.php(316): mysql_driver_ADOConnection->do_query('selectoxv_oxs…’, -1, -1, false)
#2 /var/www/clients/client1/web27/web/core/oxlegacydb.php(136): ADOConnection->Execute(‘select oxv_oxs...', false) #3 /var/www/clients/client1/web27/web/core/oxbase.php(665): oxLegacyDb->select('selectoxv_oxs…’)
#4 /var/www/clients/client1/web27/web/core/oxbase.php(612): oxBase->assignRecord(‘select `oxv_oxs…’)
#5 /var/www/clients/client1/web27/web/core/oxconfig.php(2046): oxBase->load(‘oxbaseshop’)
#6 /var/www/clients/client1/web27/web/core/oxutils.php(1030): oxConfig->getActiveShop()
#7 /var/www/clients/client1/web27/web/application/controllers/oxubase.php(547): oxUtils->seoIsActive()
#8 /var/www/clients/client1/web27/web/application/controllers/oxubase.php(578): oxUBase->_processRequest()
#9 /var/www/clients/client1/web27/web/core/oxshopcontrol.php(396): oxUBase->init()
#10 /var/www/clients/client1/web27/web/core/oxshopcontrol.php(329): oxShopControl->_initializeViewObject(‘start’, NULL, NULL, NULL)
#11 /var/www/clients/client1/web27/web/core/oxshopcontrol.php(115): oxShopControl->_process(‘start’, NULL, NULL, NULL)
#12 /var/www/clients/client1/web27/web/core/oxid.php(30): oxShopControl->start()
#13 /var/www/clients/client1/web27/web/index.php(19): Oxid::run()
#14 {main}

Connection Adress -->
Connection Error -->

3

$this->blSkipViewUsage = true;
in die config.inc.php schreiben und die views neu generieren, dann wieder rausnehmen.

4

Jap, das wars. :smiley: Vielen Dank für den Hinweis.

Gruß, Tronico