April 20, 2016 in Technical Problems
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!
This topic is now archived and is closed to further replies.
Started 46 minutes ago
Started 6 hours ago
Started Yesterday at 01:29 AM