When trying to use the table copy operation in Plesk DBWebAdmin and error is received due to no space between the auto increment and default charset keywords. The following patch can be manually applied to:
/usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/sqlparser.lib.php
to fix the problem.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
--- trunk/phpMyAdmin/libraries/sqlparser.lib.php 2006/03/28 11:37:55 8834 +++ trunk/phpMyAdmin/libraries/sqlparser.lib.php 2006/07/30 11:21:59 9205 @@ -2093,6 +2093,12 @@ $after .= ' '; } // workaround for + // AUTO_INCREMENT = 31DEFAULT_CHARSET = utf-8 + + if ($typearr[2] == 'alpha_columnAttrib' && $typearr[3] == 'alpha_reservedWord') { + $before .= ' '; + } + // workaround for // select * from mysql.user where binary user="root" // binary is marked as alpha_columnAttrib // but should be marked as a reserved word |