SQL Error : Error
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, 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, user_age, user_gender) VALUES (31, 'lam', 1028559204, '41d1de28e96dc1cde568d3b068fa17bb', 'no@no.com', '', '', '', '(Gran BsAs) Zona Norte', '15', 'ChicO','', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, -3, 'D M d, Y g:i a', 'spanish', 1, 0, 1, 1, '')
Line : 507
File : ./includes/usercp_register.php
Here's the code
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, 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, user_age, user_gender)
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) . "', '" . str_replace("\'", "''", $age) . "', '" . str_replace("\'", "''", $gender) . "','" . str_replace("\'", "''", $interests) . "', '" . 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, 0, 1, ";
Added info
Warning: SQL error: [Microsoft][Controlador ODBC Microsoft Access] Number of query values and destination fields are not the sameSQL state 22005 in SQLExecDirect in ./db/msaccess.php on line 159
Warning: Cannot add header information - headers already sent by (output started at ./db/msaccess.php:159) in ./includes/page_header.php on line 449
Warning: Cannot add header information - headers already sent by (output started at ./db/msaccess.php:159) in ./includes/page_header.php on line 450
Warning: Cannot add header information - headers already sent by (output started at ./db/msaccess.php:159) in ./includes/page_header.php on line 451
