Forums

Database storage creates an error

tigergirl 11 Oct, 2010
Hello,
I've used Chronoforms on a number of sites without a problem, but on a new site it's having issues.

When I enable database storage, submitting a form results in this error:
"Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request."
It still sends the appropriate email.

When I disable database storage, it shows the correct page and sends the email.

I need database storage to be enabled for this client, so I need some counseling on how to move forward from here.

Specs on the site:
Host - Hostcentric (will be moving it to a new host soon)
Joomla 1.5.20
Installed "ChronoForms V3.0 Stable.zip"

Form is on a development site: http://dowsers.org/dev/index.php?option=com_chronocontact&chronoformname=specialty2

Thanks in advance for any help!
GreyHead 12 Oct, 2010
Hi tigergirl,

Seems to submit OK from here. Is this now fixed?

Bob
tigergirl 13 Oct, 2010
Hi GreyHead,
Submission wasn't a problem when you tested it because database storage was off. I'm turning database storage back on so you can see the problem.

Thank you!!
GreyHead 13 Oct, 2010
Hi tigergirl,

You've got several input names that start with underscores and one with slash in it
<input type="checkbox" name="_Speaker/Instructor" id="_Speaker/Instructor" class="radio" value=" Speaker/Instructor">
The slash will certainly cause a problem and the leading underscore may well do. Please rename these inputs and the corresponding column names in the table to start with a letter and only use a-z, A-Z, 0-9 and underscore (but not at the beginning).

Bob

You need to refresh the DB Connection after any changes to database column names. In the Form Editor click the DB Connection tab and set the Connection to 'No'. Click the 'Apply icon in the toolbar to save the form, open the DB Connection tab, set the Connection back to 'Yes' and re-save the form. This will refresh the copy of the table information that ChronoForms uses.
tigergirl 14 Oct, 2010
That was exactly it! Thank you so much - I wouldn't have found that on my own.
You're the best! :-)
This topic is locked and no more replies can be posted.