#3009 (ok 3.3.3) Data too long for column 'data_sql'
When using SQL option under PMA version 3.3.0 and 3.3.1, I get this error when doing the query:
--------------------------------------------------------------------------------------
Error
SQL query:
/*NOTRACK*/ UPDATE `phpmyadmin`.`pma_tracking` SET `data_sql` = CONCAT( `data_sql` , ' # log 2010-03-23 18:40:50 MainUser DELETE FROM `Variables` WHERE Folder=''WebYajaira/SiteMiscellanea'' AND Type=''Pantalla'' AND Name=''PhotoCommentStart.php''; ' ) ,
`date_updated` = '2010-03-23 18:40:50' WHERE FIND_IN_SET( 'DELETE', tracking ) >0 AND `db_name` = 'basic_data' AND `table_name` = 'Variables' AND `version` = '1'
MySQL said:
#1406 - Data too long for column 'data_sql' at row 1
--------------------------------------------------------------------------------------
If I use the IMPORT option, the problem does NOT arise.
If I use the SQL option under version 2.9.11.3, the problem LOGICALLY does not occur, the tracking option was not enabled in said version
If you need the table and query in use, please contact me to upload a file with the query and the table definition.
Discussion
Carlos,
if you modify the phpmyadmin.pma_tracking table by changing the data_sql column's type from text to longtext, is the problem fixed?
I just tried the same query in version 3.3.2 and the error is gono without the need of changing the column's type.
Also I changed the column's type and tried in version 3.3.1, and the error did not occur.
I was able to reproduce the problem. Now in scripts/create_table.sql the data_sql field is a longtext.
For the moment, no workaround is planned for people who already have their pma_tracking table in place.