Cart messed up newbie's site, help pls

12 replies [Last post]

Wed, 04/01/2009 - 10:16

palvine

Offline

Joined: 04/01/2009

Juice: 9

Hi everyone,
I am new to drupal and ubercart. However I had a drupal 6.9 site setup and supported by ubercart for the purpose of shopping. Eventually drupal 6.10 is ready and I have updated from 6.9 to 6.10 but knowing I will need to upgrade ubercart as well because there were already internal warning messages about updating site and Ubercart (Modules).

When I eventually updated Ubercart, the shopping "cart" has become tossed over the whole site, the carts block, Buttom of the page and I cannot tell what went wrong. Updated another site and when I uploaded ubercart and a new theme, I have never been able to login. The login box just dissappeared.

However, the mess on the site comes with IE 7 but when i switch to firefox everything will seem to be fine. But with the other site, it does not matter whether i am using firefox or IE, I cannot login.

I wish some one here will have an answer to my crises. I have attached screenshots.

Preview	Attachment	Size
	ubercart forum 1.JPG SEE BLOCK SECTION WITH SHOPPING CART ICON APPEARING EVERY WHERE	142.41 KB
	ubercart forum 2.JPG SEE THE ICON APPEARING MULTIPLE TIMES ON THE BOTTOM OF THE PAGE	102.99 KB
	cannot login page.JPG. LOGIN BOX GONE MISSING FROM DRUPAL. THIS IS ANOTHER AND WHEN I AM LOGGED IN, THE SHOPPING CART ICON IS BEING ABOUT THE WHOLE SITE	104.67 KB

Wed, 04/01/2009 - 12:39

#1 View page

chum

Offline

Joined: 02/27/2009

Juice: 151

Re: Cart messed up newbie's site, help pls

The shopping cart issue happened to my Ubercart store, I noticed it in IE as well. The only fix I could come up with was to go into the theme block settings for the 'Shopping Cart' block and un-check the 'Display the shopping cart icon in the block title' option.

These options are at: /admin/build/block/configure/uc_cart/

Thu, 04/02/2009 - 08:33

#2 View page

palvine

Offline

Joined: 04/01/2009

Juice: 9

thanks mate

I have finally decided to pull down the cart block as you advised.

Wed, 04/01/2009 - 16:07

#3 View page

stephthegeek

Offline

Joined: 10/20/2007

Juice: 575

Re: Cart messed up newbie's site, help pls

This is a known bug in Beta 5: http://drupal.org/project/issues/ubercart?text=cart+icon&status=All&prio...

Info and patch is available in those issues.

Gorgeous original Drupal themes (and Ubercart themes!) ~ Psst: more Ubercart themes on our new site

Thu, 04/02/2009 - 08:37

#4 View page

palvine

Offline

Joined: 04/01/2009

Juice: 9

Thanks for your comment

At least now i know the error is generic. However, there is still a major problem as I am not able to login to one of my sites after I upgraded Ubercart to the latest version and I am hoping that someone somewhere will help share with us best practice on how to sort these types of crises

Fri, 04/03/2009 - 01:42

#5 View page

torgosPizza

Offline

Joined: 08/14/2007

Juice: 4110

Re: Thanks for your comment

You said that the login disappeared after you upgraded Ubercart "and changed the theme." If you try a different theme, are you able to login?

Also I was able to go to your login form at sportyniners.co.uk/user and it showed up without any problem. (Using Firefox3)

--
Help directly fund development: Donate via PayPal!

Fri, 04/03/2009 - 13:21

#6 View page

palvine

Offline

Joined: 04/01/2009

Juice: 9

Thanks torgoPizza

Infact I decided and deleted the site to start from scratch. I am sure at the time you visited the site, I had probably wiped out the slate clean and did everything afresh. Thanks very much for having taken your precious time to witness my crises live.

