By NatCromlech on

Hello everyone and thanks in advance for any advice you can offer me.

I have a site running Drupal 4.7.4. The VIEWS module was installed/enabled a while ago, but I just now got around to messing about with it. When I tried to save a view that I created the following error happened:

user warning: Unknown column 'page_footer' in 'field list' query: INSERT INTO view_view (vid, changed, ...

I looked at my database and found that the 'page_footer' column was indeed missing from the view_view table. I disabled views and views_ui and then re-enabled them. I tried to add a new view at that point and received the same error.

I just now disabled the views modules and dropped all view_* tables from my Drupal database. I then downloaded the views module again from drupal.org. When I tried to enabled it, I received the following error:

user warning: Table 'leppoton_drupal.view_view' doesn't exist query: SELECT * FROM view_view WHERE page = 1 in /home/leppoton/public_html/includes/database.mysql.inc on line 121.

Again, thanks for any advice.

--Nathan

⋅ Categories: Drupal 4.7.x

Comments

vm’s picture

vm commented

update to the latest versions of the views module and don't forget to run update.php after doing so.

see if this action removes the error. If not. you can install the devel module which will let you reinstall modules, including setting up of database tables.

Updating to the latest version of views should fix your problem, I believe.

NatCromlech’s picture

NatCromlech commented

Thanks for pointing out that feature in the devel module. That did the trick. I had the latest version of views already.

Again. Thanks for the quick response from both of you.

Now on to learning about creating views.

cog.rusty’s picture

cog.rusty commented

Probably the entries left in the 'sytem' table in the database tell Drupal that the module is up to date, so its tables are not created when it is installed.