Jump to content

MySql Error


Recommended Posts

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!

Link to comment
Share on other sites


  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...