Where to look after db - field list

[Tinebn]

hi

 

trying to make a new post in custormers call custermers_tilbud... need to sent a test pack, the custormers can make a select if they want one.

 

get this error... do not know which file or where to look ... have tried to make the code simelar to newsletter.

 

where to look ?? please

 

<--

1054 - Unknown column 'customers_tilbud' in 'field list'

 

update customers set customers_firstname = 'tine', customers_lastname = 'nielsen', customers_email_address = '[email protected]', customers_telephone = '443', customers_fax = '', customers_newsletter = '1', customers_tilbud = '0', customers_gender = 'f', customers_dob = '19620521' where customers_id = '9'

-->

 

Tine :-)

[burt]

Use phpmyadmin to add the tilbud to the customers table

[Tinebn]

Use phpmyadmin to add the tilbud to the customers table

hi

 

I have made a table in custormers call custermers_tilbud

 

and it put the 1 for subscribtion in the custermers_tilbud table from the form but not the 0

 

custermers joe from the standard osc. gives me no 1054 error .... strange- but still it does not understand the 0

 

it like my list number is wrong??

 

was it what you ment with phpmyadmin??

[MrPhil]

Was this "customers_tilbud" (whatever that is) part of code or an "add-on" that someone provided? If so, they should have included instructions on how to upgrade your database to add this new field to the customers table -- where to add it, and what kind of data type to declare it, and what default value to give. I would rather that you follow their instructions than try to figure it out for yourself, as you are obviously extremely inexperienced in database work. If you can't find the instructions, contact the author or supplier -- they are responsible for providing them.

[Tinebn]

Was this "customers_tilbud" (whatever that is) part of code or an "add-on" that someone provided? If so, they should have included instructions on how to upgrade your database to add this new field to the customers table -- where to add it, and what kind of data type to declare it, and what default value to give. I would rather that you follow their instructions than try to figure it out for yourself, as you are obviously extremely inexperienced in database work. If you can't find the instructions, contact the author or supplier -- they are responsible for providing them.

 

hi mrPhil

The only way to learn is to ask... and it is my own add-on so who to ask ???

but a instructions link will be fine

 

Yes you are right I am extremely inexperienced in database work

 

Tine

[www.in.no]

To ask is not the only way, you can also look, try to look at some of the other fields in the same page and try to follow them into the db. From the form field, validation, functions(tep_db_prepare_input) and so on...

Also look at other addons making changes to the account page or customer update can help you find the correct places to make the changes.

 

The way i learned a lot is by starting to take a small addon and tear it apart and understand all the code and the way in the system. Then it is easyer to know what you have to do..

[Tinebn]

To ask is not the only way, you can also look, try to look at some of the other fields in the same page and try to follow them into the db. From the form field, validation, functions(tep_db_prepare_input) and so on...

Also look at other addons making changes to the account page or customer update can help you find the correct places to make the changes.

 

The way i learned a lot is by starting to take a small addon and tear it apart and understand all the code and the way in the system. Then it is easyer to know what you have to do..

 

Hi

Thanks, thanks - my thought

 

I have looked and made some changes, but I have not found that functions :-)

 

I have to crawl before I can stand :-)))

 

Thanks alot again

 

Tine