osCommerce - almost there - paypal working but cod error

[mikez68]

Im using the fantastico installed osCommerce on my site dezinercatalog.com
I am using the Plug N Pay Payment Module for 2.2-CVS module.
PayPal is working on my site, somewhat customized and well over 200 products listed.
I am having a problem with the COD option. This should be the easy part right?
My test customer orders, chooses COD, clicks Confirm Order and gets the url http://dezinercatalog.com/commerce/checkout_process.php
which displays
1054 - Unknown column 'customers_company' 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, comments, currency, currency_value) values ('4', 'Pretty Baby', 'abc', '123 Not Real St.', '', 'Crappy', '08000', 'New Jersey', 'United States', '856-222-4563', 'pretty@dezinerwholesale.com', '2', 'Pretty Baby', 'abc', '123 Not Real St.', '', 'Crappy', '08000', 'New Jersey', 'United States', '2', 'Pretty Baby', 'abc', '123 Not Real St.', '', 'Crappy', '08000', 'New Jersey', 'United States', '2', 'Cash on Delivery', '', '', '', '', now(), '1', '', 'USD', '1.00000000')

[TEP STOP]

Any idea what i can do?
Mike Z
mikez68@aol.com

[Fireater]

ah.. that is a old problem of oscommerce.. the ustomers_company table is missed by Fantastico while installing..

You will have to added that table to the mySQL database using phpmyadmin manually... the table should be added in seven or eight places I think..

I will try to search for the old thread on oscommerce forums... wait.

[mikez68]

I guess ill have to take a forray into how MyAdmin works. Never used it.

[Fireater]

I got it.. you will have to get the latest tables structures from the CVS and manually add the changed tables to your database... but first backup the database before you attempt to do anything.

http://forums.oscommerce.com/viewtopic.php?t=31449

Let me give you my quick fix, but I don't guarantee that it will work well.. anyway, its worth a try..

1. FIRST BACK UP YOUR DATABASE, and open phpmyadmin from inside your cpanel.

2. In the phpmyadmin, open the database of oscommerce.. it should be 'your-username_shop' from the list on the left top in phpmyadmin.

3. click on 'SQL' link on the top second.. first is 'structure', second is 'SQL' and third is 'Export'... you can easily find it.

When the page opens, cut and paste the following code into the text area where it says: Run SQL query..

ALTER TABLE `orders` ADD customers_company varchar(32) AFTER `customers_name`, ADD delivery_company varchar(32) AFTER `delivery_name`, ADD `billing_name` varchar(64) NOT NULL AFTER `delivery_address_format_id`, ADD `billing_company` varchar(32) AFTER `billing_name`, ADD `billing_street_address` varchar(64) NOT NULL AFTER `billing_company`, ADD `billing_suburb` varchar(32) AFTER `billing_street_address`, ADD `billing_city` varchar(32) NOT NULL AFTER `billing_suburb`, ADD `billing_postcode` varchar(10) NOT NULL AFTER `billing_city`, ADD `billing_state` varchar(32) AFTER `billing_postcode`, ADD `billing_country` varchar(32) NOT NULL AFTER `billing_state`, ADD `billing_address_format_id` int(5) NOT NULL AFTER `billing_country`;

and press 'go' to run this SQL command..

LAST: Now try to access your shop and see if the error repeats..

Dr.Fireater

[Fireater]

1. Mike, open your cpanel and open phpmyadmin first,.

2. In phpmyadmin, to your left top, you can see a drop-down box.. click it and select 'your-page-zone-username_shop'..

That is the name of the database on which your oscommerce runs..

3. After it opens, you will have to check all the boxes.. find 'check all boxes' at the bottom..

4. Once all boxes (tables) are checked, press export to export these tables... now you have backed up your database.

then go to do what I have outlined earlier.

And feedback.

[Fireater]

mike.. wait a min.. pls.

[Fireater]

I think you can give it a try...
But I am not exactly 100% sure..

Because I don't know which version of oscommerce, fantastico uses.. maybe it gets it straight from the CVS snapshot ...

I would suggest you to try what I outlined, but if nothing works, I advise you to get a copy of oscommerce from oscommerce.com and try installing it afresh.

It is not difficult to install and will save you a lot of headaches.

Best of luck!

[mikez68]

the only database is
dezinerc_osc2
im gonna try that one- i have backed up
ill keep checking back to see if you put up a
"NO STOP DONT DO THAT"
post
thanx again
Mike Z

[mikez68]

Thankee Fireater,
Most appreciative of your assistance.
This site is an updated of www.dezinerwholesale.com
500 prducts- used to generate image pages with photoshop and edit by hand with dreamweaver. It was a mess. You have assisted me in making my life easier. Ill spend my new found spare time browsing your old posts. I have seen your tag a lot on these forums.
In your debt,
Mike Z

[Fireater]

phew! thank God it worked!

Did you test it out?

You are most welcome!

[mikez68]

I have tested it with COD, not yet Paypal - but it goes right up to thier page and all variables are passed (the order and info).
Seems my UPS shipping option is kinda overcharging, but look into the options and see what I can do. Might just call UPS to see if they have the MOD, Ill look into that today.