IP recording

[schrøder]

All works fine, exept at the last checkout_process.php when the button checkout is clicked then I got this error

 

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

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, ipaddy, ipisp) values ('2', 'even scroder', '', 'mele4', '', 'viggja', '7354', '', 'Norway', '7766554433', 'fotpleien@yahoo.no', '1', 'even scroder', '', 'mele4', '', 'viggja', '7354', '', 'Norway', '1', 'even scroder', '', 'mele4', '', 'viggja', '7354', '', 'Norway', '1', 'Cash on Delivery', '', '', '', '', now(), '1', 'USD', '1.00000000', '82.194.204.81', 'loqal.no')

 

[TEP STOP]

I think i could be something with --RUN the SQL--- and

ALTER TABLE `orders` ADD `ipaddy` VARCHAR(15) NOT NULL;

ALTER TABLE `orders` ADD `ipisp` VARCHAR(15) NOT NULL;

 

But where shall I configure this??

Breg Eugen

Edited March 13, 2007 by schrøder

[Guest]

you are exactly right you need to run those 2 ALTER commands on the database to correct this error.

 

Use phpMyAdmin (quite possibly available through your host control panel otherwise google it and download) to execute them and setup your database correctly.

 

Tom