Subject:*
<
Name/Email:*
<
Message Icon:*
<
Select*
<
Message:*
<



Click the Preview to see the content in action.
Options:*
<
Confirmation Code*
<
0 + 8 = ?  
Input the result from the expression
Maximum attempts you can try: 10
*
<
     

Re: User profile
by gooloomoo on 2011/2/27 1:05:26

Hi, I just have the same problem with profile module, if I add more than 32 custom fields(textbox), only 32 of them will be saved, the rest keep unchanged.

Anyone know how to fix this?
Re: User profile
by Catzwolf on 2010/5/17 9:56:36

@ghia: There is no limit really for this in PHP, but for performance sakes. Having a list of 1000 could send some users over the edge though.

@Nick_James: What field type do you have this set? If it is varchar (textbox)? Then set it to text (textarea). It could be the 255 limit on varchar could be causing items seem to disappear when you update them or save them.

It possibly would help further if you gave us clear examples of your profile form additions, laying out exactly what you're doing. That way we would better understand what you're trying to do and that would help us provide a solution quicker :)

ATB,

John
Re: User profile
by ghia on 2010/5/17 7:17:38

It is possible that the 32 is a PHP limit for multi select lists, try with a checkbox list.
Re: User profile
by Nick_James on 2010/5/17 2:56:33

One of my fields is supposed to allow the user to select from about 41 district courts. However, it is not saving over about 32 options.

The other options disappear when I add them.
Re: User profile
by ghia on 2010/5/16 1:28:42

Quote:
Could it be that my list of choices is too big?
No, up to 200 items are a practical limit.

Glad you figured it out, altough not sure what the problem/solution realy was.

Quote:
0.000316 - SELECT COUNT(*) FROM `users` WHERE `uname` = 'LaDads' AND `uid` <> {$uid}
Error number: 1064

Error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}' at line 1

0.000286 - SELECT COUNT(*) FROM `users` WHERE `email` = 'xxx@yyy.zzz' AND `uid` <> {$uid}
Error number: 1064
Error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}' at line 1
Don't know where (module/block) these come from, but it is generating wrong queries.

(Modified an email address in the previous post to prevent SPAM)

Who's Online

175 user(s) are online (130 user(s) are browsing Support Forums)


Members: 0


Guests: 175


more...

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits