every time a point is added, either by a post, manual add, or retroactive, i get this in the watchdog:
Column count doesn't match value count at row 1 query: INSERT INTO userpoints VALUES (11086, 0, 1173590071) in /home/grownupg/public_html/includes/database.mysql.inc on line 121.

Points do not update past user #1

Comments

kbahey’s picture

kbahey commented
Status: Active » Closed (fixed)

You must be using the wrong version.

4.7.x-2.1 should never have this problem. If you check the top of the userpoints.module, it should have this:

//$Id: userpoints.module,v 1.30.2.18 2007/01/26 02:56:40 kbahey Exp $

And that version does an INSERT with 4 columns, not 3 as you see in your error message.

iedude@remote.insidetheie.com’s picture

iedude@remote.insidetheie.com commented
Status: Closed (fixed) » Postponed (maintainer needs more info)

thank you for the fast response..
I re-downloaded, removed and re-installed with this version (same as before):
//$Id: userpoints.module,v 1.30.2.18 2007/01/26 02:56:40 kbahey Exp $

However, i still get the same error:
Column count doesn't match value count at row 1 query: INSERT INTO userpoints VALUES (11098, 0, 1173630415) in /home/growupg/public_html/includes/database.mysql.inc on line 121.
with every userpoint update.

I did previously have 1.0 installed. before installing the newer version I deactivated the modules, removed the modules, dropped the userpoints table(s) and removed the userpoints rows from the System table..
Perhaps i missed a step?
otherwise there still appears to be a problem.

kbahey’s picture

kbahey commented

There is something wrong with your installation. Perhaps the old module is still somewhere, and is being used instead of the new one.

From mysql command line, or phpMyAdmin, execute the following SQL, and paste it here.

SELECT filename FROM system WHERE name = 'userpoints';

This will tell you if it is pointing to the correct directory or one that has old stuff in it.

iedude@remote.insidetheie.com’s picture

iedude@remote.insidetheie.com commented

Output:
modules/userpoints2/userpoints.module

it appears to be pointing in the right place (the only place)..
//$Id: userpoints.module,v 1.30.2.18 2007/01/26 02:56:40 kbahey Exp $

Did I take all the right steps in removing version 1.0 (listed in my previous post)?

kbahey’s picture

kbahey commented

Is there a way for me to get access to your system and see what is going on first hand? Preferrably ssh access would be best.

Use this form http://drupal.org/user/4063/contact.

kbahey’s picture

kbahey commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

This turned out to be a problem when doing userpoints retroactive, not userpoints itself.

The version on the site was:
// $Id: userpoints_retroactive.module,v 1.1.2.3 2007/01/13 09:16:51 kbahey Exp $

It should be:
// $Id: userpoints_retroactive.module,v 1.1.2.4 2007/02/04 16:07:04 kbahey Exp $

Which does conform to the new API.