Closed (fixed)
Project:
Views (for Drupal 7)
Version:
6.x-2.12
Component:
Miscellaneous
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
16 Dec 2010 at 05:49 UTC
Updated:
2 Jan 2011 at 07:30 UTC
I had just updated to Drupal 6.20 and then updated to the latest Views. The update.php process went well but for some reason Views and Views UI was disabled after the update. Enabling them in the admin/build/modules results in this error message. Views has been running smoothly for I don't know how long before this. The server is running MySQL 5.0.90 and PHP 5.2.12.
warning: Invalid argument supplied for foreach() in /users/home/spot/domains/sjoskogen.se/web/public/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /users/home/spot/domains/sjoskogen.se/web/public/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /users/home/spot/domains/sjoskogen.se/web/public/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /users/home/spot/domains/sjoskogen.se/web/public/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /users/home/spot/domains/sjoskogen.se/web/public/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /users/home/spot/domains/sjoskogen.se/web/public/sites/all/modules/views/includes/view.inc on line 1747.
user warning: 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 ') ORDER BY vid, position' at line 1 query: SELECT * FROM sjoskogen_views_display WHERE vid IN () ORDER BY vid, position in /users/home/spot/domains/sjoskogen.se/web/public/sites/all/modules/views/includes/view.inc on line 1369.
Comments
Comment #1
merlinofchaos commentedCan you try doing a cache clear? There's a couple of ways to clear cache. The easiest is from the performance menu.
Comment #2
dadderley commentedHi I just updated.
I did not clear the cached data before running the update.
I got this error:
This was somewhat unsettling.
Fortunately, I read this post before my updating adventure.
So I went to my backup.
I flushed my cache like you suggested and ran the update.
Success, all is good. Hopefully this information is helpful.
Comment #3
dawehnerOkay the webserver couldn't read from view.inc. you might missed it on your update.
Comment #4
NiklasBr commentedNo, I hadn't cleared any caches besides disabling Boost and running cron right before running update.php. As I said, this happened only once, after re-enabling the modules because they had unexpectedly been disabled during the update process.