Download

Views cvs
Download: http://ftp.osuosl.org/pub/drupal/files/projects/views-cvs.tar.gz
Size: 66.03 KB
md5_file hash: 51b0f16ed24ee6b736537dd4da82e63a
Last updated: April 26, 2006 - 02:30

Extract to Desktop, OS X 10.4.4
FTP upload 'views' folder to /public_html/modules
Check example.com/admin/modules
'view' and 'view_ui' listed
example.com/update.php -> no updates available
enable view and view_ui

Warning: Table 'example_dbname.view_view' doesn't exist query: SELECT * FROM view_view WHERE page = 1 in /home/example/public_html/includes/database.mysql.inc on line 120

The configuration options have been saved.

goto example.com/update.php -> no updates available

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.

goto example.com/admin

Warning: Table 'example_dbname.view_view' doesn't exist query: SELECT * FROM view_view WHERE page = 1 in /home/example/public_html/includes/database.mysql.inc on line 120

goto example.com/admin/views

Warning: Table 'example_dbname.view_view' doesn't exist query: SELECT COUNT(*) FROM view_view in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_view' doesn't exist query: SELECT vid, name, description, menu_title, page_title, block_title, url, page, menu, block FROM view_view ORDER BY name LIMIT 0, 25 in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_view' doesn't exist query: SELECT name FROM view_view in /home/example/public_html/includes/database.mysql.inc on line 120

add 'popular_alltime' view

Warning: Table 'example_dbname.view_view' doesn't exist query: SELECT vid FROM view_view WHERE name='popular_alltime' in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_view' doesn't exist query: INSERT INTO view_view (vid, changed, name, access, description, page, url, page_type, page_title, use_pager, breadcrumb_no_home, nodes_per_page, page_header, page_header_format, page_footer, page_footer_format, page_empty, page_empty_format, menu, menu_tab, menu_tab_default, menu_tab_weight, menu_title, block, block_type, block_title, nodes_per_block, block_more, block_use_page_header, block_header, block_header_format, block_use_page_footer, block_footer, block_footer_format, block_use_page_empty, block_empty, block_empty_format, view_args_php, query, countquery) VALUES (17, 1146425903, 'popular_alltime', '', 'Nodes sorted by total page-views', 1, 'popular/alltime', 'table', 'all-time popular content', 1, 0, 20, '', 1, '', 1, '', 1, 1, 1, 0, '', '', 1, 'list', 'all-time popular content', 5, 1, 0, '', 1, 0 in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_sort' doesn't exist query: INSERT INTO view_sort (vid, position, field, sortorder, options) VALUES (17, 0, 'node_counter.totalcount', 'DESC', '') in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_tablefield' doesn't exist query: INSERT INTO view_tablefield (vid, tablename, field, label, handler, sortable, defaultsort, options, position) VALUES (17, 'node', 'type', 'type', '', 1, '0', '', 0) in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_tablefield' doesn't exist query: INSERT INTO view_tablefield (vid, tablename, field, label, handler, sortable, defaultsort, options, position) VALUES (17, 'node', 'title', 'title', 'views_handler_field_nodelink', 1, '0', '', 1) in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_tablefield' doesn't exist query: INSERT INTO view_tablefield (vid, tablename, field, label, handler, sortable, defaultsort, options, position) VALUES (17, 'users', 'name', 'author', '', 1, '0', '', 2) in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_tablefield' doesn't exist query: INSERT INTO view_tablefield (vid, tablename, field, label, handler, sortable, defaultsort, options, position) VALUES (17, 'node', 'created', 'created', 'views_handler_field_since', 1, '0', '', 3) in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_tablefield' doesn't exist query: INSERT INTO view_tablefield (vid, tablename, field, label, handler, sortable, defaultsort, options, position) VALUES (17, 'node_counter', 'totalcount', 'reads', '', 1, 'DESC', '', 4) in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_filter' doesn't exist query: INSERT INTO view_filter (vid, tablename, field, value, operator, options, position) VALUES (17, '', 'node.status', '1', '=', '', 0) in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_view' doesn't exist query: SELECT * FROM view_view WHERE page = 1 in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Table 'example_dbname.view_view' doesn't exist query: SELECT * FROM view_view WHERE page = 1 in /home/example/public_html/includes/database.mysql.inc on line 120

Warning: Cannot modify header information - headers already sent by (output started at /home/example/public_html/includes/database.mysql.inc:120) in /home/example/public_html/includes/common.inc on line 266

Drupal version:

Drupal 4.7.0-rc4
Download: http://ftp.osuosl.org/pub/drupal/files/projects/drupal-4.7.0-rc4.tar.gz
Size: 471.96 KB
md5_file hash: c7f3b8ccd1753b389c96336013cf36f0
First released: April 28, 2006 - 10:01
Last updated: April 28, 2006 - 09:53

upgraded yesterday from:

