MozillaZine


Viewing my posts gives a SQL error

Talk about stuff specific to the site -- bugs, suggestions, and of course praise welcome.
morat
 
Posts: 4667
Joined: February 3rd, 2009, 6:29 pm

Post Posted August 24th, 2021, 6:08 am

I get a SQL error when I click the "View your posts" and "Show your posts" and "Search user’s posts" links in Chrome and Firefox.

I tried clearing my history in both browsers. Is there a workaround?

View your posts
http://forums.mozillazine.org/search.php?search_id=egosearch

Show your posts
http://forums.mozillazine.org/search.php?author_id=523035&sr=posts (morat)

Search user’s posts
http://forums.mozillazine.org/search.php?author_id=73083&sr=posts (DanRaisch)

I tried searching for another user in a particular thread. That's gives a SQL error as well.

Search for dorando in keyconfig thread
http://forums.mozillazine.org/search.php?f=48&t=72994&author=dorando

* View your posts

General Error

SQL ERROR [ mysql4 ]

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mozine_forums.p.post_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

* User Control Panel > Show your posts
* Viewing profile - DanRaisch > Search user’s posts
* Search for dorando in keyconfig thread

General Error

SQL ERROR [ mysql4 ]

Expression #1 of ORDER BY clause is not in SELECT list, references column 'mozine_forums.p.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.

LIMPET235
Moderator

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

Post Posted August 24th, 2021, 7:59 am

Hi morat,
I just logged in, loaded my normal pages & then tried to "View your posts" & struck the same error message.

Posted my Q? in the Mods forum.

Tried with 2 different versions as well. No luck with either.
Ancient Amateur Astronomer
Win-7-HP/Intel® DualCore-2.0GHz/500G HDD/4 Gig Ram/550Watt PSU/350WattUPS/Firefox-20.0-62.0-70.0-79.0/T-bird-2.0.0.24/SnagIt-v10.0.1/MWP-7.12.
W.M.Y.C.
(Always choose the "Custom" Install.)

therube

User avatar
 
Posts: 20813
Joined: March 10th, 2004, 9:59 pm
Location: Maryland USA

Post Posted August 25th, 2021, 11:55 am

(I'll just "me too". egosearch is currently broken.
And with an ego like I have, I kind of feel broken ;-).)
Fire 750, bring back 250.
Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.19) Gecko/20110420 SeaMonkey/2.0.14 Pinball CopyURL+ FetchTextURL FlashGot NoScript

Grumpus

User avatar
 
Posts: 12809
Joined: October 19th, 2007, 4:23 am
Location: ... Da' Swamp

Post Posted August 26th, 2021, 5:20 am

Seems to me not more than a week or so ago there was some form of announcement for SQL changes, could be related.
Doesn't matter what you say, it's wrong for a toaster to walk around the house and talk to you

tanstaafl
Moderator

User avatar
 
Posts: 47918
Joined: July 30th, 2003, 5:06 pm

Post Posted August 26th, 2021, 1:10 pm

I summitted a support request to OSL Labs about ego search failing

Snake4
 
Posts: 1257
Joined: December 27th, 2017, 4:03 am
Location: Australia

Post Posted August 26th, 2021, 5:14 pm

tanstaafl wrote:I summitted a support request to OSL Labs about ego search failing

is OSL upgrading there MYSQL ? if so will that affect this forum software?

tanstaafl
Moderator

User avatar
 
Posts: 47918
Joined: July 30th, 2003, 5:06 pm

Post Posted August 26th, 2021, 6:57 pm

They upgraded their MySQL cluster to 5.7 earlier in the week, which enabled some stricter query checking. The problem is we are using phpbb 3.0.12 (pretty old) and we need to be at least phpbb 3.1.10 for MySQL 5.7 compatibility. Their first attempted solution was a hotfix patch which worked for them, but not me when I tested it.

I suggested that perhaps it was time for me to buy a domain and then submit a proposal to fork the web site. The OSL Director replied that "We'll try and come up with a short term solution for this site and then consider what we can do longer term. The user base is still pretty active it seems so it seems important that we try and keep things going."

therube

User avatar
 
Posts: 20813
Joined: March 10th, 2004, 9:59 pm
Location: Maryland USA

Post Posted August 30th, 2021, 9:48 am

(Oh, OpenSSL. In that regard, OpenSSL Releases Security Update.)
Fire 750, bring back 250.
Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.19) Gecko/20110420 SeaMonkey/2.0.14 Pinball CopyURL+ FetchTextURL FlashGot NoScript

ineuw

User avatar
 
Posts: 702
Joined: March 19th, 2006, 4:17 pm
Location: Québec, Canada

Post Posted September 13th, 2021, 7:47 pm

I am completely blind because of this. I forgot to copy the solution for displaying the bookmarks toolbar in versions > 90. So, I must ask again.
Which preference is needed to be added to about:config, since this is a valid user added preference.
My current version is Windows 10, Firefox 92.0.
The bookmarks are visible and accessible with Ctrl+h, but I need to see them on the bookmarks toolbar. Please help.
Firefox 91.0.2 with Windows 10 Pro 21H1, and Linux Mint 20.2 Cinnamon 64 bit. - posted on 2021-08-31

Frank Lion

User avatar
 
Posts: 21081
Joined: April 23rd, 2004, 6:59 pm
Location: ... The Exorcist....United Kingdom

Post Posted September 14th, 2021, 10:40 am

morat wrote:Is there a workaround?

Yep.

SOLUTION

1. Click on 'Boards(Advanced)' under Search on right hand side of a MozillaZine page.

Image

2. Enter * in 'Search for keywords:' box.

3. Select 'Search for any terms' radio button.

4. Enter desired username in 'Search for author:' box. ( the user 'dorando' is used in examples.)

5. Hit Enter and and the most recent 15 posts will appear. Bookmark page, if you want to. Page 2 onwards of this solution will fail.


FULL SOLUTION

1. As above, but in Step 2 enter this instead +*

2. All posts are shown and you're done.

3. You will note that when using this full solution that all the words are highlighted by the forum software.

You can tone this right down by putting this in your userContent.css -

Code: Select all
/*Franks Temp Tone Down of MozZ forum highlight.....*/
.posthilit {
   background-color: transparent !important;
   color: #252525 !important; }


FULL SOLUTION (SELECTIVE)

1.
As above, but enter forum of choice in 'Search options > Search in forums:' box.

For example, the user dorando has made a total of 47 posts in the Firefox General Forum.

******

Frank :)



Image
Metal Lion SeaMonkey Themes - Sea Monkey and Silver Sea Monkey
"The only thing necessary for the triumph of evil, is for good men to do nothing." - Edmund Burke (attrib.)

DanRaisch
Moderator

User avatar
 
Posts: 125136
Joined: September 23rd, 2004, 8:57 pm
Location: Somewhere on the right coast

Post Posted September 14th, 2021, 1:45 pm

Thank you, Frank. Very helpful!

ineuw

User avatar
 
Posts: 702
Joined: March 19th, 2006, 4:17 pm
Location: Québec, Canada

Post Posted September 14th, 2021, 3:38 pm

Much much thanks, Frank. You are one of the many true Mozillians on Mount Mozilla, like Olympians on Mount Olympus.
Firefox 91.0.2 with Windows 10 Pro 21H1, and Linux Mint 20.2 Cinnamon 64 bit. - posted on 2021-08-31

Return to MozillaZine Site Discussion


Who is online

Users browsing this forum: No registered users and 3 guests