Registration Stopper

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
25
71%
Very Good
6
17%
Good
0
No votes
Fair
1
3%
Poor
3
9%
 
Total votes: 35

learn
Registered User
Posts: 1
Joined: Wed Nov 22, 2006 11:19 pm
Location: Earth/France/Corrèze/Treignac
Contact:

Post by learn »

Thanks for the mod Fountain of Apples.
Darkness cannot drive out darkness; only light can do that. Hate cannot drive out hate; only love can do that.
Martin Luther King, Jr.
User avatar
ddbowman5
Registered User
Posts: 6
Joined: Thu Sep 14, 2006 6:49 pm
Contact:

Can't get it to install via EM

Post by ddbowman5 »

I may be missing something, but I've tired to get this installed with no luck. Keep getting FTP cd error - says it can't find it, but it's there.
I do see that my directory is phpbb whereas the notation mentions phpbb2? Do I need to upgrade my base phpbb before I can install this MOD via EM?
I tried the txt change (Wordpad to Notepad) and have tried changing folders to get it to work - no go
Ideas?
d
User avatar
webmacster87
Former Team Member
Posts: 3758
Joined: Fri Jun 11, 2004 2:30 am
Location: San Mateo, CA
Name: Douglas Bell
Contact:

Re: Can't get it to install via EM

Post by webmacster87 »

ddbowman5 wrote: I may be missing something, but I've tired to get this installed with no luck. Keep getting FTP cd error - says it can't find it, but it's there.
I do see that my directory is phpbb whereas the notation mentions phpbb2? Do I need to upgrade my base phpbb before I can install this MOD via EM?
I tried the txt change (Wordpad to Notepad) and have tried changing folders to get it to work - no go
Ideas?
d

Probably something's up with your installation of EasyMOD. There's a forum for that, because unfortunately, I'm no EM expert.
Dave Bean
Registered User
Posts: 210
Joined: Thu Jul 12, 2001 4:55 am
Location: Denver, Colorado
Contact:

Post by Dave Bean »

I have the registration stopper installed and I think it is working. Rather than just have the registration link missing ( where is it - dont' you hate that !), I would like to add my own link to an alternate registration process (call me or request registration contact form that I'd develop) when the registration is disabled.

I'm not sure how to cause the link to appear when the registration link goes away. Any ideas.
Building Internet Communities
www.ColoradoHealth.info
User avatar
webmacster87
Former Team Member
Posts: 3758
Joined: Fri Jun 11, 2004 2:30 am
Location: San Mateo, CA
Name: Douglas Bell
Contact:

Post by webmacster87 »

Dave Bean wrote: I have the registration stopper installed and I think it is working. Rather than just have the registration link missing ( where is it - dont' you hate that !), I would like to add my own link to an alternate registration process (call me or request registration contact form that I'd develop) when the registration is disabled.

I'm not sure how to cause the link to appear when the registration link goes away. Any ideas.

You notice that the MOD makes edits to templates/subSilver/overall_header.tpl? The edits in that file are what allow the Register link to disappear. Simply undo the edits that the MOD made to that file and you'll be good to go.
Dave Bean
Registered User
Posts: 210
Joined: Thu Jul 12, 2001 4:55 am
Location: Denver, Colorado
Contact:

Post by Dave Bean »

Thanks for the suggestion, I left the registration link and just added a note that frequently we have the registration turned off because of spam and they can contact me at my phone number and I'll get them going or arrange a time they can register.

Hopefully we won't need the Registration Stopper as much after the Group Approval Mod is available. But it is great to actually put in a mod that has an immediate and dramatic effect on spam. I turn the registrations off at night and back on in the morning when I monitor with the notify_on_all_posts mod.

Thank you !! - this definitely should be a standard part of phpBB
Building Internet Communities
www.ColoradoHealth.info
User avatar
webmacster87
Former Team Member
Posts: 3758
Joined: Fri Jun 11, 2004 2:30 am
Location: San Mateo, CA
Name: Douglas Bell
Contact:

Post by webmacster87 »

Dave Bean wrote: Thank you !! - this definitely should be a standard part of phpBB

It's going to be in Olympus. ;)
cdh555
Registered User
Posts: 2
Joined: Sun Dec 17, 2006 2:23 pm

Post by cdh555 »

Fountain of Apples wrote: The best way would be to run it through phpMyAdmin, which is provided with most webhosts.

