Create Tables

Hi,
If this question is ridiculously obvious, I apologize - I've spent some time looking through instructions and they haven't looked like what I have on my screen.

I am using ChronoForms v3.0 and Joomla v1.5.5.

I can create the form without a problem and have it submit properly. However the information is not being collected in a table. When I go to forms management, select a form, and click "Create Table", I get a screen with a series of check boxes. I select all the rows with the "Create column" box. At the bottom, I click "Save Table" and I get back the following message:

Error while creating table :Table 'jos_chronoforms_party_request' already exists SQL=CREATE TABLE `jos_chronoforms_party_request` (`cf_id` INT(11) NOT NULL auto_increment, `uid` VARCHAR(255) NOT NULL, `recordtime` TEXT NOT NULL, `ipaddress` TEXT NOT NULL, `cf_user_id` TEXT NOT NULL, `text_7` VARCHAR(255) NOT NULL, `text_6` VARCHAR(255) NOT NULL, `text_1` VARCHAR(255) NOT NULL, `text_2` VARCHAR(255) NOT NULL, `text_3` VARCHAR(255) NOT NULL, `date_10` VARCHAR(255) NOT NULL, `date_4` VARCHAR(255) NOT NULL, `text_11` VARCHAR(255) NOT NULL, `select_9` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`)) ENGINE = MYISAM ;

Nothing appears in the "Tables connected" area of the forms management page, and I assume that when I have connected it properly something will...and that I'll be able to use that to access the data that has been collected...yes?

What am I doing wrong?

Thanks in advance for your help!

Hi kernbuilt,

Table 'jos_chronoforms_party_request' already exists

Looks as though you created the table on an earlier attempt. If the table you have is OK that's fine, if not you can drop it using PHPMyAdmin and create a new version.

Most likely you also need to set Enable data saving to Yes in the DB Connection tab.

Bob

Thanks Bob, I finally understand and got it working.

Hi kernbuilt,

Great - pleased to hear it :-)

Bob

Hi!

I cannot create a tables because I cannot see "Create Table". (V3.0)

In a form management I see this screen only:
[attachment=0]db_tables_chrono.jpg[/attachment]

Could you point me to the button o screen to create table?

Hi almer,

In the Forms Manager, check the box for your form then click the icon.

Bob

[attachment=0]17-12-2008 12-09-58.png[/attachment]

Thank you, Bob! Will try.

Instead of creating a new Thread I will continue with this one. I have a strange problem. We have opted to use tables to record the results of our forms. When we create the tables nothing shows up for "Tables Connected" we checked our SQL and found all the correct tables in place. What is strange is that nothing has been recorded in those tables. The form has been used at least 30 times and no records have been recorded. Is this a bug or are we missing something?

Hi Gatsu000,

You probably need to turn on DB Connectivity in the DB Connectivity tab - and tell ChronoForms which table to link to. Please see the DataBase Tutorial in the Downloads area here for more info.

Bob