Manage Inactive Members

[Martin A.]

Hi,

Trying to upgrade to latest version and it gives this error when running the upgrade process:

Error: CREATE TABLE ibf_IF NOT EXISTS inactivemembers_excludedmembers (

exclude_id int(10) NOT NULL AUTO_INCREMENT,

exclude_date int(10) NOT NULL DEFAULT '0',

exclude_reason varchar(255) DEFAULT NULL,

PRIMARY KEY (exclude_id)

) ENGINE=MyISAM;

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 'NOT EXISTS inactivemembers_excludedmembers ( exclude_id int(10) NOT NULL AUTO_' at line 1

It is asking me if I want to continue anyway. What do I do?

Thanks

You can just click continue regardless, and the next step of the installer will run the correct query. I have uploaded v1.4.1-3 which corrects this.

[Syao]

Hi,
I'm encountering a problem when trying to use both the "Select which groups to move when inactive" (im_moveInactive_group) and the "Number of posts to get moved?" (im_moveInactive_post) settings at the same time.

I tried a clean reinstall, and the issue is still reproducible. Here are the STR from a clean installation:

• Go to Other Apps -> Manage Inactive Members -> Settings -> Move Inactive Members.
• Select a group of your choice from the "Select which groups to move when inactive" listbox.
• Hit the Update Settings button. You'll see that the group selection was correctly saved (when the page reloads, it's still highlighted in the listbox).
• Look up the ID of that group. That bit of info can be found in Members -> Member Groups -> Manage Member Groups (next to each group in the list there's an ID).
• Go back to the Other Apps -> Manage Inactive Members -> Settings -> Move Inactive Members page.
• Insert a number in the 'Number of posts to get moved?' textbox, corresponding to the group ID you found. i.e. if the group you selected had ID = 3, insert 3.
• Hit the Update Settings button.

Expected result:

• The number of posts gets saved, and every other setting is unchanged.

Actual result:

• The number of posts gets saved, but the group listbox gets cleared. You can no longer select the group until you change the posts number setting to any other value.

I'm using IP.Board 3.3.1.

[Syao]

You can just click continue regardless, and the next step of the installer will run the correct query. I have uploaded v1.4.1-3 which corrects this.

Any way we can fix the problem i mentioned above?
Just wanting to move all members who are inactive and got less than 4 posts gets me this in the Debug run:

WHERE posts <= 0 AND ( last_activity <= 1320354370 OR last_activity IS NULL ) AND joined <= 1333314370 AND member_group_id IN (3)

LIMIT 0,250

Notice the WHERE posts <= 0, where i've clearly selected ' 4 ' in the x number of posts field.

also because the 'members' group is (3) in my forums, writing the number ' 3 ' into the x number of posts field lets the debug run fail (something went wrong, see the task log etc...)
So i think there are some values swapped in this mod.
I've tried this mod on ipb 3.2.x and 3.3.x, with a fresh install. same result every time.

[Michael R]

I just installed the new version but I do not see it in the pull down

[Magic.mimi]

Hello!

Is it possible to view (list) members not active for a number of days?

Or is the mail without seeing the list of members concerned

thank you

[Martin A.]

Hi,

I'm encountering a problem when trying to use both the "Select which groups to move when inactive" (im_moveInactive_group) and the "Number of posts to get moved?" (im_moveInactive_post) settings at the same time.

I tried a clean reinstall, and the issue is still reproducible. Here are the STR from a clean installation:

• Go to Other Apps -> Manage Inactive Members -> Settings -> Move Inactive Members.
• Select a group of your choice from the "Select which groups to move when inactive" listbox.
• Hit the Update Settings button. You'll see that the group selection was correctly saved (when the page reloads, it's still highlighted in the listbox).
• Look up the ID of that group. That bit of info can be found in Members -> Member Groups -> Manage Member Groups (next to each group in the list there's an ID).
• Go back to the Other Apps -> Manage Inactive Members -> Settings -> Move Inactive Members page.
• Insert a number in the 'Number of posts to get moved?' textbox, corresponding to the group ID you found. i.e. if the group you selected had ID = 3, insert 3.
• Hit the Update Settings button.
  

Expected result:

• The number of posts gets saved, and every other setting is unchanged.
  

Actual result:

• The number of posts gets saved, but the group listbox gets cleared. You can no longer select the group until you change the posts number setting to any other value.
  

I'm using IP.Board 3.3.1.

I were not able to reproduce this issue.

Any way we can fix the problem i mentioned above?

Just wanting to move all members who are inactive and got less than 4 posts gets me this in the Debug run:

WHERE posts <= 0 AND ( last_activity <= 1320354370 OR last_activity IS NULL ) AND joined <= 1333314370 AND member_group_id IN (3)

LIMIT 0,250

Notice the WHERE posts <= 0, where i've clearly selected ' 4 ' in the x number of posts field. also because the 'members' group is (3) in my forums, writing the number ' 3 ' into the x number of posts field lets the debug run fail (something went wrong, see the task log etc...) So i think there are some values swapped in this mod. I've tried this mod on ipb 3.2.x and 3.3.x, with a fresh install. same result every time.

This I could. Little typo from when IPS started disallowing hyphens in setting keys. Open ./admin/applications_addon/other/inactiveMembers/tasks/moveinactive.php Find

$posts = intval ( $this->settings['im_moveInactive-post'] );

Replace with

$posts = intval ( $this->settings['im_moveInactive_post'] );

I just installed the new version but I do not see it in the pull down

Which "pull down"?

Hello!

Is it possible to view (list) members not active for a number of days?

Or is the mail without seeing the list of members concerned

thank you

No. you can use the standard member list in the ACP to generate such a list.

[Markus Lassfolk]

Hi Martin,
I've just started to use the Move inacative users feature.
That seems to work fine, but inactive users who logon again are not moved back.

Do they have to make a post or something else, beside logging in to be moved back?

[Martin A.]

Hi Martin,

I've just started to use the Move inacative users feature.

That seems to work fine, but inactive users who logon again are not moved back.

Do they have to make a post or something else, beside logging in to be moved back?

There's a setting for that. They either have to post, or just sign in.

[simonb]

Hi, this looks a great mod, is it all working now?

Does it work with 3.3.3?

Thanks in advance.

[miraclesun]

I just came across this! I knew there had to be mad. I checked my e-mail and saw an e-mail from a board that runs on IP.Board that was like "You haven't been on in a while we miss you" blah blah blah. And I was like...."There's got to be an app/hook for this, surely" since I need it on my board.

THANK YOU SO MUCH. Even more for making it free. I appreciate it.

[Martin A.]

Hi, this looks a great mod, is it all working now?

Does it work with 3.3.3?

Thanks in advance.

Yes it does. The patch mentioned in post #256 has not been added to the main download yet though.

[simonb]

Ok thank you. I will wait for the file to e patched before I install it.

[Phille]

Hello,
What am I doing wrong?
I've asked for members that didn't posted for more than 5 years, and I've got results ... some members that joined only 2 years ago!?
Regards,
Phille

PS: I'm using IPB 3.3.4

[Martin A.]

Hello,

What am I doing wrong?

I've asked for members that didn't posted for more than 5 years, and I've got results ... some members that joined only 2 years ago!?

Regards,

Phille

PS: I'm using IPB 3.3.4

I'm guessing that those members that have been notified haven't posted anything at all? I'm putting up and update in a minute that will take the joined date into consideration when that is the case.

[Phille]

That would be great :smile:
What should I do to receive the same message as the one the notified members received ... just to see how they look ;)

