Jump to content
cschilling

Kunden-Backoffice - The server returned a "500 Internal Server Error".

Recommended Posts

Im Backoffice kann man nicht auf - KUNDEN - Kunden zugreifen - Es folgt die Nachricht: The server returned a "500 Internal Server Error". ...
In der Webshop-Ansicht kann auch keine Kundenanmeldung oder Gastregistrierung erfolgen. 
Seit wann der Fehler besteht? Kann ich nicht nachvollziehen - ggf seit dem letzten Update oder der Installation von amazon pay. 

Hat jemand eine Abhilfe-Idee?

Shop siehe: https://acelo.net/de/

Gruß

Claus Schilling

 

Share this post


Link to post
Share on other sites
Posted (edited)

den Debug modus konnte ich aktivieren , wenn das gemeint ist 

Es wird zwischen Exception, Logs, Stack Traces unterschieden?

in der WEbansicht : 
 

[PrestaShopDatabaseException]

Table 'db779919893.nxbf_connections' doesn't exist

im Backoffice beim Anklicken von "Kunden":
 

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 nxbf_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 nxbf_guest g LEFT JOIN nxbf_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 nxbf_customer c LEFT JOIN nxbf_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN nxbf_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, 2, 1]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db779919893.nxbf_guest' doesn't exist

Edited by cschilling
additional Info (see edit history)

Share this post


Link to post
Share on other sites

Da fehlen zwei Tabellen in der Datenbank, kannst du in PHPMYADMIN anlegen:

CREATE TABLE `nxbf_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;

ALTER TABLE `nxbf_connections`
  ADD PRIMARY KEY (`id_connections`),
  ADD KEY `id_guest` (`id_guest`),
  ADD KEY `date_add` (`date_add`),
  ADD KEY `id_page` (`id_page`);

ALTER TABLE `nxbf_connections`
  MODIFY `id_connections` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;

und

CREATE TABLE `nxbf_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;

ALTER TABLE nxbf_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`);

ALTER TABLE `nxbf_guest`
  MODIFY `id_guest` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;

 

  • Thanks 1

Share this post


Link to post
Share on other sites

KLASSE! 
mir ist ist es tatsächlich gelungen , die beiden Tabellen in der Datenbank anzulegen - 

Es kam zwar noch eine Fehlermeldung - siehe unten - aber es scheint zu funktionieren - Vielen Dank 
Ich konnte zu mindest einen Gastkunden über das Web anlegen und auf "Kunden" im Backoffice habe ich auch wieder Zugriff.

Ich stehe in deiner Schuld - solltest du Fahrradteile benötigen - siehe dich in unserem Shop um oder wenn du als Läufer Startplätze beim Panorama-Baumwipfel-Lauf benötigst - gerne - siehe https://panorama-baumwipfel-lauf.de/

 

image.thumb.png.adebcbe5e86d1ea14736d54c38584ebe.png

Share this post


Link to post
Share on other sites
Posted (edited)

Bzgl. des Fehlers, da ist ein Anführungszeichen verloren gegangen, versuche es nochmal hiermit, dann sind auch die keys in der DB korrekt

ALTER TABLE `nxbf_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`);

 

Edited by JBW (see edit history)

Share this post


Link to post
Share on other sites

Das habe ich eingefügt und dann kommt folgende "Fehler-Nachricht"

 

SQL-Befehl:

CREATE TABLE `nxbf_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: 

#1050 - Tabelle 'nxbf_guest' bereits vorhanden

Share this post


Link to post
Share on other sites

Nur den neuen Teil, die Tabelle ist ja schon da.

ALTER TABLE `nxbf_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`);

 

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