user warning: Table 'drupal_insight.views_view' doesn't exist

complete mssg:

user warning: Table 'drupal_insight.views_view' doesn't exist query: SELECT DISTINCT v.* FROM views_view v INNER JOIN views_display d ON v.vid = d.vid WHERE d.url IS NOT NULL AND d.url <> '' in /var/www/vhosts/insight-communication.net/httpdocs/modules/views/includes/view.inc on line 505.

i'll poke around, but any thoughts?
thx,
m

Comments

marqpdx’s picture

marqpdx commented
Title: just got this when enabling Views in a new 6rc1 druapal --> drupal_insight.views_view' doesn't exist » Views in a new 6rc1 drupal --> drupal_insight.views_view' doesn't exist
tanoshimi’s picture

tanoshimi commented

Isn't the 6.x-2.x-dev release of views the one which states: Views 2 dev; currently not even a little bit usable.?

marqpdx’s picture

marqpdx commented

i can say that i can't get it working. it's looking for tables named 'views_*' when the 5.x version used tables 'view_*'

thought i'd give it a spin...

thx,
m

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Postponed

Views 2 doesn't have any upgrade logic; so if you're installing this on a site you updated, and Views had previously been installed, it won't have created the new tables.

Views 2 uses a totally different schema from Views 1.

I wouldn't bother trying to play with Views right now; there isn't anything to see as there is no UI right now.

dixon_’s picture

dixon_
he/him
Primary language English
Location France
commented
Status: Active » Postponed

I know the UI is still in heavy development. But I thought I reopen this issue as I am getting almost the same error as above, but on a fresh Drupal 6.1 install, with the latest CVS release of Views 2.x-dev (2008-03-11).

The message appears on some pages like admin/build/modules and admin/build/block and looks like this:

user warning: Table 'drupal.views_view' doesn't exist query: SELECT DISTINCT v.* FROM views_view v in C:\wamp\apache\htdocs\drupal\sites\all\modules\views\includes\view.inc on line 783.

In admin/build/views I am also getting the following messages:

user warning: Table 'drupal.views_object_cache' doesn't exist query: SELECT * FROM views_object_cache WHERE sid = 'hl4gf8ihgn8vrndm6oa3t20rr1' AND obj = 'view' AND name = '' in C:\wamp\apache\htdocs\drupal\sites\all\modules\views\includes\cache.inc on line 219.

user warning: Table 'drupal.views_view' doesn't exist query: SELECT * FROM views_view WHERE name = '' in C:\wamp\apache\htdocs\drupal\sites\all\modules\views\includes\view.inc on line 734.

I hope this can provide some help in the development of this excellent module. Thanks!

dixon_’s picture

dixon_
he/him
Primary language English
Location France
commented
Title: Views in a new 6rc1 drupal --> drupal_insight.views_view' doesn't exist » Error on fresh Drupal 6.1 - 'drupal.views_view' doesn't exist
Status: Postponed » Active
merlinofchaos’s picture

merlinofchaos commented

Oh good grief.

First, before I ruffle any feathers please understand that setting a postponed issue back to active is, in my view, basically a demand.

Now, please read some quotes:

From this very issue:

Views 2 doesn't have any upgrade logic; so if you're installing this on a site you updated, and Views had previously been installed, it won't have created the new tables.

From http://drupal.org/project/views :

Important: Views 2 alpha is not feature complete. It does not have an upgrade path, and it will not work on a site that has had Views 1 installed on it without first performing an 'uninstall' of the module. It is missing lots of features, but you can play with it, at least. At this time it appears not to work on PHP4.

How can I say this any more clearly and succinctly? NO UPGRADE PATH.

If you previously had Views 1 installed, IT WON'T WORK.

dixon_’s picture

dixon_
he/him
Primary language English
Location France
commented

Hi again.

Maybe I wasn't clear enought. I know that Views 2 is still under heavy development and is not feature complete. I know that. I posted this issue in good hope that it would help you developers in some way. If that wasn't the case, I'm so sorry. Relly sorry.

Again, thanks for your tremendous work, with this wonderful module. I won't steal your time any more...

Daniel Berman’s picture

Daniel Berman commented
Title: Error on fresh Drupal 6.1 - 'drupal.views_view' doesn't exist » Error on fresh Drupal 6.6 - 'drupal.views_view' doesn't exist
Version: 6.x-2.x-dev » 6.x-2.1

Curiously still getting this issue with fresh install of Views 6.x-2.1 and the latest dev. version running Drupal 6.6. Apparently this bug hasn't gotten squashed yet.

Several hours later.....

A temporary fix that worked for me:

- Separate fresh install of drupal 6.6 with a fresh install of the latest dev. version of views. With phpMyAdmin I dropped all of the site tables, except for the three associated with views and exported them. Then I opened the SQL file and changed the database name back to my original site database name and then imported the file back into my main database. A major mysql hack, but it seems to be working. I have views back without any errors.

esmerel’s picture

esmerel commented
Status: Postponed » Closed (won't fix)

Nobody's complained about this problem in a year and a half, views has been stable for much of that time.