Error when clicking "View your Posts"

Talk about stuff specific to the site -- bugs, suggestions, and of course praise welcome.
Locked
FFman
Posts: 336
Joined: January 28th, 2012, 2:06 pm

Error when clicking "View your Posts"

Post by FFman »

I get the following every time:
General Error
SQL ERROR [ mysql4 ]

Expression #1 of ORDER BY clause is not in SELECT list, references column 'mozine_forums.t.topic_last_post_time' which is not in SELECT list; this is incompatible with DISTINCT [3065]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
User avatar
DanRaisch
Moderator
Posts: 127185
Joined: September 23rd, 2004, 8:57 pm
Location: Somewhere on the right coast

Re: Error when clicking "View your Posts"

Post by DanRaisch »

You and everyone else. It's been an issue for some time and it's not something we can easily fix.

http://forums.mozillazine.org/viewtopic ... #p14913579
FFman
Posts: 336
Joined: January 28th, 2012, 2:06 pm

Re: Error when clicking "View your Posts"

Post by FFman »

Ah, thanks DanRaisch.
User avatar
LIMPET235
Moderator
Posts: 39932
Joined: October 19th, 2007, 1:53 am
Location: The South Coast of N.S.W. Oz.

Re: Error when clicking "View your Posts"

Post by LIMPET235 »

Locking this as the error has been noted, many times.
[Ancient Amateur Astronomer.]
Win-10-H/64 bit/500G SSD/16 Gig Ram/450Watt PSU/350WattUPS/Firefox-115.0.2/T-bird-115.3.2./SnagIt-v10.0.1/MWP-7.12.125.

(Always choose the "Custom" Install.)
Locked