Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • Persistent "Database Version Problem" even though update completed

    Posted by Mike Blyth
    I just upgraded from version 5.2 to 7.0 without any problems except that now on the Administrator Home page there is the "Database Version Problem" message telling me to use the installer. I ran the installer a second time but still get the error. I checked that the database collation is UTF-8. So far, in a quick run-through, I haven't seen any problem with the site. How can I fix this? Does it matter?
    Reads: 2277
    Posted by George Greene

    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.