"Could not insert data into users table"
Verfasst: 20.05.2003 19:45
Gäste können sich nicht mehr registrieren.
Ich hab letzte Woche mit einem MOD ein paar neue Felder in die MySQL-Tabelle (fürs Profil) geschrieben (z.B. user_music).
Ich hab jene neuen Felder in der usercp_register.php etc. nach user_interests hinzugefügt (etwaiger Konflikt mit z.B. Birthday-Mod?).
In der MySQL-Tabelle sind die neuen Felder jetzt ganz am Schluß angeordnet.
Benutzes MOD: http://www.phpbbhacks.com/viewhack.php?id=193
Installiertes Board: phpBB 2.0.4 (bzw. 1.0 plus mit diversen MODs).
Hier die Fehlermeldung mit exemplarischen Inhalten der Felder:
Hier ein paar Zeilen (zwischen 500 und 700) aus usercp_register.php:
Ich hab letzte Woche mit einem MOD ein paar neue Felder in die MySQL-Tabelle (fürs Profil) geschrieben (z.B. user_music).
Ich hab jene neuen Felder in der usercp_register.php etc. nach user_interests hinzugefügt (etwaiger Konflikt mit z.B. Birthday-Mod?).
In der MySQL-Tabelle sind die neuen Felder jetzt ganz am Schluß angeordnet.
Benutzes MOD: http://www.phpbbhacks.com/viewhack.php?id=193
Installiertes Board: phpBB 2.0.4 (bzw. 1.0 plus mit diversen MODs).
Hier die Fehlermeldung mit exemplarischen Inhalten der Felder:
Code: Alles auswählen
SQL Error : 1136 Column count doesn't match value count at row 1
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_from_flag, user_interests, user_movies, user_actor, user_director, user_music, 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_gender, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES (269, 'Ursula1000', 1053413202, '37a08ed30093a133b1bb4ae0b8f3601f', 's.h@on-web.de', '', '', 'occ', 'from', 'germany.gif', 'interests', 'movies' , 'actor' , 'director' , 'music' 'signatur', '81cce37924', '', 0, 0, 'AIM-Name', 'Yahoo-Messenger', 'MSN-Messenger', 1, 1, 0, 1, 1, 0, 1, 1, 1, 'd.m.Y - H:i', 'german', 2, '1', 0, 1,'3652','2004', 0, 'fc44141c73e')
Line : 594
File : /var/www/web134/html/forum/includes/usercp_register.php
Code: Alles auswählen
//
// Get current date
//
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_from_flag, user_interests, user_movies, user_actor, user_director, user_music, 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_gender, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_active, user_actkey)
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '$user_flag', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $movies) . "' , '" . str_replace("\'", "''", $actor) . "' , '" . str_replace("\'", "''", $director) . "' , '" . str_replace("\'", "''", $music) . "' '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, '$gender', 0, 1,'$birthday','$next_birthday_greeting', ";
if ( $board_config['require_activation'] == USER_ACTIVATION_SELF || $board_config['require_activation'] == USER_ACTIVATION_ADMIN || $coppa )
{
$user_actkey = gen_rand_string(true);
$key_len = 54 - (strlen($server_url));
$key_len = ( $key_len > 6 ) ? $key_len : 6;
$user_actkey = substr($user_actkey, 0, $key_len);
$sql .= "0, '" . str_replace("\'", "''", $user_actkey) . "')";
}
else
{
$sql .= "1, '')";
}
if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )
{
message_die(GENERAL_ERROR, 'Could not insert data into users table', '', __LINE__, __FILE__, $sql);
}
$sql = "INSERT INTO " . GROUPS_TABLE . " (group_name, group_description, group_single_user, group_moderator)
VALUES ('', 'Personal User', 1, 0)";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not insert data into groups table', '', __LINE__, __FILE__, $sql);
}
$group_id = $db->sql_nextid();
$sql = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending)
VALUES ($user_id, $group_id, 0)";
if( !($result = $db->sql_query($sql, END_TRANSACTION)) )
{
message_die(GENERAL_ERROR, 'Could not insert data into user_group table', '', __LINE__, __FILE__, $sql);
}