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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

All other Modules /

Discuss all other Modules here.

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

UserForms add field not working


Go to End


14 Posts   4395 Views

Avatar
CodeGuerrilla

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:

http://doc.silverstripe.org/doku.php?id=modules:userforms

And downloaded form here:

Daily Build

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?

Avatar
Willr

Forum Moderator, 5523 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

Avatar
CodeGuerrilla

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

Avatar
toarx

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

Avatar
Willr

Forum Moderator, 5523 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.

Avatar
toarx

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
http://.../dev/build?flush=all
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
http://.../admin/EditForm?flush=1
With Firefox I get following message:
SecurityID doesn't match, possible CSRF attack.

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

toarx

Avatar
Willr

Forum Moderator, 5523 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.

Avatar
toarx

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/
dev/build?flush=all
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.
toarx

Go to Top