+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: please help in this insert error (/showthread.php?tid=37501)
please help in this insert error - El Forum - 01-11-2011
[eluser]halomas[/eluser]
i'm deleted my 'cap_power' field in my table in the database
when i insert to database
this error show:
An Error Was Encountered
Error Number: 1054
Unknown column 'cap_power' in 'field list'
INSERT INTO `pd_parts` (`part_number`, `original_pn`, `old_pn`, `description`, `cap_power`, `others`, `user_id`, `last_update`) VALUES ('VEGR01-010001', 'sjsjsj', 'jsjs', 'heh', 0, 'ehhjahs', '1', '2011-01-12 09:30:14')
doesn't active record/CI automaticaly will erase the 'cap_power' in field list when I delete cap_power in my table??
how to delete cap_power in field list
or how to fix this..
because i didn't see 'field list'
thx...
please help in this insert error - El Forum - 01-11-2011
[eluser]lennierb5[/eluser]
If you deleted the field 'cap_power' in your database CI doesn't know that and will try to execute the query as it was coded. You need to find where a value is being set for 'cap_power' in CI and remove it. After that the error should go away.
please help in this insert error - El Forum - 01-11-2011
[eluser]halomas[/eluser]
[quote author="lennierb5" date="1294825125"]If you deleted the field 'cap_power' in your database CI doesn't know that and will try to execute the query as it was coded. You need to find where a value is being set for 'cap_power' in CI and remove it. After that the error should go away.[/quote]
first, i would like to thank you for replying..
hmm... i'd try to find where the 'cap_power' being set in CI, i find in my model , but i didn't got it.
it seems like , the field is generated automaticaly .
well,, this is not my web project but my job is to fix this project errors..
and i'm new to CI,but i know MVC concept..
please help in this insert error - El Forum - 01-11-2011
[eluser]halomas[/eluser]
aha! i've solved this problem..
you're right,,