Re: Update 1.8.5 -> 1.9.0 problem
> 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