Extra fields in Customer Account

[cralyn]

Hi,
Im wondering if anyone can help me add 3 extra fields in the customer account area.
I want to add the following:
Bike/ATV Make
Model
Year

I have got the extra fields in place and viewable. They also work on input from admin area. I am getting the following error message when attempting to either creat or edit an account as a customer. Could someone explain what it means and how to overcome it.

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

update address_book set entry_street_address = '56 Brickworks Road', entry_firstname = 'Craig', entry_lastname = 'Harrison', entry_postcode = '4503', entry_city = 'Kallangur', entry_country_id = '13', entry_bike_make = 'kawasaki', entry_bike_model = 'GPX 250', entry_bike_year = '1991', entry_gender = 'm', entry_suburb = '', entry_zone_id = '0', entry_state = 'Queensland' where customers_id = '2' and address_book_id = '1'

[TEP STOP]

Thanks
Craig

[stan]

Looks to me as if the entry_bike_make field doesn't exist in the address_book table of your catalog database. Are you sure that you added the new fields to the database structure?

-- stan c",)

[ozstar]

How does one 'add' new fields to the dbase as I too am interested in what he wants to do!

Thanks

[stan]

Well, I tend to use PhpMyAdmin, which makes it easy to administer databases over the web. Keep in mind that it is possible to mess up your OS Commerce when tinkering with the database, so a good measure of caution is warranted.

There are a lot of utility functions and what not, so adding fields often necessitates changes in several other areas. Not too sure what is required for adding fields to the customer off-hand...



-- stan c",)

If you want to edit the tables (and I would stress a lot of caution too), and you have the mysql program (downloadable on www.mysql.com) here's the query to use to add new fields:

ALTER TABLE tablename ADD COLUMN newfield VARCHAR(X) DEFAULT '' NOT NULL;

tablename in this case would be customers
newfield can be whatever you want. You could have it customers_bike
VARCHAR(X) is the type of field you are creating. It can be CHAR, INT, and many other things.
DEFAULT '' is the default information in the field. If INT is used this can be a number (usually 0).
NOT NULL is just that.

Again be cautious when changing fields.

[vermeerr]

Can someone explain what the process is for adding customized fields? Or does someone know a good howto on the net?

Thanx in advance.

[In-Overtime]

I also would like to add additional fields to the "create_account.php" page.

After installing an SSL cert, I need to set up a credit application for customers wishing to finance a vehicle, and I would rather tie it into the catalog database instead of going outside the directory, tieing it into the Customer Account for future reference.

If someone could put together a contribution (H'mm, maybe using something like the "Addtional pages" contribution) that would be awesome!

BTW - Additional Pages Contrib is at
http://www.oscdox.com/modules.php?op...%20New%20Boxes