Hallo,
ich habe noch einen 1.06er modified Shop.
Auf meiner Testumgebung habe ich denn die 2.0 installiert.
Dann habe ich die alte Datenbank via mysql (shell) eingespielt und über den installer das Update gemacht.
Alles super geklappt. Die letzten zwei Wochen damit gearbeitet und angepasst.
Heute habe ich dann noch mal per mysql (shell) die Datenbank eingespielt.
Dann wieder über den Installer alle Updates gemacht.
Jetzt kann ich mich als Admin nicht mehr einloggen.
customers Status ist auf eins.
Ich erhalte über die error.log "mod_warning" folgende Meldung:
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: 1054 - Unknown column
'status' in
'where clause'<br
/><br
/>SELECT
* FROM currencies WHERE status
= '1' in
File: /www
/htdocs
/*****/****.de
/inc
/db_functions_mysql
.inc
.php on Line
: 160[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#0 - /www/htdocs/*****/****.de/inc/db_functions.inc.php called at Line 104
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#1 - /www/htdocs/*****/****.de/includes/classes/xtcPrice.php called at Line 64
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#2 - /www/htdocs/*****/****.de/includes/application_top.php called at Line 302
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#3 - /www/htdocs/*****/****.de/login.php called at Line 23
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: 1054 - Unknown column
'password_request_time' in
'field list'<br
/><br
/>SELECT customers_id
, customers_vat_id
, customers_firstname
, customers_lastname
, customers_gender
, customers_password
, customers_email_address
, customers_default_address_id
, password_request_key
, password_request_time
FROM customers
WHERE customers_email_address
= 'meine@loginemail.de' AND account_type
= '0' in
File: /www
/htdocs
/*****/****.de
/inc
/db_functions_mysql
.inc
.php on Line
: 160[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#0 - /www/htdocs/*****/****.de/login.php called at Line 115
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: 1054 - Unknown column
'r.reviews_status' in
'where clause'<br
/><br
/>SELECT r
.reviews_id
, r
.reviews_rating
, substring
(rd
.reviews_text
, 1, 60) as reviews_text
, p
.products_id
, p
.products_image
, pd
.products_name
FROM reviews r
JOIN reviews_description rd
ON r
.reviews_id
= rd
.reviews_id
AND rd
.languages_id
= '2' AND
trim(rd
.reviews_text
) != '' JOIN products p
ON p
.products_id
= r
.products_id
JOIN products_description pd
ON p
.products_id
= pd
.products_id
AND
trim(pd
.products_name
) != '' AND pd
.language_id
= '2' WHERE p
.products_status
= '1' AND r
.reviews_status
= '1' ORDER BY
MD5(CONCAT
(p
.products_id
, CURRENT_TIMESTAMP
)) LIMIT
10 in
File: /www
/htdocs
/*****/****.de
/inc
/db_functions_mysql
.inc
.php on Line
: 160[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#0 - /www/htdocs/*****/****.de/templates/xtc5/source/boxes/reviews.php called at Line 66
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#1 - /www/htdocs/*****/****.de/templates/xtc5/source/boxes.php called at Line 85
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#2 - /www/htdocs/*****/****.de/login.php called at Line 202
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: 1054 - Unknown column
'status' in
'where clause'<br
/><br
/>SELECT
* FROM currencies WHERE status
= '1' in
File: /www
/htdocs
/*****/****.de
/inc
/db_functions_mysql
.inc
.php on Line
: 160[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#0 - /www/htdocs/*****/****.de/inc/db_functions.inc.php called at Line 104
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#1 - /www/htdocs/*****/****.de/includes/classes/xtcPrice.php called at Line 64
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#2 - /www/htdocs/*****/****.de/includes/application_top.php called at Line 302
[08-02-2017 11:50:02] E_USER_WARNING : LoggingManager
: Backtrace
#3 - /www/htdocs/*****/****.de/display_vvcodes.php called at Line 16 Ich weiß leider nicht, wo ich hier bei der Fehlerlösung ansetzen sollte und wäre für einen Tipp sehr dankbar.
Lieben Gruß
Heiko
Linkback: https://www.modified-shop.org/forum/index.php?topic=36635.0