Error message

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
baz0927
Registered User
Posts: 12
Joined: Fri May 30, 2008 7:43 pm

Error message

Post by baz0927 » Mon Jul 21, 2008 9:35 am

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

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50812
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Error message

Post by stevemaury » Mon Jul 21, 2008 12:24 pm

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.
Last edited by stevemaury on Mon Jul 21, 2008 12:27 pm, edited 1 time in total.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: Error message

Post by karlsemple » Mon Jul 21, 2008 12:27 pm

As steve asked have you created a custom profile field? Did you define a default value for it?
Image

baz0927
Registered User
Posts: 12
Joined: Fri May 30, 2008 7:43 pm

Re: Error message

Post by baz0927 » Mon Jul 21, 2008 2:52 pm

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.

Locked

Return to “[3.0.x] Support Forum”