| Project: | Ubercart Contributions |
| Component: | Code |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Hi Uber Cart pros-
I am new here and would like to use Ubercart for our site and future clients-
Here is my weakness up front-
I know html - I know almost no PHP and know nothing about SQL-
I use apps and stay pretty much on the app / admin side - not the coding side -
I received this error when trying to test ubercart with Paypal sandbox -
user warning: Table 'brentsit_drp03.drup_uc_shipments' doesn't exist query: SELECT sid FROM drup_uc_shipments WHERE order_id = 2 in /home4/brentsit/public_html/lolhome/includes/database.mysql.inc on line 174.
Can anyone help me understand how I might fix this? Perhaps I just have failed to set something up in the "shipments" config -
I haven no clue but would appreciate help.
Thanks
Aaron
Update:
Here are more errors I am finding under the "shipments" for "order 2"
user warning: Table 'brentsit_drp03.drup_uc_shipments' doesn't exist query: SELECT * FROM drup_uc_shipments WHERE order_id = 2 in /home4/brentsit/public_html/lolhome/includes/database.mysql.inc on line 174.
user warning: Table 'brentsit_drp03.drup_uc_packages' doesn't exist query: SELECT * FROM drup_uc_packages WHERE order_id = 2 AND sid IS NULL in /home4/brentsit/public_html/lolhome/includes/database.mysql.inc on line 174.
user warning: Table 'brentsit_drp03.drup_uc_packaged_products' doesn't exist query: SELECT op.order_product_id, CAST(SUM(op.qty) / COUNT(pp.qty) AS UNSIGNED) AS total, SUM(pp.qty) AS packaged FROM drup_uc_order_products AS op LEFT JOIN drup_uc_packaged_products AS pp ON op.order_product_id = pp.order_product_id WHERE op.order_id = 2 AND op.data LIKE '%s:9:\"shippable\";s:1:\"1\";%' GROUP BY op.order_product_id HAVING SUM(pp.qty) IS NULL OR CAST(SUM(op.qty) / COUNT(pp.qty) AS UNSIGNED) > SUM(pp.qty) in /home4/brentsit/public_html/lolhome/includes/database.mysql.inc on line 174.
Again- It would take me 10 years to try to figure out what this means.
Thanks for any help
Aaron
- another update-
I shut off the shipping right now for the cart because we have only audio files or downloads for purchase- no shippable goods-
however- that will not be the case in the near future so I would like to learn what this means and how to solve this problem.
Thanks
Aaron

The messages are telling you that the drup_uc_shipments, drup_uc_packages and drup_uc_packaged_products tables don't exist in your mysql database. Was there a problem with a page hang or something when you enabled the module?
Did you enable some ubercart modules and test it before enabling the shipments module?
If you have shut off shipments you should uninstall it too. In the /admin/build/modules page use the uninstall tab and put a tick in the shipments module checkbox on that page. Then if you re-install it it should at least create those tables in the mysql database.
There might be an issue with the orders that exist not having shipping information, but getting the tables created is probably the first priority.