Upgrade error - Duplicate column name 'prompt'

[Thomas P]

Hi

upgrading our dev forums from 4.4.3 to 4.4.6 (latest) shows the following error after the process:

Error (1060) Duplicate column name 'prompt': addColumn ["core_oauth_authorize_prompts",{"name":"prompt","type":"TEXT","length":null,"decimals":null,"values":null,"allow_null":true,"default":null,"comment":"","unsigned":false,"zerofill":false,"auto_increment":false,"binary":false}]

 

Anyone experienced the same when looking at the ACP System Logs after upgrade?

Thanks,
Thomas

 

[sound]

yep have seen this on two sites that have just updated,  all seems ok though ?

[bfarber]

You can safely ignore things like that, but thanks for pointing it out - I'll make sure it gets fixed.

The error simply means the upgrader tried to add a column, but it was already present - since it's present, you're fine.

[Thomas P]

Thanks for your clarification, glad to read.

I was aware what the error implies, just was confused how a newly introduced column already existed in an older version.
Since there can be different reasons to produce such an error I asked.

[bfarber]

The query to add it was missing from a previous release, it was added, and then the query to add the column was duplicated into the latest release. Looks like a build system artifact along the way, but either way, nothing to worry about and it's sorted for a future maintenance release now.