Could not insert data into users table "usercp_register

[Hatz]

Dont know when it started, just noticed it and a repair to sql db didnt fix so it's script error. If anyone can see what i did wrong, please help. Thank you.

Recently added mods that had me edit usercp_register i think would be only the klass mod. So maybe "klass" has something to do with this, though the mod works fine for users already registered.

Could not insert data into users table

DEBUG MODE

INSERT INTO phpbb_auto_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_rankset_id, user_dateformat, user_lang, user_style, user_klass, user_level, user_allow_pm, user_active, user_actkey) VALUES (169, 'sfdfasdjh', 1194772560, 'd0af05ff96d134266c532164e608efff', 'dsfdsdas@hotmail.com', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 0, 1, 'D M d, Y g:i a', 'english', 3, 0, 1, '0' 1, '')

Line : 993
File : usercp_register.php

[~HG~]

Try replacing '$klass' "; with $klass "; and see if that works.
_________________
~HG~

|| rodneyangell.com || || phpbb-tutorials.com ||My Hacks

[Hatz]

fixed, was missing a , after the klass....not sure why i needed it cuz there is nothing after it, but it fixed it, thanks for your help though

[CR]

Hi, I also seem to have the same/simlar error

Please someone help as I have sat and gone over the same section of code for what now feels like days....

Here is my error message:

[~HG~]

It appears to me that you have not made the necessary edits required for the hack to work.

I suggest you read the instructions carefully and ensure you have done everything required.
_________________
~HG~

|| rodneyangell.com || || phpbb-tutorials.com ||My Hacks

[CR]

The worst part is that I have no idea what hack it is that has failed. Allow me to explain.

I install each hack manually and test everything - once I'm sure there are no errors I back up the entire phpbb2 folder and also export the mysql dadabase out from phpmyadmin and begin work on the next mod.

Now the problem is that everything was working fine and all I have altered is the CSS and layout of some sections (nothing to do with the database and only made changes to some .tpl files).

Then when attempting to register a new user I got the above error... I have even gone back to an old backup including the database and the error is still there.... So, my question is - what could I have poss done to cause this and why after reverting to a previous known working backup does it still not work...?

Now you see why I'm lost...

P.S.
Thank you for you previous fast reply Just glad some folk still use phpBB2 after all this time

[cq92]

If using MySQL version 5.1 the problem will occur on registration that user data cannot be inserted into a table. (Windows Servers)
The problem is caused due to MySQL server has been configured with the "use strict" option for compatability with older MySQL versions.
Simply re-run the SQL configuration wizard with the "use strict" option unchecked and the error will disappear and registration will work perfectly.
It would appear that due to the way the script is written the SQL servr cannot properly interpret the "insert" command when strict is used.
If you do not have access to reconfiguring the SQL server then the insert data commands would have to be re-written in the PHP register pages to comply with the "strict" configuration parameters to make them work.