CMS MADE SIMPLE FORGE

Newsletter Made Simple

 

[#8537] Can't add user with fresh installation

avatar
Created By: Fab (alticom)
Date Submitted: Wed Oct 17 10:44:57 -0400 2012

Assigned To: Robert Campbell (calguy1000)
Version: 2.6.2
CMSMS Version: 1.11.2
Severity: Critical
Resolution: Fixed
State: Closed
Summary:
Can't add user with fresh installation
Detailed Description:
Error : "No list found"... when i want to add user from admin panel.
Of course i create one, and two list for test, nothing to do !
Thanks!



History

Comments
avatar
Date: 2012-10-19 08:23
Posted By: Robert (kostra)

same error here.
cmsms upgraded from 1.10 --> installed tnms (problem with no lists while
creating job) --> installed nms (problem with no lists while creating users).
i have 3 lists (1 public) created in first tab.

CMSMS: 1.11.2
NMS: 2.6.2
      
avatar
Date: 2012-10-24 08:55
Posted By:  (itmanx)

Same problem :(  Thought it was me just not figuring it out but unfortunately
not.

Error : "No list found"... when i want to add user from admin panel.
      
avatar
Date: 2012-10-24 10:16
Posted By: Broken Rules (dont)

Same problem here, with 2 cmsms  1.11.2 clean installs
      
avatar
Date: 2012-10-24 10:16
Posted By:  (itmanx)

OK, I found that inside the file action.admin_addedit_user.php line 169 there is
an SQL statement to check for lists which finds all active lists.

SELECT * FROM ".NMS_LIST_TABLE."
          WHERE active = 1 AND COALESCE(dynamic,'') != ''
          ORDER BY listid"

If you look in the cms_module_nms_list table in the database, you will find a
column called `active` with -1 as the value.  Set this to 1 and you can add
users.... at least, you can view the add user form.

But now when you try to add a user, you will get the error Incorrect datetime
value: '' for column 'dateadded' at row 1

To solve that, I went back in to the php file, line 58 and replaced with this

		  'dateadded'=>date("Y-m-d H:i:s"),
		  'dateconfirmed'=>null);



I also think there's a typo on line 93 where it has

  if( $userinfo['confirmed'] = 0 && (int)$params['confirmed'] == 1 ) {

should it not be

  if( $userinfo['confirmed'] == 0 && (int)$params['confirmed'] == 1 ) {

      
avatar
Date: 2012-10-24 10:21
Posted By:  (itmanx)

There is also another problem on line 94

  if( $userinfo['confirmed'] == 0 && (int)$params['confirmed'] == 1 ) {
    $userinfo['dateconfirmed'] = $db->DbTimeStamp(time());
  }

Incorrect datetime value: ''2012-10-24 15:19:56'' for column 'dateconfirmed' at
row 1

Changed to :

  if( $userinfo['confirmed'] == 0 && (int)$params['confirmed'] == 1 ) {
$userinfo['dateconfirmed'] = date("Y-m-d H:i:s");//
$db->DbTimeStamp(time());
  }


      
avatar
Date: 2012-10-24 10:25
Posted By:  (itmanx)

There is also a language string missing

-- Missing Languagestring - module:NMS string:operation_successful--

Open the lang/en_US.php (or whatever language you use) and add the following
somewhere

$lang['operation_successful'] = 'Operation Successful';
      
avatar
Date: 2012-10-24 10:36
Posted By: Robert Campbell (calguy1000)

fixed.... btw, the fix below was incorrect.
      
avatar
Date: 2012-10-24 13:06
Posted By: Andrew Smith (andrewvideo)

Yes I noiced the last one yesterday  

 
      
avatar
Date: 2012-10-24 17:16
Posted By:  (itmanx)

Thanks CalGuy.

Sorry if my corrections weren't correct.  Was just trying to help :(

Xian
      
avatar
Date: 2012-10-24 17:21
Posted By:  (itmanx)

I am unable to download the update though...
      
avatar
Date: 2012-10-25 07:01
Posted By:  (itmanx)

There are so many problems in your files!  Such as when checking for an existing
users email, all it does is create an $error value to say the email address
exists and then continues to add the email anyway.  I have corrected so many
errors. Still working my way through them.  You also have cross checks,
sometimes you start checking for userid and then uniqueid.  A user cant be added
to any lists because you miss that part out altogether and dont even return the
last_insert_id. Argh!! But working to fix it.  Still doesnt send emails, still
doesnt display on the homepage.

I have updated the latest version to
http://aicp.dev.itmanx.com/cmsmadesimple/modules/nms.tar.gz

To untar files:  tar xvzf nms.tar.gz

I have no idea what this dynamic variable is all about yet... hopefully soon it
will be apparent why you are asking for the user_agent or copyright info when
you already have the email addresses??
      
avatar
Date: 2012-10-25 07:39
Posted By:  (itmanx)

ok, the lists now appear on the homepage... now to get it to actually email out
:s
      
Updates

Updated: 2012-10-25 08:55
state: Open => Closed

Updated: 2012-10-24 10:36
resolution_id: 5 => 7

Updated: 2012-10-17 10:45
version_id: 29742 => 29820
resolution_id: => 5