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)
);
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | patch_79.txt | 339 bytes | joe.murray |
Comments
Comment #1
joe.murray commentedThe 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.
Comment #2
joe.murray commentedComment #3
joe.murray commentedComment #4
owahab commentedSupport to version 4.6 is dropped.