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

shythai’s picture

subscribes

paulbeaney’s picture

Hi,

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

rubencausyn’s picture

Issue summary: View changes

removed some sensitive data.