1.0.5 => 1.1 RC 1 : Creating and verifying "permissions"... Unsuccessful

[guytoon]

Hi,

I'm trying to upgrade from 1.0.5 to 1.1 RC1 in english and I got the following message :

Updating Settings.php... Successful.
Creating new tables and inserting default data...
    Creating "themes"... done.
    Creating "collapsed_categories"... done.
    Creating and verifying "permissions"... Unsuccessful!

This query:
ALTER TABLE yabbse_permissions
ADD addDeny tinyint(4) NOT NULL default '1';
Caused the error:
Nom du champ 'addDeny' déjà utilisé

Last sentence which only means "Field's name 'adddeny' already exists" is in french becaus my db is in french.
Actually that's true, this field exist !
Does anyone got an idea.
My forum was a long time ago under yabsse then SMF 1.0.1 then 1.0.2,1.0.3,1.0.4  and at the moment 1.0.5

Thank you so much for your kind support.

[Ben_S]

Odd,

Try editing upgrade1.0.sql and remove the line

ADD addDeny tinyint(4) NOT NULL default '1';

[wismerhill]

I have the same problem and i have lot's of this kind of error.
I edited the upgrade1.0.sql and remove all the line which cause problem but they are lots of.

Are you sure that we have to run upgrade.php if we have smf a 1.0.5 version ?

[Oldiesmann]

Yes, you have to run upgrade.php if you want to go from 1.0.5 to 1.1 because there have been numerous database changes.

[guytoon]

I also edited upgrade1.0.sql to remove unused queries but some of them are really more complicated than simple update of the schema. By removing them and I'm not sure of what I'm doing.

Did eveybody add the same issue or are we only few of us ? To me it's not really an update program since it includes modification of really old schemas not only the latest  .

[Oldiesmann]

I understand. I've given Compuart a modified upgrade_1-0.sql file that takes care of that, so hopefully it'll be added to the package soon.

[guytoon]

Thank you so much.

Would it be possible to get it available or to send it to me by email ?

[Oldiesmann]

Here you go

[guytoon]

Once again thank you, I'll test this evening and keep you informed.

[Compuart]

I understand. I've given Compuart a modified upgrade_1-0.sql file that takes care of that, so hopefully it'll be added to the package soon.

It's not the .sql but the upgrade.php that was causing the problems. Try the attached file, it should solve the problems.

[Oldiesmann]

It was? I looked through there and didn't find anything that would be causing that issue...

[Compuart]

It's not a problem that the query is returning an error, but it's a problem the error is actually shown and that it stops the upgrader. The detection of errors has been updated to also work with non-english databases.

[Oldiesmann]

Ah. I didn't realize there was already error detection in there.