After upgrading from pma 3.5 to 4.0 some sql queries do not work anymore.
I am using pma on a freebsd 9.1 machine with an up to date portstree, mysql 5.5, apache 2.2 and php 5.4. The apache server has been completely restarted and browser cache was emptied after the upgrade.
On certain queries there is just no result.
To reproduce this, you can create a table with the sql statements from attachment sql-create-table.txt
When doing a simple search query like
SELECT * FROM
the result looks like screenshot-working.png and everything is fine.
But if I call this query
SELECT * FROM
Callsign LIKE 'GA%'
it won't work and I get an output like in screenshot-defective.png. This appears right after submitting the search form when I just use 'GA%' as search pattern for the
There is no error message or anything else giving me at least a hint on how to troubleshoot this. It always seems to be broken as soon as I search for anything in the
I did some debugging with Firebug. I have attached a working AJAX communication in ajax-post-working.txt and ajax-reply-working.txt. In contrast ajax-post-defect.txt and ajax-reply-defect.txt are broken. However I cannot see any big difference in those two requests.
If I can provide you any further details or information in case you cannot reproduce this, please let me know.