Enable account activation Won't stay Active

I will no longer provide phpBB2 support due to phpBB2's EOL announcement. If you need help with phpBB2 you can try phpBB2 Refugees.
Locked
Coroner
Posts: 30
Joined: Wed Jan 31, 2007 9:20 pm
Contact:

Enable account activation Won't stay Active

Post by Coroner » Tue Jul 24, 2007 10:44 pm

Hello David, It's been a while!

I really could use your expert help with this one.

When I click on the Enable account activation "user" button in the acp configuration section and then submit, it keeps changing wright back to "none"????? I tried "admin" but every time it keeps going wright back to "none"

I noticed the problem after a person wanting to join said that the board thought they were a spambot. I then noticed that not only the warning line was missing from the registration page but then found the above issue. I have installed many mods but this issue just came up so I might have narrowed down to 2 listed in the support ticket on phpbb.com but I haven't got any reply.

Here's the ticket which I hope will provide enough information to some how find a fix. I'm guessing it's a data base issue.

Your phpBB board URL: http://cscoroner.com/phpbb2/index.php
Template(s) used:Glass (blue), subSilver, many more.....
Any and all MODs: Most resent mods are easyUCP= http://phpbbhacks.com/download/3576 and easyUCP Extension= http://phpbbhacks.com/download/6118. Only these before the issue started.
Do you use a port of phpBB:No
Version of phpBB:phpbb2 version .22
Version of PHP:Don't know where to find this?
Which database server and version:MySQL - 4.1.20-max-log
Host:iXwebhosting.com
Did someone install this for you/who:iX web hosting business package
Is this an upgrade/from what to what:.Start with16. upgraded 17,18,19,21,22
Is this a conversion/from what to what:No.
Have you searched for your problem:Yes
If so, what terms did you try:Enable account activation, account activation, activation, activations more.....
State the nature of your problem:When I click on the Enable account activation "user" button and then submit, it keeps changing wright back to "none"????? I tried "admin" but every time it keeps going wright back to "none"
Do you have a test account for us:id=Test, pw=654321

Please look things over and let me know what you think!

Thanks!
Image

User avatar
DavidIQ
Site Admin
Posts: 581
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Re: Enable account activation Won't stay Active

Post by DavidIQ » Fri Jul 27, 2007 7:43 am

Hmmm...not really sure why that's happening but you can try running this directly on your database and see if it activates that feature:

UPDATE phpbb_config SET config_value = 2 WHERE config_name = 'require_activation'

It might need to be set to 1 instead of 2...not sure. I don't use admin activation on any of my boards but go ahead and try the above and see if you're able to turn the feature on that way.

Coroner
Posts: 30
Joined: Wed Jan 31, 2007 9:20 pm
Contact:

Re: Enable account activation Won't stay Active

Post by Coroner » Fri Jul 27, 2007 8:23 am

Thanks for your help David, I tried both 1 and 2 and got "Affected rows: 0 (Query took 0.0003 sec)" Went in and it still resets back to none? What worrys me is that if this issue has removed the registration line from the Spambot bod telling folks not to enter any info below the info line then what else is being affected.

I did find these in the php_confirm table? Not sure what they are or if they are causeing some problems?

Your thoughts?
Attachments
php_confim.jpg
Image

User avatar
DavidIQ
Site Admin
Posts: 581
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Re: Enable account activation Won't stay Active

Post by DavidIQ » Fri Jul 27, 2007 12:17 pm

It's config not confirm.

Coroner
Posts: 30
Joined: Wed Jan 31, 2007 9:20 pm
Contact:

Re: Enable account activation Won't stay Active

Post by Coroner » Sat Jul 28, 2007 12:05 am

Thanks for your help with this David. I put the php_confirm table screen shot in because I thought it looked weird and because it's "confirm" I thought it might be related to my problems.

I found in the php_config table "require_acti" instead of "require_activation"?. Once changed to "require_activation" I can now change the settings and they hook. I tested and the board now sends an activation email so problem there solved.

The last problem I now face is with Stop_Spambot_Registration-1.0.2a mod. The red "do not enter anything below this line" in the registration profile page still doesn't show up. The mods working fine because I'm still getting attempt emails daily so that part is still up to speed. I'm not sure how long the "do not enter anything below this line" stopped working and I did install the profile mods before I found these issues so I'm not exactly sure if it's the new profile mods or something else I've done?

I've attached the SpamBot mod for you to review in case there's something else that I could do to get it back up to speed also. Very frustrating because It looks as though I'm close and it's probibly wright under my nose but I just don't have the experience or knowledge to figure it out on my own.

Please let me know what you think.
Attachments
Stop_Spambot_Registration-1.0.2a.zip
(3.13 KiB) Downloaded 288 times

User avatar
DavidIQ
Site Admin
Posts: 581
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Re: Enable account activation Won't stay Active

Post by DavidIQ » Sat Jul 28, 2007 6:20 am

The most likely cause for the red text to be missing is that you've probably removed this from your current template's profile_add_body.tpl file:

Code: Select all

	<!-- BEGIN switch_register -->
	<tr bgcolor="#FF0000">	
	  <td colspan="2">
		<span class="h1" style="color: white">{SPAMBOT_MESSAGE}</span><br /><br />
		<span class="gen" style="color: white">{SPAMBOT_MESSAGE_EXPLAIN}</span>
	  </td>
	</tr>
	<!-- END switch_register -->

