IPS 4.7 Beta 3 - Duplicate entry 'searchlog_exclude_groups' for key 'conf_key'

[aXenDev]

Hi,

When I upgrade my localhost from IPS 4.6.12.1 to IPS 4.7.0 Beta 3 I get the error:

Duplicate entry 'searchlog_exclude_groups' for key 'conf_key'

C:\xampp\htdocs\ipsdev\applications\core\setup\upg_107000\upgrade.php::59
INSERT INTO `core_sys_conf_settings` ( `conf_app`, `conf_key`, `conf_value` ) VALUES ( ?, ?, ? )

Edited May 24, 2022 by aXenDev

[Jim M]

I'm afraid, there is limited support for localhost installations. Is there an existing key with the same name in your database?

[aXenDev]

28 minutes ago, Jim M said:

Is there an existing key with the same name in your database?

Yes, can I delete this record?

Edited May 24, 2022 by aXenDev

[Stuart Silvester]

Do you have any upgrade related errors in the core_log table? Your error suggests that code ran more than once which shouldn't be possible.

[aXenDev]

10 minutes ago, Stuart Silvester said:

Do you have any upgrade related errors in the core_log table?

Yes

[aXenDev]

I restored backup and ran update again. Everything was fine.

Thanks for the help!

[Stuart Silvester]

I appreciate it may be too late now, but if you've still got a copy of that database can you export core_log to an SQL file and send it to me via PM?

[aXenDev]

Unfortunately no, after restoring the database, I deleted the database with these errors.

I didn't think about it :<

I'll remember it next time.

[Marc]

No problem. Glad to hear you got the upgrade through in any case