Jump to content

Fehler 500 beim Klick im Backend auf Kunden

Luca1987
 Share

Recommended Posts

rictools Mentor

rictools

Posted
Posted

Generell bei Fehler 500: Error Reporting aktivieren (wird hier alle paar Tage besprochen).

Auch generell: immer Prestashop-Version angeben, aktuell auch die PHP-Version, da oft für scheinbar unerklärliche Fehler verantwortlich (bis 1.7.6.x maximal PHP 7.2).

Link to comment
Share on other sites
Luca1987 Newbie

Luca1987

Posted
  • Author
Posted

HAbe ich getan und da steht dann folgendes:

 

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 ps1761_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 ps1761_guest g LEFT JOIN ps1761_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 ps1761_customer c LEFT JOIN ps1761_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ps1761_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 'usr_web25345683_3.ps1761_guest' doesn't exist

Link to comment
Share on other sites
JBW Mentor

JBW

Posted
Posted

Dir fehlt die Datenbank Tabelle ps1761_guest - hast du kürztlich ein Upgrade gemacht was nicht komplett war?

Du kannst die Tabelle z.B. über PHPmyAdmin neu erzeugen, hier der Code von PS 1.7.6.5: 

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ps_guest`
--

CREATE TABLE `ps1761_guest` (
  `id_guest` int(10) UNSIGNED NOT NULL,
  `id_operating_system` int(10) UNSIGNED DEFAULT NULL,
  `id_web_browser` int(10) UNSIGNED DEFAULT NULL,
  `id_customer` int(10) UNSIGNED DEFAULT NULL,
  `javascript` tinyint(1) DEFAULT '0',
  `screen_resolution_x` smallint(5) UNSIGNED DEFAULT NULL,
  `screen_resolution_y` smallint(5) UNSIGNED DEFAULT NULL,
  `screen_color` tinyint(3) UNSIGNED DEFAULT NULL,
  `sun_java` tinyint(1) DEFAULT NULL,
  `adobe_flash` tinyint(1) DEFAULT NULL,
  `adobe_director` tinyint(1) DEFAULT NULL,
  `apple_quicktime` tinyint(1) DEFAULT NULL,
  `real_player` tinyint(1) DEFAULT NULL,
  `windows_media` tinyint(1) DEFAULT NULL,
  `accept_language` varchar(8) DEFAULT NULL,
  `mobile_theme` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `ps_guest`
--
ALTER TABLE `ps1761_guest`
  ADD PRIMARY KEY (`id_guest`),
  ADD KEY `id_customer` (`id_customer`),
  ADD KEY `id_operating_system` (`id_operating_system`),
  ADD KEY `id_web_browser` (`id_web_browser`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `ps_guest`
--
ALTER TABLE `ps1761_guest`
  MODIFY `id_guest` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

 

Link to comment
Share on other sites
Luca1987 Newbie

Luca1987

Posted
  • Author
Posted

Wenn ich den SGL Befehl ausführe kommt folgender feheler

 

Fehler

SQL-Befehl:

---------------------------------------------------- CREATE TABLE `ps1761_guest` ( `id_guest` int(10) UNSIGNED NOT NULL, `id_operating_system` int(10) UNSIGNED DEFAULT NULL, `id_web_browser` int(10) UNSIGNED DEFAULT NULL, `id_customer` int(10) UNSIGNED DEFAULT NULL, `javascript` tinyint(1) DEFAULT '0', `screen_resolution_x` smallint(5) UNSIGNED DEFAULT NULL, `screen_resolution_y` smallint(5) UNSIGNED DEFAULT NULL, `screen_color` tinyint(3) UNSIGNED DEFAULT NULL, `sun_java` tinyint(1) DEFAULT NULL, `adobe_flash` tinyint(1) DEFAULT NULL, `adobe_director` tinyint(1) DEFAULT NULL, `apple_quicktime` tinyint(1) DEFAULT NULL, `real_player` tinyint(1) DEFAULT NULL, `windows_media` tinyint(1) DEFAULT NULL, `accept_language` varchar(8) DEFAULT NULL, `mobile_theme` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8

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

CREATE TABLE `ps1761_gue' at line 1

Link to comment
Share on other sites
Luca1987 Newbie

Luca1987

Posted
  • Author
Posted

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 ps1761_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 ps1761_guest g LEFT JOIN ps1761_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 ps1761_customer c LEFT JOIN ps1761_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ps1761_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 'usr_web25345683_3.ps1761_connections' doesn't exist

