php - Unknown column XXXX in field_list -
ok, here's weird issue :
error number: 1054
unknown column 'alias' in 'field list'
insert
projects
(id
,alias
,url
,domains
,progress
,total
,
i've been using specific database table, i've been populated through model script. after added column (let's alias
), function doesn't work anymore , displays above error.
and database population code :
function createnew($proj) { $data = array( 'id' => $proj['id'], 'alias' => $proj['alias'], 'url' => $proj['url'], 'domains' => $proj['domains'], 'progress' => $proj['progress'], 'total' => $proj['total'], 'email' => $proj['email'] ); $this->db->insert('projects',$data); }
the weirdest thing of when manually execute exact same query (e.g. using sql via phpmyadmin), works fine.
any ideas?
have tried use query
method?
$sql = 'insert projects (id, alias, url, domains, progress, total, email) values (?, ?, ?, ?, ?, ?, ?)'; $this->db->query($sql,$proj);
Comments
Post a Comment