Alter table gos wrong

[chriske]

Hello,

Something has failed in the last cacti upgrade:

ALTER TABLE host_snmp_cache MODIFY COLUMN snmp_index VARCHAR(255) NOT NULL default "" [Fail]

Now i am only getting the following message if i want to retry to upgrade:

Cacti Server v1.2.10 - Installation Wizard
Error
Your Cacti Server v1.2.10 has been installed/updated with errors

Process Log
--- NO LOG FOUND ---

If i try to run the SQL querie that failed:

mysql> ALTER TABLE host_snmp_cache MODIFY COLUMN snmp_index VARCHAR(255) NOT NULL default "";
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
mysql>

[Osiris]

You have to modify you server.cnf:

innodb_file_pertable = on
innodb_large_prefix = 1
Innodb_file_firmat = Barracuda

Restart MariaDB, then run:

php -q convert_tables.php --dynamic --innodb

[chriske]

I did everything but when i open cacti im still getting:

Error
Your Cacti Server v1.2.10 has been installed/updated with errors

Process Log
--- NO LOG FOUND ---

[Osiris]

Go into MySQL and run this command, then start again.

DELETE FROM settings WHERE name LIKE "install%";