Link to comment
Share on other sites
JBW Mentor

JBW

Posted
Posted
3 minutes ago, Luca1987 said:

ps1761_connections' doesn't exist

Noch eine andere Tabelle.

Hier das SQL: 

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;


CREATE TABLE `ps1761_connections` (
  `id_connections` int(10) UNSIGNED NOT NULL,
  `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(20) DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `http_referer` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `ps_connections`
--
ALTER TABLE `ps1761_connections`
  ADD PRIMARY KEY (`id_connections`),
  ADD KEY `id_guest` (`id_guest`),
  ADD KEY `date_add` (`date_add`),
  ADD KEY `id_page` (`id_page`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `ps_connections`
--
ALTER TABLE `ps1761_connections`
  MODIFY `id_connections` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

 

  • Like 1
Link to comment
Share on other sites
  • 9 months later...
StHl Newbie

StHl

Posted
Posted

Hallo,

ich habe auch das selbe Problem. PrestaShop-Version 1.7.6.8 / Php-Version: 7.3.27

Wenn ich im Backend auf Kunden klicke kommt die Fehlermeldung:
"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."


Nach dem aktivieren des Debug-Modus erhalte ich folgenden Fehler:
"at ErrorHandler->handleError(2, '"continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?', '/homepages/3/d21422274/htdocs/clickandbuilds/PrestaShop/Heibi-Shop/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php', 2636, array('class' => 'Doctrine\\ORM\\UnitOfWork', 'e' => 32767, 'file' => '/homepages/3/d21422274/htdocs/clickandbuilds/PrestaShop/Heibi-Shop/vendor/composer/../doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php'))in DebugClassLoader.php line 156"

 

Weiß nicht ob diese Fehlermeldung etwas mit meinem Problem zu tun hat..
Wäre super wenn mir jemand weiterhelfen könnte.

 

Danke!

Link to comment
Share on other sites
StHl Newbie

StHl

Posted
Posted

Okay danke!

Jetzt habe ich leider noch ein Problem. Ich wollte unseren Shop jetzt mit dem 1-Click-Update Modul auf 1.7.7 updaten. 
Leider kommt beim Update folgende Fehler:

Warnungen wurden beim Upgrade gefunden./homepages/3/d21422274/htdocs/clickandbuilds/PrestaShop/Heibi-Shop/weqfxtgq6zuqtmge/autoupgrade/download/prestashop.zip removed/homepages/3/d21422274/htdocs/clickandbuilds/PrestaShop/Heibi-Shop/weqfxtgq6zuqtmge/autoupgrade/latest removed 

und 

SQL 1.7.7.0 1146 in ALTER TABLE `ps_connections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'dbs923306.ps_connections' doesn't existSQL 1.7.7.0 1146 in ALTER TABLE `ps_connections_page` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'dbs923306.ps_connections_page' doesn't existSQL 1.7.7.0 1146 in ALTER TABLE `ps_connections_source` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'dbs923306.ps_connections_source' doesn't existSQL 1.7.7.0 1146 in ALTER TABLE `ps_guest` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'dbs923306.ps_guest' doesn't existSQL 1.7.7.0 1146 in ALTER TABLE `ps_statssearch` CHANGE `keywords` `keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL: Table 'dbs923306.ps_statssearch' doesn't existSQL 1.7.7.0 1146 in ALTER TABLE `ps_connections` CHANGE `http_referer` `http_referer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL: Table 'dbs923306.ps_connections' doesn't exist

 

Was ist hier der Fehler? Bzw. warum kann ich unseren Shop nicht updaten?

 

Wäre super wenn mir jemand weiterhelfen kann. Danke!
Liebe Grüße.

 

Link to comment
Share on other sites
StHl Newbie

StHl

Posted
Posted

Okay. Ehrlich gesagt habe ich jetzt mal gesucht und irgendwie nichts passendes gefunden..

Hast du zufällig einen Link zum passenden Beitrag? Oder kannst du mir so weiterhelfen?

 

Danke!

Link to comment
Share on other sites
StHl Newbie

StHl

Posted
Posted

Hallo,

könnte mir jemand erklären wie ich die zwei fehlenden Tabellen in der Datenbank wiederherstelle? 
Habe leider nichts passendes im Forum gefunden und leider bin ich nicht so Fit in SQL. Weiß ehrlich gesagt nicht wie ich das Problem genau beheben kann.

Wäre super wenn mir jemand helfen könnte. Denn gerade scheitert es nur noch daran..

 

Danke schonmal!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...