Welcome to the Tiki Central 2.0 Beta. Read the announcement
Tiki Central logo
Celebrating classic and modern Polynesian Pop

Tiki Central 2.0 - The Beta / Bugs

SQL error when clicking on next/last page of thread

Pages: 1 4 replies

S

On this thread: https://tikicentral.com/viewtopic.php?topic_id=35643&start=528

And it shows a 13th page, but clicking on it produces this error: h no. An error occurred. Site administrators have been notified of the error.

Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY post_id, reaction' at line 7

Hmmm… could be an off by one error, or I could have deleted a spam post.

I created a new post and page 13 works again:

https://tikicentral.com/viewtopic.php?topic_id=35643&start=576

I'll check the logic over the weekend.

I see this happen quite often on different threads. When i see it i just click on the page number before the last one and the most recent comment is at the bottom of that page. It used to happen a lot on the old TC as well.

H
Hamo posted on Tue, Feb 14, 2023 11:15 PM

Noticed this on two different topics while catching up tonight:

Screenshot 2023-02-15 at 12.13.11 AM

Lagoon of Mystery, page 6 https://tikicentral.com/viewtopic.php?topic_id=52009

Mai Kai, Fort Lauderdale, FL (restaurant), page 11 https://tikicentral.com/viewtopic.php?topic_id=10334

Thanks Hamo,

It's a known issue when theres the exact round number for a page of results. It's an off by 1 error I need to find to fix.

Pages: 1 4 replies