my site registration is not working

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
userkiller
I've Been Banned!
Posts: 189
Joined: Sun Dec 07, 2008 5:02 am
Location: student

my site registration is not working

Post by userkiller » Tue Apr 28, 2009 1:17 am

Hi i install auto group and my site started going crazy.

I made a posted with my previews error but the mod the made it is now giving any support, i manage to fix the problem and now i got another problem.


When am registrating after i click submit i get this
General Error
SQL ERROR [ mysqli ]

Field 'user_arcade_permissions' doesn't have a default value [1364]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Every thing was working fine until i install this stupid auto group mod.


Sad thing is that i don't have any back up, since my cp back up wasn't working for 1 month, i didn't notice until i check my email it was saying you directory is bigger then 4gb cp cannot back up.



things in did to install the mod:

Code: Select all

File Copy
Copy: root/language/en/mods/info_acp_auto_groups.php
To: language/en/mods/info_acp_auto_groups.php
Copy: root/includes/functions_autogroup.php
To: includes/functions_autogroup.php
Copy: root/adm/style/auto_groups.html
To: adm/style/auto_groups.html
Edits
s↑↓

Use your keyboard to navigate the code boxes. You may also hit 's' on your keyboard to go to the first code box.

Open: includes/functions.php
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
// append/replace SID (may change during the session for AOL users)
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.
CODE: SELECT ALL
			// Handle auto grouping
			if (!function_exists('auto_group'))
			{
				include($phpbb_root_path . 'includes/functions_autogroup.'.$phpEx);
			}
			auto_group();
			
Open: includes/functions_posting.php
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
			markread('post', $data['forum_id'], $data['topic_id'], $data['post_time']);
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.
CODE: SELECT ALL
					$user->data['user_posts']++;
		if (!function_exists('auto_group'))
		{
			include($phpbb_root_path . 'includes/functions_autogroup.'.$phpEx);
		}
		auto_group();
		$user->data['user_posts']--;
			
Open: includes/functions_admin.php
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
			
	}

	// Remove topics now having no posts?
			
Add before
Tip: Add these lines on a new blank line before the preceding line(s) to find.
CODE: SELECT ALL
			
		if (!function_exists('auto_group'))
		{
			global $phpEx;
			include($phpbb_root_path . 'includes/functions_autogroup.'.$phpEx);
		}
		auto_group(array_keys($post_counts));
			
