php - db_insert 呕吐 "Invalid parameter number: parameter was not defined"

Question

我在 Drupal 模块中有一个表单，我正在尝试提交以创建“事件”。事件表结构为:

• 事件 ID
• 城市 ID
• 事件名称
• 已创建的字段
• 图片字段
• 时间字段
• 日期字段
• 数据字段
• 事件类型字段(枚举类型)

当我尝试创建一个新事件并将其插入数据库时​​:

$eid = db_insert('events')->fields(array(
'cid' => $cid,
'name' => $name,
'time' => $time,
'date' => $timestamp,
'data' => $extra_info,
'event_type' => $checked,  //this is an array of checked checkboxes
))->execute();

它抛出一个错误:

PDOException :SQLSTATE[HY093]: Invalid parameter number: parameter was not defined: INSERT INTO {events} (cid, name, time, date, data, event_type) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5_Games, :db_insert_placeholder_5_Other); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => Name [:db_insert_placeholder_2] => 23.30 [:db_insert_placeholder_3] => 1313020800 [:db_insert_placeholder_4] => More [:db_insert_placeholder_5_Games] => Games [:db_insert_placeholder_5_Other] => Other ) in event_creation_submit().

关于我做错了什么有什么想法吗？

谢谢

Answer 1

设法解决这个问题。

将 event_type 字段的类型更改为集合，并向其传递值字符串而不是数组。这样就解决了。

谢谢大家的帮助!