hostmonster

[Jeff Greenberg-3]

I figure others like me use shared hosting for their test and/or
development servers. Thought you'd like to know that what I found out
midstream in a project, with Views tossing errors at me with the
Ubercart views. HostMonster doesn't support mysql views.  I asked why
they feel they support Drupal, and they said that they do, just not
views. I said that's like saying they support it, just not php. Their
response was, "Actually its like saying we support a Car being in our
garage.. thats not saying the Doors on the car will open"


So if you need a garage for your Drupal sites...there ya go...just don't
plan on doing any meaningful views and e-commerce.

[Maurice Mengel]

I am not sure this is the right list, but thanks for posting anyways. I don't understand how these hosters can still be so arrogant.

On Fri, Nov 6, 2009 at 7:51 AM, Jeff Greenberg <jeff@...> wrote:

I figure others like me use shared hosting for their test and/or development servers. Thought you'd like to know that what I found out midstream in a project, with Views tossing errors at me with the Ubercart views. HostMonster doesn't support mysql views.  I asked why they feel they support Drupal, and they said that they do, just not views. I said that's like saying they support it, just not php. Their response was, "Actually its like saying we support a Car being in our garage.. thats not saying the Doors on the car will open"


So if you need a garage for your Drupal sites...there ya go...just don't plan on doing any meaningful views and e-commerce.

[Michael Prasuhn]

The Views module does not make use of MySQL views. As far as the  
database is concerned* all Views module does is build queries and run  
them just like any other query in Drupal. If the errors are SQL  
related you should take a look at the SQL views is generating and  
review that against your schema. I would wager that you most likely  
have a database schema that is out of date, and you need to run  
update.php. If the errors are PHP related, it is probably an  
incompatible version of PHP itself.

-Mike


* I know that Views does so much more and then some, however all the  
RDBMS will see is just another select query.
__________________
Michael Prasuhn
mike@...
http://mikeyp.net

On Nov 5, 2009, at 10:51 PM, Jeff Greenberg wrote:

> I figure others like me use shared hosting for their test and/or  
> development servers. Thought you'd like to know that what I found  
> out midstream in a project, with Views tossing errors at me with the  
> Ubercart views. HostMonster doesn't support mysql views.  I asked  
> why they feel they support Drupal, and they said that they do, just  
> not views. I said that's like saying they support it, just not php.  
> Their response was, "Actually its like saying we support a Car being  
> in our garage.. thats not saying the Doors on the car will open"
>
>
> So if you need a garage for your Drupal sites...there ya go...just  
> don't plan on doing any meaningful views and e-commerce.
>

[Kieran Lal-2]

Jeff, yes this this the wrong place to discuss. The right place to
discuss this is: http://drupal.org/hosting-support

I maintain the list of hosting companies that support Drupal:
http://drupal.org/hosting. Hostmonster is not on the list, but I am
sure they would like to be. We can discuss off-list about why they
should be more clear about what they support.

In the meantime, you should contact the author of Ubercart Views and
ask that the dependencies or a new requirements section on the project
page include mention of the need to support database views (not Drupal
views).  http://drupal.org/project/uc_views

Cheers,
Kieran

On Thu, Nov 5, 2009 at 10:51 PM, Jeff Greenberg <jeff@...> wrote:

> I figure others like me use shared hosting for their test and/or development
> servers. Thought you'd like to know that what I found out midstream in a
> project, with Views tossing errors at me with the Ubercart views.
> HostMonster doesn't support mysql views.  I asked why they feel they support
> Drupal, and they said that they do, just not views. I said that's like
> saying they support it, just not php. Their response was, "Actually its like
> saying we support a Car being in our garage.. thats not saying the Doors on
> the car will open"
>
>
> So if you need a garage for your Drupal sites...there ya go...just don't
> plan on doing any meaningful views and e-commerce.
>
>

[Kyle Mathews-2]

Also, I used HostMonster very successfully for about a year for a
Drupal Ubercart site -- so it sounds like you guys just had a
miscommunication.

--Kyle Mathews

kyle.mathews2000.com/blog
http://twitter.com/kylemathews



On Fri, Nov 6, 2009 at 12:49 AM, Michael Prasuhn <mike@...> wrote:

