Order Editor missing 'shipping_tax' column in orders table

[cbp]

Hi,<br><br>I have been using oscommerce for the past two years and yesterday I stumbled over OSCMax. <br><br>I installed it and found this bug when I tried to create an order with Order Editor.<br>In table Orders there is a missing 'shipping_tax' column and this gives errors when trying to manually create an order.<br><br>Fix (in phpMyAdmin): ALTER TABLE orders ADD shipping_tax DECIMAL( 7, 4 ) DEFAULT '0.000' NOT NULL ;<br><br>I searched and nothing o­n this forum so I decided  to post it here. <br><br>There is a follow-up error o­nce you try to edit this order in Customer->Orders:<br><font color="#000000"><b>1146 - Table 'my_dbname.TABLE_PAYPAL_IPN' doesn't exist<br><br>select * from TABLE_PAYPAL_IPN where paypal_ipn_id = '0'<br><br></b>I am trying to fix this as we speak.<br><br>My question is this: 5 minutes after installation i found a few bugs. Are there many more? is this OSCMax updated o­nce in a while, or is the project dead?<br><br>cheers,<br></font>

---------------------------------------------------
OMG Visual Mode doesn't work.

Anyways here goes the clean version.

Hi,

I have been using oscommerce for the past two years and yesterday I stumbled over OSCMax.

I installed it and found this bug when I tried to create an order with Order Editor.
In table Orders there is a missing 'shipping_tax' column and this gives errors when trying to manually create an order.

Fix (in phpMyAdmin):

ALTER TABLE orders ADD shipping_tax DECIMAL( 7, 4 ) DEFAULT '0.000' NOT NULL ;

I searched, and nothing on this forum so I decided to post it here.

There is a follow-up error once you try to edit this order in Customer->Orders:
1146 - Table 'my_dbname.TABLE_PAYPAL_IPN' doesn't exist

select * from TABLE_PAYPAL_IPN where paypal_ipn_id = '0'

I am trying to fix this as we speak.

My question is this: 5 minutes after installation i found a few bugs. Are there many more? is this OSCMax updated once in a while, or is the project dead?

cheers,

[michael_s]

Yes, visual mode is screwed with PNphpBB2... working on it...

Remember if there are bugs in the original mod, they will be in osCMax, since we did not write the mods, and the fixes are dependent upon the mod writers.

osCMax is simply a preinstallation of the existing mods, not a fork or a new version. It is still rooted in osCommerce and it's mods. This project depends on feedback and reporting from the community. That is what the bugtracker is for. If you find a repeatable bug, post it in the bugtracker.

The project is not dead... sheesh. RC3 was just released so I am not sure where you are getting that...

Now, on to your bugs.

1. I can create orders in the admin panel without any problems. No errors at all.

2. I can edit orders in the admin without getting any errors either. Again, a default RC3 install...

Perhaps you can be more specific as to how you are generating these errors so I can reproduce.

[cbp]

The project is not dead... sheesh. RC3 was just released so I am not sure where you are getting that...

No harm intended. I am glad to see that this project is alive.
This means that I will work with OSCMax from now on. I have to build a osc site for a customer and this OCMax has most of (and some extra) features that I need.

For the next month I will work intensively with OSCMax to make it fully functional and find whatever bugs it has (most of them anyways). I will report here and in the bugs section whatever I find.

[thomaspkelley]

I am using this thread because I see the same error as the above post.

The reason I am getting the error message in admin/orders.php is that I changed the name of the PayPal IPN payment module. I removed '(Credit Card / Debit)' from the name in the checkout process. (I wanted people to use Authorize.net for credit cards and I like the IPN module.) When I go to the 'orders' table in MySQL i can add 'credit card / debit' and the order information will then appear in my Orders admin.

What file will I need to modify so that I can see the order information in Admin, but not have credit/debit show at check out?

My first post. Thank you for all your hard work.

[Asgoroth]

I had the same problem. I am using RC3 and was able to reproduce it 100% of the time. Using the "Edit Orders" screen to update an order would cause the following error:

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

I found the solution at the main osCommerce site. there were two missing entries in the store SQL for "Edit Orders" as follows:

1) Table 'orders" missing Field "shipping_tax"
2) Table 'configuration' missing entry for "Edit Orders"

Run the following script into your store SQL:

ALTER TABLE orders ADD shipping_tax DECIMAL( 7, 4 ) DEFAULT '0.000' NOT NULL ;
INSERT into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('', 'Order Editor- Display Payment Method dropdown?', 'DISPLAY_PAYMENT_METHOD_DROPDOWN', 'true', 'Display Payment Method in Order Editor as dropdown menu (true) or as input field (false)', '1', '21', NULL, '2006-04-02 11:51:01', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

I have also attched the code in a text file

[driwashsolutions]

Just had this same issue when trying to cancel an order...

[rolotech]

I am getting this error everytime I want to update a customers Order, also I don't know why in every order total is charging TAX to customers outside my State, please advise

Thanks

[michael_s]

Merged threads. Rolotech, do a search before posting. Simply searching on 1054 gets you your answer in the first 2 listings.

[rolotech]

I did search but didn't try the error number, about the answer of the member above I don't get when he say "Run the following script into your store SQL:"
can you please explain little bit detailed?

THanks

[michael_s]

Then you didn't really search...

You need to execute the sql statement on your db to add the missing column.

Use phpmyadmin to do this...