Loading...
 
Architecture / Installation

Architecture / Installation


Error updating to 1.9.1

posts: 5

Hi,

the SQL-script creates the following error message:

  1. 2005-06-20 amette: added on request of toggg(currently without CVS-access)

ALTER TABLE `tiki_pages` ADD created int( 14 )

  1. 1060 - Duplicate column name 'created'


What is to do?

Regards

Dirk

posts: 2881 United Kingdom

They are normal, ignore all errors generated through tiki-install.php when running the 1.8to1.9 upgrade

If you are using the mysql command line use the -f parameter,

You cannot use phpMyAdmin to upgrade the database.

UpgradeTo19

Damian
http://tikihost.net

posts: 4656 Japan

> They are normal, ignore all errors generated through tiki-install.php when running the 1.8to1.9 upgrade
>
> If you are using the mysql command line use the -f parameter,
>
> You cannot use phpMyAdmin to upgrade the database.

Actually you can use phpMyAdmin, but you sort of have to do it "by hand." phpMyAdmin will stop at the first error in the upgrade file. What I do is, rather than pointing to the upgrade file to run it all at once, I submit a section of the update file at a time (or even just a few lines at a time), copying and pasting the lines into phpHyAdmin's SQL query textarea. If there's an error in that submitted section, the statements up to the one with the error will have been run, but none after the error. So I resubmit the lines with those up to and including the error-causing statement deleted. This is pretty labor intensive and time-consuming, but does get the job done for people who only have phpMyAdmin access to their database.

-- Gary

posts: 5

Hi,

> Actually you can use phpMyAdmin, but you sort of have to do it "by hand." phpMyAdmin will stop at the first error in the upgrade file. What I do is, rather than pointing to the upgrade file to run it all at once, I submit a section of the update file at a time (or even just a few lines at a time), copying and pasting the lines into phpHyAdmin's SQL query textarea. If there's an error in that submitted section, the statements up to the one with the error will have been run, but none after the error. So I resubmit the lines with those up to and including the error-causing statement deleted. This is pretty labor intensive and time-consuming, but does get the job done for people who only have phpMyAdmin access to their database.

This could bealengthy process.

I think, I will try the update locally and modify the skript, so that now errors will occur.

Thanks

Dirk

posts: 5

Hi,

> They are normal, ignore all errors generated through tiki-install.php when running the 1.8to1.9 upgrade

that's good to know.

In my opinion, errors cannot be normal. Why does the script contain lines with errors?

> You cannot use phpMyAdmin to upgrade the database.

And what should people without direct access to rhe database do?

Thanks for your advise.

Dirk


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