Error after migrating
Posted: 18 Dec 2015, 11:50
Hi,
A followup to my previous topic "Table missing after "upgrade""
When trying to open a document I get this SQL-error:
Unknown column 'c.tokenhits' in 'field list' SQL=SELECT c.catid, c.filename, c.directlink, c.link_external, c.access, c.confirm_license, c.metakey, c.metadesc, cc.access as cataccess, cc.accessuserid as cataccessuserid, c.tokenhits FROM snvj5_phocadownload AS c, snvj5_phocadownload_categories AS cc WHERE c.id = 146 AND c.published = 1 AND c.approved = 1 AND c.catid = cc.id AND cc.access IN (1,1,2,3) AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2015-12-18 09:37:21' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2015-12-18 09:37:21' ) ORDER BY c.ordering LIMIT 0, 1
//Dennis
A followup to my previous topic "Table missing after "upgrade""
When trying to open a document I get this SQL-error:
Unknown column 'c.tokenhits' in 'field list' SQL=SELECT c.catid, c.filename, c.directlink, c.link_external, c.access, c.confirm_license, c.metakey, c.metadesc, cc.access as cataccess, cc.accessuserid as cataccessuserid, c.tokenhits FROM snvj5_phocadownload AS c, snvj5_phocadownload_categories AS cc WHERE c.id = 146 AND c.published = 1 AND c.approved = 1 AND c.catid = cc.id AND cc.access IN (1,1,2,3) AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2015-12-18 09:37:21' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2015-12-18 09:37:21' ) ORDER BY c.ordering LIMIT 0, 1
//Dennis