After an unsuccessful update from Joomla 2.5 to 3.3, this error appeared:

500 - Unknown column 'a.mask' in 'field list' SQL=SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id FROM eoio_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM eoio_content AS a LEFT JOIN eoio_categories AS c on c.id = a.catid LEFT JOIN eoio_users AS u on u.id = a.created_by LEFT JOIN eoio_categories as parent ON parent.id = c.parent_id LEFT JOIN eoio_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM eoio_categories AS cat JOIN eoio_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 3 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-02-24 20:25:11') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-02-24 20:25:11') AND (a.state = 1 OR a.state =2)

Who can tell where to fix it? Rolling back did not help. Thank.

  • @juliyaya, If you are given an exhaustive answer, mark it as correct (click on the check mark next to the selected answer). - Vitalina
  • How ruled? It is possible in more detail. I have the same problem. - user207157

1 answer 1

@juliyaya , in essence, eoio_content ( "a" is her nickname / alias) is missing the mask attribute. Even if you add this attribute, it is possible that an error will appear in another request (degradation).

Here they write that it is impossible to fix . So editing pens is inevitable.

  • Thanks for the advice. The database has become crooked. Corrected. - juliyaya