Nothing to worry about. It's just informing you that you already have the database columns the installer is trying to add.
Manage Inactive Members
Started by Martin, Mar 15 2009 07:36 PM
108 replies to this topic
#102
Posted 19 January 2011 - 06:34 PM
ok,thanks every thing working now..
#103
Posted 08 March 2011 - 04:26 AM
Hi Martin, ive been using Notify inactive Members 1.2.1 for the last week and everything looks all right, the e-mails are sending, but when i want to see the
View Logs
* Notify Inactive Members Logs
this blank page appear
i have a large users database, so i think maybe thats cause this. So i just wanna know if there is a way to avoid this error and i can see the Logs.
thanks in advanced.
View Logs
* Notify Inactive Members Logs
this blank page appear
Quote
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 36004655 bytes) in /var/www/vhosts/mysite/httpdocs/******/sources/classes/output/adminOutput.php on line 592
i have a large users database, so i think maybe thats cause this. So i just wanna know if there is a way to avoid this error and i can see the Logs.
thanks in advanced.
#105
Posted 08 March 2011 - 10:41 PM
well i have a dedicated server, i think maybe i have a bad configuration, i want to know where change the memory limit and avoid this.
thanks.
thanks.
#106
Posted 22 May 2011 - 04:10 PM
I've noticed in the ACP that the footer is missing when viewing the log of who was notified and if there is only one link present to view inactive members it's unclickable.
Here's a screenshot of what I'm referencing.

As you can see, there's no dark blue background or links reading: "IP.Board 3 © 2011 IPS, Inc. | Get Support | Visit IPS Resources "
This was also posted at IPS.
Here's a screenshot of what I'm referencing.

As you can see, there's no dark blue background or links reading: "IP.Board 3 © 2011 IPS, Inc. | Get Support | Visit IPS Resources "
This was also posted at IPS.
#107
Posted 07 July 2011 - 04:16 AM
Hi Martin,
When I run Notify in Debug mode, I happily come up with 50 users to notify (I'm keeping the number low due to email send restrictions at the host), and can see all the data in the log.
Top of log is as follows:
When I run in normal mode, I get a different resilt.
It reports that One user was Notified, and if I drill down on the notification, it showas a non-existant user "g" with a join date of "Jan 01 1970 10:00 AM", belonging to no group, with a number of posts equal to "g"
Any suggestions on what might be going wrong? I've just moved and migrated the forum from e-blah, have lot's of inactive members that I'd like to sort out.
Many thanks
Criag
When I run Notify in Debug mode, I happily come up with 50 users to notify (I'm keeping the number low due to email send restrictions at the host), and can see all the data in the log.
Top of log is as follows:
Quote
\Query:
SELECT *
FROM members
WHERE last_activity <= 1307419639 AND (inactive_lastNotified <= 1309925239 OR inactive_lastNotified IS NULL) AND member_group_id IN(3) AND (allow_admin_mails = 1 OR allow_admin_mails IS NULL)
LIMIT 0,50
Found 50 inactive users
Array
(
[1138] => Array
(
[member_id] => 1138
[name] => celtenlange
SELECT *
FROM members
WHERE last_activity <= 1307419639 AND (inactive_lastNotified <= 1309925239 OR inactive_lastNotified IS NULL) AND member_group_id IN(3) AND (allow_admin_mails = 1 OR allow_admin_mails IS NULL)
LIMIT 0,50
Found 50 inactive users
Array
(
[1138] => Array
(
[member_id] => 1138
[name] => celtenlange
When I run in normal mode, I get a different resilt.
It reports that One user was Notified, and if I drill down on the notification, it showas a non-existant user "g" with a join date of "Jan 01 1970 10:00 AM", belonging to no group, with a number of posts equal to "g"
Quote
Member name Joined Posts Group
g Jan 01 1970 10:00 AM g
g Jan 01 1970 10:00 AM g
Any suggestions on what might be going wrong? I've just moved and migrated the forum from e-blah, have lot's of inactive members that I'd like to sort out.
Many thanks
Criag
#108
Posted 11 July 2011 - 01:16 PM
Hi guy's
i just upgraded this mod, but when i go to the settings i get a database error as follows:
Date: Mon, 11 Jul 2011 13:07:52 +0000 Error: 1064 - 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 'WHERE conf_key='im_moveInactive-enable' at line 1 IP Address: 124.177.160.207 - /admin/index.php?adsess=b06aa1003e76ec259d027d2a554b7e39&app=inactiveMembers ----------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- mySQL query error: UPDATE core_sys_conf_settings SET WHERE conf_key='im_moveInactive-enable .---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+----------------------- --------------------------------------------------------+-------------------| | admin/applications_addon/other/inactiveMembers/modules_admin/core/index.php| [db_main_mysql].update | 45 | '----------------------------------------------------------------------------+------------------- ------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_inactiveMembers_core_index].doExecute | 285 | '----------------------------------------------------------------------------+------------------- ------------------------------------------------------------+-------------------'
i just upgraded this mod, but when i go to the settings i get a database error as follows:
Date: Mon, 11 Jul 2011 13:07:52 +0000 Error: 1064 - 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 'WHERE conf_key='im_moveInactive-enable' at line 1 IP Address: 124.177.160.207 - /admin/index.php?adsess=b06aa1003e76ec259d027d2a554b7e39&app=inactiveMembers ----------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- mySQL query error: UPDATE core_sys_conf_settings SET WHERE conf_key='im_moveInactive-enable .---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+----------------------- --------------------------------------------------------+-------------------| | admin/applications_addon/other/inactiveMembers/modules_admin/core/index.php| [db_main_mysql].update | 45 | '----------------------------------------------------------------------------+------------------- ------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_inactiveMembers_core_index].doExecute | 285 | '----------------------------------------------------------------------------+------------------- ------------------------------------------------------------+-------------------'
#109
Posted 18 April 2012 - 03:41 PM
Hi,
Trying to upgrade to latest version and it gives this error when running the upgrade process:
It is asking me if I want to continue anyway. What do I do?
Thanks
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
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users





Contributor












