hi .. thanks for the eye here:
I updated the module, ran update.php..which bombed because of a memory limit.
so i fixed the memory limit, but I think i may have altered, deleted..or not added tables..

the DEVEL module offers up this error:
'Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'AS expression, \'\' AS field_data_body__entity_type
FROM
ra_node node
WHERE (( (n\' at line 1'
in views_plugin_query_default->execute() (line 1354 of /sites/all/modules/views/plugins/views_plugin_query_default.inc).

The standard error message I receive is :

Notice: Undefined index: base table in views_handler_field_field->query() (line 80 of /sites/all/modules/views/modules/field/views_handler_field_field.inc).
the corresponding line of code is 

    $base_table_alias = $base_table = $this->definition['base table'];


Notice: Undefined index: in views_handler_field_field->query() (line 110 of /sites/all/modules/views/modules/field/views_handler_field_field.inc).
the corresponding line of code is 

    $entity_type = $this->definition['entity_tables'][$base_table];


Notice: Undefined index: entity keys in views_handler_field_field->query() (line 115 of /sites/all/modules/views/modules/field/views_handler_field_field.inc).

and the corresponding line of code is

      $this->field_alias = $this->query->add_field($base_table_alias, $entity_info['entity keys']['id'], '', $params);

Trying to determine a course of action here. Is a field missing? a table?
my back up is a week old and of course, isn't current..or I'd post the backup and start over.. (my mistake)
right now, i cannot view / edit the listing of content.
content is available and i can edit content by going to individual items.. just not the page that lets me filter content.. listing ..

any thoughts
thanks.. kinda could use this.. :)

Comments

jackhutton’s picture

jackhutton commented

I just get 'The requested page could not be found."
I can add content..

jackhutton’s picture

jackhutton commented

.. i should add. I did install the 7.x 3 dev version..
ran update..
then replaced it with the beta when errors began to render..
so, presently, i have the 7.x 3 beta version running.. thx.

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (duplicate)

This is the result of a core bug in Drupal 7.2 -- see http://drupal.org/node/1170312#comment-4547662 for a workaround. You'll need to udpate to latest Drupal 7.x-dev or risk this happening again even after you correct it.

jackhutton’s picture

jackhutton commented

I'll review that thread.. Greatly appreciated.

jackhutton’s picture

jackhutton commented

posted my follow ups questions over here.
http://drupal.org/node/1170312#comment-4547662

thx

merlinofchaos’s picture

merlinofchaos commented
Status: Closed (duplicate) » Active

Hm. I may've been over optimistic that it was really just the problem of the UI disappearing. There may be deeper problems.

ARe you really running 7.x-3.0-beta3? Try updating to 7.x-3.x-dev?

jackhutton’s picture

jackhutton commented

thanks for the eye:

Seems so: on Updates Tab

Drupal core 7.x-dev (2011-Jun-15)
Views 7.x-3.x-dev (2011-Jun-16)
Chaos tool suite 7.x-1.0-beta1

I have not run update.php
the status report recommends that I run the db update script..but, in light of the post on the other page; I'm hesitant.

just tried clearing the cache a number of time;
flushing the cache produces these errors:


Warning: Invalid argument supplied for foreach() in field_views_field_default_views_data() (line 206 of /home/sites/all/modules/views/modules/field.views.inc).
Warning: Invalid argument supplied for foreach() in field_views_field_default_views_data() (line 315 of /home/sites/all/modules/views/modules/field.views.inc).
Warning: Invalid argument supplied for foreach() in field_views_field_default_views_data() (line 315 of /home/sites/all/modules/views/modules/field.views.inc).
Notice: Undefined index: nid in view->fix_missing_relationships() (line 426 of /home/ruschmeyer/sites/all/modules/views/includes/view.inc).
Warning: Invalid argument supplied for foreach() in field_views_field_default_views_data() (line 206 of /home/sites/all/modules/views/modules/field.views.inc).
Warning: Invalid argument supplied for foreach() in field_views_field_default_views_data() (line 315 of /home/sites/all/modules/views/modules/field.views.inc).
Warning: Invalid argument supplied for foreach() in field_views_field_default_views_data() (line 315 of /home/ruschmeyer/sites/all/modules/views/modules/field.views.inc).

The DEVEL renders these "Queries exceeding 5 ms are highlighted."
out of 299 queries these were the ones exceeding 5 ms

9.75 DrupalDatabaseCache::setP A
INSERT INTO ra_cache_bootstrap (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)

a bit long here: 10.39ms

10.39 10DrupalDatabaseCache::setP A
INSERT INTO ra_cache (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)


5.2110DrupalDatabaseCache::setP A
INSERT INTO ra_cache (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)


6.87 15DrupalDatabaseCache::setP A
INSERT INTO ra_cache_views (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)


11.19 37_registry_check_codeP A E
SELECT filename FROM ra_registry WHERE name = :name AND type = :type


9.9 11_menu_build_treeP A E
SELECT ml.*, m.load_functions AS load_functions, m.to_arg_functions AS to_arg_functions, m.access_callback AS access_callback, m.access_arguments AS access_arguments, m.page_callback AS page_callback, m.page_arguments AS page_arguments, m.delivery_callback AS delivery_callback, m.tab_parent AS tab_parent, m.tab_root AS tab_root, m.title AS title, m.title_callback AS title_callback, m.title_arguments AS title_arguments, m.theme_callback AS theme_callback, m.theme_arguments AS theme_arguments, m.type AS type, m.description AS description FROM ra_menu_links ml LEFT OUTER JOIN ra_menu_router m ON m.path = ml.router_path WHERE (ml.menu_name = :db_condition_placeholder_0) ORDER BY p1 ASC, p2 ASC, p3 ASC, p4 ASC, p5 ASC, p6 ASC, p7 ASC, p8 ASC, p9 ASC

longer query time here 39.74:

39.74 11DrupalDatabaseCache::setP A
INSERT INTO ra_cache_menu (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)

and another longer time here 37.41ms

37.41 11DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM ra_cache_menu cache_menu WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE

And the contents page-node (admin/content/node) returns a page of unstyled errors:


Fatal error: Call to a member function pre_render() on a non-object in /home/sites/all/modules/views/includes/view.inc on line 992
Executed 49 queries in 46.63 ms. Queries exceeding 5 ms are highlighted.
ms
#
where
ops
query
target
0.16
5
DrupalDatabaseCache::getMultiple
P A E
SELECT cid, data, created, expire, serialized FROM ra_cache_bootstrap WHERE cid IN (:cids_0)
default
0.05
1
language_list
P A E
SELECT * FROM ra_languages ORDER BY weight ASC, name ASC
default
0.1
5
DrupalDatabaseCache::getMultiple
P A E
SELECT cid, data, created, expire, serialized FROM ra_cache_bootstrap WHERE cid IN (:cids_0)
default
1.97
5
DrupalDatabaseCache::getMultiple
P A E
SELECT cid, data, created, expire, serialized FROM ra_cache_bootstrap WHERE cid IN (:cids_0)
default
0.33
5
etcetera, etcetera... there's more but follows this pattern

flushing the cache again returns mostly the same results - times vary;

Thank you for reviewing all of this..
I really appreciate your help.

jackhutton’s picture

jackhutton commented
Version: 7.x-3.0-beta3 » 7.x-3.x-dev

saw a newer version of views 7.x-3.x-dev dated june 17 was posted
uploaded
ran an update script which did clean some issues up but continued seeing errors -

cleared cached from the performance tabs (a few times) w repeated errors

Notice: Undefined index: nid in view->fix_missing_relationships() (line 426 of /home/sites/all/modules/views/includes/view.inc).

ran webchick's fix item #40 of http://drupal.org/node/1170312#comment-4547662

Still receive a The requested page could not be found. for the admin/content node
the devel module shows a single query that took a long time to execute

26.45 1 _system_date_format_types_build P A E
SELECT dft.type, dft.title, dft.locked FROM ra_date_format_type dft ORDER BY dft.title

haven't cleared caches again.

Thanks for the help.

jackhutton’s picture

jackhutton commented

forgot to mention.. the content page renders w. 'page not found' but it is styled now - probably has little impact on the issue, but just a difference.. thx.

merlinofchaos’s picture

merlinofchaos commented

I'm a little confused. Views doesn't control "admin/content". There are a lot of conflicting messages in this issue. Are there multiple issues here?

Some of the stuff in #7 is fixed in the latest -dev, that much I'm sure of.

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Fixed

Notice: Undefined index: nid in view->fix_missing_relationships() (line 426 of /home/sites/all/modules/views/includes/view.inc)

I committed a fix that will prevent that notice. I'm not sure what else I can do on this issue. "admin/content" isn't driven by Views so shouldn't be related. Errors regarding field_views_field_default_views_data() are already fixed in -dev. Marking fixed for now, but I suspect your main problem will still be there, but isn't actually Views.

merlinofchaos’s picture

merlinofchaos commented

It looks like your problem is that Views Bulk Operations has changed and admin_views hasn't caught up. The style plugin it's using is no longer valid. You should disable admin_views module until this is fixed.

jackhutton’s picture

jackhutton commented

That did it!
I just really want to acknowledge the extensive help you all offered!

For the time being, I've disabled the admin_views - and the admin/content node renders well
I'll keep my eyes open for updates.

Thank you very much.

juroon’s picture

juroon commented

Wow, thanks! Disabling Administration views put me back in business with no other workarounds or patches.

I was getting the admin/content/node page not found error in my log, and my content was not showing up on /?q=admin/content. It's a new site, so I started over from scratch and still ended up with the same problem. Eventually I found info about the core bug, so it would have taken me forever to try disabling that particular module.

This way maybe I can get by until the next update.

Thank you, thank you, thank you!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

davidinnes’s picture

davidinnes commented
Version: 7.x-3.x-dev » 7.x-3.0-rc3
Priority: Normal » Major
Status: Closed (fixed) » Active

It's back.

I just got the content-page-not-found error on a clean installation of Drupal 7.10 with admin_views 7.x-3.0-rc1.

Once again, disabling admin_views corrected the problem.

---

p.s. Is it ok to re-open this bug or should I file a new one? I've assigned it "major" status because making the content administration page inaccessible seems major.

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Fixed

The problem is probably still admin_views

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.