-
Posts
122 -
Joined
-
Last visited
About karpfensami
- Birthday 03/23/1983
Contact Methods
- Website
Profile Information
-
Location
Austria
-
Activity
Other
Recent Profile Visitors
2,911,221 profile views
karpfensami's Achievements
-
Vielen Dank für die Info! Hier die Lösung, falls wer Mal den gleichen Fehler hat: CREATE TABLE `PREFIX_connections` ( `id_connections` int(10) unsigned NOT NULL auto_increment, `id_shop_group` INT(11) UNSIGNED NOT NULL DEFAULT '1', `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1', `id_guest` int(10) unsigned NOT NULL, `id_page` int(10) unsigned NOT NULL, `ip_address` BIGINT NULL DEFAULT NULL, `date_add` datetime NOT NULL, `http_referer` varchar(255) DEFAULT NULL, PRIMARY KEY (`id_connections`), KEY `id_guest` (`id_guest`), KEY `date_add` (`date_add`), KEY `id_page` (`id_page`) ); Jetzt funktioniert der Bereich "Kunden" wieder.
-
Hallo zusammen, habe seit heute morgen diese Fehlermeldung wenn ich auf "Benutzer" gehe. Die Tabelle ps_guest konnte ich bereits wieder herstellen. Meine Frage an euch, ist der Shop komplett im Eck und muss neu aufgesetzt werden oder ist noch was zu retten? HTTP 500 Internal Server Error An exception occurred while executing 'SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (SELECT SUM(total_paid_real / conversion_rate) FROM ps_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT c.date_add FROM ps_guest g LEFT JOIN ps_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY c.date_add DESC LIMIT 1) as connect FROM ps_customer c LEFT JOIN ps_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ps_shop s ON c.id_shop = s.id_shop WHERE (c.deleted = 0) AND (c.id_shop IN (?)) ORDER BY c.date_add DESC LIMIT 50 OFFSET 0' with params [1, 1, 1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u109536db3.ps_connections' doesn't exist Exceptions 3 Logs 2 Stack Traces 3 Doctrine\DBAL\Exception\TableNotFoundException in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php (line 53) AbstractMySQLDriver->convertException('An exception occurred while executing \'SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (SELECT SUM(total_paid_real / conversion_rate) FROM ps_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT c.date_add FROM ps_guest g LEFT JOIN ps_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY c.date_add DESC LIMIT 1) as connect FROM ps_customer c LEFT JOIN ps_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ps_shop s ON c.id_shop = s.id_shop WHERE (c.deleted = 0) AND (c.id_shop IN (?)) ORDER BY c.date_add DESC LIMIT 50 OFFSET 0\' with params [1, 1, 1]:SQLSTATE[42S02]: Base table or view not found: 1146 Table \'u109536db3.ps_connections\' doesn\'t exist', object(PDOException))in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php (line 128) DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (SELECT SUM(total_paid_real / conversion_rate) FROM ps_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT c.date_add FROM ps_guest g LEFT JOIN ps_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY c.date_add DESC LIMIT 1) as connect FROM ps_customer c LEFT JOIN ps_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ps_shop s ON c.id_shop = s.id_shop WHERE (c.deleted = 0) AND (c.id_shop IN (?)) ORDER BY c.date_add DESC LIMIT 50 OFFSET 0', array(1, 1, 1))in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php (line 855) Connection->executeQuery('SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (SELECT SUM(total_paid_real / conversion_rate) FROM ps_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT c.date_add FROM ps_guest g LEFT JOIN ps_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY c.date_add DESC LIMIT 1) as connect FROM ps_customer c LEFT JOIN ps_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ps_shop s ON c.id_shop = s.id_shop WHERE (c.deleted = 0) AND (c.id_shop IN (?)) ORDER BY c.date_add DESC LIMIT 50 OFFSET 0', array(1, 1, 1), array(1, 2, 1))in vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php (line 206) QueryBuilder->execute()in src/Core/Grid/Data/Factory/DoctrineGridDataFactory.php (line 96) 'search_query_builder' => $searchQueryBuilder, 'count_query_builder' => $countQueryBuilder, 'search_criteria' => $searchCriteria, ]); $records = $searchQueryBuilder->execute()->fetchAll(); $recordsTotal = (int) $countQueryBuilder->execute()->fetch(PDO::FETCH_COLUMN); $records = new RecordCollection($records); return new GridData( DoctrineGridDataFactory->getData(object(CustomerFilters))in src/Core/Grid/Data/Factory/CustomerGridDataFactoryDecorator.php (line 75) CustomerGridDataFactoryDecorator->getData(object(CustomerFilters))in src/Core/Grid/GridFactory.php (line 90) GridFactory->getGrid(object(CustomerFilters))in src/PrestaShopBundle/Controller/Admin/Sell/Customer/CustomerController.php (line 93) CustomerController->indexAction(object(Request), object(CustomerFilters))in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151) HttpKernel->handleRaw(object(Request), 1)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68) HttpKernel->handle(object(Request), 1, false)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200) Kernel->handle(object(Request), 1, false)in psadmin/index.php (line 86) Doctrine\DBAL\Driver\PDOException SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u109536db3.ps_connections' doesn't exist in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php (line 107) PDOStatement->execute()in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php (line 847) Connection->executeQuery('SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (SELECT SUM(total_paid_real / conversion_rate) FROM ps_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT c.date_add FROM ps_guest g LEFT JOIN ps_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY c.date_add DESC LIMIT 1) as connect FROM ps_customer c LEFT JOIN ps_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ps_shop s ON c.id_shop = s.id_shop WHERE (c.deleted = 0) AND (c.id_shop IN (?)) ORDER BY c.date_add DESC LIMIT 50 OFFSET 0', array(1, 1, 1), array(1, 2, 1))in vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php (line 206) QueryBuilder->execute()in src/Core/Grid/Data/Factory/DoctrineGridDataFactory.php (line 96) 'search_query_builder' => $searchQueryBuilder, 'count_query_builder' => $countQueryBuilder, 'search_criteria' => $searchCriteria, ]); $records = $searchQueryBuilder->execute()->fetchAll(); $recordsTotal = (int) $countQueryBuilder->execute()->fetch(PDO::FETCH_COLUMN); $records = new RecordCollection($records); return new GridData( DoctrineGridDataFactory->getData(object(CustomerFilters))in src/Core/Grid/Data/Factory/CustomerGridDataFactoryDecorator.php (line 75) CustomerGridDataFactoryDecorator->getData(object(CustomerFilters))in src/Core/Grid/GridFactory.php (line 90) GridFactory->getGrid(object(CustomerFilters))in src/PrestaShopBundle/Controller/Admin/Sell/Customer/CustomerController.php (line 93) CustomerController->indexAction(object(Request), object(CustomerFilters))in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151) HttpKernel->handleRaw(object(Request), 1)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68) HttpKernel->handle(object(Request), 1, false)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200) Kernel->handle(object(Request), 1, false)in psadmin/index.php (line 86) PDOException SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u109536db3.ps_connections' doesn't exist in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php (line 105) PDOStatement->execute(null)in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php (line 105) PDOStatement->execute()in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php (line 847) Connection->executeQuery('SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (SELECT SUM(total_paid_real / conversion_rate) FROM ps_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT c.date_add FROM ps_guest g LEFT JOIN ps_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY c.date_add DESC LIMIT 1) as connect FROM ps_customer c LEFT JOIN ps_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ps_shop s ON c.id_shop = s.id_shop WHERE (c.deleted = 0) AND (c.id_shop IN (?)) ORDER BY c.date_add DESC LIMIT 50 OFFSET 0', array(1, 1, 1), array(1, 2, 1))in vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php (line 206) QueryBuilder->execute()in src/Core/Grid/Data/Factory/DoctrineGridDataFactory.php (line 96) 'search_query_builder' => $searchQueryBuilder, 'count_query_builder' => $countQueryBuilder, 'search_criteria' => $searchCriteria, ]); $records = $searchQueryBuilder->execute()->fetchAll(); $recordsTotal = (int) $countQueryBuilder->execute()->fetch(PDO::FETCH_COLUMN); $records = new RecordCollection($records); return new GridData( DoctrineGridDataFactory->getData(object(CustomerFilters))in src/Core/Grid/Data/Factory/CustomerGridDataFactoryDecorator.php (line 75) CustomerGridDataFactoryDecorator->getData(object(CustomerFilters))in src/Core/Grid/GridFactory.php (line 90) GridFactory->getGrid(object(CustomerFilters))in src/PrestaShopBundle/Controller/Admin/Sell/Customer/CustomerController.php (line 93) CustomerController->indexAction(object(Request), object(CustomerFilters))in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151) HttpKernel->handleRaw(object(Request), 1)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68) HttpKernel->handle(object(Request), 1, false)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200) Kernel->handle(object(Request), 1, false)in psadmin/index.php (line 86) Vielen Dank im Voraus!
-
Hallo JBW, habe mich vielleicht schlecht ausgedrückt. Bei der Version 1.6.1.x gab es bei den Modulpositionen einen Live Edit um die Module an die richtige Stelle zu schieben. Dieser dürfte nach dem ich was gefunden hatte entfernt worden sein. Wie bereits oben geschrieben, komme ich im BO mit der Modulposition nicht zurecht und wollte wissen ob man diesen ev. nachinstallieren kann oder ob es ein käufliches Modul dazu gibt.
-
Hallo zusammen, wie ich gerade festgestellt habe gibt es leider den Live Editor nicht mehr in der PS 1.7. mehr. Ist es möglich diesen über einen Quelltext zu implantieren oder kennt von euch wer ein kostenpflichtiges Modul. Leider kapiere ich es nicht im BO die Module an die richtige stelle zu schieben. Vielen Dank im Voraus!
-
Hallo zusammen, neben unseren eigenen Produkten die wir EU weit verkaufen, haben wir jetzt auch Produkte mit Exklusivverkauf auf drei Länder beschränkt. Wie kann ich das Einstellen, dass diese Produkte nur für diese drei Länder sichtbar und bestellbar sind. PS: 1.7.6.1 Vielen Dank im Voraus! VG Christoph
-
karpfensami changed their profile photo
-
prestashop umstieg 1.7.x Umstieg auf 1.7.x
karpfensami replied to karpfensami's topic in Generelle Fragen
Hallo zusammen, vielen Dank für die Rückmeldung. Das klingt gut, dass die 1.7er Version bereits als Liveshop verwendet werden kann. Vielen Dank für die Rückmeldungen! -
prestashop umstieg 1.7.x Umstieg auf 1.7.x
karpfensami replied to karpfensami's topic in Generelle Fragen
Hallo ihr zwei, vielen Dank für die Antworten! Das man von 1.6 auf 1.7. nicht so einfach updaten kann, war mir bewusst. Ob mit Migrationstool oder manuelle Erstellung, Arbeit wird beides sein, aber das ist mir egal. Wichtig war für mich, ob man 1.7 jetzt schon für einen Liveshop verwenden kann oder noch die Finger lassen soll. VG Christoph -
Hallo zusammen, unser Live-Shop läuft derzeit unter PS 1.6.1.10. Leider hat unser Kauftheme einen Bug bei der Verwendung von Gutscheinen, wenn diese aufgeteilt verwendet werden. Der Ersteller ist leider nicht in der Lage den Bug zu beheben. Ich selbst habe dazu zu wenige Kenntnisse dies zu beheben und zweitens sind wir der Meinung, dass das Design heutzutage nicht mehr passend ist. Daher wollen wir uns ein neues Theme (schlichter) kaufen, dass es leider nur auf PS 1.7. gibt. Lange Zeit wurde davon abgeraten von PS 1.6. auf PS 1.7. zu wechseln. Mittlerweile ist es Mitte November 2019 und mich würde Interessieren, ob ein Wechsel auf PS 1.7. bereits sinnvoll ist oder ob man es doch noch lieber lassen soll. Wie sind die derzeitigen Meinungen dazu? Würde mich über jede Antwort freuen. Vielen Dank im Voraus! Gruß Christoph