Hallo,
ich habe offenbar ein Problem mit meiner Datenbank.
Ich kann im Adminbereich keine Artikel mehr bearbeiten.
Folgende Fehler wird im Log hinterlegt: Uncaught RuntimeException: SQL Error!
Der Gesamte Log Eintrag sieht wie folgt aus:
PHP-Code:
context: message: Uncaught RuntimeException: SQL Error!
Table 'dbxxx.products_slider_set' doesn't exist
Query: SELECT
p.*,
pd.*,
pss.*,
pic.code_isbn,
pic.code_upc,
pic.code_mpn,
pic.code_jan,
pic.google_export_condition,
pic.google_export_availability_id,
pic.brand_name,
pic.identifier_exists,
pic.gender,
pic.age_group,
date_format(pic.expiration_date, '%Y-%m-%d') as expiration_date,
date_format(p.products_date_available, '%Y-%m-%d') as products_date_available
FROM
products p
LEFT JOIN products_description pd ON pd.products_id = p.products_id
LEFT JOIN products_slider_set pss ON pss.products_slider_set_id = p.products_id
LEFT JOIN products_item_codes pic ON pic.products_id = p.products_id
WHERE
p.products_id = '1789'
AND pd.language_id = '2' in /pages/8b/1d/d0012680/home/htdocs/live-natural-life/inc/xtc_db_error.inc.php:35
Stack trace:
#0 /pages/8b/1d/d0012680/home/htdocs/live-natural-life/inc/xtc_db_query.inc.php(78): xtc_db_error('SELECT\n\t\t\tp.*,\n...',
code: 1
file: /pages/8b/1d/d0012680/home/htdocs/live-natural-life/inc/xtc_db_error.inc.php
line: 35
context:
obCleanCache: false
extra: request: method: GET
uri: /admin/categories.php?page=1&cPath=0&pID=1789&action=new_product
software: Apache
address: 81.169.234.117
userAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36
time: 201
remoteAddress: 212.100.63.207
query: page: 1
cPath: 0
pID: 1789
action: new_product
session: tpl: Honeygrid
language: german
languages_id: 2
language_charset: utf-8
language_code: de
currency: EUR
customers_status: ...
customer_id: 1
payment: invoice
shipping: ...
cartID: 40963
sendto: 1
billto: 1
Hat Jemand eine Idee, wie ich Abhilfe schaffen kann?