Forum OpenACS Development: Demo 'A simple form' Request Error

Collapse
Posted by Raul Rodriguez on
I get a request error when going to myserver/doc/acs-templating/demo/form

The error happened on a postgres installation. The query ad_template_sample_users_seq.nextval was oracle specific.

What is the process in getting form.xql to be replaced with form-oracle.xql and create form-postgresql.xql to have

select nextval('ad_template_sample_users_seq')

instead of the oracle specific sql?

Collapse
Posted by Brian Fenton on
Hi Raul

I think you just need to create those 2 new files (form-oracle.xql and form-postgresql.xql). OpenACS should pick up the right one after a restart.

See here for more info https://openacs.org/xowiki/SQL_-_XQL

hope this helps
Brian

Collapse
Posted by Raul Rodriguez on
Thank you. Yes I did that on my installation but was wondering how to get the core changed so others dont have to do the same things on new installations.
Collapse
Posted by Brian Fenton on
Hi Raul

You can check in your changes if you have permission. See here https://openacs.org/contribute/

hope this helps
Brian

Collapse
Posted by Raul Rodriguez on
I do not have permission. I went to: https://openacs.org/contribute/ to find out more information regarding how to apply the changes but this link was not working: http://www.openacs.org/doc/openacs-5-1/cvs-guidelines.html

I would also need to know how to create a patch. Do you know where I can find out the information for that as well?

Collapse
Posted by Gustaf Neumann on
fixed in the oacs-5-8 branch