• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Database error: (ID# 15-0)

    Scheduled Pinned Locked Moved
    FOG Problems
    5
    10
    4.1k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • J
      jah007
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • B
        Blackout Developer
        last edited by

        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.

        [url=“/_imported_xf_attachments/0/5_index.php?:”]index.php[/url]

        1 Reply Last reply Reply Quote 0
        • J
          jester805
          last edited by

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

          Thanks

          1 Reply Last reply Reply Quote 0
          • A
            astrouga
            last edited by

            Just curious, what is the ‘tasks’ table structure? In a terminal window, type:
            [code]
            sudo mysql -u root -p
            use fog;
            describe tasks;
            [/code]
            –astrouga

            1 Reply Last reply Reply Quote 0
            • J
              jester805
              last edited by

              [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]

              1 Reply Last reply Reply Quote 0
              • A
                astrouga
                last edited by

                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

                1 Reply Last reply Reply Quote 0
                • J
                  jester805
                  last edited by

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

                  Thanks for your help.

                  1 Reply Last reply Reply Quote 0
                  • J
                    jester805
                    last edited by

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

                    1 Reply Last reply Reply Quote 0
                    • A
                      astrouga
                      last edited by

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

                      –astrouga

                      1 Reply Last reply Reply Quote 0
                      • M
                        Martin Tinajero
                        last edited by

                        [quote=“Blackout, post: 217, member: 1”]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.[/quote]

                        this fix my problem thanks

                        1 Reply Last reply Reply Quote 0
                        • 1 / 1
                        • First post
                          Last post

                        224

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project