Page 1 of 1

Error message

Posted: Mon Jul 21, 2008 9:35 am
by baz0927
I have a problem on my Forum http://merseysidebranchrtra.com/forum/
When a new user tries to register they get this error message

-------------------------------------
General Error
SQL ERROR [ mysql4 ]

Incorrect integer value: '' for column 'pf_service_number' at row 1 [1366]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: forum@rtrmerseysidebranch.co.uk
----------------------------------------
How can I fix it please anyone

Re: Error message

Posted: Mon Jul 21, 2008 12:24 pm
by stevemaury
As far as I can tell, that field (pf_service_mumber) is not a part of phpbb, so must be from a MOD. Can you determine what MOD and ask in the place where you got that MOD?

EDIT - Is that a Custom Profile field you have added? If so, check what the acceptable values are in the ACP.

Re: Error message

Posted: Mon Jul 21, 2008 12:27 pm
by karlsemple
As steve asked have you created a custom profile field? Did you define a default value for it?

Re: Error message

Posted: Mon Jul 21, 2008 2:52 pm
by baz0927
Cheers Guys, you were spot on, I had created custom fields, have deleted them and the board works great.Thanks again.saved me lots of time.