Column count error when adding a flag [#271078]

I get the following error:

user warning: Column count doesn't match value count at row 1 query: INSERT INTO flags (fid, content_type, name, title, flag_short, flag_long, flag_message, unflag_short, unflag_long, unflag_message, roles, global, teaser, node_form) VALUES (4, 'node', 'testflag', 'testtitle', 'testlink', 'testdescrip', 'testmsg', 'testunlink', 'testundescrip', 'testunmsg', '2', 0, 'a:3:{s:12:\"show_on_page\";i:1;s:14:\"show_on_teaser\";i:0;s:12:\"show_on_form\";i:0;}') in /home/sten9/public_html/includes/database.mysql.inc on line 172.

I tried this as both an upgrade to Views Bookmarks, following the instructions, and then consequently as a fresh install, having first removed and uninstalled everything and checking that flag and views_bookmark tables were dropped. Same error in each case.

Comments

Comment #1

brunodbo

he/him

commented 16 June 2008 at 12:09

Yep, same count error on fresh install of Flag.module in Drupal 5.7:

user warning: Column count doesn't match value count at row 1 query: INSERT INTO flags (fid, content_type, name, title, flag_short, flag_long, flag_message, unflag_short, unflag_long, unflag_message, roles, global, teaser, node_form) VALUES (3, 'node', 'abuse', 'Abuse', 'flag this post', 'Do you find this post offensive? Click to let us know.', 'You successfully flagged this post. An administrator has been notified.', 'unflag this post', 'Click to unflag this post.', 'You successfully unflagged this post.', '2', 0, 'a:3:{s:12:\"show_on_page\";i:1;s:14:\"show_on_teaser\";i:0;s:12:\"show_on_form\";i:0;}') in /home/bruno/workspace/dev.indymedia.be/trunk/includes/database.mysql.inc on line 172.

Comment #2

brunodbo

he/him

commented 16 June 2008 at 12:10

Priority:

Normal

» Critical

Marking as critical as it prevents users to create new flags.

Comment #3

quicksketch

he/him

commented 16 June 2008 at 14:45

Status:

Active

» Fixed

Thanks guys for the reports. Getting Flag out for D5 and D6 is a high importance for me, and reports will definitely help with this. I've fixed this issue with the linked patch.

http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/flag/flag.m...

Please report if you have further issues, and I'll put out another beta this week. Thanks!