• We value your experience with Plesk during 2024
    Plesk strives to perform even better in 2025. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2024.
    Please take this short survey:

    https://pt-research.typeform.com/to/AmZvSXkx
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

bug Mysql5 and phpmyadmin 2.8.2.4 urgent release required !

F

fgossart

Guest
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.
 
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.
 
I finally success patching plesk phpmyadmin
and all is OK now.
I will try to post you the phpmyadmin source code
 
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.
 
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
 
Back
Top