“”

Debug Mysql or other DB Debug Mysql or other DB

debug_mysql_db / stable

Extends \TYPO3\CMS\Core\Database\DatabaseConnection and \TYPO3\CMS\Core\Database\Connection to show Errors and Debug-Messages. Debugging of sql-queries by debug and FileWriter.

This version supports TYPO3

Older versions also support TYPO3

Composer support

composer req geithware/debug-mysql-db

Tags

#mysql #Speed #benchmark

Last upload comment

compatibility TYPO3 13

Downloads by month

Download 1.9.1 Extension Manual Found an Issue? Code Insights Packagist.org Donate and Give Kudos
Author
Franz Holzinger, formerly Stefan Geith
Company
jambage.com
Last update
12. Sep 2024
First upload
17. Jan 2007
Downloads
27,717
Category
Miscellaneous
Dependencies
  • TYPO3 (13.0.0 - 13.4.99)
  • PHP (8.1.0 - 8.4.99)

Installation

  1. Download ZIP file
  2. Log into your TYPO3 backend
  3. Go to Extension Manager module
  4. Press the upload button on the top bar
  5. Select the ZIP file and upload it. If you want to overwrite an existing extension installation, activate the checkbox.
  1. Go to your folder where the root composer.json file is located
  2. Type: composer req geithware/debug-mysql-db to get the latest version that runs on your TYPO3 version.
  1. Download T3X file
  2. Log into your TYPO3 backend
  3. Go to Extension Manager module
  4. Press the upload button on the top bar
  5. Select the T3X file and upload it. If you want to overwrite an existing extension installation, activate the checkbox.

Other extensions by this user (52)

Version history

Version Upload comment Works with TYPO3 Download
1.9.1 / stable
September 12, 2024
compatibility TYPO3 13
13.0.0 - 13.4.99 Download
1.9.0 / stable
July 31, 2024
INSERT and SQL mode: lastInsertId must not raise an exception if it is 0
13.0.0 - 13.4.99 Download
1.8.1 / stable
July 25, 2024
bugfix
12.4.0 - 12.4.99 Download
1.8.0 / stable
April 05, 2024
maintenance release
12.4.0 - 12.4.99 Download
1.7.3 / stable
April 05, 2024
version for TYPO3 11
11.5.0 - 11.5.99 Download
1.7.2 / stable
March 20, 2024
maintenance release
12.4.0 - 12.4.99 Download
1.7.1 / stable
March 04, 2024
important bug fix
11.5.0 - 12.4.99 Download
1.7.0 / stable
February 16, 2024
bugfix for TYPO3 12: use request object
11.5.0 - 12.4.99 Download
1.6.0 / stable
January 31, 2024
Show SQL queries after all throwable exceptions.
11.5.0 - 12.4.99 Download
1.5.1 / stable
January 04, 2024
Remain compatible to the \TYPO3\CMS\Core\Database\Connection function declarations
11.5.0 - 12.4.99 Download
1.5.0 / stable
January 03, 2024
modifications by rector
11.5.0 - 12.4.99 Download
1.4.1 / stable
October 23, 2023
imprtant bugfix: remove endless loop from exec_SELECTquery
11.5.0 - 12.4.99 Download
1.4.0 / stable
September 23, 2023
support ALTER TABLE
11.5.0 - 12.4.99 Download
1.3.2 / stable
September 15, 2023
README file added.
Patch for TYPO3 Core to enable debugging for the install tool.
11.5.0 - 12.4.99 Download
1.3.1 / stable
July 18, 2023
add missing initialization
11.5.0 - 12.4.99 Download
1.3.0 / stable
June 30, 2023
support for TYPO3 12

11.5.0 - 12.4.99 Download
1.2.1 / stable
June 30, 2023
No TYPO3 12 yet supported
10.4.0 - 11.5.99 Download
1.2.0 / stable
May 05, 2023
support for TYPO3 12
10.4.0 - 12.4.99 Download
1.1.3 / stable
December 01, 2022
bugfix Doctrine
9.5.0 - 11.99.99 Download
1.1.2 / stable
February 24, 2022
bugfix for the SQL parser
9.5.0 - 11.99.99 Download
1.1.1 / stable
February 13, 2022
bugfix for Doctrine Api
9.5.0 - 11.99.99 Download
1.1.0 / stable
January 15, 2022
bugfix for PHP 8 and TYPO3 11
9.5.0 - 11.99.99 Download
1.0.0 / stable
January 16, 2021
Manually entered labels annihilate normally ignored excluded stripped tables.
8.7.0 - 10.4.99 Download
0.9.3 / stable
November 13, 2020
support for UPDATE, DELETE and INSER with the Doctrine framework

8.7.0 - 9.5.99 Download
0.9.2 / stable
September 02, 2020
bugfix in the SQL query logger
8.7.0 - 9.5.99 Download
0.9.1 / stable
July 19, 2020
improvements for the FileWriter Logger. Add the possibility to turn off debugUtility outputs which might be needed for Ajax calls.
8.7.0 - 9.5.99 Download
0.9.0 / stable
July 12, 2020
new feature: Database Logger with support for a FileWriter and for the debug method.

