Hello all.

I have a problem like this
"user warning: Table 'client_drpl1.cache_views' doe"

closed normal support 5.x-1.6-beta4 8 weeks 1 day ago


i am use upadate.php ,
table cache_views was created ,
but and i have this result :


[quote]

Drupal database update

  • user warning: Table 'u64340.view_view' doesn't exist query: ALTER TABLE view_view ADD is_cacheable int(1) in /home/u64340/demo.selikoff.ru/www/includes/database.mysql.inc on line 172.
  • user warning: Table 'u64340.view_view' doesn't exist query: SELECT name FROM view_view ORDER BY name in /home/u64340/demo.selikoff.ru/www/includes/database.mysql.inc on line 172.
  • user warning: Table 'u64340.view_view' doesn't exist query: ALTER TABLE view_view DROP query in /home/u64340/demo.selikoff.ru/www/includes/database.mysql.inc on line 172.
  • user warning: Table 'u64340.view_view' doesn't exist query: ALTER TABLE view_view DROP countquery in /home/u64340/demo.selikoff.ru/www/includes/database.mysql.inc on line 172.
  • user warning: Table 'u64340.view_view' doesn't exist query: ALTER TABLE view_view ADD menu_tab_default_parent_type varchar(10) in /home/u64340/demo.selikoff.ru/www/includes/database.mysql.inc on line 172.
  • user warning: Table 'u64340.view_view' doesn't exist query: ALTER TABLE view_view ADD menu_parent_title varchar(255) in /home/u64340/demo.selikoff.ru/www/includes/database.mysql.inc on line 172.
  • user warning: Table 'u64340.view_view' doesn't exist query: ALTER TABLE view_view ADD menu_parent_tab_weight int(4) in /home/u64340/demo.selikoff.ru/www/includes/database.mysql.inc on line 172.
  • user warning: Table 'u64340.view_view' doesn't exist query: UPDATE view_view SET menu_tab_default_parent_type = 'normal' WHERE menu_tab_default_parent_type = '' OR menu_tab_default_parent_type IS NULL in /home/u64340/demo.selikoff.ru/www/includes/database.mysql.inc on line 172.

Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged.
[/quote]


When I ON/OFF checkbox Views 5.x-1.6
In a page /admin/build/modules i have this Error Report:

  • user warning: Table 'u64340.view_view' doesn't exist query: SELECT * FROM view_view WHERE page = 1 in /home/u64340/demo.selikoff.ru/www/includes/database.mysql.inc on line 172.
  • user warning: Table 'u64340.view_view' doesn't exist query: SELECT * FROM view_view WHERE page = 1 in /home/u64340/demo.selikoff.ru/www/includes/database.mysql.inc on line 172.



-----------------------


"Views" can't create Tables? Why?

pls help.

Comments

merlinofchaos’s picture

merlinofchaos commented

Under some rare circumstances it seems Drupal's install process skips table creation entirely.

You should attempt to completely uninstall Views. On the modules page, disable Views; then click the uninstall tab that should appear on top of the page, and uninstall Views. Then re-enable it.

If that doesn't work, visit http://drupal.org/node/64165 for a manual method of completely uninstalling views. Then enable it again.

vidalmb’s picture

vidalmb commented

I had the same problem a couple of days ago.

I've seen last comment and I think it isn't precise: the manual method of http://drupal.org/node/64165 says that you must remove all views_ tables of the database, but doesn't say anything in case when activating views module it doesn't create newer ones (that was my problem).

It is really easy to fix it:

- Check your database to see if any views_ tables remain in it (erase all of them).

- Views module comes inside a directory called views, and it includes a file called views.install, then you get all the code inside that file (it is php code) and post it like a page in your site.

- Be careful that at the end of that page you must call all functions of views.install (if you don't do it, drupal won't execute any code).

- Check your database in order to see if all the tables were created.

- Then you erase the page and activate views module, that's all.

merlinofchaos’s picture

merlinofchaos commented

Uhh.

Don't follow vidalmb's advice. Trying to run views.install code manually might work but it might not. Manually deleting all of the tables and forcing Drupal to think VIews is fully uninstalled is the most effective way to do this.

selff’s picture

selff commented
Status: Active » Closed (fixed)

ye,
after the command
DELETE FROM system WHERE name LIKE 'views%';
module Views was installed successfully.
tnx!