Open: includes/functions_user.php
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
			
		'group_founder_manage'	=> 'int',
			
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.
CODE: SELECT ALL
			
		// auto group mod
		'group_min_days'		=> 'int',
		'group_max_days'		=> 'int',
		'group_min_warnings'	=> 'int',
		'group_max_warnings'	=> 'int',
		'group_min_posts'		=> 'int',
		'group_max_posts'		=> 'int',
		'group_auto_default'	=> 'int',
			
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
			$group_only_ary = array('group_receive_pm', 'group_legend', 'group_message_limit',
In-line Find
Tip: This is a partial match of a line for in-line operations.
CODE: SELECT ALL
'group_founder_manage'
In-line Add after
CODE: SELECT ALL
, 'group_min_days', 'group_max_days', 'group_min_warnings', 'group_max_warnings', 'group_min_posts', 'group_max_posts', 'group_auto_default'
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
		// Setting the log message before we set the group id (if group gets added)
		$log = ($group_id) ? 'LOG_GROUP_UPDATED' : 'LOG_GROUP_CREATED';
Add before
Tip: Add these lines on a new blank line before the preceding line(s) to find.
CODE: SELECT ALL
		if (!function_exists('auto_group'))
		{
			global $phpEx;
			include($phpbb_root_path . 'includes/functions_autogroup.'.$phpEx);
		}
		$make_default = false;
		$auto_add_users = auto_groups_create($group_id, $make_default);

		// now we have all the information to insert auto users into the table if required
		if (isset($auto_add_users) && sizeof($auto_add_users))
		{
			group_user_add($group_id, $auto_add_users, false, false, $make_default, 0, 0, false, 1);

			unset($auto_add_users);
		}
		// end auto groups mod
			
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
function group_user_add
In-line Find
Tip: This is a partial match of a line for in-line operations.
CODE: SELECT ALL
$group_attributes = false
In-line Add after
CODE: SELECT ALL
, $auto_group = 0
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
				'user_pending'	=> (int) $pending,
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.
CODE: SELECT ALL
				'auto_group'	=> (int) $auto_group,
			
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
function group_user_del
In-line Find
Tip: This is a partial match of a line for in-line operations.
CODE: SELECT ALL
$group_name = false
In-line Add after
CODE: SELECT ALL
, $auto_group = 0
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
	
	$sql = 'DELETE FROM ' . USER_GROUP_TABLE . "
		WHERE group_id = $group_id
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.
CODE: SELECT ALL
			AND (auto_group = $auto_group
				OR auto_group = 1)
Open: includes/acp/acp_groups.php
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
						'message_limit'		=> request_var('group_message_limit', 0),
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.
CODE: SELECT ALL
						// auto groups mod
						'min_days'		=> request_var('min_group_days', 0),
						'max_days'		=> request_var('max_group_days', 0),
						'min_warnings'	=> request_var('min_group_warnings', 0),
						'max_warnings'	=> request_var('max_group_warnings', 0),
						'min_posts'		=> request_var('min_group_posts', 0),
						'max_posts'		=> request_var('max_group_posts', 0),
						'auto_default'	=> isset($_POST['group_auto_default']),
			
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
$test_variables = array
In-line Find
Tip: This is a partial match of a line for in-line operations.
CODE: SELECT ALL
'founder_manage'
In-line Add after
CODE: SELECT ALL
					, 'min_days', 'max_days', 'min_warnings', 'max_warnings', 'min_posts', 'max_posts', 'auto_default'
				
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
					'GROUP_HIDDEN'		=> $type_hidden,
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.
CODE: SELECT ALL
					// auto group mod
					'MIN_GROUP_DAYS'		=> (isset($group_row['group_min_days'])) ? $group_row['group_min_days'] : 0,
					'MAX_GROUP_DAYS'		=> (isset($group_row['group_max_days'])) ? $group_row['group_max_days'] : 0,
					'MIN_GROUP_WARNINGS'	=> (isset($group_row['group_min_warnings'])) ? $group_row['group_min_warnings'] : 0,
					'MAX_GROUP_WARNINGS'	=> (isset($group_row['group_max_warnings'])) ? $group_row['group_max_warnings'] : 0,
					'MIN_GROUP_POSTS'		=> (isset($group_row['group_min_posts'])) ? $group_row['group_min_posts'] : 0,
					'MAX_GROUP_POSTS'		=> (isset($group_row['group_max_posts'])) ? $group_row['group_max_posts'] : 0,
					'S_GROUP_AUTO_DEFAULT'	=> (isset($group_row['group_auto_default']) && $group_row['group_auto_default']) ? ' checked="checked"' : '',
			
Open: adm/style/acp_groups.html
Find
Tip: This may be a partial find and not the whole line.
CODE: SELECT ALL
	
	<fieldset>
		<legend>{L_GROUP_AVATAR}</legend>
Add before
Tip: Add these lines on a new blank line before the preceding line(s) to find.
CODE: SELECT ALL
		<!-- INCLUDE auto_groups.html -->
			
Requesting people that can develop softwares pm me.
example gaming trainers.
If you are a rpgmmo gamers pm me.

User avatar
COD3M4ST3R-X
Registered User
Posts: 2269
Joined: Sat Aug 02, 2008 5:47 am
Location: Lahore,Pakistan

Re: my site registration is not working

Post by COD3M4ST3R-X » Tue Apr 28, 2009 1:53 am

The error is coming from the Arcade Mod you have installed.
Try this,
Doesn't have a default value errors
But i doubt this might not fix the issue as this is only intended to Fix default phpbb table,s
For Auto Groups MOD Just undo the Edits/Clear your board,s Cache :)
“Need and struggle are what excite and inspire us.”

userkiller
I've Been Banned!
Posts: 189
Joined: Sun Dec 07, 2008 5:02 am
Location: student

Re: my site registration is not working

Post by userkiller » Tue Apr 28, 2009 2:27 am

