search

gajus / xhprof.io

GUI to analyze the profiling data collected using XHProf – A Hierarchical Profiler for PHP.
http://xhprof.io/
Other
429 stars 103 forks source link

STRICT_ALL_TABLES #49

Open nmalcolm opened 11 years ago

nmalcolm commented 11 years ago

XHProf.io doesn't work with sql_mode=STRICT_ALL_TABLES. The application is trying to insert invalid data in to the database. This is an issue for me as the software I develop should have STRICT_ALL_TABLES enabled during development.

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'mu' at row 1' in /var/www/html/xhprof/xhprof/classes/data.php:258

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1364 Field 'request_caller_id' doesn't have a default value' in /var/www/html/xhprof/xhprof/classes/data.php:185

gms8994 commented 10 years ago

Changing request_caller_id to allow null, and changing mu to allow signed integers causes the application to continue to work.