MODS.DB9.DK

[zzZZ-Arjen-ZZzz]

Hello,

Since I've updated my forum to phpBB 2.0.10 (clean update) and reinstalled the Birthday Mod (1.5.7em) users can't register anymore. The rest is working fine.

This is the code I get:

Could not insert data into users table

DEBUG MODE

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_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES (46, 'test', 1100787749, '7651320fc8fd972af966e40752ddcecc', 'test@test.nl', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 1, 'j-m-Y, G:i', 'dutch', 4, 0, 1, 0, '5d4faace0b20cc7795')

Line : 600
File : /home/sites/site31/web/forum/includes/usercp_register.php

I think it's a problem in includes/usercp_register but where tot start?

I looked at the database and all the needed items are there, so what is wrong? Hopefully there is someone to help me out.

Thanks.

[zzZZ-Arjen-ZZzz]

I already solved the problem.....

[tikilab]

I already solved the problem.....

Augh... what was the problem? I'm having the same thing happen... :\

[zzZZ-Arjen-ZZzz]

Recheck your code lines. I had some small errors in it.

[tikilab]

Thanks. I checked, and somewhere along the line I cut and pasted an extra quotation mark in there. Doh!

[Niels]

thank you to both of you, I pretty shure other users here on mods will find this usefull.

It is of geat importence that users do report back when getting there problems solved, other users can then see that you have installed it succefully and almost no errors did happen

[stupidgirl12345]

I was getting a very simmilar error... I checked and double checked for mistakes, but I'm really new at this so I barely know what I'm looking for. Any suggestions?

[Niels]

First of all, it would be easyer to help, if you do post you DEBUG message....this will usually show what you have done wrong.

I think it's a problem in includes/usercp_register but where tot start?

you are right, look into usercp_register.php and carefully check the SQL lines witch have been modifyed.

AS said in the how-to you need to be very careful with these 2 lines as meny users are having truble modifying these 2 lines....

to locate the place in the file where ther problem is, simply search for

"INSERT INTO

or

"UPDATE

One of the 2 STRINGS starting so are wrongly modifyed - go check your file agains the description in the how-to - be VERY exact with the PLACEMENT, and do not remove or add ANY extra code (look for the ,)
THIS IS VERY IMPORTENT, since you may (or may not) accidentially grant regular users with admin priveleges if modifyed improber.
Since you got a debug message - you are safe, but if the line was wrongly moded, and you diden't get a debug message - the the chance was that your wrongly modifyed code could give admin access for some users.