Hello,
for my website http://www.entoenentoen.nl/CZ I made a form and want to store the results in a database. Somehow on the way I did something wrong, because as you can see in the attachement, the results of the form are not stored.
Does someone see what I did wrong? Probably a simple thing, but I am searching for it more than 2 hours now:(
Thanks!
for my website http://www.entoenentoen.nl/CZ I made a form and want to store the results in a database. Somehow on the way I did something wrong, because as you can see in the attachement, the results of the form are not stored.
Does someone see what I did wrong? Probably a simple thing, but I am searching for it more than 2 hours now:(
Thanks!
Hi stevenlips,
I don't see anything wrong with the form* and the data is submitting the data correctly.
I notice that your table view doesn't include a cf-id column. Does the table have a primary key set?
Bob
PS Except that you have some mismatched names & ids and two inputs with the same name.
I don't see anything wrong with the form* and the data is submitting the data correctly.
I notice that your table view doesn't include a cf-id column. Does the table have a primary key set?
Bob
PS Except that you have some mismatched names & ids and two inputs with the same name.
PS Except that you have some mismatched names & ids and two inputs with the same name.
You where right, thanks! I had twice a text_4 instead of a text_ and text_5. This does not solve the issue thought...
I notice that your table view doesn't include a cf-id column. Does the table have a primary key set?
yes, please have a look at the attachement, does it look alright?
Do you have any additional suggestions? that would be great!
Hi stevenlips,
Please try refreshing the DB Connection: set it to No, Apply the form to save it; then set it back to Yes again and re-save. This will updated ChronoForms internal record of the table columns. Hopefully that will help.
Bob
Please try refreshing the DB Connection: set it to No, Apply the form to save it; then set it back to Yes again and re-save. This will updated ChronoForms internal record of the table columns. Hopefully that will help.
Bob
Please try refreshing the DB Connection: set it to No, Apply the form to save it; then set it back to Yes again and re-save. This will updated ChronoForms internal record of the table columns. Hopefully that will help.
Sadly this does not help.
Could it be that the fact that the form is ancopied form that I adjusted? I made a new database thought so I think I did it correctly..
And the fact that I renamed the field names by using the wizzard (text_1, text_2 etc)
A solution may be...
I did the following: selected the form in form management> create table > save> then I get
I did the following: selected the form in form management> create table > save> then I get
Error while creating table :Table 'entoen_chronoforms_Deelnameform_cz' already exists SQL=CREATE TABLE `entoen_chronoforms_Deelnameform_cz` (`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, PRIMARY KEY (`cf_id`)) ENGINE = MYISAM ;
Hi Bob,
I also deleted the existing db using myphpadmin and made a new one in the Chronoforms component backend. Sadly it does not solve the mysterie. Do you happen to have another suggestion? Next week a big campaign will begin that lands on this form and therefore I am very very eager to get the db connected correctly... Thanks in advance for your help!
I also deleted the existing db using myphpadmin and made a new one in the Chronoforms component backend. Sadly it does not solve the mysterie. Do you happen to have another suggestion? Next week a big campaign will begin that lands on this form and therefore I am very very eager to get the db connected correctly... Thanks in advance for your help!
Hi stevenlips,
By all means email or PM me a SuperAdmin login and the site URL and I'll take a quick look.
Bob
By all means email or PM me a SuperAdmin login and the site URL and I'll take a quick look.
Bob
Hi stevenlips,
The table had no columns for the form data. I created a new one and it looks as though it is saving OK.
Bob
The table had no columns for the form data. I created a new one and it looks as though it is saving OK.
Bob
It works great now. Many many thanks, you saved the day!
Do you happen to have a link with tutorial or info about making such columns?
thanks again for your work
Do you happen to have a link with tutorial or info about making such columns?
thanks again for your work
Hi stevenlips,
You need to check all the columns in the Create Table display. Yours is an old version and I checked the box at the top of the column - in the later version there are red & green bars and an icon at the top right that selects 'all'.
Bob
PS I forgot to say that I installed EasySQL to look at the database, its a useful free extension (but dangerous in careless hands) - either keep it or uninstall if you prefer.
Bob
You need to check all the columns in the Create Table display. Yours is an old version and I checked the box at the top of the column - in the later version there are red & green bars and an icon at the top right that selects 'all'.
Bob
PS I forgot to say that I installed EasySQL to look at the database, its a useful free extension (but dangerous in careless hands) - either keep it or uninstall if you prefer.
Bob
For some reason, I'm having difficulty creating the Table in the database.
The GUI in Chronforms for Create Table and Table Manager shows that the cf_id, uid, recordtime, ipaddress and cf_userid are created successfully.
I have verified this in the create table and table manager in Chronoforms.
The table jos_chronoforms_HeroRide2010 has been created in phpmyadmin with the above field structure.
I can see in the Create Table Manager in Chronoforms that the other fields are there but they are RED.http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=5&t=17293 I have read this post, I tried selecting them all using the upper right check on the blue Field Name to turn them all GREEN and then saved it by clicking on the floppy disk icon next to the Green Plus Icon at the top. It's weird, because I can turn them all green by selecting them, Save it and when I go back in to check it later on, its like I never did anything. Its not saving my changes.
The problem is that when I go to create / select the other fields within the Create table interface, it does not save/create the other fields. They are:
firstname_2, lastname_3,phone1_4,phone2_5, city_8,state_10 etc, etc, etc,
Nothing I do seems to make any difference to force the field structure to be created. Each time I select and save its like nothing changed or wasy saved. I'm not a wiz with databases or php and am just dangerous enough in looking at phpmyadmin and know that it can be created using it but I don't know how.
Any suggestions?
[attachment=2]create_table_before_save.jpg[/attachment]
[attachment=1]create_table_select_all.jpg[/attachment]
[attachment=0]error_while_creating_table.jpg[/attachment]
Here is the version of PHP and MySQL I'm using:
PHP Version 5.2.9
Chrono ver 3.1 RC5.5
MySQL version 5.0.81
The GUI in Chronforms for Create Table and Table Manager shows that the cf_id, uid, recordtime, ipaddress and cf_userid are created successfully.
I have verified this in the create table and table manager in Chronoforms.
The table jos_chronoforms_HeroRide2010 has been created in phpmyadmin with the above field structure.
I can see in the Create Table Manager in Chronoforms that the other fields are there but they are RED.http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=5&t=17293 I have read this post, I tried selecting them all using the upper right check on the blue Field Name to turn them all GREEN and then saved it by clicking on the floppy disk icon next to the Green Plus Icon at the top. It's weird, because I can turn them all green by selecting them, Save it and when I go back in to check it later on, its like I never did anything. Its not saving my changes.
The problem is that when I go to create / select the other fields within the Create table interface, it does not save/create the other fields. They are:
firstname_2, lastname_3,phone1_4,phone2_5, city_8,state_10 etc, etc, etc,
Nothing I do seems to make any difference to force the field structure to be created. Each time I select and save its like nothing changed or wasy saved. I'm not a wiz with databases or php and am just dangerous enough in looking at phpmyadmin and know that it can be created using it but I don't know how.
Any suggestions?
[attachment=2]create_table_before_save.jpg[/attachment]
[attachment=1]create_table_select_all.jpg[/attachment]
[attachment=0]error_while_creating_table.jpg[/attachment]
Here is the version of PHP and MySQL I'm using:
PHP Version 5.2.9
Chrono ver 3.1 RC5.5
MySQL version 5.0.81
Hi owensg,
I think that I'm right in saying that the Create Table dialogue only creates tables. You can use the Table editor to add or remove columns or to delete tables.
Either Create a new table with a different name of use the table manager to add the extra columns to the exisiting table. (Or delete the old one with the Table Manager, then rebuild it with Create Table.)
Bob
I think that I'm right in saying that the Create Table dialogue only creates tables. You can use the Table editor to add or remove columns or to delete tables.
Either Create a new table with a different name of use the table manager to add the extra columns to the exisiting table. (Or delete the old one with the Table Manager, then rebuild it with Create Table.)
Bob
(Or delete the old one with the Table Manager, then rebuild it with Create Table.)
Hi Bob,
The above Suggestion worked like a charm. My form is now saving all of my fields to the table and I can export them to an Excel Spreadsheet.
To ALL people reading this post. If you experience this problem try this. Over the course of several days reading the forums, etc. I found a post by another. Tried to use the create table feature thinking I could just add them (them= the fields) to the existing table that I thought should have been there in the first place (In a perfect world maybe). Anyway, it would never save what I was trying to add using Create Table before I asked Bob my question. So Please use Bob's very skilled and wise advise and delete your table, heck, its not saving the data anyway so your not going to lose any data if it was never there to begin with. Try it. It worked for me.
Hi Bob,
The above Suggestion worked like a charm. My form is now saving all of my fields to the table and I can export them to an Excel Spreadsheet.
To ALL people reading this post. If you experience this problem try this. Over the course of several days reading the forums, etc. I found a post by another. Tried to use the create table feature thinking I could just add them (them= the fields) to the existing table that I thought should have been there in the first place (In a perfect world maybe). Anyway, it would never save what I was trying to add using Create Table before I asked Bob my question. So Please use Bob's very skilled and wise advise and delete your table, heck, its not saving the data anyway so your not going to lose any data if it was never there to begin with. Try it. It worked for me.
This topic is locked and no more replies can be posted.
