Mismatched fields, values [#468266]

Not sure why this hasn't been reported earlier, since it prevents adding or editing limits (happens when adding or editing a limit):

user warning: Column count doesn't match value count at row 1 query: INSERT INTO node_limit VALUES('1', '1', 'Business Listings (one only)', '0') in /home/localie/public_html/local/sites/all/modules/node_limit_dev/node_limit.module on line 521.

You're trying to save 4 values into a db with 5 fields. The type field is either unnecessary now and can be removed or needs to have a value.

Comments

Comment #1

aldenpoetker commented 27 May 2009 at 19:24

Priority:

Normal

» Critical

I have loaded the module but am unable to add any node limits. I keep getting the following message:

"user warning: Column count doesn't match value count at row 1 query: INSERT INTO node_limit VALUES('1', '1', 'Limits salon owner to one salon listing per registration', '0') in /home2/visualch/public_html/salonrecruiter/sites/all/modules/node_limit/node_limit.module on line 521."

Were you able to solve this problem? Any help is greatly appreciated as this module would be very helpful to me if it worked!

Alden

Comment #2

mrtoner commented 28 May 2009 at 04:27

Priority:

Critical

» Normal

Alden, use the release version, which works fine.

Comment #3

dewolfe001 commented 4 October 2009 at 05:35

I saw this too, but I'm pretty sure I downloaded the release version.
My workaround was:

  db_query("INSERT INTO {node_limit} (lid, `limit`, title, weight, `type`) VALUES ('%d', '%d', '%s', '%d', '%s')", $limit['lid'], $limit['limit'], $limit['title'], $limit['weight'], $limit['element']);

Comment #4

ifoundthetao commented 4 November 2009 at 03:22

yeah, I independently did the same. This module could be really awesome if it were worked on. I'm working on it now on my own, but that's just to get it working with the Organic Groups node limiting.

there's a bunch of stuff in the dev that's bad news bears, so I don't know if it's worth going through and seeing what they were doing, or starting afresh.

Comment #5

mavimo commented 27 December 2009 at 00:39

I fix it and some other issue on #668404: Some improvement, code cleaning, and comment. Please test this patch.

Comment #6

arski commented 8 June 2010 at 20:01

Umm, too bad this module isn't maintained really.. answers like "use the release version" when people are suggesting fixes for the dev version are indeed very helpful :!

Comment #7

mrtoner commented 12 June 2010 at 17:15

@arksi: Not exactly sure what good that comment was. I was I who suggested both the fix for the dev version and that users continue to use the stable release version. Dev versions are a work in progress and not guaranteed to work as described. If you'd like to step up and maintain this project, feel free to contact the powers-that-be.