MozillaZine


"View your posts" and then mysql4 error?

Talk about stuff specific to the site -- bugs, suggestions, and of course praise welcome.
Flycaster

User avatar
 
Posts: 1055
Joined: November 19th, 2008, 12:13 pm
Location: Boynton Beach, FL

Post Posted August 27th, 2021, 2:07 pm

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 10 21H1, FF 93.0, Chrome v89.0.2, Edge v94, Thunderbird 91.2, Defender

dickvl

User avatar
 
Posts: 53555
Joined: July 18th, 2005, 3:25 am

Post Posted August 27th, 2021, 3:56 pm

No, there is no easy fix possible.

See:
viewtopic.php?f=11&t=3078542

James
Moderator

User avatar
 
Posts: 27833
Joined: June 18th, 2003, 3:07 pm
Location: Made in Canada

Post Posted August 27th, 2021, 5:10 pm

Not a Firefox browser issue and this ego search issue is known as mentioned in threads in MozillaZine Site Discussion like viewtopic.php?f=11&t=3078542 as mentioned.

Return to MozillaZine Site Discussion


Who is online

Users browsing this forum: No registered users and 2 guests