Hello! Everyone! We had to migrate to a new server, which also required updating much of the software. This, unfortunately, may have caused some issues, in terms of things not working right. The good news, at least, is that the server is significantly faster.

I'll be working on fixing problems over the next few weeks. If you find any issues, please let me know in this post, and I'll look into it!

Edited 1 time(s). Last edit at 07/30/2024 11:03PM by JacobJ.

Hi, Jacob. Thanks for the updates. We appreciate everything you do here.

Could you explain what the "thumbs down" button is for, please? If it's ticked a certain number of times, does that trigger you and the Mods to look at a post? I'm just curious since the button magically appeared out of nowhere.

The following errors show up when I click to read any post:

Database Error
Message: MySQL Query fail: SELECT DISTINCT user_id, author FROM ph_messages WHERE thread = 933258 AND user_id != ORDER BY datestamp DESC LIMIT 3
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 2:37:00 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: Invalid query_id: Records could not be fetched.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 2:37:00 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: MySQL Query fail: SELECT DISTINCT user_id, author FROM ph_messages WHERE thread = 932873 AND user_id != ORDER BY datestamp DESC LIMIT 3
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 2:37:00 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: Invalid query_id: Records could not be fetched.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 2:37:00 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: MySQL Query fail: SELECT DISTINCT user_id, author FROM ph_messages WHERE thread = 933231 AND user_id != ORDER BY datestamp DESC LIMIT 3
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 2:37:00 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: Invalid query_id: Records could not be fetched.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 2:37:00 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]

@drdoggie00 -- I believe I fixed the errors you mentioned, but I'm not 100% sure. Can you check again, and see if it's still there? It's very possible there's more errors as well. Thank you!

These error messages appear at the top of the "Latest" page:

Database Error
Message: MySQL Query fail: SELECT DISTINCT user_id, author FROM ph_messages WHERE thread = 933575 AND user_id != ORDER BY datestamp DESC LIMIT 3
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:23 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: Invalid query_id: Records could not be fetched.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:23 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: MySQL Query fail: SELECT DISTINCT user_id, author FROM ph_messages WHERE thread = 933231 AND user_id != ORDER BY datestamp DESC LIMIT 3
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:23 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: Invalid query_id: Records could not be fetched.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:23 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]

No, I'm still getting them. I can read and post as normal if I scroll beyond the error messages at the top of the screen.

Database Error
Message: MySQL Query fail: SELECT DISTINCT user_id, author FROM ph_messages WHERE thread = 933662 AND user_id != ORDER BY datestamp DESC LIMIT 3
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:44 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: Invalid query_id: Records could not be fetched.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:44 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: MySQL Query fail: SELECT DISTINCT user_id, author FROM ph_messages WHERE thread = 933258 AND user_id != ORDER BY datestamp DESC LIMIT 3
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:44 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: Invalid query_id: Records could not be fetched.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:44 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: MySQL Query fail: SELECT DISTINCT user_id, author FROM ph_messages WHERE thread = 932873 AND user_id != ORDER BY datestamp DESC LIMIT 3
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:44 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: Invalid query_id: Records could not be fetched.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:44 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: MySQL Query fail: SELECT DISTINCT user_id, author FROM ph_messages WHERE thread = 933231 AND user_id != ORDER BY datestamp DESC LIMIT 3
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:44 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]
Database Error
Message: Invalid query_id: Records could not be fetched.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY datestamp DESC LIMIT 3' at line 1
Date: Wednesday, July 31, 2024 at 3:28:44 PM
Script: /jjnotification/headerajax.php
Referer: [www.mysteryshopforum.com]

OK -- I went ahead and had to disable the "updates" feature for now. This will take more time than I thought to figure out this particular bug. Hopefully I'll be able to figure it out within the next week. In the meantime, let me know if you find any other issues!

@JacobJ wrote:

OK -- I went ahead and had to disable the "updates" feature for now. This will take more time than I thought to figure out this particular bug. Hopefully I'll be able to figure it out within the next week. In the meantime, let me know if you find any other issues!

Okay, thank you, Jacob. We appreciate you and all your hard work.

You never did explain about the "thumbs down" button. What happens if it's selected on a post? Is there a number limit before something happens? Inquiring minds want to know...thanks!

Honestly -- I forget what happens! Though, I'm pretty sure that if enough people press the thumbs down button, it gets hidden and flagged for review. It's only available to certain members though, to prevent it from getting abused. It's mostly a way to quickly deal with trolls.

The "updates" notice missing. The one that alerts the user to new activity, likes and replies in a thread where they've been active.

Ever since the change, I have been unable to access on my phone. It says Forbidden - You don't have permission to access this resource. Additionally, a 403 forbidden error was encountered while trying to use an error document to handle the request.

I don't know how to fix this. I have tried a few things. I can access it on my second phone, on my computer, even on my work computer but not my primary phone.

@JacobJ

Ever since the change, I have been unable to access on my phone. It says Forbidden - You don't have permission to access this resource. Additionally, a 403 forbidden error was encountered while trying to use an error document to handle the request.

At first I was able to access on one of my phones but now I am unable to access on either phone. For now, I can only access on my laptop but that is not always with me of course.

Yes. The "Updates" feature does not seem to work anymore.

@sestrahelena wrote:

The "updates" notice missing. The one that alerts the user to new activity, likes and replies in a thread where they've been active.

I have no problem accessing the Forum on my Samsung Galaxy S24.

@myst4au wrote:

I have no problem accessing the Forum on my Samsung Galaxy S24.

I have the exact same phone. Only happened after the server upgrade. I can't figure it out.

@JimmyP wrote:

Yes. The "Updates" feature does not seem to work anymore.

@sestrahelena wrote:

The "updates" notice missing. The one that alerts the user to new activity, likes and replies in a thread where they've been active.

Per one of JacobJ's earlier posts, he temporarily disabled the "updates" function.

@Okie wrote:

@Datagirl wrote:

Ever since the change, I have been unable to access on my phone. It says Forbidden - You don't have permission to access this resource. Additionally, a 403 forbidden error was encountered while trying to use an error document to handle the request.

At first I was able to access on one of my phones but now I am unable to access on either phone. For now, I can only access on my laptop but that is not always with me of course.

I recently had that happen on both my desktop (Windows, Chrome) and phone (iPhone, Chrome). Not sure if this will work for you, but deleting cookies for this specific website resolved it for me.

This actually worked! I have an android but there was another page information tab I didn't see before and I was able to delete the cookies and site data for just this forum and then it worked. Thank you!

Glad I found this page today as I have been just sending messages directly to Jacob.
But I too do not get the red update flags any longer. Please update here when it gets fixed so if it still does not work for us we can let you know. Jacob you do a wonderful job.