[Phille]

Should I fully reinstall the app or can you give me the changes I have to make manually?

[Martin A.]

Should I fully reinstall the app or can you give me the changes I have to make manually?

Re-upload the files, and run the upgrader, and you're done.

That would be great :smile:

What should I do to receive the same message as the one the notified members received ... just to see how they look ;)

That would mean that you could end up getting 250 emails, or once pr day. Not a good idea if you ask me.
It looks like any other standard email sent from IP.Board, but with different content. Just have a look in your email, you should get many of then in return from mail boxes that are either full or no longer in use.

[Phille]

Re-upload the files, and run the upgrader, and you're done.

Thanks :)

That would mean that you could end up getting 250 emails, or once pr day. Not a good idea if you ask me.

It looks like any other standard email sent from IP.Board, but with different content. Just have a look in your email, you should get many of then in return from mail boxes that are either full or no longer in use.

I was wondering why I didn't received any message in return ... so 2 questions ... which mail address is used as "sender"? and how can I see if there are messages sent?

[Martin A.]

I was wondering why I didn't received any message in return ... so 2 questions ... which mail address is used as "sender"? and how can I see if there are messages sent?

It's using the same as used when sending registration verification emails, topic digests, etc.

[Phille]

Something went wrong ... NO mail in return ... not a single one concerning message sent by MIM !?
According log, 3542 messages should have been sent.

How can I check if mail sending system is working? (Manage Inactive Members'system)

[Martin A.]

Look in the mail error logs. Should be an entry in the mail log too if the emails were successfully sent.

[Phille]

No mail sent :sad:

[Martin A.]

It's unlikely that emails sent from the board will show up there. As you can see, not even registration mails are there. Look in the mail (error) logs in the ACP.

[Phille]

OK ... I've made some changes and now mails have been sent.
Can I stop an ongoing task? If yes, how? (I've ask for 100 members per day ... but wanna stop the task because I've made a typo error in the message)

[Kurt De Pauw]

Is there a way to delete the members but not delete the posts or topics they created ?
Otherwise you will have posts where things are missing.
So just delete the user without deleting all the rest, or rename to guest or something