Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

Problems with userfields by registration (TEXT NOT NULL)

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.
Make the ones you include to register mandatory.
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 PHP-Fusion. I think i must change the STRICT mode from the MySQL server or PHP-Fusion will not work correct. On my own server is that no problem, but on a rented webspace nobody can change that.
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.
Thread Information
Author
Replies
4 posts
Views
214 times
Last Post
Last updated on 14 days ago
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.
Users who participated in discussion: Falk, Ernst74