Hostgator, ServInt, and some other hosting providers do not allow their users to have the CREATE VIEW privilege for performance reasons. And when doing work for a client, you are often stuck with their hosting provider.

Is it possible to write this so that mysql views are not a hard requirement? I'm assuming you're using it because it allows simpler database queries, but it can actually be a performance hog - and that's why some major service providers don't let their users have CREATE VIEW privileges.

Comments

madsph’s picture

madsph commented

uc_views_marketing is the only module that requires CREATE VIEW privilege so you can use all the other features.

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented
Category: feature » support
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Eli Baskin’s picture

Eli Baskin commented
Status: Closed (fixed) » Active

I am a customer of Servint, which is a major hosting provider. It seems they are disallowing CREATE VIEW. Is there a way to bypass it so I can use Ubercart Marketing module?

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented
Status: Active » Fixed

If you need "customers who bought this product also bought" then you can use http://drupal.org/project/uc_views_upsell. Otherwise, there is currently no replacement for the other marketing submodule features.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.