Architecture / Installation

Posted by George Greene 14 Jul 2011 14:13 GMT-0000 posts: 257

I've been getting the same message through about three or four Tiki version upgrades. Each time I then do the database upgrade and the notice never goes away. Each time I also get error messages and have no idea if they are benign or Catastrophic:

''Operations failed: 2 SQL queries. Display details.

During an upgrade, it is normal to have SQL failures resulting with Table already exists messages.

20110609_missing_sql_tiki

ALTER TABLE `tiki_sefurl_regex_out` ADD UNIQUE `left` (`left`(128))
Duplicate key name 'left'

ALTER TABLE `tiki_polls` ADD `anonym` ENUM( 'a', 'u', 'i', 'c' ) NOT NULL DEFAULT 'u'
Duplicate column name 'anonym' ''

That missing-SQL-Tiki sound pretty dang ominous, doesn't it?!

I did the database upgrade again, this time choosing to ignore the 20110609_missing_sql_tiki. It proceeded farther into the install. Got to "enter Tiki and lock installer". Now I'm not getting the database version warning!

Who knows if ignoring the ...missing sql.. thing will cause me grief.