Messages

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

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

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