Welcome to the Tiki Central 2.0 Beta. Read the announcement
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 2 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.

Pages: 1 2 replies