Problems with userfields by registration (TEXT NOT NULL)
Asked Modified Viewed 989 times
asked
I have a lot of problems with userfields after the registration that have TEXT NOT NULL. This userfields are activated only for profile and not for the registration.
If a new person had make a registration for the site there is an error: Field 'XXXX' doesn't have a default value The error is when the registration copy the informations from the table new_users to the table users.
If a new person had make a registration for the site there is an error: Field 'XXXX' doesn't have a default value The error is when the registration copy the informations from the table new_users to the table users.
Falk
Falk 131
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 11 questions
Make the ones you include to register mandatory.
answered
OK, that is the quick and dirty solution for the user fields. I have seen the user signature is by setup VARCHAR(500) but after deactivate and new activate of the field it is TEXT NOT NULL
Database fields with TEXT NOT NULL are general a problem at me with PHPFusion. I think i must change the STRICT mode from the MySQL server or PHPFusion will not work correct. On my own server is that no problem, but on a rented webspace nobody can change that.
Database fields with TEXT NOT NULL are general a problem at me with PHPFusion. I think i must change the STRICT mode from the MySQL server or PHPFusion will not work correct. On my own server is that no problem, but on a rented webspace nobody can change that.
Falk
Falk 131
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 11 questions
Yes, perhaps crude. But will solve the issue instantly. You can also select to no include these user_fields to the registration so they only display when users edit their profiles.
It sounds odd, so without checking I know that VARCHAR can not exceed 255 if we want a optimal indexing of the table. Anything above should be TEXT.
It sounds odd, so without checking I know that VARCHAR can not exceed 255 if we want a optimal indexing of the table. Anything above should be TEXT.
Edited by Falk on 24-06-2020 22:29,
Category Forum
Suspected Bugs and Errors - 8Labels
None yet
Statistics
- Views 0 views
- Posts 3 posts
- Votes 0 votes
- Topic users 2 members
2 participants
Falk 131
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 11 questions
Ernst74 10
- Junior Member, joined since
- Contributed 32 posts on the community forums.
- Started 14 threads in the forums
- Started this discussions
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions