Loading...
 
Architecture / Installation

Architecture / Installation


Re: Update 1.8.5 -> 1.9.0 problem

posts: 41 Spain

> 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

There are no comments at this time.

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