Welcome Guest, Not a member yet? Register   Sign In
please help in this insert error
#1

[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...
#2

[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.
#3

[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..
#4

[eluser]halomas[/eluser]
aha! i've solved this problem..
you're right,,




Theme © iAndrew 2016 - Forum software by © MyBB