Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
on /admin/reports/page-title there's the error:
Debug:
'Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column \'page_title.language\' in \'field list\''
in views_plugin_query_default->execute() (line 1380 of xxxx/sites/all/modules/views/plugins/views_plugin_query_default.inc).
I tracked this down to be related to the "content translation" core module (7.8).
Comments
Comment #1
shythai CreditAttribution: shythai commentedsubscribes
Comment #2
paulbeaney CreditAttribution: paulbeaney commentedHi,
I have got round this (possibly breaking title translations) by adding this a field to the table page_title. The table schema now looks like this:
CREATE TABLE `page_title` (
`type` varchar(15) NOT NULL default 'node',
`id` int(10) unsigned NOT NULL default '0',
`page_title` varchar(255) NOT NULL default '',
`language` char(2) default 'en',
PRIMARY KEY (`type`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Regards,
- Paul
Comment #2.0
rubencausyn CreditAttribution: rubencausyn commentedremoved some sensitive data.