Architecture / Installation

Posted by Lex 29 Jul 2005 10:46 GMT-0000 posts: 41

> Hi, I was trying to upgrade 1.8.5. to 1.9.0, but I have only ftp access to the site. For the upgrade, I didn't find info for ftp-only users. Anyway, I went ahead, copied the files, tried to upgrade the database by logging into phpMyAdmin and put the file tiki_1.8to1.9.sql into the query field.
>
> I got errors, that first changed once or twice and than remained the same:
>
> #1060 - Duplicate column name 'name'

I forgot to say, on the upgrade 1.8 to 1.9 page, I read this:

Upgrade scripts are located in the "db" subdirectory and are run with this mysql command: mysql -f -u dbuser -p tikidb < tiki_1.8to1.9.sql
where "dbuser" is the name of a mysql user with sufficient privs in the tiki db to modify that table structures and data rows (probably root), and "tikidb" is the name of your tiki database. The -p is only needed if you have a password on the database (which is highly recommended). The -f is required to force all the updates to occur. You can safely ignore any errors, but if the script aborts (as it would without the -f), then your database will be missing part of the update.

Now, i don't know how to do this. I've copied the text from the tiki_1.8to1.9.sql file into the query window and sent it off to phpMyAdmin. But I don´t see a possibility to do something with the -f. So the problem might be something as simple (I hope) as this -f.

Anyone an idea what to do? Or should i send an email to my hosting company and ask them to do something. They normally help quite a bit when asked...

Lex

Posted by Damian Parker 30 Jul 2005 07:33 GMT-0000 posts: 2881

Hi Lex

after the FTP upload, just goto the tiki-install.php. login with the admin password and then choose the tiki_1.8to1.9.sql upgrade from the bottom section of the page.

I do trust you have taken full backups before you started ?

Damian
http://free.tiki.at.tikihost.net

Posted by mrrafs 08 Aug 2005 17:21 GMT-0000 posts: 34

>I was trying to upgrade 1.8.5. to 1.9.0, but I have only ftp access to the site.

i'm in the same situation.. my result was that after doing the update i got a whole lot of 'Print operations failed' and now my wiki is a white blank... ideas please?

Print operations failed - random snippits

Command: # $Header: /cvsroot/tikiwiki/tiki/db/tiki_1.8to1.9.sql,v 1.79.2.154 2005/08/04 22:16:06 franck Exp $

1. The following script will update a tiki database from verion 1.8 to 1.9
3. To execute this file do the following:
4. snip
5. added on 2005-02-01 by kyori (new features for Galaxia Workflow)

ALTER TABLE galaxia_instances ADD name varchar(200) default 'No Name' NOT NULL AFTER started
Message: Duplicate column name 'name'

Command: ALTER TABLE galaxia_activities ADD expirationTime int(6) unsigned default 0
Message: Duplicate column name 'expirationTime'

snip

Command: # added on 2004-01-16 by damosoft: new marking a blog entry as private
ALTER TABLE `tiki_blog_posts` ADD `priv` VARCHAR( 1 )
Message: Duplicate column name 'priv'

Command: # added on 2004-01-22 by mose, changing trackers options
CREATE TABLE tiki_tracker_options (
trackerId int(12) NOT NULL default '0',
name varchar(80) NOT NULL default '',
value text default NULL,
PRIMARY KEY (trackerId,name(30))
) TYPE=MyISAM
Message: Table 'tiki_tracker_options' already exists

snip

Command: # Added on 29 Jan 2004 by Swillie, to hold choice for displaying user avatar on post heading
ALTER TABLE `tiki_blogs` ADD `show_avatar` char(1) default NULL
Message: Duplicate column name 'show_avatar'
snip

rafs