Coroner
Posts: 30
Joined: Wed Jan 31, 2007 9:20 pm
Contact:

Re: Enable account activation Won't stay Active

Post by Coroner » Wed Aug 01, 2007 11:40 am

Thanks for the help David. Yes the code is in there. I have attached the file for you to look at. Maybe there's something blocking the code from working or do you think it's another db issue?

Please let me know.

Thanks!
Attachments
profile_add_body.zip
(2.67 KiB) Downloaded 270 times
Image

User avatar
DavidIQ
Site Admin
Posts: 581
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Re: Enable account activation Won't stay Active

Post by DavidIQ » Wed Aug 01, 2007 11:55 am

I totally overlooked this part on the includes/usercp_register.php edits:

Code: Select all

#
#-----[ FIND ]------------------------------------------
#

		$template->assign_block_vars('switch_edit_profile', array());
	}

#
#-----[ AFTER, ADD ]------------------------------------------
#

//----BEGIN Stop Spambot Registration MOD
	if ( $mode == 'register' )
	{
		$template->assign_block_vars('switch_register', array());
		$template->assign_vars(array(
			'SPAMBOT_MESSAGE' => $lang['Spambot_message'],
			'SPAMBOT_MESSAGE_EXPLAIN' => $lang['Spambot_message_explain'])
		);
	}
//----END Stop Spambot Registration MOD
Without that the spambot message variables don't get populated and the section doesn't get rendered.

Coroner
Posts: 30
Joined: Wed Jan 31, 2007 9:20 pm
Contact:

Re: Enable account activation Won't stay Active

Post by Coroner » Wed Aug 01, 2007 11:55 pm

Thats already in there. Here's the full file for you to review:
Attachments
usercp_register.zip
(13.78 KiB) Downloaded 284 times
Image

User avatar
DavidIQ
Site Admin
Posts: 581
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Re: Enable account activation Won't stay Active

Post by DavidIQ » Thu Aug 02, 2007 7:43 am

Ah....I see where the problem is. You installed easyUCP and the location where the code is is commented out. Take this code:

Code: Select all

//----BEGIN Stop Spambot Registration MOD
	if ( $mode == 'register' )
	{
		$template->assign_block_vars('switch_register', array());
		$template->assign_vars(array(
			'SPAMBOT_MESSAGE' => $lang['Spambot_message'],
			'SPAMBOT_MESSAGE_EXPLAIN' => $lang['Spambot_message_explain'])
		);
	}
//----END Stop Spambot Registration MOD
and replace it with this:

Code: Select all

*/
//----BEGIN Stop Spambot Registration MOD
	if ( $mode == 'register' )
	{
		$template->assign_block_vars('switch_register', array());
		$template->assign_vars(array(
			'SPAMBOT_MESSAGE' => $lang['Spambot_message'],
			'SPAMBOT_MESSAGE_EXPLAIN' => $lang['Spambot_message_explain'])
		);
	}
//----END Stop Spambot Registration MOD
/*
That should bring you back up.

Coroner
Posts: 30
Joined: Wed Jan 31, 2007 9:20 pm
Contact:

Re: Enable account activation Won't stay Active

Post by Coroner » Thu Aug 02, 2007 8:25 am

Thanks again for your help with this David. I tried the new code commenting the spam mod back in and it didn't work. Weird huh?

I've attached both easyUCP's that are installed for you to look at. One is the original and the other is the extension mod that had more db additions.
Attachments
easyUCP extension - Second Profilpage.zip
(30.2 KiB) Downloaded 290 times
easyUCP 1.2.0.zip
(32.16 KiB) Downloaded 281 times
Image

User avatar
DavidIQ
Site Admin
Posts: 581
Joined: Thu Sep 07, 2006 4:31 pm
Location: Earth
Contact:

Re: Enable account activation Won't stay Active

Post by DavidIQ » Thu Aug 02, 2007 8:56 am

Ok...one last try. In usercp_register.php do the following:

Code: Select all

#
#----- [FIND] -----
#
$template->assign_block_vars('switch_register', array());

#
#----- [REPLACE WITH] -----
#
$template->assign_block_vars('switch_ucp_require.switch_register', array());

Coroner
Posts: 30
Joined: Wed Jan 31, 2007 9:20 pm
Contact:

Re: Enable account activation Won't stay Active

Post by Coroner » Fri Aug 03, 2007 12:15 am

Thank for you efforts and patients with this David but I'm afraid it didn't hook. Here's a screen shot with both the edits. If I leave the first comment edits out the registration page looks normal so I think I might have a db issue or just might need to find another anti-spambot mod. I really like this one and it's been faithful for so long. I got 3 spambot notifications today so I know it still works but If folks don't read the announcement section across the top of the front page then they wind up getting kicked.

Please take your time is you would please. Maybe there's something needing to be removed rather then added. I have no clue but I really do appreciate all you've done to help.
Attachments
screenshot3.JPG
Image

Coroner
Posts: 30
Joined: Wed Jan 31, 2007 9:20 pm
Contact:

Re: Enable account activation Won't stay Active

Post by Coroner » Sun Sep 23, 2007 4:01 pm

Found the problem. Just needed to move the edit to another location so easyUCP wouldn't over write it.
Image

Locked