bug Mysql5 and phpmyadmin 2.8.2.4 urgent release required !

[fgossart]

there is a incompatibility with recent 8.1 using mysql 5 engine.
now when I want to copy a table I have a error message
.....
) ENGINE = MYISAM AUTO_INCREMENT = 275DEFAULT CHARSET = latin1

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '275DEFAULT CHARSET = latin1' at line 45
....

it's urgent to have a phpmyadmin 2.9.2 upgrade to plesk.
I verify to a local server and there's no bug with this release.
Unless it is possible to upgrade myself phpmyadmin, but I don't find where is the config file.

 

[KirkM]

I have the same issue. The problem is it isn't putting a space between the auto increment value and the Default charset command. If I copy and paste the entire sql command into the SQL window and add the space between them, it works. I would like to know how to update PHPMyAdmin to the latest version without breaking Plesk so I can fully use it with MySQL 5.

 

[fgossart]

I finally success patching plesk phpmyadmin
and all is OK now.
I will try to post you the phpmyadmin source code

 

[KirkM]

That would be very much appreciated!

 

[DerFalk]

what about the source code?

 

[dopsmorts]

Patch code for php myadmin default charset error

Please, can u sent me the source code of patch or tell me what I needed to change in phpmyadmin to fix this problem.
Tks.

 

[KeeB]

Please share the solution

I am on Plesk 9.2.3 + Mysql5 and phpmyadmin 2.8.2.4 and have found the exact same problem. In fact it occurs with 'copy' as well as 'move' and is due to a missing space.
I would appreciate if you could tell us how you fixed the problem
Thx

 

[KirkM]

Best thing to do is upgrade phpmyadmin to the later version. It is pretty simple and it worked perfectly on 2 of my servers. One is running 32 bit and the other 64 bit.

Here are the instructions:

http://forum.parallels.com/showpost.php?p=391654&postcount=5