Database error: (ID# 15-0)

[jah007]

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]

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]

[jester805]

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

Thanks

[astrouga]

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

[jester805]

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

[astrouga]

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

[jester805]

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

Thanks for your help.

[jester805]

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

[astrouga]

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

–astrouga

[Martin Tinajero]

[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