Database error: (ID# 15-0)



  • I have a new install on Ubuntu server 11.10 and get an error when clicking on the button "Install/Upgrade Now"
    The webpage says that "Your database schema is not up to date, …
    The error is
    Database error: (ID# 15-0)
    Database Error:
    Duplicate column name ‘taskBPM’

    I have killed off the fog database and reinstalled but no success. I am approaching to reinstall the server from scratch, but all is working expect for that.
    BTH it is Ubuntu 11.10 32bit.

    Thanks,
    jah007



  • @Blackout, post: 217, member: 1 said:

    It looks like you might already be updated, or maybe in an in between state.

    The Schema updater has been updated in 0.33 allowing it to continue if it encounters an error like this.

    I have hacked the 0.32 schema updater to allow it to continue even if there are errors. It will then display all errors at the end.

    Please replace ‘commons/schemaupdater/index.php’ with the attached file.

    this fix my problem thanks



  • Cool. I was just going to recommend that. I just installed .32 on a 11.10 system and did not have any issues.

    –astrouga



  • I deleted the database and re-ran the fog setup. I got past that error now.



  • This is Ubuntu 11.10 32-bit. It is a new install of FOG.

    Thanks for your help.



  • Hmm. Which version of ubuntu? Was this a new install, or is it an upgrade of an existing server? If this is an upgrade, did you backup your database before you upgraded? You could always restore the old db and run the updater again.

    –astrouga



  • [INDENT=1]mysql> describe tasks;[/INDENT]
    [INDENT=1]±-----------------------±--------------------------±-----±----±--------±---------------+[/INDENT]
    [INDENT=1]| Field | Type | Null | Key | Default | Extra |[/INDENT]
    [INDENT=1]±-----------------------±--------------------------±-----±----±--------±---------------+[/INDENT]
    [INDENT=1]| taskID | int(11) | NO | PRI | NULL | auto_increment |[/INDENT]
    [INDENT=1]| taskName | varchar(250) | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskCreateTime | datetime | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskCheckIn | datetime | NO | MUL | NULL | |[/INDENT]
    [INDENT=1]| taskHostID | int(11) | NO | MUL | NULL | |[/INDENT]
    [INDENT=1]| taskState | int(11) | NO | MUL | NULL | |[/INDENT]
    [INDENT=1]| taskCreateBy | varchar(200) | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskForce | varchar(1) | NO | MUL | NULL | |[/INDENT]
    [INDENT=1]| taskScheduledStartTime | datetime | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskType | varchar(1) | NO | MUL | NULL | |[/INDENT]
    [INDENT=1]| taskPCT | int(10) unsigned zerofill | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskBPM | varchar(250) | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskTimeElapsed | varchar(250) | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskTimeRemaining | varchar(250) | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskDataCopied | varchar(250) | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskPercentText | varchar(250) | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskDataTotal | varchar(250) | NO | | NULL | |[/INDENT]
    [INDENT=1]| taskNFSGroupID | int(11) | NO | MUL | NULL | |[/INDENT]
    [INDENT=1]| taskNFSMemberID | int(11) | NO | MUL | NULL | |[/INDENT]
    [INDENT=1]| taskNFSFailures | char(1) | NO | MUL | NULL | |[/INDENT]
    [INDENT=1]| taskLastMemberID | int(11) | NO | MUL | NULL | |[/INDENT]
    [INDENT=1]±-----------------------±--------------------------±-----±----±--------±---------------+[/INDENT]
    [INDENT=1]21 rows in set (0.00 sec)[/INDENT]
    [INDENT=1] [/INDENT]
    [INDENT=1]mysql>[/INDENT]



  • Just curious, what is the ‘tasks’ table structure? In a terminal window, type:

    
    sudo mysql -u root -p
    use fog;
    describe tasks;
    
    

    –astrouga



  • Blackout,
    I tried doing what you said, but I still get the same error as jah007. Any other ideas?

    Thanks


  • Developer

    It looks like you might already be updated, or maybe in an in between state.

    The Schema updater has been updated in 0.33 allowing it to continue if it encounters an error like this.

    I have hacked the 0.32 schema updater to allow it to continue even if there are errors. It will then display all errors at the end.

    Please replace ‘commons/schemaupdater/index.php’ with the attached file.

    index.php


Log in to reply
 

408
Online

38746
Users

10569
Topics

100054
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.