SQL error involving custom fields

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
brucefenster
Registered User
Posts: 8
Joined: Fri Aug 17, 2012 7:23 pm

SQL error involving custom fields

Post by brucefenster »

At the end of last year we had a consultant upgrade our phpBB board from a low 3.?.? to 3.3.10. He had a difficulty doing so but finally got it updated. We of course lost all the data we had collected in 5 custom fields and the fields themselves. I recreated the custom fields which ar primarily used at registration. All was good except every time a test registration was run a MySQL error popped up and no data was stored to the custom fields. Initially I thought this was for all accounts new or old. We turned the custom fields off till we had more time to investigate and have been suffering without their availability.

In the past day or so I've had time to revisit this. I realized the custom fields work fine for all accounts created with the old version of phpBB. However a SQL error occurs when trying to create a new account or edit an account created with the 3.3.10 version. Here is the error.
SQL error.png
I'm not a SQL guy but it looks like a field "pf_phpBB_occupation" doesn't have a default value. And in normal operation this doesn't cause an issue until we try to write data to the custom fields that have been created. And since this does not happen when editing a record created with the old system, either there wasn't a "pf_phpBB_occupation" field or those records have data or a default in that field. What is that field anyway, we don't use it for anything?

Does my theory sound plausible? Could it be as simple as setting the newly created "pf_phpBB_occupation" to a default? If so how do we go about setting such a default. Could someone explain that procedure so I can explain it to our "consultant" who would actually have to make the change.

Thanks

Bruce
You do not have the required permissions to view the files attached to this post.
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 6028
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.

Re: SQL error involving custom fields

Post by thecoalman »

This a bug and should be fixed as of version 3.3.11

https://tracker.phpbb.com/browse/PHPBB-17145
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
brucefenster
Registered User
Posts: 8
Joined: Fri Aug 17, 2012 7:23 pm

Re: SQL error involving custom fields

Post by brucefenster »

Could it be that simple? Can anyone confirm the fix is in 3.3.11 or I assume 3.3.12?

Though I can't upgrade the software myself it becomes a little harder to get done. Always something.

Thanks

Bruce
User avatar
Mike-on-Tour
Registered User
Posts: 505
Joined: Wed Jan 15, 2020 3:51 pm
Location: Germany
Name: Michael

Re: SQL error involving custom fields

Post by Mike-on-Tour »

It is that simple, if you read the provided tracker link you would have seen that this issue was fixed last summer for phpBB 3.3.11, the link even provide the changed code if you are interested.
So just update your board and you are set.
Watz fo lunch?
If you like my extensions or my support please consider a donation: Image
brucefenster
Registered User
Posts: 8
Joined: Fri Aug 17, 2012 7:23 pm

Re: SQL error involving custom fields

Post by brucefenster »

Well our forum consultant just upgraded our forum to 3.3.12 and it did not fix the problem. It is the same as above with version 3.3.10. though the lines are different in the error if you compare it to that from 3.3.10.

Any other ideas?

Thanks

Bruce
SQL error 3.3.12.png
You do not have the required permissions to view the files attached to this post.

Return to “[3.3.x] Support Forum”