I got an error when upgrading. Error given is Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'superfish_itemcount_1' for key 'PRIMARY': UPDATE {variable} SET name = REPLACE(name, :old, :new) WHERE name LIKE :name; Array ( [:old] => count [:new] => itemcount [:name] => superfish_count_% ) in superfish_update_7100() (line 53 of /etc/drupal/7/sites/all/modules/superfish/superfish.install).

Comments

edg’s picture

edg commented
Version: 7.x-1.8 » 6.x-1.8

Using the Variable Check module I found 2 invalid variable entries in Superfish:

superfish_arrow_1 s:4:"1";
superfish_shadow_1 s:4:"1";

Probably explains this error message when trying to upgrade from Drupal 6.20 to 7:

Notice: unserialize() [function.unserialize]: Error at offset 2 of 8 bytes in variable_initialize() (line 749 of /includes/bootstrap.inc).
    
Notice: unserialize() [function.unserialize]: Error at offset 2 of 8 bytes in variable_initialize() (line 749 of /includes/bootstrap.inc).

Update: I thought I was using version 6.x-1.8 but checking again I see that it's 6.x-1.6, so this may have been fixed in later version...

mehrpadin’s picture

mehrpadin commented
Status: Active » Fixed

Hey there,

Fixed as of v1.9-beta3 :) thank you both.

Automatically closed -- issue fixed for 2 weeks with no activity.