GuidoB.
27.02.2021, 11:20
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:
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?
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:
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?