Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] [PostgreSQL] Attachments Statistics in admin cp (new error) [R] [C-Michael83]
Although the other error has been fixed, there is now a new one showing in the same place in the Attachments Statistics area of the admin cp.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    42803 - ERROR: column "u.uid" must appear in the GROUP BY clause or be used in an aggregate function
    SELECT a.*, u.uid AS useruid, u.username, SUM(a.filesize) as totalsize FROM trunk_attachments a LEFT JOIN trunk_users u ON (u.uid=a.uid) GROUP BY a.aid,,a.posthash,a.uid,a.filename,a.filetype,a.filesize,a.attachname,a.downloads,a.dateuploaded,a.visible,a.thumbnail ORDER BY totalsize DESC LIMIT 5

Yep, I got the error too.
[Image: prostgresqlerrorattacheem3.jpg]
1scream Founder
Former MyBB Developer & SQA Member
My Twitter
Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.

With regards,
MyBB Group
I'm filing this as a regression in the SVN under the previous bug report because it's just an incomplete fix

Forum Jump:

Users browsing this thread: 1 Guest(s)