Data is e-mailed, but not entered into table.

Ok, here goes.

I'm running Joomla 1.5 in legacy mode and Chronoforms 2.5 J1.5 RC3.1

As the subject suggests, the form data gets e-mailed correctly, but not entered into the jos_chronoforms_5 table.

I am attaching the cfback file for you to see.

[file name=ACT_2_.cfbak size=6437]http://www.chronoengine.com/images/fbfiles/files/ACT_2_.cfbak[/file]

Hi Andy,

I see no problem, is your form id is "5" ?

Yes, that is correct.

It writes the table when I click the link to create one, so I think that it's not a mysql problem.

Here is a link to the current form.

The Form Page

do you have a redirect url once form is submitted ?

yes "index.php"
feel free to try out the form, for now it is just an attempt to get the data written to the table.

Ok, remove the redirect, does it save the data fine ?

yes, it does! should I be redirecting to a different page?

No, there was a bug, where and when did you download the Chronoforms package you have installed ?

Let's see, it was through the Joomla extensions page. Is there a log in Joomla that I can check that has a record from when I did the installation?

No, you have Joomla 1.5 or 1.0 ? and when did you download Chronoforms, you forgot this one ?😉

Joomla 1.5, around April 25th

Ok, plz go to the downloads page and download the upgrade package to RC3.1, you will overwrite all your component files, this should fix it!

Cheers

Max

I will let you know how it goes!
Thank you so much for helping, you were extremely prompt and your help was spot-on.

You have my sincere thanks!

Andy

Bummer, RC3.1 Upgrade failed! I overwrote all the component files and editted the form to use "index.php" for the redirect and it still won't write to the table. Is there a way I can edit the "blank" page by adding content to it?

Hi Andy, after the upgrade, send me the chronocontact.php file you have running, attach it here please so I can check it!

Max

Here ya go. I unpacked the chronoforms_2.5rc3.1_upgrade.zip
and uploaded the contents to the root of my website.

The file below was downloaded via ftp.
chronocontact.php [/file]

Here ya go. I unpacked the chronoforms_2.5rc3.1_upgrade.zip
and uploaded the contents to the root of my website.

The file below was downloaded via ftp. Had to rename it because this forum won't allow me to upload .php

[file name=chronocontact-41f339390da6db210780467bcf9cc7d9.txt size=21438]http://www.chronoengine.com/images/fbfiles/files/chronocontact-41f339390da6db210780467bcf9cc7d9.txt[/file] chronocontact.php.txt [/file]

We are already running 2.5 J1.5 RC3.1

But are now experiencing the same problem. Bob, as you may recall from our prior thread we were fighting with the CB registration plug-in... we have now rebuilt our forms without the CB registration plug-in and are using only the tables created by Chronoforms and we are having this same problem... the html looks good, the emails look good, but no fields are written to the table.

Does this upgrade have something in it that we may have missed out on starting with RC3.1?

Does anyone have other suggestions?

Hi,

There is abug with the redirect and there is some miss, the version which i think is bug free has the bug too, please overwrite chronocontact.php in your install with the one attached and this will fix it!

Cheers

Max [file name=chronocontact-31b61995388673d6680229bf768cd79a.zip size=5615]http://www.chronoengine.com/images/fbfiles/files/chronocontact-31b61995388673d6680229bf768cd79a.zip[/file]

Thank you! This definitely fixed my problem!
Would you mind giving a short explanation about the bug?
What did you change?

My sincere thanks Max, you are great!

Andy

Hi Andy,

The bug is just a misplaced closing bracket right at the end of the showform function in chroncontact.php. It should look like this:

            /**
             * Run the SQL query if there is one
             */
            if ( $paramsvalues->autogenerated_order == $ixx ) {
                if ( ! empty( $rows[0]->autogenerated ) ) {
                    eval( "?>" . $rows[0]->autogenerated );
                }
            }
        }
        /**
         * Redirect the page if requested
         */
        if ( ! empty( $rows[0]->redirecturl ) ) {
            $mainframe->redirect( $rows[0]->redirecturl );
        }
    
    }
}

If there are only two curly brackets '}' instead of three in the middle and four at the end, then the file is buggy. Best not to try and edit it though, just overwrite with the correct version.

Bob

I already overwrote it, just wanted to know what made that bug tick😉 Once again, thank you for all the help you guys have provided. I am extremely pleased and impressed with what are doing here.

Keep up the good work!

Andy

I have the same problem, when i delete the redirect url on submit, the data is saved.

strange after submitting this post i see the answer posts.

Thanks , working fine now.

Hi liefstepa,

Please see the fix in Max's message #8753 in this thread.

Bob

You are too fast guys , you can delete my posts.
Thanx again

Hi,
first thing, thank you for your!!
I have a couple of form running on this site:

<!-- w --><a class="postlink" href="http://www.orsaramusica.it">www.orsaramusica.it</a><!-- w -->

But I still experiencing some trouble with data saved in table.
Before to upgrade to the release 3, data was saved but randomly we had some missing registration and we could not figure out why. Now I have just upgrade to the last version and checked that chronocontact.php is bug free according to the last posts.
Although everything is working correctly, now no data are not recorded!!!

Can you please help me??? The form url is:
http://www.orsaramusica.it/index.php?option=com_chronocontact&Itemid=90

I have attached also a backup of the form.

Thank you again for your help.

Luca [file name=iscrizione.cfbak size=10028]http://www.chronoengine.com/images/fbfiles/files/iscrizione.cfbak[/file]

Hi Luca,

Sorry, I can't be much help. The form saves data OK here.

