schrøder Posted March 13, 2007 Posted March 13, 2007 (edited) 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', '[email protected]', '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 Quote In a sacred manner I live, in heaven I gaze, in a sacred manner I live my horses are many.
Guest Posted March 13, 2007 Posted March 13, 2007 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.