Problem when reaching 225.000 messages

Posted by jero01 
Problem when reaching 225.000 messages
January 23, 2015 12:11PM
Hello,


- On one forum, the list of topics seems corrupted and not accessible
[dafina.net]

When I go to mysql, the messages are all there but somehow I cannot access them as I get the message that my limit of 225 000 is passed (I have 225.025 messages)


Please help me solve these issue.

Jero
Re: Problem when reaching 225.000 messages
January 23, 2015 02:44PM
which if your forums is showing that issue? could you put the full link to the forum?
there is no special limit at 225k messages. Check on your server for limits in memory or mysql settings.


Thomas Seifert
Re: Problem when reaching 225.000 messages
January 23, 2015 03:46PM
Hello,

Thanks for answering.
The forum with poblems is [dafina.net]

Cordially
Re: Problem when reaching 225.000 messages
February 26, 2015 03:24PM
Hello,

I fixed the problem which was that the database got corrupted.
But now an entire thread (2700 messages) is not showing while all the messages are in the database (with the proper ForumID, message and thread).
Here is a copy of the missing thread messages.
Thanks for your help.
Attachments:
open | download - dafDB.jpg (163.8 KB)
Re: Problem when reaching 225.000 messages
February 26, 2015 08:16PM
You need one message with: message_id = thread_id , and parent_id is 0

Check the status.

// message statuses
define("PHORUM_STATUS_APPROVED", 2);
define("PHORUM_STATUS_HOLD", -1);
define("PHORUM_STATUS_HIDDEN", -2);

You may have other status numbers depending on how old your phorum is (version 3.x).
Re: Problem when reaching 225.000 messages
February 27, 2015 06:50PM
Hello and Thanks for your help,

I am using Phorum 5.2.13
All statuses are "2"
I do not have such a message (message_id = thread_id , and parent_id is 0 ) in this thread.
Should I create it?
Cordially
Re: Problem when reaching 225.000 messages
February 27, 2015 09:52PM
Yes, if you are positive it doesn't exist.

As an alternate... look for a backup that has the missing message(s). Export the missing messages.
Re: Problem when reaching 225.000 messages
March 04, 2015 12:33AM
Hello,

And thanks for your help.
The missing messages of this thread are back now but I have lost the index on this thread so the pages are not connected.
How shall I fix that ?
Re: Problem when reaching 225.000 messages
March 04, 2015 02:10PM
rebuild thread info in admin


Thomas Seifert
Re: Problem when reaching 225.000 messages
March 06, 2015 09:11PM
It worked perfectly.
Thanks, guys.
Re: Problem when reaching 225.000 messages
June 25, 2026 06:22PM
Dear all,

Can you help on GitHub?

I have created a new ticket to have a new team, to have PHP support improvements, etc.:
- [github.com]

There are two PRs:
- [github.com]
- [github.com]

captcha in GitHub tickets:
- [github.com]

I have created a ticket to report all vulnerabilities and security flaws:
- [github.com]

Thanks in advance.
Sorry, only registered users may post in this forum.

Click here to login