Jump to content


Hosting Developers Payment Shipping Accounting Templates Marketing Books

Our Partners


Latest News: (loading..)

Issue Information

  • #000259

  • 0 - None Assigned

  • Confirmed

  • 3.0.1

  • -

Issue Confirmations

  • Yes (0)No (0)
Photo

Internal errors can not be displayed in error_log module

Posted by foxp2 on 09 April 2011 - 04:03 PM

hi harald

these errors block the module :
PHP Fatal error:  Out of memory (allocated 786432) (tried to allocate 6144 bytes) in \osCommerce\OM\Core\Autoloader.php on line 48

PHP Fatal error:  Uncaught exception ''PDOException'' with message ''SQLSTATE[HY000] [2002] Aucune connexion n’a pu être établie car l’ordinateur cible l’a expressément refusée.

[img]https://lh4.googleusercontent.com/_xMCt3WiwDp8/TaCA50D4krI/AAAAAAAAAMs/aD9xZt4dJEc/s800/Capture.jpg[/img]


if i search 'PHP fatal error', the function return 0, but with SQLite Database Browser, i found 14 fatal errors. :

[img]https://lh3.googleusercontent.com/_xMCt3WiwDp8/TaCCOqIMzwI/AAAAAAAAANA/w31SM4lT8Yg/s800/Capture.jpg[/img]


fatal error list :

[img]https://lh4.googleusercontent.com/_xMCt3WiwDp8/TaCCtzt4jkI/AAAAAAAAANU/RdqA-VOi8bk/s800/Capture.jpg[/img]


Harald Ponce de Leon

Apr 09 2011 06:23 PM
Updating status to: Won't Fix
Issue fixed in: 3.0.2

Hi Laurent..

PHP does not use custom error handlers for fatal errors and is the reason why fatal errors are not logged in the sqlite3 database. What does happen though is that the fatal error gets logged to osCommerce/OM/Work/Logs/errors.txt and on the next page request, is automatically imported from the text file into the sqlite3 database.

There is a workaround to register a shut down function to detect fatal errors so they can be logged directly into sqlite3, however more research into this is needed.

Kind regards,


Harald Ponce de Leon

Apr 09 2011 06:24 PM
Issue fixed in: None


Harald Ponce de Leon

Apr 09 2011 10:28 PM
Moving to: osCommerce Online Merchant v3.x


Harald Ponce de Leon

Apr 09 2011 10:29 PM
Updating severity to: 0 - None Assigned
Updating status to: Won't FIx
Updating version to: 3.0.1
Issue fixed in: None


foxp2
Apr 11 2011 10:11 AM
hi harald,

the issue is due to a bad formating in sqlite database.(with specials characters),
look at this :

[img]https://lh3.googleusercontent.com/_xMCt3WiwDp8/TaLO8505tqI/AAAAAAAAATk/RM7pOm9yVgY/s800/Capture.jpg[/img]

the error log module is frozen with a javascript error :

[img]https://lh5.googleusercontent.com/_xMCt3WiwDp8/TaLQeQCVSFI/AAAAAAAAAT4/sJ3p1e4HIOs/s800/Capture.jpg[/img]


Erreur : $("<span>").text(string).html is not a function
Fichier Source : http://localhost:90/oscom3/public/sites/Admin/javascript/general.js
Ligne : 194

if i replace these characters (in sqlite database) :

[img]https://lh4.googleusercontent.com/_xMCt3WiwDp8/TaLSEyTCWnI/AAAAAAAAAUg/WtD5-yjfyFc/s800/Capture.jpg[/img]

the error log module runs normally :

[img]https://lh5.googleusercontent.com/_xMCt3WiwDp8/TaLRQHBy4kI/AAAAAAAAAUM/17WTtbQCvmg/s800/Capture.jpg[/img]

now,i don't know if you see what i mean ....[img]http://forums.oscommerce.com/public/style_emoticons/default/huh.gif[/img]

Edited by foxp2, 11 April 2011 - 10:13 AM.



Harald Ponce de Leon

Apr 11 2011 10:43 AM
Updating severity to: 0 - None Assigned
Updating status to: In Progress
Updating version to: 3.0.1
Issue fixed in: None

Hi Laurent..

Could you force the same fatal error to occur again and before making another page request, check in osCommerce/OM/Logs/errors.txt and confirm the error messages there are logged correctly in utf8?

Thanks,


Gergely
Apr 11 2011 10:54 AM

foxp2, on 11 April 2011, 12:11, said:

