[Koha-bugs] [Bug 7184] have mysql returning errors

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7184

--- Comment #2 from Paul Poulain <paul.poulain at biblibre.com> 2011-11-06 08:37:32 UTC ---
Created attachment 6238
  --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6238
Bug 7184 raise mySQL error if debug is set

Before this patch, if a mySQL occured in Koha (any error), then the user was
seeing nothing.
With this patch, if DEBUG is set in Koha VirtualHost, any mySQL error will make
Koha die and display the SQL error

Step to test:
=== BEFORE PATCH ===
go anywhere, and change a mySQL statement to make it invalid.
Launch a page using the SQL you've made wrong, you'll see nothing, except you
won't see the expected results

=== AFTER PATCH ===
Modify koha-httpd.conf, and add the following line, in the virtualhost (if it
does not already exist)
SetEnv DEBUG 1
restart/reload Apache
Launch the same page, you'll get a Perl statement saying something like:

DBD::mysql::st execute failed: <<blablabla SQL error>> at <<where the error was
raised line <<error line>>

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.