MODS.DB9.DK

[pzsniper]

Sorry, i can't explain, now it DOESN'T work anymore....

i dunno why, i'm near to cry

[pzsniper]

OK!!
Deleted and re-created alla SQL tables and NOW it work perfectly!
Also problem of 1970 date is gone!

Now age is correct

[Niels]

it should not have been nessesary to re-do the sql, any way happy you got it working

[Been Told]

I have the same problem with the same error.
Here is the error message:

Code: Select all

Could not insert data into users table

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_users (user_registered_ip, user_registered_hostname, 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_viewsig, 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_show_quickreply, user_quickreply_mode, user_open_quickreply, user_lang, user_style, user_gender, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES ('54adc8b8', 'p54ADC8B8.dip.t-dialin.net', 290, 'JohnWayne', 1130692856, '596a96cc7bf9108cd896f33c44aedc8a', 'johnnyboy1981@hotmail.com', '54adc8b8', '', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', 1, 1, 1, 1, 0, 0, 1, 1, 1, 'D, d. F Y, H:i', 1, 1, 1, 'german', 3, '0', 0, 1, 0, '91a4d00378f')

Line : 683
File : usercp_register.php

Now, I've counted the values and fields and there are a few missing. Namely:

Code: Select all

user_birthday,
user_next_birthday_greeting,
user_active,
user_actkey)


I think I sort of understand the problem here (more fields to fill than values to enter) but I don't know how to correct this since I'm a bit of a noob when it comes to this sort of thing.

Here is the offending bit of usercp_register.php

Code: Select all

$sql = "INSERT INTO " . USERS_TABLE . "   (user_registered_ip, user_registered_hostname, 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_viewsig, 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_show_quickreply, user_quickreply_mode, user_open_quickreply, user_lang, user_style, user_gender, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_active, user_actkey)
            VALUES ('" . str_replace("\'", "''", $user_registered_ip) . "', '" . str_replace("\'", "''", $user_registered_hostname) . "', $user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email)  . "', '" . $userdata['session_ip']. "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, $viewsig, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', $user_show_quickreply, $user_quickreply_mode, $user_open_quickreply, '" . str_replace("\'", "''", $user_lang) . "', $user_style, '$gender', 0, 1, ";


Please help me with this, as nobody is able to register on my forum.