当我试图在postgresql中的用户表中插入一行时,我遇到了一个问题,例如
我有一个带有活动记录的正常插入,$this->db->insert($table,$data),我得到一个类似这样的错误:
错误:关系«user_accounts»第1行:插入"user_account"("user_aaccounts"。"uacc_group_fk"
我认为问题可能是我将插入的字段中的表名("user_accounts"。"uacc_group_fk"),.
你知道我该怎么避免吗?我只想把字段的名称没有表名。
提前谢谢
是否检查了"user_accounts"列。"uacc_group_fk"是否存在(带引号)?
这是的insert_user函数中使用的数据数组https://github.com/haseydesign/flexi-auth/blob/master/library_files/application/models/flexi_auth_model.php:
$sql_insert = array(
$this->auth->tbl_col_user_account['group_id'] => $group_id,
$this->auth->tbl_col_user_account['email'] => $email,
$this->auth->tbl_col_user_account['username'] => ($username) ? $username : '',
$this->auth->tbl_col_user_account['password'] => $hash_password,
$this->auth->tbl_col_user_account['ip_address'] => $ip_address,
$this->auth->tbl_col_user_account['last_login_date'] => $this->database_date_time(),
$this->auth->tbl_col_user_account['date_added'] => $this->database_date_time(),
$this->auth->tbl_col_user_account['activation_token'] => $activation_token,
$this->auth->tbl_col_user_account['active'] => 0,
$this->auth->tbl_col_user_account['suspend'] => $suspend_account
);