• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Problems copying table with phpMyAdmin

B

BigScreen

Guest
I am encountering a problem when trying to copy a table using phpMyAdmin.

The error message reads:

#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 '8322882DEFAULT CHARSET =

The offending part of the command is:

) ENGINE = MYISAM AUTO_INCREMENT = 8322882DEFAULT CHARSET = utf8

There is no space between the AUTO_INCREMENT value and the "DEFAULT CHARSET" parameter. This is without the "Add AUTO_INCREMENT value" checkbox checked. If I check it and re-run the operation, it just adds the "AUTO_INCREMENT =8322882" text onto the end of the command, basically repeating the text before it that is causing the problem.

This appears to be the same problem reported here:
http://forum.swsoft.com/showthread.php?t=40819

I upgraded to Plesk 8.3 in the hopes that this would be fixed, but it was not. The above error report was submitted 13 months ago for Plesk 8.1, so it's surprising that it wasn't fixed since that time.

My installation is Plesk 8.3 for Linux, phpMyAdmin 2.8.2.4 (current stable release is 2.11.5), PHP 5.2.5, and MySQL 5.0.51a.

This error makes it very difficult to make test copies of tables for development or backup snapshots of tables. I am doing a workaround by copying the table manually with an SQL command, but that's not the point of having a web-based package like phpMyAdmin in the first place.

Any information about the status of this problem would be greatly appreciated!
 
Please try upgrade phpmyadmin it is located here. just copied files
/usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/

But before create backup file of phpMyAdmin
 
Back
Top