Error with fast easy checkout

[rommany]

Hello

 

Could someone pls help

 

A few months ago i added PWA contribution but today changed it to the fast easy checkout cont.

 

But im get errors we i pay by check or C/C, below is the error

 

1054 - Unknown column 'createaccount' 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, createaccount, currency_value) values ('49', 'xxxxxxxxx xxxxxxxxxxx', '', 'xxxxxxxxxx', '', 'xxxxxxxxxx', 'xxxxxxxxx', 'xxxxxxxxxx', 'Belarus', 'xxxxxxxxxxxxx', 'xxxxxxxxxx@hotmail.com', '1', 'xxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx', '', 'xxxxxxxxxxxxxxxx', '', 'xxxxxxxxxxxxx', 'xxxxxxxxxx', 'xxxxxxxxxxxx', 'United Kingdom', '1', 'xxxxxxxxx xxxxxxxxxxx', '', 'xxxxxxxxxx', '', 'xxxxxxxxxx', 'xxxxxxxxx', 'xxxxxxxxxx', 'Belarus', '1', 'Credit Card', 'Visa', 'xxxxxxxxx xxxxxxxxxxx', 'xxxxxxxxxxxxxxx', '0406', now(), '2', 'GBP', 'N', '1.00000000')

 

[TEP STOP]

 

Is the above is because i changed the DB for PWA and have not changed it back or is this something else.

 

If it is something to do with the DataBase is it possible to reload the basic DB for osC or am i just going down the wrong road ?

 

 

Kind Regards

[nana]

you have to create a new field in the db createaccount in your customers table as per instruction and set the default value to "Y"

also there is a support tread i just found this by accident

http://www.oscommerce.com/forums/index.php?showtopic=167064