This don't work, what was the point am i already unistall the mod that how i fix the previews error now am getting this stupid error, omg am going crazy :twisted: :twisted: :twisted: :twisted:
Requesting people that can develop softwares pm me.
example gaming trainers.
If you are a rpgmmo gamers pm me.

User avatar
COD3M4ST3R-X
Registered User
Posts: 2269
Joined: Sat Aug 02, 2008 5:47 am
Location: Lahore,Pakistan

Re: my site registration is not working

Post by COD3M4ST3R-X » Tue Apr 28, 2009 2:36 am

userkiller wrote:This don't work, what was the point am i already unistall the mod that how i fix the previews error now am getting this stupid error, omg am going crazy :twisted: :twisted: :twisted: :twisted:
I already said it might not fix the issue.
That error is coming from the ARCADE MOD to fix it refer to the MOD,s TOPIC
By, the way did you ran the SQL Queries generated by the script in phpmy admin?
“Need and struggle are what excite and inspire us.”

userkiller
I've Been Banned!
Posts: 189
Joined: Sun Dec 07, 2008 5:02 am
Location: student

Re: my site registration is not working

Post by userkiller » Tue Apr 28, 2009 2:42 am

So is it the php files or the database?
Requesting people that can develop softwares pm me.
example gaming trainers.
If you are a rpgmmo gamers pm me.

User avatar
COD3M4ST3R-X
Registered User
Posts: 2269
Joined: Sat Aug 02, 2008 5:47 am
Location: Lahore,Pakistan

Re: my site registration is not working

Post by COD3M4ST3R-X » Tue Apr 28, 2009 2:44 am

userkiller wrote:So is it the php files or the database?
Database
“Need and struggle are what excite and inspire us.”

userkiller
I've Been Banned!
Posts: 189
Joined: Sun Dec 07, 2008 5:02 am
Location: student

Re: my site registration is not working

Post by userkiller » Tue Apr 28, 2009 2:56 am

Code: Select all

ALTER TABLE phpbb_groups ADD group_min_posts MEDIUMINT(8) DEFAULT 0;
ALTER TABLE phpbb_groups ADD group_max_posts MEDIUMINT(8) DEFAULT 0;
ALTER TABLE phpbb_groups ADD group_min_warnings MEDIUMINT(8) DEFAULT 0;
ALTER TABLE phpbb_groups ADD group_max_warnings MEDIUMINT(8) DEFAULT 0;
ALTER TABLE phpbb_groups ADD group_min_days MEDIUMINT(8) DEFAULT 0;
ALTER TABLE phpbb_groups ADD group_max_days MEDIUMINT(8) DEFAULT 0;
ALTER TABLE phpbb_groups ADD group_auto_default TINYINT(1) DEFAULT 0;
ALTER TABLE phpbb_user_group ADD auto_group TINYINT(1) DEFAULT '0';

That the database thing i added when every stopped working.

I guess they are not compatible.
Requesting people that can develop softwares pm me.
example gaming trainers.
If you are a rpgmmo gamers pm me.

User avatar
COD3M4ST3R-X
Registered User
Posts: 2269
Joined: Sat Aug 02, 2008 5:47 am
Location: Lahore,Pakistan

Re: my site registration is not working

Post by COD3M4ST3R-X » Tue Apr 28, 2009 2:58 am

COD3M4ST3R-X wrote:That error is coming from the ARCADE MOD to fix it refer to the MOD,s TOPIC
“Need and struggle are what excite and inspire us.”

userkiller
I've Been Banned!
Posts: 189
Joined: Sun Dec 07, 2008 5:02 am
Location: student

Re: my site registration is not working

Post by userkiller » Tue Apr 28, 2009 3:01 am

One thing this mod was install almost 2 month ago, my site started going crazy yesterday when i installed auto group.



Thank any ways.


I already posted my issue


i dId a database restore and still the same problem. jesus none of the support team people want to help :cry:
Requesting people that can develop softwares pm me.
example gaming trainers.
If you are a rpgmmo gamers pm me.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50582
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: my site registration is not working

Post by stevemaury » Wed Apr 29, 2009 12:01 pm

For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

Locked

Return to “[3.0.x] Support Forum”