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.

Kindred · September 23, 2018, 06:11:49 PM

there is no code fix needed. it works perfectly well on hundreds of other sites... it has something to do with your host's specific (mis)configuration.

Yikesfactor · September 23, 2018, 08:48:13 PM

Quote from: Kindred on September 23, 2018, 06:11:49 PM
there is no code fix needed. it works perfectly well on hundreds of other sites... it has something to do with your host's specific (mis)configuration.

Can you please explain that in terms the host will understand, including why it's not just a change to for my domain, and why it should be applied to the whole server.

They wont look here, and unless I can show them something they will understand, they wont make that change.

Is there anything I can change in my Cpanel to do this?

Kindred · September 23, 2018, 10:02:38 PM

I don't know... all I know is that it works on every (or at least almost every) other installation... which indicates that the core issue has something to do with your host.

Yikesfactor · September 23, 2018, 10:38:38 PM

I sent them your comment. Thanks.

shawnb61 · September 24, 2018, 12:48:18 AM

It appears your host has "strict mode" enabled in mysql. With strict mode enabled, certain queries don't work. SMF 2.0.x doesn't yet fully support strict mode.

Ask them to disable strict mode for you. They didn't like setting the mode to blanks... Maybe you'll get further asking them to disable strict mode.

Yikesfactor · September 24, 2018, 02:06:21 AM

Quote from: shawnb61 on September 24, 2018, 12:48:18 AM
It appears your host has "strict mode" enabled in mysql. With strict mode enabled, certain queries don't work. SMF 2.0.x doesn't yet fully support strict mode.

Ask them to disable strict mode for you. They didn't like setting the mode to blanks... Maybe you'll get further asking them to disable strict mode.

Thanks. Suggested it.

Yikesfactor · September 24, 2018, 05:50:08 AM

Quote from: shawnb61 on September 24, 2018, 12:48:18 AM
It appears your host has "strict mode" enabled in mysql. With strict mode enabled, certain queries don't work. SMF 2.0.x doesn't yet fully support strict mode.

They did the change, but ti made no difference.

In the meantime, I've edited out the display of the text for the link, so it cant be clicked on any more.

GigaWatt · September 24, 2018, 10:25:40 PM

Since the forum is new, could you try and put the forum on a free host and see if the same error is generated? The only thing you'd require is the forum's files, the database and repair_settings.php. You don't have to transfer your domain, you could use a temporary domain (a subdomain from the free hosting service perhaps

).

This way, if the error doesn't appear, you could show your host that there is actually something wrong with their server. if the error does appear, then we at least ruled out server misconfiguration

.

Yikesfactor · September 24, 2018, 10:33:38 PM

Quote from: GigaWatt on September 24, 2018, 10:25:40 PM
Since the forum is new, could you try and put the forum on a free host and see if the same error is generated? The only thing you'd require is the forum's files, the database and repair_settings.php. You don't have to transfer your domain, you could use a temporary domain (a subdomain from the free hosting service perhaps ).

This way, if the error doesn't appear, you could show your host that there is actually something wrong with their server. if the error does appear, then we at least ruled out server misconfiguration .

That's an interesting option. Not having used the before, can you link me to one?

Forum is down again, getting 500 errors apparently, or at least that's what people say before it died completely.

Everything is there and seems to be ok, but all we get is a blank screen when accessing the domain.

Advised vodahost support, but no response yet. 5 hours down and counting. Most like the server is totally overloaded by 50 people online at any time. And I guess they dont care.

Doesn't appear to be anything I can do.

Sir Osis of Liver · September 24, 2018, 10:39:31 PM

You can move to a better host. Could have done that many times with the effort you've put into this. Only thing you need is a good database dump, everything else can be set up from scratch.

Yikesfactor · September 24, 2018, 10:46:55 PM

Quote from: Sir Osis of Liver on September 24, 2018, 10:39:31 PM
You can move to a better host. Could have done that many times with the effort you've put into this. Only thing you need is a good database dump, everything else can be set up from scratch.