hi harald,

the issue is due to a bad formating in sqlite database.(with specials characters),
look at this :

[img]https://lh3.googleusercontent.com/_xMCt3WiwDp8/TaLO8505tqI/AAAAAAAAATk/RM7pOm9yVgY/s800/Capture.jpg[/img]

the error log module is frozen with a javascript error :

[img]https://lh5.googleusercontent.com/_xMCt3WiwDp8/TaLQeQCVSFI/AAAAAAAAAT4/sJ3p1e4HIOs/s800/Capture.jpg[/img]


Erreur : $("<span>").text(string).html is not a function
Fichier Source : http://localhost:90/oscom3/public/sites/Admin/javascript/general.js
Ligne : 194

if i replace these characters (in sqlite database) :

[img]https://lh4.googleusercontent.com/_xMCt3WiwDp8/TaLSEyTCWnI/AAAAAAAAAUg/WtD5-yjfyFc/s800/Capture.jpg[/img]

the error log module runs normally :

[img]https://lh5.googleusercontent.com/_xMCt3WiwDp8/TaLRQHBy4kI/AAAAAAAAAUM/17WTtbQCvmg/s800/Capture.jpg[/img]

now,i don't know if you see what i mean ....[img]http://forums.oscommerce.com/public/style_emoticons/default/huh.gif[/img]

Hi,

All datatables must collate utf8! I cant install only into utf8 tables the hungarian language. The iso (8859-1) standards fails.

Regards,
Gergely


foxp2
Apr 11 2011 11:00 AM

Harald Ponce de Leon, on 11 April 2011, 12:43, said:

Updating severity to: 0 - None Assigned
Updating status to: In Progress
Updating version to: 3.0.1
Issue fixed in: None

Hi Laurent..

Could you force the same fatal error to occur again and before making another page request, check in osCommerce/OM/Logs/errors.txt and confirm the error messages there are logged correctly in utf8?

Thanks,

action : shutdwon mysql service
the error is correctly encoded in errors.txt :
[11-Apr-2011 12:54:51] PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Aucune connexion n’a pu être établie car l’ordinateur cible l’a expressément refusée.



Harald Ponce de Leon

Apr 11 2011 11:21 AM
Updating severity to: 0 - None Assigned
Updating status to: In Progress
Updating version to: 3.0.1
Issue fixed in: None

Hi Laurent..

That's really strange as I copied that line to my errors.txt and it imported to sqlite properly.

For some reason it is not being imported into your sqlite3 database properly. There is no way to set a charset for sqlite3 as it already operates in utf8.

Kind regards,


foxp2
Apr 11 2011 11:29 AM
sorry harald,my report is incomplete ...[img]http://forums.oscommerce.com/public/style_emoticons/default/blush.gif[/img]

full and exact report :
[11-Apr-2011 12:54:51] PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Aucune connexion n’a pu être établie car l’ordinateur cible l’a expressément refusée.

' in C:\UwAmp\www\oscom3\osCommerce\OM\Core\PDO\MySQL\Standard.php:44
Stack trace:
#0 C:\UwAmp\www\oscom3\osCommerce\OM\Core\PDO\MySQL\Standard.php(44): PDO->__construct('mysql:dbname=os...', 'root', 'root', Array)
#1 C:\UwAmp\www\oscom3\osCommerce\OM\Core\PDO\MySQL\V5.php(20): osCommerce\OM\Core\PDO\MySQL\Standard->connect()
#2 C:\UwAmp\www\oscom3\osCommerce\OM\Core\PDO\MySQL\Standard.php(32): osCommerce\OM\Core\PDO\MySQL\V5->connect()
#3 C:\UwAmp\www\oscom3\osCommerce\OM\Core\PDO.php(63): osCommerce\OM\Core\PDO\MySQL\Standard->__construct('127.0.0.1', 'root', 'root', 'oscom3', '3306', Array)
#4 C:\UwAmp\www\oscom3\osCommerce\OM\Core\Site\Admin\Controller.php(25): osCommerce\OM\Core\PDO::initialize()
#5 [internal function]: osCommerce\OM\Core\Site\Admin\Controller::initialize()
#6 C:\UwAmp\www\oscom3\osCommerce\OM\Core\Site\RPC\Controller.php(52): call_ in C:\UwAmp\www\oscom3\osCommerce\OM\Core\PDO\MySQL\Standard.php on line 44



Harald Ponce de Leon