However, if you don't have that, then go to this URL and copy and paste ALL the code from the textbox on the page into a plain text file. Save this file with the name db_update.php. Then, in your phpBB installation, create a directory called install and upload db_update.php to that directory. Then, navigate to http://www.yourdomain.tld/path_to_phpBB ... update.php in your web browser, and follow the instructions. Once that's done, delete the install directory, and your database will have been updated.


First post, and I need a little help please.
I am attempting to install this mod an dI have to do this manually, now the file editing is no problem.

I am having to attempt to install this way as I do not have phpMyAdmin, I go the the link you provided but there is no text in the textbox.
Could you please look into this and advise?

Thanks.
User avatar
webmacster87
Former Team Member
Posts: 3758
Joined: Fri Jun 11, 2004 2:30 am
Location: San Mateo, CA
Name: Douglas Bell
Contact:

Post by webmacster87 »

The MOD team has an SQL Parser which you can use. Go to that link, and on the next page, copy in the SQL code to execute, then follow the rest of the directions. On the third step, you will be provided with code which you can save as a PHP file. Then, upload that PHP file to your board, run it in your web browser, and delete it--your database will be updated.
cdh555
Registered User
Posts: 2
Joined: Sun Dec 17, 2006 2:23 pm

Post by cdh555 »

Thanks for that. All added and working now.
ddhblt
Registered User
Posts: 57
Joined: Sun Feb 09, 2003 10:09 pm

Post by ddhblt »

Having trouble finding the correct code in profile.php only. I have the Profile Control Panel Mod so maybe that's the cause. Can you offer any advice?

Code: Select all

