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.
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@ayendesigns.com> 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.
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@mikeyp.net 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.
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@mikeyp.net> 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@mikeyp.net 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.
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, 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@ayendesigns.com>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.
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.
good point, my bad. On Fri, Nov 6, 2009 at 11:52 AM, Jeff Greenberg <jeff@ayendesigns.com>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.
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@ayendesigns.com> 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.
participants (6)
-
Jeff Greenberg -
Jim Taylor -
Kieran Lal -
Kyle Mathews -
Maurice Mengel -
Michael Prasuhn