Jump to content
tomate44

500 Internal Server Error

Recommended Posts

Hallo und guten Tag an alle hier.

Und zwar habe ich folgendes Problem, ich habe PrestaShop 1.7.6.1 auf mein Server, und bekkome immer Fehlermeldungen zwar wenn ich, in den Adminbereich auf die Kategorien klicke, kommt immer

Oops! An Error Occurred

The server returned a "500 Internal Server Error".

Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.

Wer kann mir da weiter Helfen ich bedanke mich schon mal.

Share this post


Link to post
Share on other sites

Aktiviere den Debug Modus unter "Leistung" um die detailierte Fehlermeldung zu sehen.

Share this post


Link to post
Share on other sites

jetzt habe ich es mal kurtz Deakteviert und jetzt das

403

Forbidden

Access to this resource on the server is denied!

Share this post


Link to post
Share on other sites
8 minutes ago, tomate44 said:

ja habe ich jetzt gemacht und unter was muss ich schauen jetzt ? da steht so fiel

Fehlermeldung hier posten

Share this post


Link to post
Share on other sites

Ich kann dir nur das zeigen

Oops! An Error Occurred

The server returned a "500 Internal Server Error".

Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.

Wenn ich denn Debug Modus an mache und dann wieder aus geht die ganze seite nicht mehr dann muss ich alles löschen und neu drauf machen

Share this post


Link to post
Share on other sites

Ist es eine ganz frische Installation ohne fremdes Theme oder Module oder hast du schon verschiedenes daran gemacht, hast du Kategorien erstellt oder importiert, konnte man die Kategorieseite mal aufrufen?

Was genau hast du "mal kurtz Deakteviert"?

Ggf. mußt du in den Server Logs nach Fehlermeldungen schauen.

Share this post


Link to post
Share on other sites

In Erweiterte Einstellungen und dann Log-Dateien

Zeigt er mir nur denn Fehler hier

Class \"AdminLinkWidgetController\" not found in controllers/admin

Aber ich denke das es das nicht ist

Der Fehler kommt auch nur wenn ich im Admin Bereich auf Bestellungen,Lieferschein - Katerlog,Kategorien - Kunden, - Kundenservice, klicke

Share this post


Link to post
Share on other sites

Die Datei gehört zum Modul ps_linklist. Du kannst das mal testweise deaktivieren und bei Erfolg versuchen neu zu installieren.

Share this post


Link to post
Share on other sites
On 9/26/2019 at 9:16 PM, JBW said:

Die Datei gehört zum Modul ps_linklist. Du kannst das mal testweise deaktivieren und bei Erfolg versuchen neu zu installieren.

Ok und wie kann ich es deaktivieren ? Und gegeben falls neuInstallieren 

Share this post


Link to post
Share on other sites

Du hast wenn ich das richtig übersehe nichts davon geschrieben, daß du nicht auf die Seite mit den Modulen im BO kämst, also wo liegt das Problem beim Deaktivieren, Resetten oder Deinstallieren und neu installieren? Außerdem gibt es die Option, per FTP den Modulordner umzubenennen oder zu löschen.

Share this post


Link to post
Share on other sites

So habe mal Bilder von gemacht das erklärt es eventuell besser

Das ist im ADMIN bereich aber das kennt ihr ja

Auf dem Bild wo der Rote Punkt ist da kommt immer die Fehler Meldung

Konversionsrate 30 Tage

Oops! An Error Occurred

The server returned a "500 Internal Server Error".

Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.

Unbenannt-4.jpg

Share this post


Link to post
Share on other sites

Die Seite "Module" ist aber nicht dabei, wo liegt also das Problem, diese aufzurufen und ein möglicherweise verantwortliches Modul zu deaktivieren? Oder unter Leistung alle Module und Overrides testweise zu deaktivieren?

Share this post


Link to post
Share on other sites

So habe ich jetzt mal getestet unter Leistung alle Module und Overrides testweise zu deaktivieren

geht aber nicht fehler ist immer noch da

Ich bin auch ganz neu bei Prestashop und kenne mich leider nicht so aus da mit

Ich könnte in ja mal ein Test ACC ertellen und sie können ja mal schauen wenn sie zeit habe wer super nett von ihnen

Share this post


Link to post
Share on other sites

Kannst mir gerne einen Test Account for PN schicken

Share this post


Link to post
Share on other sites

Du hast PHP-Version 7.3.9 - Prestashop ist nur bis 7.2 kompatibel. Stelle das in deinem Webhosting um und probieren dann mal.

Share this post


Link to post
Share on other sites

Und folgende Parameter solltest du auch anpassen (in der PHP.ini bzw. Einstellungen deines Hostings)

Speichergrenze 128M
max_execution_time: 30

Mehr infos hier:

 

Share this post


Link to post
Share on other sites

Schau mal in Erweiterte Einstellungen->Infomationen. Deine Server Konfiguration ist leider immer noch nicht korrekt

Quote

Erforderliche Parameter Bitte prüfen Sie folgende(n) Fehler

Aktivieren Sie die Fileinfo-Erweiterung auf Ihrem Server.

intl (fehlende Beschreibung)

Optionale Parameter Bitte prüfen Sie folgende(n) Fehler

intl (fehlende Beschreibung)

 

Share this post


Link to post
Share on other sites

Keine Ahnung was ich gemacht habe aber jetzt geht alles einfach was drücken und geht lol komisch 😉

Share this post


Link to post
Share on other sites

Ja deine notwendigen Parameter sind jetzt korrekt und schon gehts ;) Wenn du den Shop produktiv einsetzen willst empfehle ich aber dennoch die Speichergrenze und Ausführungszeit zu erhöhen und mal die anderen Einstellungen aus dem verlinkten  Beitrag zu prüfen.
Viel Spaß und Erfolg

Share this post


Link to post
Share on other sites

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!
 

Share this post


Link to post
Share on other sites

Jetzt fehlt noch die Tabelle ps_connections. Glaube die kannst du auch wieder herstellen, von diesen fehlern hab ich hier schon öfters gelesen

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More