Unread Post Count 1.2.0

[Chris D]

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]

I'm asking to Chris

 

[Alexey.P]

I'm asking to Chris

Will be easier if you'd quote next time

 

[rdn]

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.

 

[Alexey.P]

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]

@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]

@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):

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:

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

Then install the addon?

 

[Chris D]

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.

 

[rdn]

To avoid un-expected timeout during install.

 

[Chris D]

If you are getting an unexpected timeout during install, yes, you should manually run that query as per the instructions.

 

[Alexey.P]

@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?

Oki, waiting for the next update.

 

[Rizwan Kassim]

Any suggestions so that I could make this show unread threads rather than unread posts?

 

[Chris D]

Any suggestions so that I could make this show unread threads rather than unread posts?

There's another add on that does that already.

 

[Rizwan Kassim]

In the toolbar? The only one that I saw does that in the visitors panel only...

 

[Chris D]

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.

 

[Pierre Boulanger]

love this add on.. Waiting for Chris

 

[Chris D]

Waiting for what?

 

[Pierre Boulanger]

Waiting for what?

Compatibility with 1.2

 

[Allan]

Compatibility with 1.2

Work on 1.2 ^^

 

[Chris D]

Work on 1.2 ^^

Not officially.

A fully compatible 1.2 version will be released shortly.