Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

All other Modules

Discuss all other Modules here.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

UserForms add field not working

Go to End

14 Posts   2403 Views


10 February 2010 at 3:11pm Community Member, 105 Posts

I am using SS v2.3.5 and trying to use UserForms as descriped here:


And downloaded form here:

[url=]Daily Build[/url]

Followed the installation steps but when I try and create a field on the form builder I get the following error:

Couldn't run query: SELECT MAX("Sort") FROM "EditableFormField" WHERE "ParentID" = '13' 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 '"EditableFormField" WHERE "ParentID" = '13'' at line 1

Anyone else have this problem?


10 February 2010 at 3:47pm Forum Moderator, 5511 Posts

You should use Userforms 0.2.* with SilverStripe 2.3 sites.

Daily builds of userforms are for SilverStripe 2.4


10 February 2010 at 3:51pm (Last edited: 10 February 2010 5:24pm), Community Member, 105 Posts

Thanks Willr I did a svn checkout on tags/0.2.1 and it seems fine now


10 November 2010 at 8:12pm Community Member, 34 Posts

a half year later, userforms-trunk-r104941, Silverstripe 2.4.2.
the same behavior.
If I push 'add', add a new control, which I selected before, the CMS will be a white page, nothing else.
display URL .../admin/EditForm


11 November 2010 at 5:48pm Forum Moderator, 5511 Posts

toarx - Try visit admin?flush=all rather admin and see how it goes. If you get a blank screen it means the javascript click event has not been registered (via live) so for some reason the UserForm.js file isn't up to date for clicking the link.


12 November 2010 at 12:13am Community Member, 34 Posts

hello willr,
I test it from more than one computer, OS and browser.
everytime the same.
Now I do following stuff on webserver:
(example bal)
delete cache on server
cd /tmp/silverstripe-cache-home-silvers-bal-site
rm -f * ;rm -f .cache*

delete stuff in assets
cd ~bal/site/assets
rm -f *.js; rm -f _comb*

kill webserverprocess
kill bal

rebuild database
no error, Database build completed!

If I add in register 'forms' a new control, f.e. a textfiel.
But the result is the same, I get a white body.

I reload the URL, which I see on browser again, with flush=1
With Firefox I get following message:
SecurityID doesn't match, possible CSRF attack.

Duration of all steps, which I described, 1 minute.



13 November 2010 at 11:56am Forum Moderator, 5511 Posts

Thanks toarx, that process looks thorough enough to say I have no idea what could be wrong in this instance! If you stumble on a solution let me know. I've setup UDF on about ~20 sites on 2.4.2 and blank screens have never had the issue still fail after getting rid of the cache so I'm at a loss.


14 November 2010 at 6:21am Community Member, 34 Posts

Now I create a new projekt, on 2.4.2., themes blackcandy, my testthemes.
userforms-trunk-r104941 inside of site/
the same.
Where I should channel my focus?
I have one other project, with the same resources, absolutly, which create on May 2010. It the only one, which is working, other else not.
I need a way to test or compare it.
Thanks for your help.

Go to Top