Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • Error updating to 1.9.1

    Posted by Bibo

    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

    Reads: 1514
    Posted by Damian Parker

    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.netQuestion

    Posted by Gary Cunningham-Lee

    > 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

    Posted by Bibo

    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

    Posted by Bibo

    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