By david.ng@vtselaw.com.au on

Hi all,

I work for a law firm and one of our former employees set up our website using Drupal a year or two ago. I've been trying to update it today, but none of my attempted changes can be saved. Every time I try to save the page I get the following message:

The website encountered an unexpected error. Please try again later.

(and then the following in a red box of death)

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'revision_id' in 'where clause': DELETE FROM {metatag} WHERE (entity_type = :db_condition_placeholder_0) AND (entity_id = :db_condition_placeholder_1) AND (revision_id = :db_condition_placeholder_2) AND (language = :db_condition_placeholder_3) ; Array ( [:db_condition_placeholder_0] => node [:db_condition_placeholder_1] => 17 [:db_condition_placeholder_2] => 17 [:db_condition_placeholder_3] => en ) in metatag_metatags_save() (line 541 of /hsphere/local/home/vtselaw/vtselaw.com.au/sites/all/modules/metatag/metatag.module).

I have been trying for a few hours so the problem seems unlikely to resolve itself. Further, the error occurs in response to any change (even very minor ones) and to changes to any page on our website.

Our Drupal version seems to vary across different modules but is basically between 7.x-1.12 and 7.x-3.8. There are some new updates but I have so far been reluctant to install them for fear that it will break our website, especially now that our IT guru has left us.

Would really appreciate any advice and suggestions that other forumers can offer on this problem.

Thanks,

David

⋅ Categories: Drupal 7.x

Comments

nevets’s picture

nevets commented

Hope fully you are trying the update on a dev version of the site (and not the live site).

What steps have you taken so far to update the site?

david.ng@vtselaw.com.au’s picture

david.ng@vtselaw.com.au commented

Hey nevets,

It is the live site I am trying to update. Our IT guru set up a mock-up site but this is currently not working either, worse luck.

In terms of updating, all I have done is logged into the editing function (i.e. webaddress/user), gone to the relevant page, pressed the 'edit' tab at the top and then tried (originally) to insert some pictures and text and pressed the 'save' radio button down the bottom. It is when I press save that the error message comes up.

Once I got the error, I tried making smaller changes (i.e. just text, no images) and trying to change different pages, but to no avail - still get the error message.

Don't quite know what else to try ... our IT guru used to edit the site so I'm a little at sea.

Cheers,

David