Problem med Registering

[MathiaSthlm]

Hejsan, jag har har phpbb sedan ett tag installerat och allt har fungerat utmärkt, tills nyligen då jag tror de har hänt nått med Databasen.

Jag har phpBB 2.0.19 installerat.

När man försöker registrera sig så kommer man till nästa sida där de står:

Kod: Markera allt

Could not insert data into users table

DEBUG MODE

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_regip, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (221, 'matte', 1168867384, '202cb962ac59075b964b07152d234b70', 'mr_beer@hotmail.com', 'c2446232', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 1, 'D M d, Y g:i a', 'english', 3, 0, 1, 0, '1b5798dc')

Line : 637
File : usercp_register.php

Forumet fungerar som vanligt förutom att det inte går att registrera nya användare...

Vad kan ha hänt? Jag har testat att använda gamla .php filer om de är någon M.O.D som har pajat för mig

//Mathias

[PazZze]

har detta hänt efter någon modd installerades eller? känns som om den inte hittar till rätt tabell... fungerar det att skriva inlägg osv?

[MathiaSthlm]

har detta hänt efter någon modd installerades eller? känns som om den inte hittar till rätt tabell... fungerar det att skriva inlägg osv?

Hejsan, allt annat fungerar utan problem

Jag har 2 installerade mod:s, IP registering och någon en som heter "Prune Users" så man kan mass sparka användare... och Prune är den senaste installerade...

Jag installerade Prune för inte så länge sedan så de är inte omöjligt att de hänt nått där

[PazZze]

får sätta mig lite senare och titta på vad det kan vara.. orkar itne just nu...

men kan du klistra in rad 635->640 från usercp_register.php (gärna med radnummer på raderna om du orkar)

så ska jag se vad det kan tänkas vara i morgon

[MathiaSthlm]

får sätta mig lite senare och titta på vad det kan vara.. orkar itne just nu...

men kan du klistra in rad 635->640 från usercp_register.php (gärna med radnummer på raderna om du orkar)

så ska jag se vad det kan tänkas vara i morgon

Fan va snällt.. självklart...

Kod: Markera allt

630				else				
631				{				
632					$sql .= "1, '')";			
633				}				
634								
635				if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )				
636				{				
637					message_die(GENERAL_ERROR, 'Could not insert data into users table', '', __LINE__, __FILE__, $sql);			
638				}				
639								
640				$sql = "INSERT INTO " . GROUPS_TABLE . " (group_name, group_description, group_single_user, group_moderator)				
641					VALUES ('', 'Personal User', 1, 0)";			
642				if ( !($result = $db->sql_query($sql)) )				
643				{				
644					message_die(GENERAL_ERROR, 'Could not insert data into groups table', '', __LINE__, __FILE__, $sql);			
645				}				
646								
647				$group_id = $db->sql_nextid();				
648								
649				$sql = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending)				

Säg till om de räcker eller om de är nått mer du behöver veta...

tackar!

[MathiaSthlm]

Hittade denna fil för installation av Inactive User - Prune:

Kod: Markera allt

<?php 
/*************************************************************************** 
*                               db_update.php 
*                            ------------------- 
* 
*   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey 
* 
***************************************************************************/ 

/*************************************************************************** 
* 
*   This program is free software; you can redistribute it and/or modify 
*   it under the terms of the GNU General Public License as published by 
*   the Free Software Foundation; either version 2 of the License, or 
*   (at your option) any later version. 
* 
***************************************************************************/ 

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

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


if( !$userdata['session_logged_in'] ) 
{ 
   $header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: '; 
   header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true)); 
   exit; 
} 

if( $userdata['user_level'] != ADMIN ) 
{ 
   message_die(GENERAL_MESSAGE, 'You are not authorised to access this page'); 
} 


$page_title = 'Updating the database'; 
include($phpbb_root_path . 'includes/page_header.'.$phpEx); 

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">'; 
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">'; 


$sql = array(); 

$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_inactive_emls TINYINT( 1 ) NOT NULL"; 
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_inactive_last_eml INT( 11 ) NOT NULL"; 
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('removed_users', '0')";

for( $i = 0; $i < count($sql); $i++ ) 
{ 
   if( !$result = $db->sql_query ($sql[$i]) ) 
   { 
      $error = $db->sql_error(); 

      echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />'; 
   } 
   else 
   { 
      echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successfull</b></font></li><br />'; 
   } 
} 


echo '</ul></span></td></tr>'; 

echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Have a nice day</a></span></td></table>'; 

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

?>

Den har säkert pajat nått.

[Marcus]

Finns det någon uppgift om vilka ändringar som krävs i filen:

includes/usercp_register.php

/marcus

[MathiaSthlm]

Finns det någon uppgift om vilka ändringar som krävs i filen:

includes/usercp_register.php

/marcus

inga va ja kan förstå, de är nog nått i databasen som e keff tyvärr.. så här ser install.txt ut:

Kod: Markera allt

