The error message "Unknown column 'generation_expression' in 'field list' (1054)" suggests that the database structure is not compatible with the operation you're trying to perform in Plesk, possibly due to differences in MySQL versions or table definitions.

To address this issue, you can try the following steps:

1. Update MySQL Server:

   • Ensure that your MySQL server is up-to-date. If you're using an older version of MySQL, consider upgrading to a newer version that is supported by Plesk.

2. Check Database Compatibility:

   • Verify that the database and its tables are compatible with the MySQL version installed on your server. Some features or syntax might not be supported in older versions.

3. Check Table Definitions:

   • Review the structure of the affected table(s) to ensure they are correctly defined. Pay special attention to any columns with generation expressions, as this might be related to the error.

4. Try a Different Dump Method:

   • Instead of using the Plesk interface, you might attempt to create a database dump using the command-line tools (e.g., mysqldump). This can bypass any potential issues related to Plesk's interface.

   Example:

   bashCopy code

   mysqldump -u username -p database_name > dump.sql

5. Check for MySQL Compatibility Mode:

   • If you've recently upgraded MySQL, ensure that it's not running in a compatibility mode that emulates an older version. This can sometimes cause compatibility issues.

6. Repair or Optimize Tables:

   • Use MySQL tools like mysqlcheck to check and repair any potentially corrupted tables. Additionally, you can try optimizing the tables.

   Example:

   bashCopy code

   mysqlcheck -u username -p --auto-repair --check --optimize database_name

7. Check for MySQL Extensions:

   • If you have custom MySQL extensions or plugins installed, ensure they are compatible with the MySQL version you're using.

8. Contact Plesk Support:

   • If the issue persists, it's recommended to reach out to Plesk support for further assistance. They can provide specific guidance based on your server's configuration and the nature of the error.

Remember to always back up your database before making significant changes or repairs to ensure you can revert to a stable state if needed.