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   2562 Views


Community Member, 105 Posts

10 February 2010 at 3:11pm

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?


Forum Moderator, 5513 Posts

10 February 2010 at 3:47pm

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

Daily builds of userforms are for SilverStripe 2.4


Community Member, 105 Posts

10 February 2010 at 3:51pm

Edited: 10/02/2010 5:24pm

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


Community Member, 34 Posts

10 November 2010 at 8:12pm

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


Forum Moderator, 5513 Posts

11 November 2010 at 5:48pm

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.


Community Member, 34 Posts

12 November 2010 at 12:13am

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.



Forum Moderator, 5513 Posts

13 November 2010 at 11:56am

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.


Community Member, 34 Posts

14 November 2010 at 6:21am

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