16 August, 2010 (19:48) | PHP, Web Development, debug, mysql | By: Pablo Viquez
You can do profiling on PHP using XDebug or Zend Debugger ad both works beautifully, however what about MySQL? Can you do something similar? The response is yes you can. Now the best part is that you can take advantage of the tools MySQL give you, if you want to take the profiler to a [...]
Tags: mysql, PHP
Comments: 7
25 November, 2009 (16:23) | PHP, debug, tech | By: Pablo Viquez
I wanted to enable logging of exceptions to my PHP log file and also display them using FireBug. On a standard setup of Zend Framework, the Zend error handler plugin (Zend_Controller_Plugin_ErrorHandler) enable by default and it was designed for: Errors due to missing controllers or actions Errors occurring within action controllers I wanted to keep [...]
Tags: debug, firebug, firephp, PHP, Zend Framework
Comments: 8
17 July, 2009 (13:51) | PHP, Web Development, debug, iso 8859-1, utf-8 | By: Pablo Viquez
Download the demo files While I was looking at some AJAX calls, I started to have a problem, for some reason, when I tried to query a JSON service I did using JQuery, the result was null for some fields. Going a little deeper, I notice that the records from the DB were OK, and [...]
Tags: ajax, i18n, iso 8859-1, jquery, json, json_encode, PHP, utf-8
Comments: 2
14 June, 2009 (19:22) | PHP, Web Development, debug, errors | By: Pablo Viquez
After a while struggling with the php function set_include_path() on windows, became to my attention that using the windows registry to set php configuration values they are set using the php_admin_value which forbids overriding it on run time. So for example, if you set the include_path on the windows registry and then you call the [...]
Tags: debug, PHP, set_include_path, windows registry
Comments: -
14 June, 2009 (15:36) | General, PHP, debug, errors | By: Pablo Viquez
Instalé Zend Server en mi computadora ya que estoy probando y comparando XDebug y Zend Server. (Ver Instalación de XDebug) La instalación realmente fue sencilla y me quedo funcionando de maravilla. Lo único que noté es que Zend Server no instala a PHP como un módulo sino como CGI. Esto hace que si creo un [...]
Tags: .htaccess, 500 error, internal server error, zend server
Comments: 5
13 June, 2009 (02:09) | PHP, Web Development, debug, training | By: Pablo Viquez
Este tutorial enseña como ejecutar un script PHP paso a paso haciendo su depuración más sencilla y fácil. Tambien muestra paso a paso como instalar Eclipse PDT y configurarlo para usar XDebug. Este mismo tutorial esta disponible para descargar, haga click aquí Que necesita: Eclipse PDT http://www.eclipse.org/pdt/downloads/ Extensión de XDebug http://xdebug.org/files/php_xdebug-2.0.4-5.2.8.dll Para este tutorial, se [...]
Tags: debug, eclipse, ejecutar paso a paso, xdebug
Comments: 6
14 May, 2009 (22:42) | General, debug, errors, mysql | By: Pablo Viquez
Estaba haciendo unos procedimientos almacenados en MySQL 5 y cuando estaba hanciedo pruebas, me comenzó a dar este error: Script line: 73 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation ‘=’ Buscando donde estaba el error, me di cuenta que el procedimiento almacenado que estaba probando utiliza un cursor comparando un String de parametro [...]
Tags: collations, iso 8859-1, latin1, mysql, utf-8
Comments: 1