Manage Inactive Members

[Mousie]

I upgraded a 3.2.3 board to 3.3.0 with this app installed. It works as it ever did LOL

Unsure whether that's sarcasm there, but have tried to do this myself and no success. App seems to be functioning mostly fine, until I try and enable a task through the task settings. Then getting this error:

Fatal error: Using $this when not in object context in /home/.../forums/admin/sources/base/core.php(1558) : eval()'d code on line 6

Never actually ran the app on 3.2, so I don't know if this is a pre-existing bug with my configuration. :D

[tAPir]

No, no sarcasm. I already had it installed on 3.2.3 and already had set it up. I upgraded to 3.3.0 and it's still working.

I've just tried altering my settings, however, and am getting the same error as you. So it looks like you're stuck until the App is revamped to work on 3.3.0. Sorry.

[Rugger]

No disrespect to you two. However I'm a little surprised people are running to upgrade to 3.3. It's bound to take modders several weeks to upgrade their apps. Also should IPS revamp 3.3 due to issues, it may mean modders who were early to update their app, MAY have to redo the app again.

[Martin A.]

I had already thought of that. However all our member groups are used, and if we added another group, members would ask,"what's this new group for?" We in return would have to explain that it's for people with long term sickness, or going to be away for a while. Now some people don't want other members to know they have a medical condition, or whatever it could be, and just want to inform an admin in confidence.

Also we have lots of group which have varying forums permissions, etc. This new group couldn't be tailored for the varying permissions, and we would have to set up a exception group for each existing group which would get out of control.

Hence why I made my above suggestion. Do you feel you could add this function in?

I do like your suggestion, and will add a new section where you can add members who should be excluded from all tasks :)
I'll get that done after the initial update for 3.3.

Unsure whether that's sarcasm there, but have tried to do this myself and no success. App seems to be functioning mostly fine, until I try and enable a task through the task settings. Then getting this error:

Never actually ran the app on 3.2, so I don't know if this is a pre-existing bug with my configuration. :D

I'll look into that as soon as my 3.3 dev board is set up :)

[Rugger]

Thx Martin :)

[Logan]

Hi Martin,

On all outgoing emails from the system I see an image at the top "logo_transparent.png". Is there anyway to remove that from the emails? I looked through some of the source files but I couldn't find it.

[Martin A.]

Hi Martin,

On all outgoing emails from the system I see an image at the top "logo_transparent.png". Is there anyway to remove that from the emails? I looked through some of the source files but I couldn't find it.

That is part of the new HTML email template introduced in v3.2, but the image have been removed in v3.3.

[Martin A.]

Updated for fix the error in IP.Board 3.3 when updating settings. Also added the request below.

I had already thought of that. However all our member groups are used, and if we added another group, members would ask,"what's this new group for?" We in return would have to explain that it's for people with long term sickness, or going to be away for a while. Now some people don't want other members to know they have a medical condition, or whatever it could be, and just want to inform an admin in confidence.

Also we have lots of group which have varying forums permissions, etc. This new group couldn't be tailored for the varying permissions, and we would have to set up a exception group for each existing group which would get out of control.

Hence why I made my above suggestion. Do you feel you could add this function in?

[ClanFeC]

I installed this and got sql errors and now when I try to remove it, it says problem with the database. Not sure what's going on.

[tAPir]

I installed this and got sql errors and now when I try to remove it, it says problem with the database. Not sure what's going on.

It seems to work except you get an error with this on install:

CREATE TABLE ibf_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) );

I put that exact line in three times manually and it was accepted on the third go as being successful.

[Martin A.]

I installed this and got sql errors and now when I try to remove it, it says problem with the database. Not sure what's going on.

It seems to work except you get an error with this on install:

CREATE TABLE ibf_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) );

I put that exact line in three times manually and it was accepted on the third go as being successful.

That is odd. Did both an upgrade and fresh install before I released it, without any issues. Does the error log say what's wrong with the query? (Stats > Logs > SQL Error Logs)

[tAPir]

No , that's the strange thing. It said something along the lines of "There is an error in your SQL syntax near
exclude_id int(10) NOT NULL AUTO_INCREMENT, I clicked continue anyway and got the message
"There is an error with your database" referring to that error.
I then logged into ACP again and tried inserting the line manually through SQL Toolbox. It failed twice with the same message and then the
third time just said "query successful".

I'm no wiser because there's no entry in the sql log since the 24th.

[ClanFeC]

I think I had leftover sql stuff from the last time I installed this, I'm not sure. Is there a way to manually remove the information so I can remove the application/?

[Martin A.]

The added columns and tables should be removed when you uninstall that app.

If you still have leftovers after the app is removed, you can run these queries:

DROP TABLE IF EXISTS `inactivemembers_excludedmembers`;

ALTER TABLE members DROP `inactive_notified`, DROP `inactive_lastNotified`, DROP `inactive_oldGroup`, DROP `inactive_moved`;

[Tarun]

That is odd. Did both an upgrade and fresh install before I released it, without any issues. Does the error log say what's wrong with the query? (Stats > Logs > SQL Error Logs)

I too encountered this error. There is nothing in SQL error logs about it.

Error: CREATE TABLE ipb_`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`)

);


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

I was unable to proceed with updating the mod from 1.3.4 to 1.4.0 and I was also unable to uninstall it after trying to upgrade it to 1.3.4. Edit: This happens with a clean install too. Got this message:

· CREATE TABLE ipb_`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 '`inactivemembers_excludedmembers` ( `exclude_id` int(10) NOT NULL AUTO_INCREME' at line 1

[Martin A.]

Ah, I see. The table prefix is outside the quotes. Should be fixed now in 1.4.1.

[tAPir]

Ah, I see. The table prefix is outside the quotes. Should be fixed now in 1.4.1.

Oops :P

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)

);

[Tarun]

Oops :tongue:

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)

);

Is it still occurring? (I haven't tried to reinstall it yet. I removed 1.3.4 and figured wait.)

[Martin A.]

Oops :tongue:

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)

);

Oh dear lord.

What about now? Rebuilt the zip file.

[tAPir]

Thanks Martin, installs perfectly but (there's always a but):

Warning: Invalid argument supplied for foreach() in /usr/www/users/mysite/forum/admin/applications_addon/other/inactiveMembers/tasks/deleteOldMsg.php on line 203

When trying to alter settings for Delete Old Messages. Also the section of that form for task debugging is duplicated:
Task Debugging
Enable debug? YesNo
Useful to figure out why the task doesn't work!
When this is enabled, no messages will be deleted.

After enabling this, a list of message ID's, as well as the query will be printed if you run the query manually trough "Task Manager"

TURN OFF when you're done Task Debugging
Enable debug? YesNo
Useful to figure out why the task doesn't work!
When this is enabled, no messages will be deleted.

After enabling this, a list of message ID's, as well as the query will be printed if you run the task manually trough the "System Scheduler"

TURN OFF when you're done

[Martin A.]

Nothing catastrophic with those.

I'm on the move, so I'll have to deal with those after Easter.

[Escort Cabriolet Club]

Have downloaded latest package and uploaded but havent got the option to install from acp?

[AlexJ]

Still same error I guess:

CREATE TABLE ipb_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

[tAPir]

Nothing catastrophic with those.

I'm on the move, so I'll have to deal with those after Easter.

When you get back to this, I also get an error message when trying to run the Delete Old Messages from the ACP:

Warning: Invalid argument supplied for foreach() in /usr/www/mysite/admin/applications_addon/other/inactiveMembers/tasks/deleteOldMsg.php on line 203

The same as when trying to alter the settings.

The task appears to run OK though :smile:

[Azoun]

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