Hallo Gemeinde, ich habe zwei Shopware 4.2.3 Shops und bei beiden gibt es Probleme. Es gibt immer Probleme wenn ich einen Artikel bearbeiten will und auf den Bleistift klicke. Dann bekomme ich erstmal die Fehlermeldung: [quote]503 - Service unavailable - Ups! Ein Fehler ist aufgetreten! Wir wurden bereits über das Problem informiert und arbeiten an einer Lösung, bitte versuchen Sie es in Kürze erneut. [/quote] Ich habe schon festgestellt, dass jedes mal wenn ich das ausprobiere in logs/core_production-2014-11-05.log eine Fehlerzeile hinzugefügt wird. Diese lautet: [2014-11-05 02:24:00] core.ERROR: exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd01a1a62.s\_article\_configurator\_template\_prices' doesn't exist' in xxxx/shop\_neu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:693 Stack trace: #0 xxxx/shop\_neu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(693): PDOStatement-\>execute() #1 xxxx/shop\_neu/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery('SELECT s0\_.id A...', Array, Array, NULL) #2 xxxx/shop\_neu/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 xxxx/shop\_neu/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 xxxx/shop\_neu/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(586): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #5 xxxx/shop\_neu/engine/Shopware/Controllers/Backend/Article.php(1977): Doctrine\ORM\AbstractQuery-\>getArrayResult() #6 xxxx/shop\_neu/engine/Shopware/Controllers/Backend/Article.php(2037): Shopware\_Controllers\_Backend\_Article-\>getArticleConfiguratorTemplate('63', Array) #7 xxxx/shop\_neu/engine/Shopware/Controllers/Backend/Article.php(1484): Shopware\_Controllers\_Backend\_Article-\>getArticle('63') #8 xxxx/shop\_neu/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Article-\>loadStoresAction() #9 xxxx/shop\_neu/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('loadStoresActio...') #10 xxxx/shop\_neu/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 xxxx/shop\_neu/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #12 xxxx/shop\_neu/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 xxxx/shop\_neu/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 xxxx/shop\_neu/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(243): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 xxxx/shop\_neu/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 xxxx/shop\_neu/shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main} Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'SELECT s0\_.id AS id0, s0\_.article\_id AS article\_id1, s0\_.unit\_id AS unit\_id2, s0\_.order\_number AS order\_number3, s0\_.suppliernumber AS suppliernumber4, s0\_.additionaltext AS additionaltext5, s0\_.active AS active6, s0\_.instock AS instock7, s0\_.stockmin AS stockmin8, s0\_.weight AS weight9, s0\_.width AS width10, s0\_.length AS length11, s0\_.height AS height12, s0\_.ean AS ean13, s0\_.position AS position14, s0\_.minpurchase AS minpurchase15, s0\_.purchasesteps AS purchasesteps16, s0\_.maxpurchase AS maxpurchase17, s0\_.purchaseunit AS purchaseunit18, s0\_.referenceunit AS referenceunit19, s0\_.packunit AS packunit20, s0\_.shippingfree AS shippingfree21, s0\_.releasedate AS releasedate22, s0\_.shippingtime AS shippingtime23, s1\_.id AS id24, s1\_.template\_id AS template\_id25, s1\_.customer\_group\_key AS customer\_group\_key26, s1\_.`from` AS from27, s1\_.`to` AS to28, s1\_.price AS price29, s1\_.pseudoprice AS pseudoprice30, s1\_.baseprice AS baseprice31, s1\_.percent AS percent32, s2\_.id AS id33, s2\_.groupkey AS groupkey34, s2\_.description AS description35, s2\_.tax AS tax36, s2\_.taxinput AS taxinput37, s2\_.mode AS mode38, s2\_.discount AS discount39, s2\_.minimumorder AS minimumorder40, s2\_.minimumordersurcharge AS minimumordersurcharge41, s3\_.id AS id42, s3\_.template\_id AS template\_id43, s3\_.attr1 AS attr144, s3\_.attr2 AS attr245, s3\_.attr3 AS attr346, s3\_.attr4 AS attr447, s3\_.attr5 AS attr548, s3\_.attr6 AS attr649, s3\_.attr7 AS attr750, s3\_.attr8 AS attr851, s3\_.attr9 AS attr952, s3\_.attr10 AS attr1053, s3\_.attr11 AS attr1154, s3\_.attr12 AS attr1255, s3\_.attr13 AS attr1356, s3\_.attr14 AS attr1457, s3\_.attr15 AS attr1558, s3\_.attr16 AS attr1659, s3\_.attr17 AS attr1760, s3\_.attr18 AS attr1861, s3\_.attr19 AS attr1962, s3\_.attr20 AS attr2063, s4\_.id AS id64, s4\_.template\_price\_id AS template\_price\_id65 FROM s\_article\_configurator\_templates s0\_ LEFT JOIN s\_article\_configurator\_template\_prices s1\_ ON s0\_.id = s1\_.template\_id LEFT JOIN s\_core\_customergroups s2\_ ON s1\_.customer\_group\_key = s2\_.groupkey LEFT JOIN s\_article\_configurator\_templates\_attributes s3\_ ON s0\_.id = s3\_.template\_id LEFT JOIN s\_article\_configurator\_template\_prices\_attributes s4\_ ON s1\_.id = s4\_.template\_price\_id WHERE s0\_.article\_id = ?' with params ["63"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd01a1a62.s\_article\_configurator\_template\_prices' doesn't exist' in xxxx/shop\_neu/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 xxxx/shop\_neu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(701): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'SELECT s0\_.id A...', Array) #1 xxxx/shop\_neu/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery('SELECT s0\_.id A...', Array, Array, NULL) #2 xxxx/shop\_neu/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 xxxx/shop\_neu/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 xxxx/shop\_neu/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(586): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #5 xxxx/shop\_neu/engine/Shopware/Controllers/Backend/Article.php(1977): Doctrine\ORM\AbstractQuery-\>getArrayResult() #6 xxxx/shop\_neu/engine/Shopware/Controllers/Backend/Article.php(2037): Shopware\_Controllers\_Backend\_Article-\>getArticleConfiguratorTemplate('63', Array) #7 xxxx/shop\_neu/engine/Shopware/Controllers/Backend/Article.php(1484): Shopware\_Controllers\_Backend\_Article-\>getArticle('63') #8 xxxx/shop\_neu/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Article-\>loadStoresAction() #9 xxxx/shop\_neu/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('loadStoresActio...') #10 xxxx/shop\_neu/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 xxxx/shop\_neu/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #12 xxxx/shop\_neu/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 xxxx/shop\_neu/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 xxxx/shop\_neu/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(243): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 xxxx/shop\_neu/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 xxxx/shop\_neu/shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main} [] {"uid":"bdf94d3"} Also die Fehlermeldung sagt mir ja: 'd01a1a62.s\_article\_configurator\_template\_prices' doesn't exist' in xxxx/shop\_neu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:693 Jetzt habe ich in der Datenbank geschaut und nein es gibt da keine „s_article_configurator_template_prices“. Ich habe aber auch mal in funktionierenden Shops geschaut, die auch auf 4.2.3 laufen und dort gibt es ebenfalls diese Tabelle nicht. Das Problem kann also davon doch eigentlich nicht ausgehen?? --------------------------- Jetzt kommen wir zum zweiten Shop. Auch hier die Fehlermeldung s. o. wenn ich auf den Bleistift klicke. Hier hilft es komischerweise den Cache zu leeren, dann kann die das Produkt wieder bearbeiten. Das ganze hält ein paar Stunden, logge ich mich am nächsten Tag wieder ein ist das Problem wieder da. Bei Shop 1 hilft Cache leeren rein gar nichts. Hier habe ich eine andere Fehlermeldung in der /logs, allerdings mit einer ähnlichen Aussage: [2014-11-05 01:45:35] core.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 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 'WHERE s0\_.id = '4370'' at line 1' in xxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:693 Stack trace: #0 xxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(693): PDOStatement-\>execute() #1 xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery('SELECT s0\_.id A...', Array, Array, NULL) #2 xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(586): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #5 xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(1713): Doctrine\ORM\AbstractQuery-\>getArrayResult() #6 xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(2011): Shopware\_Controllers\_Backend\_Article-\>getArticleData('4370') #7 xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(1484): Shopware\_Controllers\_Backend\_Article-\>getArticle('4370') #8 xxxx/shopware42/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Article-\>loadStoresAction() #9 xxxx/shopware42/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('loadStoresActio...') #10 xxxx/shopware42/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 xxxx/shopware42/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #12 xxxx/shopware42/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 xxxx/shopware42/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 xxxx/shopware42/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(243): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 xxxx/shopware42/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 xxxx/shopware42/shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main} Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'SELECT s0\_.id AS id0, s0\_.main\_detail\_id AS main\_detail\_id1, s0\_.supplierID AS supplierID2, s0\_.taxID AS taxID3, s0\_.pricegroupID AS pricegroupID4, s0\_.filtergroupID AS filtergroupID5, s0\_.configurator\_set\_id AS configurator\_set\_id6, s0\_.name AS name7, s0\_.description AS description8, s0\_.description\_long AS description\_long9, s0\_.datum AS datum10, s0\_.active AS active11, s0\_.pseudosales AS pseudosales12, s0\_.topseller AS topseller13, s0\_.keywords AS keywords14, s0\_.metaTitle AS metaTitle15, s0\_.changetime AS changetime16, s0\_.pricegroupActive AS pricegroupActive17, s0\_.laststock AS laststock18, s0\_.crossbundlelook AS crossbundlelook19, s0\_.notification AS notification20, s0\_.template AS template21, s0\_.mode AS mode22, s0\_.available\_from AS available\_from23, s0\_.available\_to AS available\_to24, s1\_.id AS id25, s1\_.articleID AS articleID26, s1\_.unitID AS unitID27, s1\_.ordernumber AS ordernumber28, s1\_.suppliernumber AS suppliernumber29, s1\_.kind AS kind30, s1\_.additionaltext AS additionaltext31, s1\_.active AS active32, s1\_.instock AS instock33, s1\_.stockmin AS stockmin34, s1\_.weight AS weight35, s1\_.width AS width36, s1\_.length AS length37, s1\_.height AS height38, s1\_.ean AS ean39, s1\_.position AS position40, s1\_.minpurchase AS minpurchase41, s1\_.purchasesteps AS purchasesteps42, s1\_.maxpurchase AS maxpurchase43, s1\_.purchaseunit AS purchaseunit44, s1\_.referenceunit AS referenceunit45, s1\_.packunit AS packunit46, s1\_.shippingfree AS shippingfree47, s1\_.releasedate AS releasedate48, s1\_.shippingtime AS shippingtime49, s2\_.id AS id50, s2\_.tax AS tax51, s2\_.description AS description52, s3\_.id AS id53, s3\_.articleID AS articleID54, s3\_.articledetailsID AS articledetailsID55, s3\_.attr1 AS attr156, s3\_.attr2 AS attr257, s3\_.attr3 AS attr358, s3\_.attr4 AS attr459, s3\_.attr5 AS attr560, s3\_.attr6 AS attr661, s3\_.attr7 AS attr762, s3\_.attr8 AS attr863, s3\_.attr9 AS attr964, s3\_.attr10 AS attr1065, s3\_.attr11 AS attr1166, s3\_.attr12 AS attr1267, s3\_.attr13 AS attr1368, s3\_.attr14 AS attr1469, s3\_.attr15 AS attr1570, s3\_.attr16 AS attr1671, s3\_.attr17 AS attr1772, s3\_.attr18 AS attr1873, s3\_.attr19 AS attr1974, s3\_.attr20 AS attr2075, s3\_.article\_Keynet AS article\_Keynet76 FROM s\_articles s0\_ LEFT JOIN s\_articles\_details s1\_ ON s0\_.main\_detail\_id = s1\_.id LEFT JOIN s\_core\_tax s2\_ ON s0\_.taxID = s2\_.id LEFT JOIN WHERE s0\_.id = ?' with params ["4370"]: SQLSTATE[42000]: Syntax error or access violation: 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 'WHERE s0\_.id = '4370'' at line 1' in xxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 xxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(701): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'SELECT s0\_.id A...', Array) #1 xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery('SELECT s0\_.id A...', Array, Array, NULL) #2 xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 xxxx/shopware42/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(586): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #5 xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(1713): Doctrine\ORM\AbstractQuery-\>getArrayResult() #6 xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(2011): Shopware\_Controllers\_Backend\_Article-\>getArticleData('4370') #7 xxxx/shopware42/engine/Shopware/Controllers/Backend/Article.php(1484): Shopware\_Controllers\_Backend\_Article-\>getArticle('4370') #8 xxxx/shopware42/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Article-\>loadStoresAction() #9 xxxx/shopware42/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('loadStoresActio...') #10 xxxx/shopware42/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 xxxx/shopware42/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #12 xxxx/shopware42/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 xxxx/shopware42/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 xxxx/shopware42/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(243): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 xxxx/shopware42/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 xxxx/shopware42/shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main} [] {"uid":"2a5c636"} Also ich bin so langsam am Ende mit meinem Latein. Wo kommen diese Fehlermeldungen her? Ich habe keinen Anhaltspunkt wieso das so ist, geschweige denn wüsste ich nicht, dass ich irgendetwas in Shopware geändert hätte. Ich hoffe inständig auf irgendwelche Hilfe von Außen. Gruß kweb
Doch die Tabelle s_article_configurator_template_prices exisitiert und muss auch vorhanden sein. Das d01a1a62 ist lediglich ein präfix welcher vor der eigentlichen Tabelle steht, um diese zu identifizieren. Solltest du bspw. mehrere Installationen in einer Tabelle haben. PS: Hatte gerade in meiner 4.3 Installation geschaut, nicht 4.2
Ach Entschuldigung. natürlich habe auch ich 4.3.2. Okay gut, komisch aber, dass es diese Tabelle bei meinen anderen Shops auch nicht gibt. Nunja, wie kann ich die Tabelle nachträglich installieren ohne etwas kaputt zu machen? Weiß jemand ab welcher Version die Tabelle hinzugefügt wurde. Es kann ja nur mit einem Update gekommen sein, denn natürlich könnte ich schon mal Produkte bearbeiten in diesem Shop. Waere um weitere Hilfe echt dankbar. kayyy schon mal vielen Dank für Deine recherchen. Gruß , kweb
Hast du schon einmal die recovery installation durchlaufen lassen ? Vorher aber unbedingt ein Backup machen ! Ansonsten evtl. Shopware kurz lokal installieren, die Tabelle exportieren von dort und dann importieren in deine Installation. Was sagt den Systen Informationen - Sind dort alle Dateien vorhanden ?
d01a1a62.s_article_configurator_template_prices bedeutet “Tabelle s_article_configurator_template_prices in der Datenbank d01a1a62”. Schau mal in der Datenbank d01a1a62 nach, ob es die Tabelle gibt.
Hi, nein, eine s_article_configurator_template_prices gibt es nicht, ich habe nur eine s_article_configurator_template_prices_attributes Soweit ich weiß hatte ich damals das Update von 4.3.1 auf 4.3.2 mit /recovery durchgeführt, so wie es in der readme von Shopware steht. Also nochmal das Update fahren? Sonst gibt es keine Möglichkeit die Tabelle manuell hinzufügen zu lassen? Irgendwo müsste doch der entsprechende SQL-Query zu finden sein oder?
[quote=“kayyy”]Hast du schon einmal die recovery installation durchlaufen lassen ? Vorher aber unbedingt ein Backup machen ! Ansonsten evtl. Shopware kurz lokal installieren, die Tabelle exportieren von dort und dann importieren in deine Installation. Was sagt den Systen Informationen - Sind dort alle Dateien vorhanden ?[/quote] Noch ein Nachtrag: Systeminformationen sehen gut aus, keine Fehler.
Wie siehts aus mit: CREATE TABLE IF NOT EXISTS `s_article_configurator_template_prices` ( `id` int(11) unsigned NOT NULL, `template_id` int(10) unsigned DEFAULT NULL, `customer_group_key` varchar(30) COLLATE utf8\_unicode\_ci NOT NULL, `from` int(10) unsigned NOT NULL, `to` varchar(30) COLLATE utf8\_unicode\_ci NOT NULL, `price` double NOT NULL DEFAULT '0', `pseudoprice` double DEFAULT NULL, `baseprice` double DEFAULT NULL, `percent` decimal(10,2) DEFAULT NULL )
Das Problem sind die Foreign Key Checks (s. http://www.troyfawkes.com/solved-mysql- … errno-150/). Du kannst versuchen, sie zu deaktivieren, wenn Du die Tabelle einspielst (SET FOREIGN_KEY_CHECKS = 0;), das könnte aber Nebenwirkungen haben. Wenn Du ein relativ aktuelles Backup der Datenbank hast, wo die Tabelle enthalten ist, ist es wohl am besten, wenn Du das wieder einspielst.
[quote=„kayyy“]Wie siehts aus mit: CREATE TABLE IF NOT EXISTS `s_article_configurator_template_prices` ( `id` int(11) unsigned NOT NULL, `template_id` int(10) unsigned DEFAULT NULL, `customer_group_key` varchar(30) COLLATE utf8\_unicode\_ci NOT NULL, `from` int(10) unsigned NOT NULL, `to` varchar(30) COLLATE utf8\_unicode\_ci NOT NULL, `price` double NOT NULL DEFAULT '0', `pseudoprice` double DEFAULT NULL, `baseprice` double DEFAULT NULL, `percent` decimal(10,2) DEFAULT NULL ) [/quote] Vielen lieben Dank für deine Hilfe. Daran scheint es gelegen zu haben. Jetzt kann ich die Artikel wieder bearbeiten, Problem 1 gelöst =) Wenn euch zu Problem 2 noch was einfällt, also [2014-11-05 01:45:35] core.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 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 'WHERE s0\_.id = '4370'' at line 1' in xxxx/shopware42/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:693 Stack trace: dann wäre das super. Auch hier kommt auch die Fehlermeldung Service Unavailable, allerdings wenn ich dann den Cache lösche geht es…bis zum nächsten Tag. Alles sehr merkwürdig. LG @timme? Meinst du damit beide Probleme?