AbanteCart Community
Shopping Cart Operations => Support => Topic started by: cdhobbycreativ 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
-
Looks like your database inner time differ than server time
you can try run query
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)
-
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
-
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
-
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