Error when attempting to create an RSVP:
user error: Unknown column 'token' in 'field list'
query: INSERT INTO rsvp (uid, timestamp, name, invite_text, blind, list_email, allow_invite, nid, token, rid) VALUES (1, 1166475245, 'test1', 'heh', '0', '0', '0', '9', '0f84622e23b5d8909dd25290c6a16b3e', 4) in /var/www/virtual/toronto.socialjustice.org/webroot/htdocs/includes/database.mysql.inc on line 66.

The rsvp.mysql for 4.6 does not include the token field:
CREATE TABLE rsvp (
rid int(10) unsigned NOT NULL auto_increment,
nid int(10) unsigned NOT NULL default '0',
uid int(10) unsigned NOT NULL default '0',
name varchar(128) default '',
invite_text text,
blind int(3) unsigned NOT NULL default '0',
list_email int(3) unsigned NOT NULL default '0',
allow_invite int(3) unsigned NOT NULL default '0',
timestamp int(10) unsigned NOT NULL default '0',
PRIMARY KEY (rid,uid,nid)
);

CREATE TABLE rsvp_invite (
response enum('yes','no','maybe','none') NOT NULL default 'none',
rid int(10) unsigned NOT NULL default '0',
uid int(10) NOT NULL default '0',
email varchar(128) NOT NULL default '',
hash varchar(255) NOT NULL default '',
invited int(10) unsigned NOT NULL default '0',
received int(10) unsigned NOT NULL default '0',
timestamp int(10) unsigned NOT NULL default '0',
PRIMARY KEY (rid,email,uid)
);

CommentFileSizeAuthor
#1 patch_79.txt339 bytesjoe.murray

Comments

joe.murray’s picture

Title: missing field in table » dealing with new token field in $_POST
StatusFileSize
new339 bytes

The problem was that a new token field is being passed:
$rid = rsvp_create_rsvp($_POST['edit']);
I've attached a patch to deal with issue.

joe.murray’s picture

Status: Active » Reviewed & tested by the community
joe.murray’s picture

Status: Reviewed & tested by the community » Needs review
owahab’s picture

Status: Needs review » Closed (won't fix)

Support to version 4.6 is dropped.