Unread Post Count

Unread Post Count 1.2.0

No permission to download

Chris D

XenForo developer
Staff member
Why?

That runs automatically during install. What is that going to achieve?

Do you refer to me? :)
If so, where, at ssh?

And is there a way to revert later in case it isn't the best solution?

The forum is already running, that's why :)
Don't follow that advice. It's erroneous. And not even related to the issue.
 

rdn

Well-known member
Why?

That runs automatically during install. What is that going to achieve?



Don't follow that advice. It's erroneous. And not even related to the issue.
To avoid timeouts.

Add:
Ha ? What did you say?
Erroneous?
I'm not advicing to him.
I'm asking to you.

What kind of words. (n)
 

Alexey.P

Member
Why?

That runs automatically during install. What is that going to achieve?



Don't follow that advice. It's erroneous. And not even related to the issue.
Alright! :)

So only issue is: how to edit a value (if it is possible at all)
Or maybe to change the unread_post files instead
 

Chris D

XenForo developer
Staff member
@Alexey.P please keep the add-on disabled for now. It does not currently support XenForo 1.2. A XenForo 1.2 version will be released when I have time.

@RoldanLT I misunderstood because I wasn't sure what you were asking me. What is your question?
 

rdn

Well-known member
@Alexey.P please keep the add-on disabled for now. It does not currently support XenForo 1.2. A XenForo 1.2 version will be released when I have time.

@RoldanLT I misunderstood because I wasn't sure what you were asking me. What is your question?
I just read this on the documentation:

IMPORTANT INSTALL NOTE

Something very important happens during the install or upgrade of the add-on.

An index is added to the xf_post table. This index applies to the post_date column.

Adding an index can sometimes be a lengthy operation (directly dependent on the number of posts in the xf_post table). On my forum with 3,000,000 posts the operation took 50 seconds.

Often this amount of time is beyond the PHP max execution time.

If you receive an error during install or upgrade stating that the max execution time has been exceeded, then please run the following query directly on your XenForo MySQL database using PHP My Admin (or preferably directly on the command line):

Code:
ALTER TABLE `xf_post` ADD INDEX `unread_post_count_post_date` (`post_date` ASC)

After that query has run, the add-on will install/upgrade without issue.

In the event that you're unable to perform this query and as a result performance problems persist then you should uninstall the add-on as no further support can be provided.
So I'm asking:
How about running this query first:
Code:
ALTER TABLE `xf_post`
ADD INDEX `unread_post_count_post_date` (`post_date` ASC)
Then install the addon?
 

Chris D

XenForo developer
Staff member
I don't know what you are asking...

What about running that query first?

That query runs automatically anyway. I have no idea why you're referring to it.
 

Chris D

XenForo developer
Staff member
If you are getting an unexpected timeout during install, yes, you should manually run that query as per the instructions.
 
  • Like
Reactions: rdn

Chris D

XenForo developer
Staff member
I don't know.

But my add-on specifically counts unread posts so you should ask the author of that other add-on to change its position.
 
Top