Update to 0.9.2 failed - Duplicate column name

I downloaded the update to move from 0.9.1 to 0.9.2. I installed com_joobb and was presented with the UPDATE/RE-INSTALL screen. I clicked Update and then got:

Duplicate column name 'auto_subscription' SQL=ALTER TABLE `jos_joobb_users` ADD `auto_subscription` tinyint(1) NOT NULL default '0' AFTER `enable_emotions`;

Any ideas?

Re: Update to 0.9.2 failed - Duplicate column name

Martin,

I wish that I had a answer for you but I did not get that error. Were you definitely at version .9.1 before upgrading?

Jeff

Re: Update to 0.9.2 failed - Duplicate column name

Yes. I can PM you with Joomla admin access if you want to have a peek?

Re: Update to 0.9.2 failed - Duplicate column name

Martin,

Is what I meant was that I did not encounter that error? It appears from the error that it is attempting to add the "auto-subscription" field and it already exists.

I'm not sure of all the database changes as I did not compare the two ahead of time, but if they occurred for you and it's attempting to repeat them, that's where you error is coming in.

IF they are all in there, you could take the .sql portion of the install out of the xml install script and it may go in for you. Thats only IF all database changes already exist?

Did you revert back to a backup copy yet?

Re: Update to 0.9.2 failed - Duplicate column name

No, not yet. I will reinstall from a backup then try the update again and report back. Thanks.

Re: Update to 0.9.2 failed - Duplicate column name

I receive a following mistake at installation

Code

Column count doesn't match value count at row 1 SQL=INSERT INTO `jos_joobb_configs`...

Re: Update to 0.9.2 failed - Duplicate column name

I will have a look at all this when I'm at home.

There can be errors on clicking "update" twice. If so, nevermind, that's OK.

[Edit]

@Freedom
Sorry for removing the code. The syntax highlighter (new in 0.9.2) crashed. I got the code so I will check it out.

Kind regards,
Robbie

Re: Update to 0.9.2 failed - Duplicate column name

Freedom,

did you made an update or new install?

[Edit]
Can you check in your database the table #__joobb_configs? Please let me know if there is a field named "parse_settings". Thank you very much.

[Second Edit]

I got the problem. It's on a fresh install. I solved it. You may download and install again now.

Robbie