Closed (won't fix)
Project:
Views (for Drupal 7)
Version:
4.7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
8 Jul 2006 at 18:47 UTC
Updated:
7 Sep 2006 at 05:11 UTC
user warning: Unknown column 'page' in 'where clause' query: SELECT * FROM view_view WHERE page = 1 in /Volumes/INPROL_DATA/WebServer/Documents/includes/database.mysql.inc on line 120.
Keep getting this error. Removed Views module. Dropped Views tables. Reinstalled Views module (downloaded from project/modules, not cvs).
Comments
Comment #1
trailerparkopera commentedI think I've narrowed down the problem: views.install isn't working in the cvs version, at least for my system. Problems went away when I manually installed Views tables used code stripped from the .install file. Here it is if anyone else needs it.
Comment #2
merlinofchaos commentedCould you give me the results of a 'describe view_view'?
Comment #3
merlinofchaos commentedWhoops, missed the followup when I replied. Sorry.
Comment #4
mariuss commentedSame problem here.
Also, upgraded from Drupal 4.6 and the views module did not upgarde the tables at all.
Comment #5
merlinofchaos commentedFor the 4.6 upgrade, you are probably stuck dropping your tables and reinstalling Views. So much changed in the table layout that an upgrade path never got written from 4.6 to 4.7, and the .install files didn't exist when I made the changeover, so there wasn't really an easy way to do it.
See http://drupal.org/node/64165 for instructions on how to reset the tables and re-install the module.
Comment #6
merlinofchaos commented