[SOLVED] blank page when editing record

[solved] I solved the problem, but don't ask me how....
Hi everybody,

I started using ChronoConnectivity and, with some difficults, I create a very well functioning visualization.
Suddenly, after a few records added, the edit_record does not work anymore. I visualize correctly the records, but when I click on edit_record i get a totally blank page, no html at all, and on the address bar I get http://www.myaddressname.it/it/component/chronoconnectivity/?connectionname=Adesione&task=editrecord&cids=8

I started troubleshooting and reading forums to find a way to solve the problem, and so i noticed that also in the admin site "show data" has the same problem, I get the usual blank page, but in the address bar I get simply http://www.myaddressname.it/index2.php.

I thought that the form associated in chronoform worked without a glitch, instead the form in chronoform does not "redirect" after submit and does not memorize data, but sends email!

I also cannot create new connections in ChronoConnectivity, simply when I press save nothing happens.

Thank you for any help!

Another update: I switched on error report on joomla, I got when submit in chronoforms:

Fatal error: Call to a member function bind() on a non-object in /mydomain.it/public_html/components/com_chronocontact/libraries/customcode.php(71) : eval()'d code on line 13

and I got when edit_record in chronoconnectivity:

Fatal error: Call to a member function load() on a non-object in /mydomain.it/public_html/components/com_chronoconnectivity/libraries/connection.php on line 357

Hi mauromas,

That bind error flags a problem with loading the table data that ChronoForms has stored. The most common cause is a dash '-' in an input name.

Bob

When I click on 'Show Data', I also get a blank page (just my joomla menu, but no data). I changed all the data from the record and deleted all the '-', but still no succes.

In my form on my website you have to use a '-'. How can I fix this?

Hi flyboeing,

The problem is not with the data, nor with the labels or other text in the form. It is with dashes in the names of form inputs or database table columns.

Bob

I took a look at the databasetables (in phpmyadmin). All the columnames are with a dash. I only have one column with the name check(). Here the data of the checkboxes is stored.

Some information that the users fill into the form is with a '-'. For example the aircraftregistration (example: G-ODBC). Can that be the problem?

Hi flyboeing,

If any of the column names include dashes this **will** be a problem.

Dashes in the data are OK.

Bob

Thank you for your help.
I will try to change the columnnames, maybe that will help.

Fatal error: Call to a member function bind() on a non-object in /mydomain.it/public_html/components/com_chronocontact/libraries/customcode.php(71) : eval()'d code on line 13

I m also getting the same error.
i have no column name with "-" in it.

Hi bramya ,

Please check for spaces, quotes or any other special characters apart from a-z, A-Z, 0-9 and underscore '_'.

Bob

no other special characters other than'_'...
the same error exists "Fatal error: Call to a member function bind() on a non-object in C:\xampp\htdocs\store3\components\com_chronocontact\libraries\customcode.php(71) : eval()'d code on line 13".

give some solution for this...

Hi Ramya,

If you are using CHronoForms v3 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.

Bob