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, email) values (80511, 'some alias', 'somedomains.com', 'xxxxxx', 0, 199, 'some@gmail.com')

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

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -