Now i run the latest Update with the Maintenance Tool and get the following error.
Code: Select all
ERROR 1064 (42000) at line 14: 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 'IF EXISTS lock$cust_ban_tbl;
ALTER TABLE prevent_table_drop DROP KEY IF EXISTS' at line 9
Error while executing /home/openemm/webapps/emm/WEB-INF/sql/mysql/emm-mysql-update-20.10.121-basic.sql
And i found the one possible explanation. I looked in the tables and the update script and found that one table name didnt match.
Name in database: cust1_ban_tbl
Name in script: lock$cust_ban_tbl
Here "viewtopic.php?f=2&t=6614&start=15#p17144" you provide an updated script but i didnt work either
I tried the script statements from line 9.
Line 9 and 10 both didnt work because there is no cust_ban_tbl, only cust1_ban_tbl, Line 12 runs fine and 13 tries also to alter cust_ban_tbl, which don't exists, because, why?
What are the changes in the script? Or do i have to rename the table?