Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted April 20, 20168 yr Hi guys, I'm hoping that someone may have seen this before. On our dev site this error just popped up : Sorry, there is a problem Something went wrong. Please try again. Error code: EX1052 All that was changed was a block was put on the homepage, the underlying error seems to be because the table isn't named in the MySQL in the order by clause, however this isn't code I even know how to touch! SELECT forums_topics.*, author.*, last_commenter.*, core_tags_cache.tag_cache_text FROM `XXXforums_topics` AS `forums_topics` LEFT JOIN `XXXforums_forums` AS `forums_forums` ON forums_topics.forum_id=forums_forums.id LEFT JOIN `XXXcore_tags_cache` AS `core_tags_cache` ON tag_cache_key=MD5(CONCAT('forums;forums;',forums_topics.tid)) LEFT JOIN `XXXcore_members` AS `author` ON author.member_id = forums_topics.starter_id LEFT JOIN `XXXcore_members` AS `last_commenter` ON last_commenter.member_id = forums_topics.last_poster_id WHERE forums_topics.approved=1 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_topics.forum_id IN(5,7,8,13,15,16,17,18,19,20,21,22,23,24,25,26,27,32,33,34,35,36,37,38,39,40,41,42,43,46,47,48,50,51,52,54,55,56,57,59,60,61,63,66,67,68) ORDER BY last_post desc LIMIT 5 IPS\Db\Exception: Column 'last_post' in order clause is ambiguous (1052) Can anyone advise? It's making us very nervous of upgrading!
Archived
This topic is now archived and is closed to further replies.