Home » Projects » Ubercart Contributed Modules » Ubercart Contributions » Issues

User Warning

Submitted by Aaron on Mon, 03/08/2010 - 10:23
Project:Ubercart Contributions
Component:Code
Category:support request
Priority:critical
Assigned:Unassigned
Status:active
Description
Project: 
Ubercart

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
Thu, 03/11/2010 - 07:20
#1 View page
the_g_bomb
the_g_bomb's picture
Offline
Joined: 03/02/2010
Juice: 7
#1

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.

Top
Thu, 03/11/2010 - 08:38
#2 View page
Aaron
Aaron's picture
Offline
Joined: 03/08/2010
Juice: 8
#2

Thanks the_g_bomb -

I did shut it off as we don't need shipping right now-

and your answer is the same as the techie at our host - that the table was not there-

I think, once we have products that are not digital, we will be able to turn the shipping module and configure it, and I suppose the tables will be constructed through UC-

I am hoping that is the solution -

Thanks again for posting a response here-

Here is our site where UC is installed

http://www.longonlife.net/

Here is the audio download that is working properly now - as we have working orders for it -

http://www.longonlife.net/content/5-rights-john-chapter-5

since we do live and audio training for sales and marketing - UC seems like the best solution. . .

and this shopping cart install is properly working with paypal and with digital downloads-

Blessings,
Aaron

Aaron
www.longonlife.net

Top