Well even after the new installation, Ubercart then began communicating in a language a newbie does not understand unfortunately.
What errors is the code below describing and how can we sort this error to perfection? Waiting for your responses. Many Thanks In Advance

user warning: Table 'iphoneu1_sportyniners.uc_order_products_qty_vw' doesn't exist query: SELECT node.nid AS nid, node.title AS node_title, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, uc_products.sell_price AS uc_products_sell_price, node.type AS node_type, uc_order_products_qty_vw.sum_qty AS uc_order_products_qty_vw_sum_qty FROM node node LEFT JOIN uc_order_products_qty_vw uc_order_products_qty_vw ON node.nid = uc_order_products_qty_vw.nid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE uc_order_products_qty_vw.sum_qty >= 1 ORDER BY uc_order_products_qty_vw_sum_qty DESC LIMIT 0, 10 in /home/iphoneu1/public_html/sportyniners.co.uk/sites/all/modules/views/includes/view.inc on line 731

Fri, 04/03/2009 - 15:03

#7 View page

torgosPizza

Offline

Joined: 08/14/2007

Juice: 4110

Re: Thanks torgoPizza

I wouldn't say my time is "precious" - I'm just happy to help

The error you're getting means the table "uc_order_product_qty_vw" doesn't exist. That doesn't look like a normal Ubercart table. Did you do any messing around with the tables in the backend? Or is there some kind of a module that's enabled that would be trying to insert something with "VW" in it? It doesn't ring any bells for me so I'm trying to figure out where that came from...

--
Help directly fund development: Donate via PayPal!

Fri, 04/03/2009 - 15:18

#8 View page

stephthegeek

Offline

Joined: 10/20/2007

Juice: 575

Re: Re: Thanks torgoPizza

That looks like UC Views: http://drupal.org/project/uc_views

Gorgeous original Drupal themes (and Ubercart themes!) ~ Psst: more Ubercart themes on our new site

Fri, 04/03/2009 - 15:22

#9 View page

Lyle

Offline

Joined: 08/07/2007

Juice: 6846

Re: Re: Thanks torgoPizza

That's a database view created by the uc_views module. It's basically a way to reference a query's results as if they were in their own table.

Fri, 06/26/2009 - 14:32

#10 View page

dmh

Offline

Joined: 12/09/2008

Juice: 11

Re: Re: Re: Thanks torgoPizza

Is there a solution to this?

I just upgraded to the latest D6 and UC2, when I try to use the UC Views module I get the same error.

user warning: Table 'fronncom_frontage.uc_order_products_qty_vw' doesn't exist query: SELECT node.nid AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, uc_products.sell_price AS uc_products_sell_price, uc_order_products_qty_vw.sum_qty AS uc_order_products_qty_vw_sum_qty FROM node node LEFT JOIN uc_order_products_qty_vw uc_order_products_qty_vw ON node.nid = uc_order_products_qty_vw.nid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE uc_order_products_qty_vw.sum_qty >= 1 ORDER BY uc_order_products_qty_vw_sum_qty DESC LIMIT 0, 10 in /home/fronncom/public_html/modules/views/includes/view.inc on line 755.

Fri, 06/26/2009 - 15:36

#11 View page

RSTaylor

Offline

Joined: 04/02/2008

Juice: 99

Re: Re: Re: Re: Thanks torgoPizza

One reason that occurs is if you install uc_views and the site's database user doesn't have permission to create views within MySQL.

You may be able to create the views by copying and pasting the queries from uc_views.install into PHPMyAdmin, the MySQL command line, or whatever you use for database administration. See http://drupal.org/node/395362#comment-1657080

Fri, 06/26/2009 - 16:37

#12 View page

dmh

Offline

Joined: 12/09/2008

Juice: 11

RSTaylor wrote:One reason

RSTaylor wrote:

One reason that occurs is if you install uc_views and the site's database user doesn't have permission to create views within MySQL.

That was it. No more errors and the module's working.

Thank you!

Ubercart

Navigation

User login