phpMyAdmin Version information: 3.5.2
Server: RHEL 5
When directly editing a row via the edit page (AJAX disabled), I am unable to update a DATE column by selecting "CURRENT_DATE" from the functions drop down list. The issue is that if there is already a value in the field the SQL query is sent as:
> UPDATE `table` SET `date` = CURRENT_DATE( '2012-08-17' ) WHERE `id` = 1
If I attempt to update with no value in the DATE column the SQL query will be as follows:
> UPDATE `table` SET `date` = CURRENT_DATE( '' ) WHERE `id` = 1
Which also fails because CURRENT_DATE( '' ) is not proper MySQL syntax.
In phpMyAdmin 2.* under MySQL 4.1.22 this was not an issue, phpMyAdmin would send CURDATE() regardless of the value in the input field for the DATE column.