Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Since ~6 month blank page after admin login  (Read 1846 times)

Offline cdhobbycreativ

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Since ~6 month blank page after admin login
« on: January 23, 2022, 04:32:05 AM »
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

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Since ~6 month blank page after admin login
« Reply #1 on: January 23, 2022, 06:20:21 AM »
Looks like your database inner time differ than server time

you can try run query
Code: [Select]
select now();
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)
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline cdhobbycreativ

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Since ~6 month blank page after admin login
« Reply #2 on: January 23, 2022, 10:08:37 AM »
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

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Since ~6 month blank page after admin login
« Reply #3 on: January 23, 2022, 11:16:52 AM »
Code: [Select]
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

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
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline cdhobbycreativ

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Since ~6 month blank page after admin login
« Reply #4 on: January 23, 2022, 12:42:10 PM »
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

 

Powered by SMFPacks Social Login Mod