Following this error, I do not manage to put these two lines of codes correctly, I have this error, please can you help me ?
Could not insert data into users table usercp_register.php
- Code: Select all
INSERT INTO phpbb_users (user_reg_ip, user_reg_host,user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, disallow_profile_search, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_skype, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_allow_mass_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_gender, user_sponsor_id, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_passwd_change, user_active, user_actkey) VALUES ('127.0.0.1', 'user01',130, 'Bidon', 1096850951, '25d55ad283aa400af464c76d713c07ad', 'o3665hbee2tdmq1@jetable.net', '', '', '', '', '', 0, '', '', '', 0, 1, '', '', '', '', 1, 1, 1, 1, 1, 1, 1, 2, 1, 2, 'D d M Y G:i', 'french', 1, '2', 3, 0, 1, 1096850951,0, 'cf866e')
- Code: Select all
$sql = "INSERT INTO " . USERS_TABLE . " (user_reg_ip, user_reg_host,user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, disallow_profile_search, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_skype, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_allow_mass_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_gender, user_sponsor_id, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_passwd_change, user_active, user_actkey)
- Code: Select all
VALUES ('" . str_replace("\'", "''", $user_reg_ip) . "', '" . str_replace("\'", "''", $user_reg_host) . "',$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) . "', '" . str_replace("\'", "''", $interests) . "', $disallow_profile_search, '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', '" . str_replace("\'", "''", $skype) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $allow_mass_pm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, '$gender', $sponsor_id, 0, 1, ".time().",";
