Upgrade from 13.1 to 14.0 problems
Hi there.
I have numerous upgrade issues trying to go from 13.1 to 14.0
I have run the upgrade using tiki-install.php, this was successfull with only 2 errors:
CREATE TABLE `tiki_tabular_formats` ( `tabularId` INT NOT NULL PRIMARY KEY AUTO_INCREMENT, `trackerId` INT NOT NULL, `name` VARCHAR(30) NOT NULL, `format_descriptor` TEXT, KEY `tabular_tracker_ix` (`trackerId`) ) Table 'tiki_tabular_formats' already exists
and
ALTER TABLE `tiki_tabular_formats` ADD COLUMN `filter_descriptor` TEXT AFTER `format_descriptor` Duplicate column name 'filter_descriptor'
Regardless, I then continue to the site and it appears ok, apart from not having the correct css but everything is in place. When I click the menus, only home and reports work, the other things like articles, settings file galleries don't open when I click the menu.
I done a clean install, it works fine without my files in the folder so I imported my 13.1 database.
Now none of my modules are authorised, I have to go through and re authorise them, the menu no longer works, same issue, I click, nothing happens.
Then when I go into control panels this message appears
Database Version Problem Your database requires an update to match the current Tiki version. Please proceed to the installer. Using Tiki with an incorrect database version usually provokes errors. If you have shell (SSH) access, you can also use the following, on the command line, from the root of your Tiki installation: php console.php database:update
I run the upgrade again, but this message refuses to go away.
I then run the installer again, fresh database, my files in the htdocs folder, works fine, apart from the menus so I import individual tables to see which ones might be the issue. As you can guess this is a very very lengthy process and I am still not able to figure it out.
Has anyone else had this problem? And any suggestions as to how I can fix it without importing each table individually? which I somehow don't think will fix it.