We've been using this plugin for a few months and recently discovered an enormous error.
If you enable the Custom Profile Fields Block (and because of this you have to enable the Editable by Usergroups), you can no longer use Apostrophes in your custom profile fields without causing an error whenever you edit the "Edit Options."
I thought it may have been messing with another plugin, or something we did wrong... So I created a tester board. I made a field with the absolute basics with no other plugins installed (other than xThreads). We ended up getting the same error.
All I did was type in "I've"
Code:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - 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 've' WHERE ufid='1'' at line 2
Query:
UPDATE mybb_userfields SET `fid4`='i've' WHERE ufid='1'
|
Could you please try the updated version from the first post (I've just updated)?
Just replace the previous files with the new one (you don't need to deactivate it).
Thanks.
Hello, I'm having a lot of trouble trying to understand how to use this. I'm trying to create a custom table, placed separate from the custom profile fields, but I just don't know what I'm supposed to do. Can I get some help, please?
What table? A static table? If so, you don't need a plugin. Just put the table directly in the template.
Hi all, I'm using UCP Main Page, but I have many problems:
- It doens't save when I change something in User CP
- It deletes all checkboxes in options (show avatars etc) when I save in main of usercp
- I have created a Custom Profile Fields (required, for Terms of use of the forum), but it is required also in usercp (I don't want it in usercp). Anyway now I can't edit usercp because it says me "You have not entered an option for the field "Terms of use". Fill it or select one of the options."
I have rebuilded in ACP - Cache: xt_proffields 3.72 KB
But nothing
Thank you!
Last problem. If I modify by checking the checkboxes and save, they do not remain saved.
I deleted the options to usercp_options but still does not work.
If I save from UserCP main, I do not see the avatars, signatures, and everything else, as if I cancel options
I dont know what i am doing wrong, but the custom profile field is not getting displayed in usercp. PLEASE HELP!
custom profile for fid=5
![[Image: RFGLFWl.jpg]](http://i.imgur.com/RFGLFWl.jpg)
usercp template
![[Image: RHdz5j0.jpg]](http://i.imgur.com/RHdz5j0.jpg)
p.s. I just want to display the custome profile data. Don't want to give the option to edit it
I guess this thread is dead
This isn't a hugely active forum. I regularly only see two users online, myself and ZiNgA. You can't expect a response extremely quickly.
As for your problem, you haven't provided an awful lot of data. Instead of screenshots, please provide the actual code wrapped in code tags here please. And elaborate your problem further. "They're not working" is not enough details. What are your settings set to? Had you changed anything recently relating to this? I'm afraid we can't read your mind.