Please check that the datatable in the AutoGenerated tab - #__chronoforms_4 - matches up with the table in the database.

Next step would be to echo the sql out and try that in PHPMyAdmin to see if there is any fault there.

Bob

Hi,

**EDIT**
My bad.. I didn't know that I had to create the table in order for it to start recording values. I know it sounds kinda stupid of me.. but it didn't seem intuitive to me. I was assuming that the values would be stored in the db anyways, and that admin action was necessary to view this data. Again, my bad.. and thanks for this component🙂
*******

I just downloaded the file attached in message #8753, but it appears to be for J1.5. I am running a J1.0.x site. Is there a file for the J1.0.x versions?

Also, I notice that the code on my chronocontact.php file is exactly the same as the code pasted by greyhead a couple of message later. But I still can't get the tables to load😟

			/**
			 * Run the SQL query if there is one
			 */
			if($paramsvalues->autogenerated_order == $ixx){
				if ( !empty($rows[0]->autogenerated) ) {
					eval( "?>".$rows[0]->autogenerated );
				}
			}
		}

	    /**
	     * Redirect the page if requested
	     */
	    if ( !empty($rows[0]->redirecturl) ) {
	        mosRedirect($rows[0]->redirecturl);
	    }
	}
}

Pls help.. this is for our wedding website🙂

- V

Thank you Bob for taking time to help me.
Is there a easy way to debug (echo) the sql insert statement?
I have put the form in debug mode and deleted the redirect url, but still do not get the sql.

here the code in the AutoGenerated tab - #__chronoforms_4

$database->setQuery( "INSERT INTO #__chronoforms_4 VALUES  (
'' ,
 '". date('Y-m-d')." - ".date("H:i:s")."',
 '".$_SERVER['REMOTE_ADDR']."',
 '".JRequest::getVar('date','', 'post', 'string', '' )."',
 '".JRequest::getVar('nome','', 'post', 'string', '' )."',
 '".JRequest::getVar('cognome','', 'post', 'string', '' )."',
 '".JRequest::getVar('data_nascita','', 'post', 'string', '' )."',
 '".JRequest::getVar('indirizzo','', 'post', 'string', '' )."',
 '".JRequest::getVar('citta','', 'post', 'string', '' )."',
 '".JRequest::getVar('cap','', 'post', 'string', '' )."',
 '".JRequest::getVar('telefono','', 'post', 'string', '' )."',
 '".JRequest::getVar('email','', 'post', 'string', '' )."',
 '".JRequest::getVar('tipo_iscrizione','', 'post', 'string', '' )."',
 '".JRequest::getVar('corso','', 'post', 'string', '' )."',
 '".JRequest::getVar('esperienza','', 'post', 'string', '' )."',
 '".JRequest::getVar('lettura','', 'post', 'string', '' )."',
 '".JRequest::getVar('improvvisazione','', 'post', 'string', '' )."',
 '".JRequest::getVar('altri_seminari','', 'post', 'string', '' )."',
 '".JRequest::getVar('altri_seminari_quali','', 'post', 'string', '' )."',
 '".JRequest::getVar('reference','', 'post', 'string', '' )."',
 '".JRequest::getVar('brani','', 'post', 'string', '' )."',
 '".JRequest::getVar('consenso','', 'post', 'string', '' )."');" );

here the table structure

CREATE TABLE `jos_chronoforms_4` (
  `cf_id` int(11) NOT NULL auto_increment,
  `recordtime` text NOT NULL,
  `ipaddress` text NOT NULL,
  `date` longtext NOT NULL,
  `nome` longtext NOT NULL,
  `cognome` longtext NOT NULL,
  `data_nascita` longtext NOT NULL,
  `indirizzo` longtext NOT NULL,
  `citta` longtext NOT NULL,
  `cap` longtext NOT NULL,
  `telefono` longtext NOT NULL,
  `email` longtext NOT NULL,
  `tipo_iscrizione` longtext NOT NULL,
  `corso` longtext NOT NULL,
  `esperienza` longtext NOT NULL,
  `lettura` longtext NOT NULL,
  `improvvisazione` longtext NOT NULL,
  `altri_seminari` longtext NOT NULL,
  `altri_seminari_quali` longtext NOT NULL,
  `reference` longtext NOT NULL,
  `brani` longtext NOT NULL,
  `consenso` longtext NOT NULL,
  PRIMARY KEY  (`cf_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;

Can the problem be related to inserting commas or ' in the input form fields?

Thank you again!!

Luca

Hi bob!!
I have runned few more tests and it seems that I have found the problem: it seems related to apostrophes or quote signs, which are commun sign in italian...If in the input field I insert a text with ' the insert sql seems not working...
Do have any idea how to correct it?

Luca


The following insert went wrong:

date  	16-06-2008
nome 	l\'amore
cognome 	e\' bello
data_nascita 	09/05/1968
indirizzo 	via\'\'lkjklj
citta 	l\'ecco
cap 	22222
telefono 	329 2912069
email 	luca.mainieri@gmail.com
tipo_iscrizione 	effettivo
corso 	pianoforte
esperienza 	professionale
lettura 	ottima
improvvisazione 	ottima
altri_seminari 	si
altri_seminari_quali 	+++++ test di debug +++++
reference 	motori di ricerca
brani 	+++++ test di debug +++++
consenso 	si


Submitted by 79.98.40.74

Hi mingus,

Ah yes, that makes sense - please see this post.

Bob

Hi Bob!
It seems that the problem was really related to apostrophes...
Thank you very very much for your help

Luca