DB error after upgrade 2.3 > 4.0
Hi there!
I did an "install over existing files" update, as instructed on the website. I Ran the installation, skipped some steps (used the green arrow for "upgrade". I got the following 6 SQL errors (which might be normal because it's an upgrade?).
Copy to clipboard
#sylvieg 2008-10-29 ALTER TABLE `tiki_tracker_items` ADD index `trackerId` (`trackerId`) Duplicate key name 'trackerId' ALTER TABLE `tiki_tracker_fields` ADD index `trackerId` (`trackerId`) Duplicate key name 'trackerId' ALTER TABLE `tiki_tracker_item_attachments` ADD index `itemId` (`itemId`); Duplicate key name 'itemId' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Search','tiki-searchindex.php',13,'feature_search','tiki_p_search','',0) Duplicate entry '42-Search-tiki-searchindex.php-13-feature_search-tiki_p_search-' for key 2 -- 2009-09-18 lphuberdeau ALTER TABLE `tiki_transitions` ADD COLUMN guards TEXT NOT NULL DEFAULT '[]' BLOB/TEXT column 'guards' can't have a default value UPDATE `users_objectpermissions` SET `permName`=? WHERE `permName`=? Duplicate entry '8ea543dc59b0ac91dc0b133e9bf889e4-category-Registered-tiki_p_view' for key 1
I locked the installer and wanted to have a look, if my site is running. Locking worked (lock file exists), but I get an error:
Copy to clipboard
System error. The following error message was returned: SQLSTATE[HY000] [2005] Unknown MySQL server host '127.0.0.1:3307' (3)
Comparing the old and nwe local.php (I thought it to be a problem with this file), the only thing changed was the $dbversion_tiki field. Everything was running smoothly with those settings.
Please help!