I've got a complete copy of everything this time.

My problem is being in Australia, and not having a clue about who the reliable hosts are these days. I dont trust any of them in Australia at all, and the pipe to Australia is too slow anyway. Which is why I've been with Vodahost all these years. They must have been taken over or something, as back in the day, they did more than just shared servers, and now they dont.

I'm exploring options, but feeling so frustrated at the moment.

I'm sorry I'm being such a total pain with you guys, and appreciate your help, even if I dont understand half of it.

Sir Osis of Liver · September 24, 2018, 10:56:12 PM

Doesn't matter where you are geographically, you can sign up with any host anywhere. One of my regulars runs multiple forums from Australia on GoDaddy (

), which is US based. I've been using Crocweb, based in Montreal, for 2-3 years, after 20 years with same host that went down the crapper. They're very good, inexpensive, support is excellent. You can get other recommendation in hosting board.

Yikesfactor · September 24, 2018, 11:05:54 PM

Quote from: Sir Osis of Liver on September 24, 2018, 10:56:12 PM
Doesn't matter where you are geographically, you can sign up with any host anywhere. One of my regulars runs multiple forums from Australia on GoDaddy (), which is US based. I've been using Crocweb, based in Montreal, for 2-3 years, after 20 years with same host that went down the crapper. They're very good, inexpensive, support is excellent. You can get other recommendation in hosting board.

I looked at the hosting board yesterday, but all the threads are so way out of date now, they no longer recommend themselves.

Bookmarked Crocweb, thanks.

GoDaddy I wont touch at all. I had dealings with their Aussie end, and never again!

GigaWatt · September 24, 2018, 11:12:57 PM

Quote from: Yikesfactor on September 24, 2018, 10:33:38 PM
That's an interesting option. Not having used the before, can you link me to one?

I currently use this one.

https://wwhost.ga/

It has cPanel access, 2GB of hosting space (including database), 50GB monthly bandwidth and you can set up to 5 databases with a free account

.

Quote from: Yikesfactor on September 24, 2018, 10:46:55 PM
My problem is being in Australia, and not having a clue about who the reliable hosts are these days. I dont trust any of them in Australia at all, and the pipe to Australia is too slow anyway. Which is why I've been with Vodahost all these years. They must have been taken over or something, as back in the day, they did more than just shared servers, and now they dont.

I currently use 1and1 as my paid hosting provider. Don't have much to complain about, except not having cPanel, LOL

. Other than that, they're pretty good

, haven't had any down time since I started using them (about 6 or 7months ago). You could check my board (it's in my profile

).

https://www.1and1.com/web-hosting

If your forum is not too buys, I'd go for the Basic plan

. It's $0.99 per month for the first year

.

Quote from: Yikesfactor on September 24, 2018, 11:05:54 PM
GoDaddy I wont touch at all. I had dealings with their Aussie end, and never again!

Smart move

.

Sir Osis of Liver · September 24, 2018, 11:13:34 PM

Yeah, GoDaddy is pretty bad. A lot of SMF forums run on GD because they feature the software at top of their cpanel. I've moved several forums from GD to Crocweb. You can contact Croc before signing up, explain your situation, ask questions. They'll move pretty much everything for you. Tell them thekrash sent you.

Yikesfactor · September 25, 2018, 12:46:40 AM

Quote from: Sir Osis of Liver on September 24, 2018, 11:13:34 PM
Yeah, GoDaddy is pretty bad. A lot of SMF forums run on GD because they feature the software at top of their cpanel. I've moved several forums from GD to Crocweb. You can contact Croc before signing up, explain your situation, ask questions. They'll move pretty much everything for you. Tell them thekrash sent you.

Thanks for that.

Quote from: GigaWatt on September 24, 2018, 11:12:57 PM
I currently use this one.

https://wwhost.ga/

It has cPanel access, 2GB of hosting space (including database), 50GB monthly bandwidth and you can set up to 5 databases with a free account .

Thanks.

News:

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