8.7.0 - 9.5.99 Download
0.8.2 / stable
February 23, 2020
bugfix for TYPO3 9.5
8.7.0 - 9.5.99 Download
0.8.1 / stable
February 20, 2020
readd support for old style TYPO3_DB MySQL for TYPO3 8.7
8.7.0 - 9.5.99 Download
0.8.0 / stable
February 04, 2020
First version with support for the QueryBuilder SQL query.
New feature: debug output for the Doctrine method executeQuery
8.7.0 - 9.5.99 Download
0.7.1 / stable
January 03, 2020
bugfix: the initialization has been moved into the method initialize
9.5.0 - 9.99.99 Download
0.7.0 / stable
August 24, 2019
This version only works under TYPO3 9.5 in combination with the extension typo3db_legacy.
9.5.0 - 9.99.99 Download
0.6.3 / stable
January 19, 2018

Do not debug SESSION queries.

6.1.0 - 8.99.99 Download
0.6.2 / stable
September 08, 2017

support for TYPO3 8.7.6

6.1.0 - 8.99.99 Download
0.6.0 / stable
June 30, 2016

Runs now also with TYPO3 7.x and PHP 7.x

6.1.0 - 7.99.99 Download
0.5.9 / stable
October 28, 2015
TYPO3 6.2 uses the method query($query) instead of $this->link->query($query)
and other bugfixes.
Thankst to F.Holzinger

6.1.0 - 6.2.999 Download
0.5.8 / stable
July 24, 2015
Modified ext_conf_template.txt
6.1.0 - 6.2.999 Download
0.5.7 / stable
July 22, 2015
Bugfix
6.1.0 - 6.2.999 Download
0.5.6 / stable
June 19, 2015
Followup fix bug #67459: TYPO3 6.2.x has a table sys_refindex which misses the field uid
6.1.0 - 6.2.999 Download
0.5.5 / stable
June 16, 2015
fix bug #67459: TYPO3 6.2.x has a table sys_refindex which misses the field uid.
6.1.0 - 6.2.999 Download
0.5.2 / stable
March 25, 2014
New compatibility with Typo3 6.1-6.2; For Typo3 V4.3-4.7 see Versions 0.4.x
6.1.0 - 6.2.999 Download
0.5.1 / stable
March 25, 2014
New compatibility with Typo3 6.1-6.2; For Typo3 V4.3-4.7 see Versions 0.4.x
6.1.0 - 6.2.999 Download
0.5.0 / stable
June 05, 2013
NEW Verson for TYPO3 6.x!!!! Extends \\TYPO3\\CMS\\Core\\Database\\DatabaseConnection (former t3lib_db) to show Errors and Debug-Messages. Usefull for viewing and debugging of sql-queries generated using its methods. Shows error messages if they occur. Si
6.0.0 - 6.0.999 Download
0.4.5 / beta
June 05, 2013
FOR TYPO3 4.x !! Last Version for Typo3 4.3-4.7 !! (For TYPO3 CMS 6.x see Versions 0.5+)
4.3.0 - 4.7.99 Download
0.4.2 / beta
June 11, 2012
Now compatible with Typo3 up to 4.7
Download
0.4.1 / beta
May 02, 2011
Bugfix: SQL ERROR has not been shown when an alias has been used in long queries (Thanks to F.Holzinger)

Download
0.4.0 / beta
March 02, 2011
use the latest query in debug output if lastBuiltQuery is empty
add conflict with the dbal extension
fix bug: SQL ERROR has not been shown when an alias has been used
Thanks to Franz Holzinger
Download
0.3.6 / beta
October 11, 2010
Fix bug in debugging not the tables from EXCLUDETABLES; Thanks to Franz Holzinger

Download
0.3.4 / beta
May 03, 2010
Changed: do not call any code of debug_mysql_db if TYPO3_MODE is not FE or BE or ALL. This should speed it up. (by Franz Holzinger)
Download
0.3.3 / beta
February 10, 2010
Changed: do not debug disabled tables even in an error case (by Franz Holzinger)
Download
0.3.2 / beta
November 25, 2009
Version 0.3.2
add exclude table names which are normally system tables and the output is not wanted for the debugging of extensions;
add the TCA option to show only those tables from which the $TCA has been loaded;
fix bug where queries with tabl
Download
0.3.0 / beta
July 17, 2009
Add all new methods of t3lib_DB from TYPO3 4.3 (Thanks to Franz Holzinger)
Download
0.2.2 / beta
February 09, 2009
Added separator line to debug output for better readability.
Download
0.2.1 / beta
January 16, 2009
Thanks to Franz Holzinger:
* allow Disable mysql errormessages
* fix bug 8728
* fix bug not to show a PHP Warning
Download
0.2.0 / beta
November 27, 2008
See changelog:
* fill in debug_backtrace always when BTRACE_SQL has been set
* use microtime(true); instead of time() to get the time in microseconds
* enter and display time in miliseconds
* do the time measurements always
* new feature OUTPUT: make
Download
0.1.102 / alpha
February 13, 2007
Bugfix: Now Works with Typo3 3.8x also.
Download
0.1.101 / alpha
February 02, 2007

Download
0.1.100 / alpha
January 17, 2007
First TER Upload. exec_SELECTgetRows() and sql_fetch...() dont debug yet.
Download