i am using D 4.7.6 and userpoints 2.1 and getting following error - unable to userpoints retroactive -

Column count doesn't match value count at row 1 query: INSERT INTO userpoints VALUES ('1', '-10', '1170591689') in /home/incom/public_html/art/includes/database.mysql.inc on line 121.

How i can replace this with userpoints 1.1 and what fields in database to delete for removing the above error. Please guide me

Comments

incom’s picture

I re-installed 2.1 and getting different error

   * user warning: Column count doesn't match value count at row 1 query: INSERT INTO userpoints VALUES (1, 0, 1170598239) in /home/incom/public_html/art/includes/database.mysql.inc on line 121.
    * user warning: Column count doesn't match value count at row 1 query: INSERT INTO userpoints VALUES (2, 0, 1170598239) in /home/incom/public_html/art/includes/database.mysql.inc on line 121.
    * user warning: Column count doesn't match value count at row 1 query: INSERT INTO userpoints VALUES (3, 0, 1170598239) in /home/incom/public_html/art/includes/database.mysql.inc on line 121.
kbahey’s picture

Title: Error in Userpoints » Incorrect number of columns in userpoints_retroactive
Status: Active » Fixed

Fixed in 4.7.x-dev. Wait for 8 hours and then download the tar ball.

Anonymous’s picture

Status: Fixed » Closed (fixed)