Fedex Automated Labels - Database Problem

[tightwatt]

My web host set up the default oscommerce setup. When they did this, they put an extension on the top level of the database.

 

My database name is allen1. The orders are stored in allen1.osc_orders. The fedex labels module (admin/ship_fedex.php) is giving me an error:

 

1146 - Table 'allen1.orders' doesn't exist

 

select * from orders where orders_id = 383

 

I know that if I could get the path to be 'allen1.osc_orders' that the problem would go away, but I am not sure where this is located in the code.

 

Any help would be appreciated as I think this is an excellent add-in, but it's not working yet.

 

Thanks,

 

Stephen Allen.

[tightwatt]

I figured this one out on my own. This issue will affect anyone who has aplus.net as their web host with their installation of osCommerce.

 

There are two locations in the admin/ship_fedex.php file that will have be changed.

 

Find:

 

tep_db_query("select * from orders where orders_id = $order");

 

replace with:

 

tep_db_query("select * from osc_orders where orders_id = $order");

 

This change, along with changes to sql_new_install (to match database names) will get your automated FedEx labels working.

 

Stephen Allen.