Jump to content

MySql Error


Chatgroup

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

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...