MySQL Error

[john2010]

I created a custom module and when i attempt to add a record I get MySQL error 1064. I have searched the forums but none of the solutions posted pertain to a custom module.

Here is the error:
Query Failed:INSERT into stude_students set id='5a7b505a-5549-56c9-3466-487cbdb92581', date_entered='2008-07-15 15:10:07', date_modified='2008-07-15 15:10:07', modified_user_id='1', created_by='1', description=null, deleted='0', assigned_user_id='1', first_name='First', last_name='Last', do_not_call='0', phone_home=null, phone_mobile=null, phone_work=null, phone_fax=null, primary_address_street=null, primary_address_city=null, primary_address_state=null, primary_address_postalcode=null, county='Southern Chautauqua', typeofschooling='In High School', birthdate=null, release='0', interning='0', jobshadow='0', businesstours='0', mockinterviews='0', sywep='0', apprenticeships='0', careerfairs='0', careermentoring='0', lifementoring='0', miscellaneousnotes=null::MySQL error 1064:

I am using 1&1 hosting
Sugar 5.0.0f
PHP 5 and MySQL 5

Thank you!

[Angel]

Take a look at your database and make sure that all the referenced columns exist in the stude_students table.

[john2010]

That was it. The database was missing "release." I deleted the field in Fields and removed it from the layout and everything works.

Thanks!