> The Views module does not make use of MySQL views. As far as the database is
> concerned* all Views module does is build queries and run them just like any
> other query in Drupal. If the errors are SQL related you should take a look
> at the SQL views is generating and review that against your schema. I would
> wager that you most likely have a database schema that is out of date, and
> you need to run update.php. If the errors are PHP related, it is probably an
> incompatible version of PHP itself.
>
> -Mike
>
>
> * I know that Views does so much more and then some, however all the RDBMS
> will see is just another select query.
> __________________
> Michael Prasuhn
> mike@...
> http://mikeyp.net
>
> On Nov 5, 2009, at 10:51 PM, Jeff Greenberg wrote:
>
>> I figure others like me use shared hosting for their test and/or
>> development servers. Thought you'd like to know that what I found out
>> midstream in a project, with Views tossing errors at me with the Ubercart
>> views. HostMonster doesn't support mysql views.  I asked why they feel they
>> support Drupal, and they said that they do, just not views. I said that's
>> like saying they support it, just not php. Their response was, "Actually its
>> like saying we support a Car being in our garage.. thats not saying the
>> Doors on the car will open"
>>
>>
>> So if you need a garage for your Drupal sites...there ya go...just don't
>> plan on doing any meaningful views and e-commerce.
>>
>
>

[Jeff Greenberg-3]

Michael Prasuhn wrote:

> The Views module does not make use of MySQL views. As far as the
> database is concerned* all Views module does is build queries and run
> them just like any other query in Drupal. If the errors are SQL
> related you should take a look at the SQL views is generating and
> review that against your schema. I would wager that you most likely
> have a database schema that is out of date, and you need to run
> update.php. If the errors are PHP related, it is probably an
> incompatible version of PHP itself.
>
It's the Ubercart Views module that does.

[Jim Taylor-3]

Jeff,

I think you're barking up the wrong tree on this one, uc_views is simply ading additional views based on the views module.  It not doing anything that vanila views does not in other word it does not use SQL Views.

Jim

On Fri, Nov 6, 2009 at 11:07 AM, Jeff Greenberg <jeff@...> wrote:

Michael Prasuhn wrote:

The Views module does not make use of MySQL views. As far as the database is concerned* all Views module does is build queries and run them just like any other query in Drupal. If the errors are SQL related you should take a look at the SQL views is generating and review that against your schema. I would wager that you most likely have a database schema that is out of date, and you need to run update.php. If the errors are PHP related, it is probably an incompatible version of PHP itself.

It's the Ubercart Views module that does.

[Jeff Greenberg-3]

Jim Taylor wrote:
> Jeff,
>
> I think you're barking up the wrong tree on this one, uc_views is
> simply ading additional views based on the views module.  It not doing
> anything that vanila views does not in other word it does not use SQL
> Views.
>
> Jim
>
Well, perhaps, but since this is in the module install:
   db_query("CREATE VIEW {uc_order_products_qty_vw}
(nid,order_count,avg_qty,sum_qty,max_qty,min_qty)  AS SELECT `op`.`nid`
AS `nid`, COUNT(`op`.`nid`) AS `order_count`,AVG(`op`.`qty`) AS
`avg_qty`, SUM(`op`.`qty`) AS `sum_qty`,MAX(`op`.`qty`) AS `max_qty`,
MIN(`op`.`qty`) AS `min_qty` FROM {uc_order_products} `op` GROUP BY
`op`.`nid` ORDER BY `op`.`nid`");

along with two others, and since that Popular Products view uses them,
and since the module description in projects says that Mysql Views
create permissions are needed...I think I'm barking in the right direction.

[Jim Taylor-3]

good point, my bad.

On Fri, Nov 6, 2009 at 11:52 AM, Jeff Greenberg <jeff@...> wrote:

Jim Taylor wrote:

Jeff,

I think you're barking up the wrong tree on this one, uc_views is simply ading additional views based on the views module.  It not doing anything that vanila views does not in other word it does not use SQL Views.

Jim

Well, perhaps, but since this is in the module install:
 db_query("CREATE VIEW {uc_order_products_qty_vw} (nid,order_count,avg_qty,sum_qty,max_qty,min_qty)  AS SELECT `op`.`nid` AS `nid`, COUNT(`op`.`nid`) AS `order_count`,AVG(`op`.`qty`) AS `avg_qty`, SUM(`op`.`qty`) AS `sum_qty`,MAX(`op`.`qty`) AS `max_qty`, MIN(`op`.`qty`) AS `min_qty` FROM {uc_order_products} `op` GROUP BY `op`.`nid` ORDER BY `op`.`nid`");

along with two others, and since that Popular Products view uses them, and since the module description in projects says that Mysql Views create permissions are needed...I think I'm barking in the right direction.