MY SQL error

[Guest]

I get the following error in oscommerce

 

1146 - Table 'petcals_osc1.TABLE_PRODUCTS_SHIPPING' doesn't exist

 

select products_ship_price, products_ship_price_two, products_ship_zip, products_ship_methods_id from TABLE_PRODUCTS_SHIPPING where products_id = '69'

 

[TEP STOP]

 

What can I do, how do I find the fix for this? Is it MySQL? or is it another place? The table does exist.

[kgt]

Look in includes/database_tables.php and make sure TABLE_PRODUCTS_SHIPPING is defined as products_shipping.