Apr 11 2011 11:47 AM
Updating severity to: 0 - None Assigned
Updating status to: In Progress
Updating version to: 3.0.1
Issue fixed in: None

Hi Laurent..

Can you copy the following file to:

osCommerce/OM/Custom/ErrorHandler.php

Attached File  ErrorHandler.php   5.59K   1 downloads

This inserts the following to the sqlite3 database everytime it opens a connection to it:

Test error:  n’a être établie l’ordinateur l’a expressément refusée äöü߀£ÄÖÜ

Thanks,


foxp2
Apr 11 2011 12:04 PM
before i test your solution, i've tested mine with :
in errors.txt :
[11-Apr-2011 12:54:51] PHP Fatal error:  'Olé Olé toro !'  in C:\UwAmp\www\oscom3\osCommerce\OM\Core\PDO\MySQL\Standard.php:44


and i've changed 1 line in the same file [ErrorHandler.php]->method : static function import:

.../...
$message = substr(utf8_encode($error), 23);
.../...


[img]https://lh6.googleusercontent.com/_xMCt3WiwDp8/TaLt-ugNcRI/AAAAAAAAAU0/u3t7NvmQM4M/s800/Capture.jpg[/img]


so now, i'm going to test your solution.


foxp2
Apr 11 2011 12:12 PM
with your test, errors _log module runs normally :


[img]https://lh3.googleusercontent.com/_xMCt3WiwDp8/TaLvp-YprPI/AAAAAAAAAVI/-pJXwK9j3zw/s800/dashboard.jpg[/img]

[img]https://lh4.googleusercontent.com/_xMCt3WiwDp8/TaLv2G-dLqI/AAAAAAAAAVQ/S0wQB3Ezmxg/s800/errors_log.jpg[/img]

so, what's up ?

Edited by foxp2, 11 April 2011 - 12:14 PM.



Harald Ponce de Leon

Apr 11 2011 12:17 PM
Updating severity to: 0 - None Assigned
Updating status to: In Progress
Updating version to: 3.0.1
Issue fixed in: None

Hi Laurent..

One more test :-) Please replace osCommerce/OM/Custom/ErrorHandler.php with the following and try again:

Attached File  ErrorHandler.php   5.65K   2 downloads

Thanks,

Edited by Harald Ponce de Leon, 11 April 2011 - 12:18 PM.



foxp2
Apr 11 2011 12:20 PM

[img]http://forums.oscommerce.com/public/style_emoticons/default/blush.gif[/img]

An Error Occurred
Sorry, an error occurred. If you are unsure on how to use a feature, or don't know why you got this error message, try looking through the help files for more information.


[#10170] We could not find the attachment you were attempting to view.


Harald Ponce de Leon

Apr 11 2011 12:21 PM
Updating severity to: 0 - None Assigned
Updating status to: In Progress
Updating version to: 3.0.1
Issue fixed in: None

Hi Laurent..

Please try the download again - I spotted an error and replaced it with a working version.

Thanks,


foxp2
Apr 11 2011 12:26 PM
everything is ok :

[img]https://lh6.googleusercontent.com/_xMCt3WiwDp8/TaLzC-MI2iI/AAAAAAAAAVk/UGZLAW5CyfM/s800/dashboard.jpg[/img]


[img]https://lh6.googleusercontent.com/_xMCt3WiwDp8/TaLzNUu6tlI/AAAAAAAAAVs/p4v4DkercgE/s800/errors_log.jpg[/img]


Harald Ponce de Leon

Apr 11 2011 12:28 PM
Updating severity to: 0 - None Assigned
Updating status to: In Progress
Updating version to: 3.0.1
Issue fixed in: None

Hi Laurent..

Strange. Could you work on this further to see if you can spot the failure? It's hard for me as I can't reproduce the error.

Thanks,


foxp2
Apr 11 2011 12:41 PM
imo, it's a typical issue with a windows operating system ...


Harald Ponce de Leon

Apr 11 2011 12:46 PM
Updating severity to: 0 - None Assigned
Updating status to: In Progress
Updating version to: 3.0.1
Issue fixed in: None

Hi Laurent..

In case others can help, can you mention which PHP/Apache/Windows/WAMP-Package version this error occurs on?

Thanks,


Back to osCommerce Online Merchant v3.x


  1. osCommerce Support Forum
  2. → Bug Reports
  3. → osCommerce Online Merchant
  4. → osCommerce Online Merchant v3.x
  5. → Status: Confirmed
  6. → Version: 3.0.1
  7. Privacy Policy
  8. Forum Rules ·