<?php
/***************************************************************************
 *                            profile.php
 *                            -----------
 *	begin				: 08/05/2003
 *	copyright			: Ptirhiik
 *	email				: admin@rpgnet-fr.com
 *
 *	version				: 1.0.9 - 17/10/2003
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'profilcp/functions_profile.'.$phpEx);

include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);
include($phpbb_root_path . 'includes/functions_validate.'.$phpEx);
include($phpbb_root_path . 'includes/functions_post.'.$phpEx);
include($phpbb_root_path . 'includes/bbcode.'.$phpEx);
include($phpbb_root_path . 'includes/emailer.'.$phpEx);
include_once($phpbb_root_path . 'includes/functions_topics_list.' . $phpEx);

//
// Start session management
$userdata = session_pagestart($user_ip, PAGE_PROFILE);
init_userprefs($userdata);

//
// Set default email variables
//
$script_name = preg_replace('/^\/?(.*?)\/?$/', '\1', trim($board_config['script_path']));
$script_name = ( $script_name != '' ) ? $script_name . '/profile.'.$phpEx : 'profile.'.$phpEx;
$server_name = trim($board_config['server_name']);
$server_protocol = ( $board_config['cookie_secure'] ) ? 'https://' : 'http://';
$server_port = ( $board_config['server_port'] <> 80 ) ? ':' . trim($board_config['server_port']) . '/' : '/';

$server_url = $server_protocol . $server_name . $server_port . $script_name;

//
//  get viewed user id
$view_user_id = ANONYMOUS;
if ( isset($HTTP_POST_VARS[POST_USERS_URL]) || isset($HTTP_GET_VARS[POST_USERS_URL]) )
{
	$view_user_id = isset($HTTP_POST_VARS[POST_USERS_URL]) ? intval($HTTP_POST_VARS[POST_USERS_URL]) : intval($HTTP_GET_VARS[POST_USERS_URL]);
}
if ($view_user_id==ANONYMOUS) $view_user_id = $userdata['user_id'];

//
// get the menu
$dir = @opendir($phpbb_root_path . "profilcp");
$setmodules = true;
while( $file = @readdir($dir) )
{
	if( preg_match("/^profilcp_.*?\." . $phpEx . "$/", $file) )
	{
		include($phpbb_root_path . "profilcp/" . $file);
	}
}
@closedir($dir);
unset($setmodules);

//
// sort
for ($i=0; $i < count($module['sub']); $i++)
{
	if ( !empty($module['sub'][$i]) )
	{
		@array_multisort( $module['sub'][$i]['sort'], $module['sub'][$i]['mode'], $module['sub'][$i]['shortcut'], $module['sub'][$i]['url'], $module['sub'][$i]['page_title'] );
	}
}
@array_multisort( $module['sort'], $module['mode'], $module['shortcut'], $module['url'], $module['page_title'], $module['sub'] );

//
// Mode
$mode = 'home';
if ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) )
{
	$mode = isset($HTTP_POST_VARS['mode']) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
}
if ( $mode == 'activate' ) 
{
	include($phpbb_root_path . "profilcp/profilcp_activate.$phpEx");
}
if ( $mode == 'email' ) 
{
	include($phpbb_root_path . "profilcp/profilcp_email.$phpEx");
}
if ( $mode == 'sendpassword' ) 
{
	include($phpbb_root_path . "profilcp/profilcp_sendpassword.$phpEx");
}
if ($mode == 'privmsg_popup')
{
	include($phpbb_root_path . "profilcp/profilcp_privmsg_popup.$phpEx");
}
if ( !in_array($mode, $module['mode']) ) $mode = 'home';

// no user_id asked, use current user
if ( $userdata['session_logged_in'] && ($view_user_id == ANONYMOUS) ) $view_user_id = $userdata['user_id'];

// check other $mode value
if ( !$userdata['session_logged_in'] )
{
	if ($mode != 'register')
	{
		if ($view_user_id == ANONYMOUS)
		{
			redirect(append_sid("login.$phpEx?redirect=profile.$phpEx", true));
		}
		else if ($mode != 'activate') 
		{
			redirect(append_sid("login.$phpEx?redirect=profile.$phpEx&mode=viewprofile&" . POST_USERS_URL . "=$view_user_id", true));
			$mode = 'viewprofile';
		}
	}
}
if ( $userdata['session_logged_in'] )
{
	if ($view_user_id == ANONYMOUS) $view_user_id = $userdata['user_id'];
	if ( ($view_user_id != $userdata['user_id']) && !is_admin($userdata) && ($mode != 'activate') )
	{
		$mode = 'viewprofile';
	}
}

// check view_user_id
$sql = "SELECT * FROM " . USERS_TABLE . " WHERE user_id=$view_user_id";
if(!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Couldn\'t obtain user information.', '', __LINE__, __FILE__, $sql);
}
if (!$user_row = $db->sql_fetchrow($result) )
{
	message_die(GENERAL_ERROR, $lang['No_such_user']);
}

// get curopt
$curopt = -1;
for ($i=0; ( ($i < count($module['mode'])) && ($curopt < 0) ); $i++ )
{
	if ($mode == $module['mode'][$i])
	{
		$curopt = $i;
	}
}

// sub-option
$sub = '';
if ( isset($HTTP_POST_VARS['sub']) || isset($HTTP_GET_VARS['sub']) )
{
	$sub = isset($HTTP_POST_VARS['sub']) ? $HTTP_POST_VARS['sub'] : $HTTP_GET_VARS['sub'];
}
if ( !isset($module['sub'][$curopt]['mode']) || !in_array($sub, $module['sub'][$curopt]['mode']) )
{
	$sub = '';
}

// get cur subopt
$cur_subopt = -1;
for ($i=0; ( ($i < count($module['sub'][$curopt]['mode'])) && ($cur_subopt < 0) ); $i++ ) if ($sub == $module['sub'][$curopt]['mode'][$i]) $cur_subopt = $i;
if ( ($cur_subopt < 0) && (count($module['sub'][$curopt]) > 0) )
{
	$cur_subopt = 0;
	$sub = $module['sub'][$curopt]['mode'][0];
}

// action
$set = '';
if ( isset($HTTP_POST_VARS['set']) || isset($HTTP_GET_VARS['set']) )
{
	$set = isset($HTTP_POST_VARS['set']) ? $HTTP_POST_VARS['set'] : $HTTP_GET_VARS['set'];
}
$no_header = in_array($set, array('add', 'remove'));

// session id get
$sid = '';
if (!empty($HTTP_POST_VARS['sid']) || !empty($HTTP_GET_VARS['sid']))
{
	$sid = (!empty($HTTP_POST_VARS['sid'])) ? $HTTP_POST_VARS['sid'] : $HTTP_GET_VARS['sid'];
}

// Control
$submit = ( isset($HTTP_POST_VARS['submit']) || (($mode=='privmsg') && isset($HTTP_POST_VARS['post'])) );
$reset = isset($HTTP_POST_VARS['reset']);
$remove = isset($HTTP_POST_VARS['remove']);
$adduser = isset($HTTP_POST_VARS['adduser']);
$preview = isset($HTTP_POST_VARS['preview']);
$cancel = isset($HTTP_POST_VARS['cancel']);
$confirm = isset($HTTP_POST_VARS['confirm']);

// privmsg
$save = isset($HTTP_POST_VARS['save']);
$mark_list = ( !empty($HTTP_POST_VARS['mark']) ) ? $HTTP_POST_VARS['mark'] : 0;
$save = ($save && $mark_list && ($sub != 'savebox') && ($sub != 'outbox'));

// reload the user row
$view_userdata = $user_row;
if ($submit || $remove || $adduser || $no_header || $save || $confirm)
{
	// session id check
	if ( ($sid != $userdata['session_id']) && ($set == '') && !$no_header && !defined('NO_SID'))
	{
		message_die(GENERAL_ERROR, 'Invalid_session');
	}

	if ( !empty($module['url'][$curopt]) && empty($module['sub'][$curopt]['url'][$cur_subopt]) )
	{
		@include( $phpbb_root_path . './profilcp/' . $module['url'][$curopt] );
	}
	if ( !empty($module['sub'][$curopt]['url'][$cur_subopt]) )
	{
		include( $phpbb_root_path . './profilcp/' . $module['sub'][$curopt]['url'][$cur_subopt] );
	}
	if (!$error && !$no_header)
	{
		$ret_link = append_sid("./profile.$phpEx?mode=$mode" . (($cur_subopt < 0) ? '' : "&sub=$sub") . "&" . POST_USERS_URL . "=$view_user_id" );
		$template->assign_vars(array(
			'META' => '<meta http-equiv="refresh" content="3;url=' . $ret_link . '">')
		);
		$message = $lang['Profile_updated'] . '<br /><br />' . sprintf($lang['Click_return_profilcp'], '<a href="' . $ret_link . '">', "</a>") . '<br /><br />';
		message_die(GENERAL_MESSAGE, $message);
	}
}
else if ($cancel)
{
	redirect(append_sid("./profile.$phpEx?mode=$mode&sub=$sub"));
}
else
{
	// set the page title and include the page header
	$page_title = $module['page_title'][$curopt];
	if ($cur_subopt >= 0) $page_title .= ' :: ' . $module['sub'][$curopt]['page_title'][$cur_subopt];
	include ($phpbb_root_path . './includes/page_header.' . $phpEx);

	// template file
	$template->set_filenames(array(
		'profilcp_header' => 'profilcp/profilcp_header.tpl')
	);
	//
	// menu
	$nb_opt = count($module['shortcut']);
	if ( $nb_opt < 8 ) $nb_opt = 8;
	$width = intval(100 / $nb_opt) +1;
	$filler_width = 100 - $width * count($module['shortcut']);
	if ($filler_width < 0) $filler_width = 0;
	$template->assign_vars(array(
		'NBOPT'			=> $nb_opt,
		'WIDTH'			=> $width,
		'FILLER_WIDTH'	=> $filler_width,
		)
	);
	if ( $nb_opt > count($module['shortcut']) )
	{
		$template->assign_block_vars('filleropt', array() );	
	}

	for ($i=0; $i < count($module['shortcut']); $i++)
	{
		$switch = ($curopt==$i) ? 'curopt' : ( ($userdata['session_logged_in'] && ( ($userdata['user_id'] == $view_user_id) || (is_admin($userdata) && ($level_prior[get_user_level($userdata)] > $level_prior[get_user_level($view_userdata)])))) ? 'otheropt' : 'inactopt' );
		$template->assign_block_vars('opt', array());
		$link = append_sid("./profile.$phpEx?mode=" . $module['mode'][$i] . ( ($view_userdata['user_id'] != ANONYMOUS) ? '&' . POST_USERS_URL . '=' . $view_userdata['user_id'] : '') );
		if ( count($module['sub'][$i]['mode']) == 1 )
		{
			// only one sub-module
			$link = append_sid("./profile.$phpEx?mode=" . $module['mode'][$i] . "&sub=" . $module['sub'][$i]['mode'][0] . ( ($view_userdata['user_id'] != ANONYMOUS) ? '&' . POST_USERS_URL . '=' . $view_userdata['user_id'] : '') );
		}
		$template->assign_block_vars('opt.' . $switch, array(
			'SHORTCUT'		=> $module['shortcut'][$i],
			'U_SHORTCUT'	=> $link,
			)
		);
	}
	//
	// sub-menu
	if ( ($cur_subopt >= 0) && (count($module['sub'][$curopt]['mode']) > 1) )
	{
		$nb_opt = count($module['sub'][$curopt]['shortcut']);
		if ( $nb_opt < 8 ) $nb_opt = 8;
		$width = intval(100 / $nb_opt) +1;
		$filler_width = 100 - $width * count($module['sub'][$curopt]['shortcut']);
		if ($filler_width < 0) $filler_width = 0;

		$template->assign_block_vars('sub_menu', array(
			'U_MODULE'		=> append_sid("./profile.$phpEx?mode=" . $module['mode'][$curopt] . "&sub=$sub" . ( ($view_userdata['user_id'] != ANONYMOUS) ? '&' . POST_USERS_URL . '=' . $view_userdata['user_id'] : '') ),
			'L_MODULE'		=> $module['sub'][$curopt]['page_title'][$cur_subopt],
			'NBOPT'			=> $nb_opt,
			'WIDTH'			=> $width,
			'FILLER_WIDTH'	=> $filler_width,
			)
		);

		if ( $nb_opt > count($module['sub'][$curopt]['shortcut']) )
		{
			$template->assign_block_vars('sub_menu.filleropt', array() );
		}

		for ($i=0; $i < count($module['sub'][$curopt]['shortcut']); $i++)
		{
			$switch = ($cur_subopt==$i) ? 'curopt' : ( ($userdata['session_logged_in'] && ( ($mode=='viewprofile') || ($userdata['user_id'] == $view_user_id) || (is_admin($userdata) && ($level_prior[get_user_level($userdata)] > $level_prior[get_user_level($view_userdata)])))) ? 'otheropt' : 'inactopt' );
			$template->assign_block_vars('sub_menu.opt', array());
			if ($i < count($module['sub'][$curopt]['shortcut']))
			{
				$template->assign_block_vars('sub_menu.opt.' . $switch, array(
					'SHORTCUT'		=> $module['sub'][$curopt]['shortcut'][$i],
					'U_SHORTCUT'	=> append_sid("./profile.$phpEx?mode=" . $module['mode'][$curopt] . "&sub=" . $module['sub'][$curopt]['mode'][$i] . ( ($view_userdata['user_id'] != ANONYMOUS) ? '&' . POST_USERS_URL . '=' . $view_userdata['user_id'] : '') ),
					)
				);
			}
		}
	}

	// system info
	$s_hidden_fields  = '<input type="hidden" name="mode" value="' . $mode . '">';
	$s_hidden_fields .= '<input type="hidden" name="' . POST_USERS_URL . '" value="' . $view_user_id . '">';
	$s_hidden_fields .= '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '">';
	if ( $cur_subopt >= 0) $s_hidden_fields .= '<input type="hidden" name="sub" value="' . $sub . '">';

	$s_pagination_fields = 'mode=' . $mode;
	if ($view_user_id != ANONYMOUS)
	{
		$s_pagination_fields .= '&' . POST_USERS_URL . "=$view_user_id";
	}
	$s_pagination_fields .= '&sid=' . $userdata['session_id'];
	if ($cur_subopt >= 0)
	{
		$s_pagination_fields .= '&sub=' . $sub;
	}

	//
	// page header constant
	if (!isset($nav_separator)) $nav_separator = '&nbsp;->&nbsp;';
	$template->assign_vars(array(
		'NAV_SEPARATOR'		=> $nav_separator,
		'L_MODULE'			=> ( ($view_userdata['user_id'] != ANONYMOUS) ? $view_userdata['username'] : $lang['Guest'] ) . '&nbsp;:&nbsp;' . $module['page_title'][$curopt],
		'U_MODULE'			=> append_sid("./profile.$phpEx?mode=" . $module['mode'][$curopt] . ( ($view_userdata['user_id'] != ANONYMOUS) ? '&' . POST_USERS_URL . '=' . $view_userdata['user_id'] : '') ),
		)
	);

	// header
	$template->pparse('profilcp_header');

	// module
	if ( !empty($module['url'][$curopt]) && empty($module['sub'][$curopt]['url'][$cur_subopt]) )
	{
		@include( $phpbb_root_path . './profilcp/' . $module['url'][$curopt] );
	}
	if ( !empty($module['sub'][$curopt]['url'][$cur_subopt]) )
	{
		@include( $phpbb_root_path . './profilcp/' . $module['sub'][$curopt]['url'][$cur_subopt] );
	}

	// footer
	$template->set_filenames(array(
		'profilcp_footer' => 'profilcp/profilcp_footer.tpl')
	);

	// sub-menu
	if ( $cur_subopt >= 0 )
	{
		$template->assign_block_vars('sub_menu_b', array());
	}
	$template->pparse('profilcp_footer');

	//
	// page_footer
	include($phpbb_root_path . './includes/page_tail.'.$phpEx);
}

?>
aprilbelle
Registered User
Posts: 5
Joined: Mon Jan 01, 2007 10:02 am

Post by aprilbelle »

im having big problems.

im trying to upload a hack onto my gwyneth boards [ www.gwynethpaltrowfan.com ] that will allow me to turn off registration, we realllllly need it at the momment because of spam , plus of the negative attention shes getting now we get a lot of haters sign up.

i uploaded the right files, etc and i went into myphpadmin and ran the mysql code and i think ive mucked it up. is there anyway to reverse it? i can't get this script to work and its really buggered me!

i ran:

Code: Select all

 INSERT INTO `phpbb_config` VALUES ('registrations_accept', '1');
and when i do now i get this :

Code: Select all


INSERT INTO `phpbb_config`
VALUES (
'registrations_accept', '1'
)

MySQL said: Documentation
#1062 - Duplicate entry 'registrations_accept' for key 1



and when i go to my forum and click the disable registrations i get this messgae:

Code: Select all



Failed to update general configuration for ('registrations_accept', '1');

DEBUG MODE

SQL 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 'registrations_accept', '1');'' at line 3

UPDATE phpbb_config SET config_value = '' WHERE config_name = ' ('registrations_accept', '1');'

Line : 69
File : admin_board.php

on admin_board.php im pretty positive i did that right.


if someone can fix it or tell me how to fix it i will be greatful!


if you can help please email me fansite.email@gmail.com or leave a message!
User avatar
webmacster87
Former Team Member
Posts: 3758
Joined: Fri Jun 11, 2004 2:30 am
Location: San Mateo, CA
Name: Douglas Bell
Contact:

Post by webmacster87 »

ddhblt wrote: Having trouble finding the correct code in profile.php only. I have the Profile Control Panel Mod so maybe that's the cause. Can you offer any advice?

Yes: Don't use Profile Control Panel. :)

Well, okay, so I'm a little biased with regards to that. However, this MOD is not compatible with Profile Control Panel, I'm afraid, and I don't really know my way around that MOD's files.

_________________
aprilbelle: First of all, do this to flush out whatever happened to your database:

Code: Select all

DELETE FROM phpbb_config WHERE config_name = 'registrations_accept';
If it lets you do that, good, if it doesn't let you do that, something else is wrong.
If it lets you do that, try this again:

Code: Select all

INSERT INTO phpbb_config VALUES ('registrations_accept', '1');
If either of those give you errors in phpMyAdmin, post them here. If both work fine and are accepted by phpMyAdmin, then try the script again and see if it works.
aprilbelle
Registered User
Posts: 5
Joined: Mon Jan 01, 2007 10:02 am

Post by aprilbelle »

Thanks a bunch for the mysql to fix it. It did fine as far as I can see.

I'm still getting:

Code: Select all

Failed to update general configuration for ('registrations_accept', '1');

DEBUG MODE

SQL 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 'registrations_accept', '1');'' at line 3

UPDATE phpbb_config SET config_value = '' WHERE config_name = ' ('registrations_accept', '1');'

Line : 79
File : admin_board.php
I checked out my line 79 and this is what it is:

Code: Select all

				message_die(GENERAL_ERROR, "Failed to update general configuration for $config_name", "", __LINE__, __FILE__, $sql);
What can I try next?
User avatar
webmacster87
Former Team Member
Posts: 3758
Joined: Fri Jun 11, 2004 2:30 am
Location: San Mateo, CA
Name: Douglas Bell
Contact:

Post by webmacster87 »

I think I'm seeing what's wrong here, and it's probably my fault. Go into phpMyAdmin, and click on the database you're using from the left. Then on the new list that appears on the left side, click on the phpbb_config link. From the tabs at the top of the page, click on Browse. This should now show a long list. Go to the last page (click the >> button, I think), and the very last item (or near the last item) in the list shoulld say registrations_accept somewhere inside it. (It may say something weirder.) Hit the delete button (a red X) within that row to delete it.

Then, try this new SQL (a little bit stricter):

Code: Select all

INSERT INTO phpbb_config (config_name, config_value) VALUES ('registrations_accept', '1');
Then tell me if that works. Also, tell me what version of MySQL you are using. If that doesn't work, then we'll have to dig deeper. ;)
Post Reply

Return to “[2.0.x] MOD Database Releases”