"View your posts" and then mysql4 error?

Talk about stuff specific to the site -- bugs, suggestions, and of course praise welcome.
Locked
User avatar
Flycaster
Posts: 1167
Joined: November 19th, 2008, 12:13 pm
Location: Boynton Beach, FL

"View your posts" and then mysql4 error?

Post by Flycaster »

Firefox 91.0.2. When logged in and then going to "View your posts," I get this error message:
"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 have forwarded this error message to the Board Admin, but perhaps I can get a quicker solution here?
Windows 11, FF Latest, Edge v94, Thunderbird Latest, Defender
User avatar
dickvl
Posts: 54161
Joined: July 18th, 2005, 3:25 am

Re: "View your posts" and then mysql4 error?

Post by dickvl »

No, there is no easy fix possible.

See:
http://forums.mozillazine.org/viewtopic ... &t=3078542
User avatar
James
Moderator
Posts: 28005
Joined: June 18th, 2003, 3:07 pm
Location: Made in Canada

Re: "View your posts" and then mysql4 error?

Post by James »

Not a Firefox browser issue and this ego search issue is known as mentioned in threads in MozillaZine Site Discussion like http://forums.mozillazine.org/viewtopic ... &t=3078542 as mentioned.
Locked