Forums

DB connection don't work - strange characters appearing

lselbach 06 Aug, 2010
Hello,
First of all, thanks for the great extension.

Using: ChronoForms_V3.1_RC5.5
Chrono Connectivity 2.0 Rc3
Joomla 1.5.18
MySQL 4.0.27
PHP 5.1.6 - check at http://premiumcorporate.com.br/versao.php

Before starting, I've passed all the tutorials (some of them twice).

My prime objective:
- A CV form to allow candidates record their resumé
- A page to administrator browse the data
- A search tool for the admin look into database

My form is at the address
http://www.premiumcorporate.com.br/joomla/index.php?option=com_chronocontact&chronoformname=cvnovo

The initial problem is when I make the connection between the form and DB at DB Connection / Enable Data Storage (Yes) option, it comes with a strange behavior.
The submit page (generate by chronoforms) gets empty (only submit data), with no website content (check it out, try to submit the form).

I also checked the database and doesn't add any record. Tried many ways, created another form. No chance.

Tried to debug with no success (empty page).

I also have a strange behavior. Sometimes I open the form (click on form title) and get a bunch of characters on the page. Click on Forms Management, get back to the form and then opens (sometimes in the 3rd tryout). (check attached image).

Finally, the last strange behavior is when I open and close the form, I get some weird code put into the Form Code:
<script type="text/javascript" src="http://www.premiumcorporate.com.br/joomla/administrator/components/com_chronocontact/js/tiny_mce/themes/advanced/langs/en.js"></script>

which scrambles my form, also appears twice.

So, there's a lot to do. Please help me out. Thanks in advance.

Cheers
Lucas http://www.e-feito.net
Brazil
GreyHead 06 Aug, 2010
Hi lselbach,

The problem with the DB Connection is probably because you have at least one input name with a dash '-' in it. Please replace this with an undescore, rename the corresponding table column to match and refresh the DB Connection (see below).

The problem with large amounts of JavaScript appearing in the Forms Manager has been reported a few times before but as far as I know no-one has yet managed to identify the cause and Max hasn't been able to fix it. Changing to another browser to edit forms may emove the problem. :-(

The insertion of the single script language file from the editor is weird, I haven't seen it before and have no idea why it's happening. The editor is only used in the Admin area and then many files are included.

It you want to send me a form backup I'll see if those problems reproduce on my test site.

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.
lselbach 06 Aug, 2010
Hi Grey!
Thanks for the quick response.

The problem with the DB Connection is probably because you have at least one input name with a dash '-' in it. Please replace this with an undescore, rename the corresponding table column to match and refresh the DB Connection (see below).



Done, it worked fine.

The problem with large amounts of JavaScript appearing in the Forms Manager has been reported a few times before but as far as I know no-one has yet managed to identify the cause and Max hasn't been able to fix it. Changing to another browser to edit forms may emove the problem.

The insertion of the single script language file from the editor is weird, I haven't seen it before and have no idea why it's happening. The editor is only used in the Admin area and then many files are included.



I've changed from Google Chrome to Firefox and it's ok.
It seems that the script is also a problem from Chrome.
I'm also using JCE as editor, I don't know if there is any related matter about.

Since everything is working fine, I don't need you to check the form, it's ok.
I just have two more questions:

1. (a hint) Is there any way to change the fields order? I tried in ChronoForms and also in PHPMyAdmin and couldn't find a way to do it.

2. I tried Chrono Connectivity to make a frontend view of database but it isn't working. I double checked everything, even making login as superadministrator and it doesn't work.

Thanks a lot
Cheers
Lucas
lselbach 17 Aug, 2010
Hi Grey,
It seems that we really have a BUG with GOOGLE CHROME.
I'm using 5.0.375.126

When I open the Form Code to edit, sometimes it put this code inside:

<script type="text/javascript" src="http://porfazer.com.br/premium/administrator/components/com_chronocontact/js/tiny_mce/themes/advanced/langs/en.js"></script>;


and bugs the form.
So I'm sending this Forum post to Google Chrome team.

Cheers and thanks again for this great extension.
Lucas Selbach
Brasil
This topic is locked and no more replies can be posted.