the forum have a bug

Talk about stuff specific to the site -- bugs, suggestions, and of course praise welcome.
Locked
Michael REMY
Posts: 323
Joined: December 19th, 2009, 2:27 am

the forum have a bug

Post by Michael REMY »

hi,

i tried to find an old post i write a few years ago, so i clicked on the right panel link "View your posts" but there is this error messag :
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.
I hope the admin could repair it !

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

Re: the forum have a bug

Post by LIMPET235 »

Hi Michael,
It's been faulty for many months & apparently will not be fixed soon.
No Admin at present.

But, there is a "work-around."
Ref; this thread & the post/s by Frank Lion...
> http://forums.mozillazine.org/viewtopic ... &t=3078542

Moving to Site Discussion...
[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.)
morat
Posts: 6406
Joined: February 3rd, 2009, 6:29 pm

Re: the forum have a bug

Post by morat »

Michael REMY
Posts: 323
Joined: December 19th, 2009, 2:27 am

Re: the forum have a bug

Post by Michael REMY »

thank you both of you.
Locked