Is this SQL error critical ?

[MikeChoy]

I have one SQL error which alway appears during upgrading/testing of version1.4 hopefully someone can enlighten me if this is critical or can be ignored

INSERT INTO `xx_hook_module` (`id_module`, `id_hook`, `position`) VALUES (23, 9, (SELECT max_position from (SELECT MAX(position)+1 as max_position FROM `xx_hook_module` WHERE `id_hook` = 9) tmp))

(1062) Duplicate entry '23-9' for key 'PRIMARY'

Thanks in advance

[rocky]

It seems you have a duplicate entry in your ps_hook_module table. Check whether there are two rows with id_module 23 and id_hook 9. If there is, delete one of them.

[MikeChoy]

I have checked the database before upgrading and there is only one instance of id_module 23 and id_hook 9 in ps_hook_module table. After upgrading - that is with the error message, checked again....also one entry

[MikeChoy]

Is this critical...can I ignore this SQL error?

Thks

[rocky]

I think so. At worst, you may have a module missing from a hook.