Prerequisits:
Installed: Views 6.x-2.8
DB server: MySQL 5.1.41
Enabled modules: Views and Views UI
Need to upgrade to: Views 6.x-2.10
Steps to reproduce:
1. Disable Views and Views UI
2. Delete Views 6.x-2.8 module directory
3. Put Views 6.x-2.10 into modules directory
4. Run update.php - Views updated succesfully without any warnings/errors
5. Enable Views and Views UI 6.x-2.10
6. Every time I enable Views and Views UI 6.x-2.10 I get following warning:
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 views_display WHERE vid IN () ORDER BY vid, position in D:\xampplite\htdocs\sites\all\modules\views\includes\view.inc on line 1369.
If I disable Views module and enable it again I get same warning ALWAYS. But Views looks like working fine. So, I do not know how this impacts site functionality.
What I tried:
- cleared site cache, cleared views cache, cleared browser cache - bug still exists
- Found similar issue documented here: http://drupal.org/node/765352 for postgress database http://drupal.org/node/765352#comment-2825268
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | upgError616-617.jpg | 71.75 KB | lhugg |
Comments
Comment #1
.zLaW commentedI have the same problem after upgrading to 6.x-2.10. Everything done the same as above. MySQL 5.0.81, Drupal 6.16
After enabling views:
* The configuration options have been saved.
* Skipping broken view
and
* warning: Invalid argument supplied for foreach() in /homepages/17/d277729268/htdocs/drupal_615/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /homepages/17/d277729268/htdocs/drupal_615/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /homepages/17/d277729268/htdocs/drupal_615/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /homepages/17/d277729268/htdocs/drupal_615/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /homepages/17/d277729268/htdocs/drupal_615/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /homepages/17/d277729268/htdocs/drupal_615/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /homepages/17/d277729268/htdocs/drupal_615/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /homepages/17/d277729268/htdocs/drupal_615/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /homepages/17/d277729268/htdocs/drupal_615/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 views_display WHERE vid IN () ORDER BY vid, position in /homepages/17/d277729268/htdocs/drupal_615/sites/all/modules/views/includes/view.inc on line 1369.
Flushing caches doesn't remove this error, but all views (9 of them, coinciding with the # of warnings) appear to be working normally.
Looks like http://drupal.org/node/626834 again.
Comment #2
dawehnerI think so, too. So i mark this as duplicate of the other issue.
Perhaps post your detailed initial node, to be able to reproduce the problem. I fear this keeps a drupal core bug.
Comment #3
.zLaW commentedI'm sorry, but what do you mean by "post your detailed initial node"?
Comment #4
bassplaya commentedI get this when I upgrade to 6.x-2.10:
warning: Invalid argument supplied for foreach() in /Users/GraphicDesign/Sites/mysite/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /Users/GraphicDesign/Sites/mysite/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /Users/GraphicDesign/Sites/mysite/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /Users/GraphicDesign/Sites/mysite/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /Users/GraphicDesign/Sites/mysite/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /Users/GraphicDesign/Sites/mysite/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /Users/GraphicDesign/Sites/mysite/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /Users/GraphicDesign/Sites/mysite/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /Users/GraphicDesign/Sites/mysite/sites/all/modules/views/includes/view.inc on line 1747.
warning: Invalid argument supplied for foreach() in /Users/GraphicDesign/Sites/mysite/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 views_display WHERE vid IN () ORDER BY vid, position in /Users/GraphicDesign/Sites/mysite/sites/all/modules/views/includes/view.inc on line 1369.
Although I GOT a failure message when updating but I didn't save that line ..
Comment #5
lhugg commentedSame exact issue is occuring during upgrade from Acquia's version of 6.16 to 6.17. This would be Views 6.x-2.10-acquiadev-1.
Comment #6
dawehnerIs is right that you disabled and enabled views?
Comment #7
ressaI got this error message after updating Views to 6.x-2.11:
* warning: Invalid argument supplied for foreach() in /home/www/example.com/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /home/www/example.com/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /home/www/example.com/sites/all/modules/views/includes/view.inc on line 1747.
* warning: Invalid argument supplied for foreach() in /home/www/example.com/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 views_display WHERE vid IN () ORDER BY vid, position in /home/www/example.com/sites/all/modules/views/includes/view.inc on line 1369.
UPDATE: The web site seems to work fine. It might not be related, but I also updated CCK and FileField, and I had to re-enable CCK ImageField.
Comment #8
dawehner@ressa
That's a known issue with schema api. If you don't disable/enable views during the update this does not happen. If you clear the cache again nothing happens.
Comment #9
webservant316 commentedI just updated to Views 6.x-2.11 and got these errors and I did not disable Views before the upgrade, but simply took the site off line.
So what is the solution to the problem? Can the errors safely be ignored? After the errors, I cleared all caches and ran update again and there was no error reported. Furthermore my Views appear to display properly.
Comment #10
merlinofchaos commentedIf the error doesn't keep showing up then you don't need to be worried about it. I haven't found that we can do much about it. Schema API seems to just do things wrong sometimes, and I can't figure out why.
Comment #11
dawehner#626834: Disable then enable views displays errors