Loading...
 
Architecture / Installation

Architecture / Installation


Alternative database upgrade 1.8>1.9?

posts: 19 Germany

Hi all,

I would like to upgrade my Tiki 1.8.3 to 1.9.5.
Unfortunately, I run Tiki on a hosting environment where I can't use the "mysql -f tiki_1.8to1.9.sql" command.
The hosting provider only allows database admin through PhpMyAdmin.
If I import the upgrade file using PhpMyAdmin, I get error messages in virtually every line of the upgrade script.

I'm not a mysql expert; is there any way I can modify the database upgrade script so it can run through to the end?
I already replace all "ALTER TABLE" statements with "ALTER IGNORE TABLE", and all "INSERT INTO" with "INSERT IGNORE INTO", but still the script does not run through.

Any tips would be greatly appreciated.

Regards,
Christian
www.eidolons-inn.net
www.worldofmule.net

posts: 9309 Germany

Use tiki-install.php. There you can run the update script.

It will throw some errors, sure. But only for all the changes between 1.8.0 and 1.8.3, which you already have as you started with 1.8.3. Just ignore the error messages.


posts: 19 Germany
Thanks! That worked. biggrin

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
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