CNB No Activation email / No entry in nuke_users_temp

slappy · New Member Joined: May 28, 2006 Posts: 23

Hi,

Before installing CNB Your Account, new users were getting the activation email and an entry was being added to the nuke_users_temp table in the database. Users were able to click on the link in the email and activate their account and log on to my site with no problems. All was working fine. After installing CNBYA activation emails are not being sent and there is no new entries being added to the nuke_users_temp table in the database after a new user registers. Website feedback is still working. The settings in the CNB User config are as follows:

Allow User Registration: Yes
Require Admin Approval: No
Allow User self-deactivation: No
Doublecheck email at registration: Yes
COPPA Compliance Required: Yes
Show Terms of Service [TOS]: No
Show TOS to members as well: No

Email Options
Server can send mail? Yes
Notify Admin of User Registration: No
Notify Admin of User Deactivation: No
Use Email Activation? Yes
Allow User Email Change: Yes
Validate Email Changes: Yes

I am using the following:
CNB Your Account 4.4.0
NUKE 7.6 patch 3.1
Apache2Triad version 1.4.4
Apache version 2.0.55
MySQL version 4.0.26
PHP version 4.4.2
Path to PHP C:/apache2triad/php/bin/php.exe
Ability Mail Server v2.52

srhh · Involved Joined: Dec 27, 2005 Posts: 296

Sounds like the database info didn't get installed right. I recall I had to manually input the SQL into the database using phpmyadmin when I installed CNBYA because the self-installer didn't work.

Here is a post with the SQL info:

Only registered users can see links on this board!
Get registered or login to the forums!

slappy · New Member Joined: May 28, 2006 Posts: 23

OK everything went fine up to the point where I ran the Alter Table line:

When I run:

SQL query:

ALTER TABLE ".$user_prefix."_users ADD agreedtos TINYINT( 1 ) DEFAULT 0 NOT NULL

MySQL said: Documentation
#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 '".$user_prefix."_users ADD agreedtos TINYINT(1) DEFAULT 0 NOT N

SQL query:

ALTER TABLE ".$user_prefix."_users_temp ADD realname VARCHAR( 255 ) NOT NULL AFTER username

MySQL said: Documentation
#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 '".$user_prefix."_users_temp ADD realname VARCHAR(255) NOT NULL

My syntax is incorect?

Please help!

slappy · New Member Joined: May 28, 2006 Posts: 23

OK, It looks like nuke_users and nuke_users_temp all ready have the added agreedtos and realname tables added. Probably from the first run of the install.php. I am still not getting any entry in the temp_users table after submitting and no email.

Somthing else is not right here.

slappy · New Member Joined: May 28, 2006 Posts: 23

OK,

I think I figured it out, but I need a fix for this. I De-installed the tables, and re-installed a fresh copy via install.php. All operations completed OK.

Then I went through the User config and left the security code check OFF. That did it. When I have Security code turned on, and try to register, I dont get the entry in the nuke_users_temp and no email. When I turn it off, everything works. I seem to remember seeing somthing like this somewhere in these forums. If you know the link or know what is going on, please let me know.

Thanks
Slappy

Pride · Regular Joined: Oct 22, 2003 Posts: 59

slappy wrote:

OK,

I think I figured it out, but I need a fix for this. I De-installed the tables, and re-installed a fresh copy via install.php. All operations completed OK.

Then I went through the User config and left the security code check OFF. That did it. When I have Security code turned on, and try to register, I dont get the entry in the nuke_users_temp and no email. When I turn it off, everything works. I seem to remember seeing somthing like this somewhere in these forums. If you know the link or know what is going on, please let me know.

Thanks
Slappy

I have this same exact problem! If you find a fix for it, please let me know and I'll do the same!

Only registered users can see links on this board!
Get registered or login to the forums!

slappy · New Member Joined: May 28, 2006 Posts: 23

I have not found a fix, and I am still running with Security Code check OFF. But if I find anything, I will post here.

gregexp · Posted: Fri Jun 09, 2006 6:29 pm

slappy...was that the sql query u ran from phpmyadmin or did u run the installer?

SQL query:

ALTER TABLE ".$user_prefix."_users ADD agreedtos TINYINT( 1 ) DEFAULT 0 NOT NULL

MySQL said: Documentation
#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 '".$user_prefix."_users ADD agreedtos TINYINT(1) DEFAULT 0 NOT N

slappy · New Member Joined: May 28, 2006 Posts: 23

Well, The first time I installed it, I used the installer. The second time, I ran from phpmyadmin. I didn't remove agreedtos and realname tables befor running the second time, so I think that is why I got those errors.

gregexp · Posted: Fri Jun 09, 2006 6:49 pm

the real reason u got the error...is ".$user_prefix." is a variable...when nuke runs it...it actually says nuke_users...as that variable is by default set to nuke.

if its there dont worry bout this but if the agreedtos isnt there...just make it nuke_users instead of ".$user_prefix."_users

slappy · New Member Joined: May 28, 2006 Posts: 23

Ok,

Well the agreedtos and realname tables are there. But the problem of not being able to turn on the Security Code Check still exits.

gregexp · Posted: Fri Jun 09, 2006 7:06 pm

open ur text editor...paste this:

<?php
if (extension_loaded('gd')) echo "GD is loaded";
else echo "GD is NOT loaded";
?>

..name is php.php
Then upload it to the root of ur site

then goto ursite.com/php.php

If it says GD is loaded then we have some problems to figure out....if it says its not loaded then this is a server issue that u cannot address.

slappy · New Member Joined: May 28, 2006 Posts: 23

It says GD is loaded Dance-Y

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

The testing for the 5.0 beta of CNBYA has been reactivated. We should add this to the testing process to make sure it is address in the new version.

darklord, it seems you might be a good candidate for that testing if you are not already involved. Interested?

slappy · New Member Joined: May 28, 2006 Posts: 23

I have an update on my issue. I was able to get the security code check to work for Log on Only. New user registration still has it turned off. If I turn it on for both, or just new registration, I get the problem where the new user is not added to temp_user table and no email is sent.

So, has there been a fix for this? I would really like to have a security code check for new user registration.

Thanks,
Slappy

Website:

Only registered users can see links on this board!
Get registered or login to the forums!

PHP-NUKE v7.6 / patched 1.3
Apache2Triad version 1.4.4
Apache version 2.0.55
MySQL version 4.0.26
PHP version 4.4.2
CNB Your Account version 4.4.0

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

Development and testing is focused on the 5.0 version. We can request that this be tested in that version. I'd guess they'd be reluctant to revisit the 4.4.2 version, though, when the 5.0 version is so close (well, it's been close for about a year now).