Any ideas on how to fix this ?
If not, I can restore from backup...
Thanks !
- Jay
Unknown column 'ua.id' in 'on clause' SQL=SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title FROM tpjt8_content as a LEFT JOIN tpjt8_categories AS c ON c.id = a.catid LEFT JOIN tpjt8_users AS ua ON ua.id = a.created_by LEFT JOIN tpjt8_users AS um ON um.id = a.modified_by LEFT JOIN tpjt8_content_rating AS v ON a.id = v.content_id LEFT JOIN tpjt8_viewlevels AS vl ON a.access = vl.id LEFT JOIN tpjt8_languages AS l ON a.language = l.lang_code LEFT OUTER JOIN (select rsi.provider_id, rsi.order from tpjt8_roksprocket_items as rsi where module_id = 204) rsi on a.id = rsi.provider_id WHERE ((a.access IN(1,1,2,3) AND (a.state != -2)) AND a.catid IN (15)) ORDER BY rsi.order
Unknown column 'ua.id' in 'on clause' SQL=SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title FROM tpjt8_content as a LEFT JOIN tpjt8_categories AS c ON c.id = a.catid LEFT JOIN tpjt8_users AS ua ON ua.id = a.created_by LEFT JOIN tpjt8_users AS um ON um.id = a.modified_by LEFT JOIN tpjt8_content_rating AS v ON a.id = v.content_id LEFT JOIN tpjt8_viewlevels AS vl ON a.access = vl.id LEFT JOIN tpjt8_languages AS l ON a.language = l.lang_code LEFT OUTER JOIN (select rsi.provider_id, rsi.order from tpjt8_roksprocket_items as rsi where module_id = 155) rsi on a.id = rsi.provider_id WHERE ((a.access IN(1,1,2,3) AND (a.state != -2)) AND a.id IN (77,80,79,78)) ORDER BY IF(ISNULL(rsi.order),1,0),rsi.order
If not, I can restore from backup...
Thanks !
- Jay
Unknown column 'ua.id' in 'on clause' SQL=SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title FROM tpjt8_content as a LEFT JOIN tpjt8_categories AS c ON c.id = a.catid LEFT JOIN tpjt8_users AS ua ON ua.id = a.created_by LEFT JOIN tpjt8_users AS um ON um.id = a.modified_by LEFT JOIN tpjt8_content_rating AS v ON a.id = v.content_id LEFT JOIN tpjt8_viewlevels AS vl ON a.access = vl.id LEFT JOIN tpjt8_languages AS l ON a.language = l.lang_code LEFT OUTER JOIN (select rsi.provider_id, rsi.order from tpjt8_roksprocket_items as rsi where module_id = 204) rsi on a.id = rsi.provider_id WHERE ((a.access IN(1,1,2,3) AND (a.state != -2)) AND a.catid IN (15)) ORDER BY rsi.order
Unknown column 'ua.id' in 'on clause' SQL=SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title FROM tpjt8_content as a LEFT JOIN tpjt8_categories AS c ON c.id = a.catid LEFT JOIN tpjt8_users AS ua ON ua.id = a.created_by LEFT JOIN tpjt8_users AS um ON um.id = a.modified_by LEFT JOIN tpjt8_content_rating AS v ON a.id = v.content_id LEFT JOIN tpjt8_viewlevels AS vl ON a.access = vl.id LEFT JOIN tpjt8_languages AS l ON a.language = l.lang_code LEFT OUTER JOIN (select rsi.provider_id, rsi.order from tpjt8_roksprocket_items as rsi where module_id = 155) rsi on a.id = rsi.provider_id WHERE ((a.access IN(1,1,2,3) AND (a.state != -2)) AND a.id IN (77,80,79,78)) ORDER BY IF(ISNULL(rsi.order),1,0),rsi.order