Loading...
 
Architecture / Installation

Architecture / Installation


DB error after upgrade 2.3 > 4.0

posts: 14

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?).

SQL errors during 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:

Erroro on fresh 4.0
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!

posts: 14

My hosts recommendation and TW's default are: MySQL 5: Datenbank Servername => 127.0.0.1:3307 which did work well for month in 2.3 but does not work in 4.0 (see above).

I tried with "localhost:3307" with the same result, trying with "localhost" w/o port in my local.php did cause an "SQLSTATE28000 1045 Access denied for user '1234'@'localhost' (using password: YES)" Error (password and username are correct, got no idea what it does try to connect to).



Upcoming Events

1) 
TikiFestParis2024
2)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  25 Jun 2024 16:00 GMT-0000
Data umbrella : Build Your First Database Web App with (open source) Tiki Trackers
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting