Show new replies to your posts bug. Crashes when none to display.

Yikesfactor · September 21, 2018, 12:31:41 AM

The show new replies to your posts link crashes whenever there are none to display.

This has only started happening since my post-server-crash rebuild.

Any ideas how to fix it?

"Database Error. Please try again. If you come back to this error screen, report the error to an administrator."

SychO · September 21, 2018, 05:30:09 AM

Check your forum error log, and past the error here

Yikesfactor · September 21, 2018, 06:13:42 AM

Database Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'xxx_author.t.id_last_msg' which is not in SELECT list; this is incompatible with DISTINCT
Apply Filter: Only show the errors from this file
File: /xxxxxx/writersanctum.com/Sources/Recent.php
Line: 1108

Illori · September 21, 2018, 06:30:03 AM

seems related to https://bugs.mysql.com/bug.php?id=79134

what version of mysql is your server running?

Yikesfactor · September 21, 2018, 06:41:27 AM

Database server

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.7.23 - MySQL Community Server (GPL)
Protocol version: 10
User:
Server charset: UTF-8 Unicode (utf8)

Web server

cpsrvd 11.74.0.8
Database client version: libmysql - 5.1.73
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 5.6.30

Yikesfactor · September 21, 2018, 06:53:38 AM

People also getting this:

<html lang="en-US"><head>
<meta charset="ISO-8859-1"></head><body></body></html>

Yikesfactor · September 22, 2018, 12:47:38 AM

What file has the actual display of this?

Fastest workaround seems to be removing the link.

vbgamer45 · September 22, 2018, 12:50:10 AM

You can fix issues by by setting
sql_mode =""

In my.cnf the config file for mysql and then reload mysql

Yikesfactor · September 22, 2018, 02:12:10 AM

Quote from: vbgamer45 on September 22, 2018, 12:50:10 AM
You can fix issues by by setting
sql_mode =""

In my.cnf the config file for mysql and then reload mysql

Where is my.cnf, and what do you mean by reboot mysql? (Out of my depth here)

Yikesfactor · September 22, 2018, 04:01:18 AM

Which file displays 'Show new replies to your posts', and what code do I delete in order to remove it?

Also, how do I add a text message after 'Show unread posts since last visit', so people will see it and use it more?

Illori · September 22, 2018, 05:47:16 AM

if you dont have a dedicated or VPS server, you cant do that. you need to ask your host to fix it.

Kindred · September 22, 2018, 09:03:26 AM

Please do not open multiple topics on the same issue...

topics merged.

And removing the link won't work, because there are several different ways to get to that screen.... not to mention direct.

Solve the issue, not the trigger

Yikesfactor · September 22, 2018, 09:11:31 AM

Quote from: Kindred on September 22, 2018, 09:03:26 AM
And removing the link won't work, because there are several different ways to get to that screen.... not to mention direct.

Solve the issue, not the trigger

How?

Quote from: vbgamer45 on September 22, 2018, 12:50:10 AM
You can fix issues by by setting
sql_mode =""

In my.cnf the config file for mysql and then reload mysql

I don't know what this is or what you do with it. Can someone provide some actual instructions please?

Illori · September 22, 2018, 09:19:16 AM

Quote from: Illori on September 22, 2018, 05:47:16 AM
if you dont have a dedicated or VPS server, you cant do that. you need to ask your host to fix it.

Yikesfactor · September 22, 2018, 09:30:45 AM

I've submitted a request.

Yikesfactor · September 22, 2018, 12:54:26 PM

Quote from: vbgamer45 on September 22, 2018, 12:50:10 AM
You can fix issues by by setting
sql_mode =""

In my.cnf the config file for mysql and then reload mysql

Host says they cant do this on a shared server.

I've given instructions so they can generate the error themselves.

Kindred · September 22, 2018, 09:32:59 PM

It seriously sounds like you need a new host who has a clue

Yikesfactor · September 22, 2018, 09:39:08 PM

Quote from: Kindred on September 22, 2018, 09:32:59 PM
It seriously sounds like you need a new host who has a clue

I'm beginning to think the same thing.

How does one find out here who the best hosts are?

I still want to go with my main request. Where is the link displayed from, so I can remove it, if only temporarily?

Illori · September 23, 2018, 05:40:45 AM

https://www.simplemachines.org/community/index.php?board=155.0

Yikesfactor · September 23, 2018, 11:41:42 AM

Quote from: Illori on September 23, 2018, 05:40:45 AM
https://www.simplemachines.org/community/index.php?board=155.0

thanks, bookmarked, but well down the list of things to do. Forum is too new to move it again.

I am going nuts with the number of reports of this error message.

Doesn't anyone know where the display of the link is in the code or the default theme? For now, all I want to do is rip that link out so people stop clicking on it.

Also, I cant understand why a coder cant recommend a code fix for when it returns nothing.

News:

Show new replies to your posts bug. Crashes when none to display.