Shopping Cart Operations > Support

Since ~6 month blank page after admin login

(1/1)

cdhobbycreativ:
Hi All,
since 6 month I get a blank page after admin login, shopsystem works fine. Lot of solutions I've testet - without GD2. Who can help in this case? My error file entry from Today:

2022-01-23 9:33:57 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642840437' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 9:43:05 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642840985' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 9:58:50 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642841930' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:01:10 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842070' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:01:12 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842072' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:01:24 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842084' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:01:59 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842119' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:02:07 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842127' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:03:08 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842188' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:03:57 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842237' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:04:31 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842271' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:05:07 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842307' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:05:55 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842355' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:06:15 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842375' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:06:16 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842376' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:07:43 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842463' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:07:43 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842463' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:07:44 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842464' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:07:44 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842464' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:07:44 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842464' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 10:07:57 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642842477' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>

This error comes at I try to login as admin.

Entry of apdomysql.php:

......
    public function query($sql, $noexcept = false, $params = array())
    {
        if (!$noexcept) {
            $this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $this->connection->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
        }

        $this->statement = $this->connection->prepare($sql);          ==line 60
        $result = false;

        $time_start = microtime(true);
        try {
            if ($this->statement && $this->statement->execute($params)) {
.....

Many thanks for suggested solutions.
Best regards
Jens

abolabo:
Looks like your database inner time differ than server time

you can try run query

--- Code: ---select now();
--- End code ---

and  compare it with server time.

Anyway, your issue i not a php-code problem.

If your host have a php mysql-dirver your can switch cart from "pdo" driver to "amysqli" (see system/config.php, DB_DRIVER constant)

cdhobbycreativ:
Hi abolabo,

thanks for your support.

database and server time are the same (checked from webhoster hotline)
GD2-module activated - nothing
changed from DB_DRIVER', 'apdomysql to DB_DRIVER', 'amysqli - error on admin login page (before login):

2022-01-23 15:44:07 - :  AbanteCart core v.1.2.13 SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '1642862647' in <b>/home/www/cd-hobby-creativ.de/core/database/apdomysql.php</b> on line <b>60</b>
2022-01-23 15:48:38 - database error:  AbanteCart core v.1.2.13 SQL Error: Incorrect TIMESTAMP value: '1642862918'<br />Error No: 1525<br />SQL: SELECT *
                                    FROM abc_currencies
                                    WHERE code != 'EUR'
                                        AND date_modified > '1642862918' in <b>/home/www/cd-hobby-creativ.de/core/database/amysqli.php</b> on line <b>114</b>

Note:
AC version 1.2.13
MySQL version 8.0.22
PHP version (tested) 7.1, 7.2, 7.3 and 7.4 - same result
PHP 8.0 - error:

warning: Undefined array key "rt" in /home/www/cd-hobby-creativ.de/core/init.php on line 77warning: Undefined array key 0 in /home/www/cd-hobby-creativ.de/core/lib/error.php on line 114
Fatal error: Uncaught Error: Undefined constant "IS_ADMIN" in /home/www/cd-hobby-creativ.de/core/lib/exceptions/exception.php:93 Stack trace: #0 /home/www/cd-hobby-creativ.de/core/lib/exceptions.php(111): AException->showErrorPage() #1 /home/www/cd-hobby-creativ.de/core/lib/exceptions.php(59): ac_exception_handler(Object(AException)) #2 /home/www/cd-hobby-creativ.de/core/lib/error.php(114): ac_error_handler(2, 'Undefined array...', '/home/www/cd-ho...', 114) #3 /home/www/cd-hobby-creativ.de/core/lib/exceptions/exception.php(76): AError->toLog() #4 /home/www/cd-hobby-creativ.de/core/lib/exceptions.php(109): AException->logError() #5 [internal function]: ac_exception_handler(Object(AException)) #6 {main} thrown in /home/www/cd-hobby-creativ.de/core/lib/exceptions/exception.php on line 93
error: Uncaught Error: Undefined constant "IS_ADMIN" in /home/www/cd-hobby-creativ.de/core/lib/exceptions/exception.php:93 Stack trace: #0 /home/www/cd-hobby-creativ.de/core/lib/exceptions.php(111): AException->showErrorPage() #1 /home/www/cd-hobby-creativ.de/core/lib/exceptions.php(59): ac_exception_handler(Object(AException)) #2 /home/www/cd-hobby-creativ.de/core/lib/error.php(114): ac_error_handler(2, 'Undefined array...', '/home/www/cd-ho...', 114) #3 /home/www/cd-hobby-creativ.de/core/lib/exceptions/exception.php(76): AError->toLog() #4 /home/www/cd-hobby-creativ.de/core/lib/exceptions.php(109): AException->logError() #5 [internal function]: ac_exception_handler(Object(AException)) #6 {main} thrown in /home/www/cd-hobby-creativ.de/core/lib/exceptions/exception.php on line 93

May be can help an update from AC 1.2.13 to 1.3.2 ? Can I do this without admin access? Guide: abantecart.atlassian.net/wiki/spaces/AD/pages/5275676/Upgrade+manually

What do you mean?

Thanks and best regards
Jens

abolabo:

--- Code: ---Note:
AC version 1.2.13
MySQL version 8.0.22
PHP version (tested) 7.1, 7.2, 7.3 and 7.4 - same result
--- End code ---

you have a 1.2.13 version which DO NOT SUPPORT php greater than 5.6.
1.2.16 supports 7.1
1.3.0 supports 8.0

You should to upgrade your abantecart  under php5.6 to version 1.2.16. Then switch to php7.4 and upgrade cart to latest 1.3.2 . In that case you can switch to  php8.0

cdhobbycreativ:
many thanks for your help !!

I've upgraded to 1.2.16 and the admin page loaded !

Upgrade to 1.3.2 I will do next week.

Best wishes and thanks
Jens

Navigation

[0] Message Index

Go to full version
Powered by SMFPacks Social Login Mod