Drupal 4.6.5
Download: http://ftp.osuosl.org/pub/drupal/files/projects/drupal-4.6.5.tar.gz
Size: 445.31 KB
md5_file hash: b70ffc0066dece5d6a6b14907042ce9f
First released: December 12, 2005 - 15:20
Last updated: April 7, 2006 - 19:15

Views did not function in 4.6.5 either. Similar errors.

Comments

merlinofchaos’s picture

merlinofchaos commented

In 4.6.5 you had to install the tables manually. 4.7 uses the new .install method which I'm kind of wishing hadn't been done just now, since I've seen a few reports of it intermittently not working.

Question: Did you have Views installed prior to the update from 4.6.5 to 4.7? Had you ever had it installed at any time?

You've got a couple of ways to fix this:

1) open views.install, cut & paste the queries into your mysql client. Be sure to remove the {} from around the tablenames, but otherwise the queries can be cut & paste just find.

2) Alternatively, install devel.module and use its 'reinstall module' option (I believe it has to be enabled either in menu.module or in admin/devel/settings to show up; I can't remember for sure at this time).

merlinofchaos’s picture

merlinofchaos commented

Option #3:

Actually this one is much easier than the other 2.

Execute this query:

DELETE FROM system WHERE name in ('views', 'views_ui');

Then go to admin/modules. views and views_ui should no longer show up as enabled.

Enable them. In the messages it should say that the views tables were successfully created.

JasonGrizzlebee’s picture

JasonGrizzlebee commented
Title: Table 'example_dbname.view_view' doesn't exist; after install » getting there

I would try #3, as I do have Devel installed and trying to reinstall hasn't been working, but I took the first route, shaved views.install down to the following code and ran the query in PHP admin. Tables were created and I was able to add all five default views, no errors (frontpage, popular_alltime, popular_recent, taxonomy_term and tracker) There may be more glitches to follow, but as of now, all is good.

CREATE TABLE if not exists view_view (
        vid int(10) unsigned NOT NULL default '0',
        name varchar(32) NOT NULL UNIQUE,
        description varchar(255),
        access varchar(255),
        -- page fields
        page int(1),
        page_title varchar(255),
        page_header longtext,
        page_header_format int(4) NOT NULL,
        page_empty longtext,
        page_empty_format int(4) NOT NULL,
        page_footer longtext,
        page_footer_format int(4) NOT NULL,
        page_type varchar(20),
        use_pager int(1),
        nodes_per_page int(2), -- yes, no more than 99
        url varchar(255),
        -- menu fields
        menu int(1),
        menu_tab int(1),
        menu_tab_default int(1),
        menu_tab_weight int(4),
        menu_title varchar(255),
        -- block fields
        block int(1),
        block_title varchar(255),
        block_use_page_header int(1),
        block_header longtext,
        block_header_format int(4) NOT NULL,
        block_use_page_footer int(1),
        block_footer longtext,
        block_footer_format int(4) NOT NULL,
        block_use_page_empty int(1),
        block_empty longtext,
        block_empty_format int(4) NOT NULL,
        block_type varchar(20),
        nodes_per_block int(5),
        block_more int(1),
        -- breadcrumb
        breadcrumb_no_home int(1), -- true means start breadcrumb trail from 'Home'.
        -- other
        changed int(11),
        query longtext,
        countquery longtext,
        view_args_php longtext,
        PRIMARY KEY (vid),
        KEY (name)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE if not exists view_sort (
        vid int(10) unsigned NOT NULL default '0',
        position int(2),
        field varchar(255),
        sortorder varchar(5),
        options varchar(255),
        tablename varchar(255),
        KEY (vid)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE if not exists view_argument (
        vid int(10) unsigned NOT NULL default '0',
        type varchar(25),
        argdefault varchar(255),
        title varchar(255),
        options varchar(255),
        position int(2),
        KEY (vid)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE if not exists view_tablefield (
        vid int(10) unsigned NOT NULL default '0',
        tablename varchar(255),
        field varchar(255),
        label varchar(255),
        handler varchar(255),
        sortable int(1),
        defaultsort varchar(5),
        options varchar(255),
        position int(2),
        KEY (vid)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE if not exists view_filter (
        vid int(10) unsigned NOT NULL default '0',
        tablename varchar(255),
        field varchar(255),
        value longtext,
        operator varchar(20),
        options varchar(255),
        position int(2),
        KEY (vid)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE if not exists view_exposed_filter (
        vid int(10) unsigned NOT NULL default '0',
        field varchar(255),
        label varchar(255),
        optional int(1),
        is_default int(1),
        operator int(1),
        single int(1),
        position int(2),
        KEY (vid)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
JasonGrizzlebee’s picture

JasonGrizzlebee commented
Title: getting there » Table 'example_dbname.view_view' doesn't exist

oops, title

JasonGrizzlebee’s picture

JasonGrizzlebee commented
Status: Active » Fixed

I'd say that got it. Thank you.

JasonGrizzlebee’s picture

JasonGrizzlebee commented

option #3 was the better choice. see here: http://drupal.org/node/61183

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)