Jump to content

Recommended Posts

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).

Share this post


Link to post
Share on other sites
On 5/24/2020 at 6:44 PM, Luca1987 said:

wo aktiviere ich das error reporting?

Erweiterte Einstellungen->Leistung->Debug Modus

grafik.thumb.png.b0c585f35f7db02d9c81877931abe059.png

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 */;

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
  • 9 months later...

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!

Share this post


Link to post
Share on other sites

Prestashop 1.7.6 ist bis max PHP 7.2 kompatibel. Bei 7.3 kommt der vor dir genanne Fehler

Share this post


Link to post
Share on other sites

Danke für die schnelle Antwort! 

Wenn ich die PrestaShop Version auf 1.7.7. update sollte der Fehler dann weg sein oder?
Oder ist diese Version auch nicht kompatibel?

 

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites
Posted (edited)

Dir fehlen zwei Datenbank Tabellen. Der Fehler kam hier schon ofter vor, einfach mal nach den Tabellennamen suchen, dann fndest du auch das SQL um diese zu erzeugen.

Edited by JBW (see edit history)

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
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
×
×
  • Create New...

Important Information

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