Some queries are not logged in class.mysql
A for , submitted by nickdunn on 05 January 2010
Announcement
Symphony's issue tracker has been moved to Github.
Issues are displayed here for reference only and cannot be created or edited.
Browse
Closed#197: Some queries are not logged in class.mysql
-
-
- nickdunn
- Comment #1
- 05 Jan 10, 2:34 am
-
-
- nickdunn
- Comment #2
- 05 Jan 10, 2:36 am
Sussed! Line 263 of class.mysql.php builds a unique hash for the query by hashing the current time. If two of the same query are fired one after the other, within a fraction of a second, this hash will be identical so only one will be logged.
Fixed by using microtime() instead:
$query_hash = md5($query.microtime());
-
-
- nickdunn
- Comment #3
- 07 Jan 10, 2:21 am
-
-
- Alistair
- Comment #4
- 11 Jan 10, 9:04 am
Pulled. Thanks
This issue is closed.
Some queries are missing from the internal logger in class.mysql.php. The total is often higher than the number of queries printed out using
->debug('queries').