############################################################## 
## MOD Title: Inactive Users
## MOD Author: Sko22 < sko22@quellicheilpc.it > (N/A) http://www.quellicheilpc.it/
## MOD Description: Checks how many users who have never been activated, or 
## have 0 messages it makes you choose whether to contact them or to delete them
## MOD Version: 1.1.8 
##
## Installation Level: Easy 
## Installation Time: 5 Minutes 
## Files To Edit: 
##			language/lang_english/lang_admin.php
##			admin/admin_users.php
## Included Files: 
##			admin/admin_users_inactive.php
##			templates/subSilver/admin/user_inactive_body.tpl
##			language/lang_english/email/user_inactive_contact.tpl
##			language/lang_english/email/user_inactive_delete.tpl
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/ 
##############################################################
## Author Notes: 
## I have tested this MOD whit phpBB 2.0.10 and MySQL Database 3.23.56
## This MOD work only if in "Enable account activation" you have selected "User" or "Admin".
##
## Future versions can be found at http://www.quellicheilpc.it
## I've set up a support forum for my mods at http://www.quellicheilpc.it/forum
##
## This MOD is released under the GPL License. 
## Intellectual Property is retained by the MOD Author(s) listed above 
## Copyright:      ©2003 Inactive Users 1.1.8 - Sko22
############################################################## 
## MOD History: 
##
##   2005-03-13 - Version 1.1.8
##	- Added a tracer for removed users
##   2004-08-08 - Version 1.1.7
##	- Added links to select checkboxs in just one click
##   2004-06-13 - Version 1.1.6
##	- Added a minipanel to show user whit zero messages
##	- Added user last login in the panel (Tanks to wanted)
##   2004-06-10 - Version 1.1.5
##	- Added Users whit zero messages
##   2004-02-27 - Version 1.1.4
##	- Added colors past days
##   2003-10-21 - Version 1.1.3
##	- Added edit profile users
##   2003-10-21 - Version 1.1.2
##	- Fixed bug with activation link (Tanks to rocco)
##	- Fixed bug with installer
##	- Fixed bug whith delete users
##   2003-09-19 - Version 1.1.1
##	- Added email link to see user email, fixed bugs with  Mozilla 1.0.1 on Linux (Tanks to Adam Paquet)
##   2003-09-18 - Version 1.1.0
##	- Added Activate button and the Last Email Sent Date in the panel
##   2003-09-16 - Version 1.0.0
##	- Initial Release
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 

#
#-----[ COPY ]------------------------------------------
#

copy admin_users_inactive.php to admin/admin_users_inactive.php
copy user_inactive_body.tpl to templates/subSilver/admin/user_inactive_body.tpl
copy user_inactive_contact.tpl to language/lang_english/email/user_inactive_contact.tpl
copy user_inactive_delete.tpl to language/lang_english/email/user_inactive_delete.tpl

# 
#-----[ SQL ]------------------------------------------ 
# 
#   If you don't know how to execute sql queries, then copy
#   mysql_install.php into your phpbb directory and run it.
#   (assuming you use mysql)
#   After process delete it.
#
#   If you don't use mysql, you'll have to edit these queries accordingly
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 

ALTER TABLE phpbb_users ADD user_inactive_emls TINYINT( 1 ) NOT NULL ;
ALTER TABLE phpbb_users ADD user_inactive_last_eml INT( 11 ) NOT NULL ;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('removed_users', '0') ;

# 
#-----[ OPEN ]------------------------------------------ 
#

admin/admin_users.php

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

//
// Begin program
//

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

// 
// Set username
// 
if( isset( $HTTP_GET_VARS['username'] ) )
{
	$HTTP_POST_VARS['username'] = $HTTP_GET_VARS['username'];
}

# 
#-----[ OPEN ]------------------------------------------ 
#

language/lang_english/lang_admin.php

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

//
// That's all Folks!
// -------------------------------------------------

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
#

//Beginning Inactive Users

$lang['Users_Inactive'] = 'Inactive Users';
$lang['Users_Inactive_Explain'] = 'If in "Enable account activation" you have selected "User" or "Admin", in this list you will have the Users who have never been activated.<br /><br />By clicking on "Contact" you will send a contact e-mail to all the selected Users.<br />By clicking on "Activate" you will activate all the selected Users.<br />By clicking on "Delete" you will send an e-mail and delete all the selected Users.';
$lang['UI_Check_None'] = '"Enable account activation" is on <b>None</b>.';
$lang['UI_Check_User'] = '"Enable account activation" is on <b>User</b>';
$lang['UI_Check_Admin'] = '"Enable account activation" is on <b>Admin</b>.';
$lang['UI_Check_Recom'] = '%sChange it%s.';
$lang['UI_Removed_Users'] = 'Removed Users';
$lang['UI_User'] = 'User';
$lang['UI_Registration_Date'] = 'Registration Date';
$lang['UI_Last_Visit'] = 'Last Visit';
$lang['UI_Active'] = 'Active';
$lang['UI_Email_Sents'] = 'Email Sents';
$lang['UI_Last_Email_Sents'] = 'Last Email';
$lang['UI_CheckColor'] = 'Check';
$lang['UI_CheckAll'] = 'Check All';
$lang['UI_UncheckAll'] = 'Uncheck All';
$lang['UI_InvertChecked'] = 'Invert Checked';
$lang['UI_Contact_Users'] = 'Contact';
$lang['UI_Delete_Users'] = 'Delete';
$lang['UI_Activate_Users'] = 'Activate';
$lang['UI_select_user_first'] = 'You must to select a User before';
$lang['UI_return'] = 'Click %sHere%s to return to the Inactive Users';
$lang['UI_Deleted_Users'] = 'The Users has been removed';
$lang['UI_Activated_Users'] = 'The Users has been actived';
$lang['UI_Alert_Days'] = "days";
$lang['UI_with_zero_messages'] = "with zero messages";
$lang['UI_Alert_Every'] = "Every";
$lang['UI_Alert_UpTo'] = "Up to";
$lang['UI_Alert_Over'] = "Over";

//End Inactive Users

# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM 

[MathiaSthlm]

Någon tapper hjälte som ser vad som är fel?

[MathiaSthlm]

Någon kanske? Har fortfarande inte fått till det?