Data not being saved in table

Hi, I just installed the lastest version of CF3.1 on one of my sites. Created a new Joomla login for which is working perfectly. I have added additional fields onto the form, and set them to save into a new table. The time/date, uid etc is going in but not the data from my form fields!

I created the form using the wizard, and the table using CF so everything is spelt correctly. I have tried turning on/off the database connection, but still nothing. When I looked in the auto generated code for the form, it seems like there is no code to send the extra fileds to the database?

Hi james_sgp,

The most common reason for this is that your fields were not selected when you used the Create Table command. By default they show red bars (with tick icons) and are *not* selected.

Bob

Bob,

I already followed that path, but I will delete the table, turn off the DB connection etc. And do everything from scratch again to see if it helps.


James

Hi James,

Take a look at the table with PHPMyAdmin or EasySQL to see if the columns are there or not.

Bob

Ahh....haaa....

I tried that, now something different is happening. I`m getting the following error:

Warning: implode() [function.implode]: Invalid arguments passed in /home/ultrali1/public_html/divewear/libraries/joomla/database/database/mysql.php on line 540


It's added all the use data into the 'users' table, but nothing is in the CF table I created and linked (all using the wizards).

Any ideas?

Hi James,

Do you have a column or field name with a dash or a space in it? (or some other non-alphanumeric character)

Bob

Bob,

I don`t think so...
But i just tried the form again, and bizzarly it works...hmm...

I`ll publish it and monitor how it goes...

Thanks for your time,

James

I just installed this component and it is wonderful and extremely flexible but I have one major complaint and I'm not sure if this is the correct place to post this but the user interface for the create tables UI (and a few of the other UI options) is extremely confusing. You have a green check mark which typically means something is selected representing an option that is not selected over a red bar which usually means stop or inactive. Then when you activate the option the bar turns green and the symbol turns from a green check mark to a red X. One UI convention or the other needs to be chosen as this current behavior is extremely confusing.

What was wrong with the old user interface as it appears in your tutorials?

Hi arhospitality,

Max changed the interface a couple of releases ago. I agree that it is confusing. I think that the logic is that the color bar shows the state (green is enabled) and the icon shows the action (clicking the x disables). I've no idea whay he changed it.

Note: this applies to both the Plugin tab and the Create Table page.

Bob

Thank you for explaining that bit of information. It would be fine if he at least had a tooltip explaining what was going on. I looked all over for a tooltip but didn't find one if there is one. Also the UI is different than what appears in the tutorials which is also confusing. I appreciate all the work you guys put into this.

Jason

Hi,

I have a very serious problem with ChronoForms, as I'm using it for our clients to upload their files to our server.

And everytime they completed sending us their work, you can read the following:

Warning: implode() [function.implode]: Invalid arguments passed in /homepages/17/d283999350/htdocs/page/libraries/joomla/database/database/mysql.php on line 541

Line 541 belongs to a function:

function insertObject( $table, &$object, $keyName = NULL )
{
$fmtsql = 'INSERT INTO '.$this->nameQuote($table).' ( %s ) VALUES ( %s ) ';
$fields = array();
foreach (get_object_vars( $object ) as $k => $v) {
if (is_array($v) or is_object($v) or $v === NULL) {
continue;
}
if ($k[0] == '_') { // internal field
continue;
}
$fields[] = $this->nameQuote( $k );
$values[] = $this->isQuoted( $k ) ? $this->Quote( $v ) : (int) $v;
}
$this->setQuery( sprintf( $fmtsql, implode( ",", $fields ) , implode( ",", $values ) ) );
if (!$this->query()) {
return false;
}
$id = $this->insertid();
if ($keyName && $id) {
$object->$keyName = $id;
}
return false;
}


And Line 541 is:

$this->setQuery( sprintf( $fmtsql, implode( ",", $fields ) , implode( ",", $values ) ) );

Can anyone help? It's really urgent.

Thanks in advance!

AnimusVitae

Hi AnimusVitae,

Which Joomla and Chronoforms versions ?

the easiest and quick way to fix this issue is to set "error reporting" under the Joomla global config to "none" or "default" which should ignore any warnings!

Regards
Max

Hi Admin,

I already did that before sending you this post.

Although the setting is "default" or "none", you can still see the message.

Joomla version 1.15.14 and

ChronoForms_Plugin_V3.1_RC5.2.zip
ChronoForms_V3.1_RC5.5.zip

AnimusVitae

Hi,

My only thought now is to disable E_NOTICE in the php configuration, try to ask your web host to do this, its not suggested to have it enabled for production servers anyway!

Regards,
Max

Ho appena installato questo componente ed è meraviglioso ed estremamente flessibile, ma ho una denuncia gravi e non sono sicuro se questo è il posto giusto per questo post, ma l'interfaccia utente per la creazione di tabelle UI (e alcune delle altre UI opzioni) è estremamente confusa. Si dispone di un segno di spunta verde che indica in genere che qualcosa è stato selezionato rappresenta un'opzione che non è selezionata su una barra rossa che di solito significa fermarsi o inattive. Poi, quando si attiva l'opzione la barra diventa verde e il simbolo si trasforma da un segno di spunta verde per una X rossa Una convenzione utente o l'altro ha bisogno di essere scelto come questo comportamento attuale è molto confusa.

Google Translation added by Greyhead:

I just installed this component and it is wonderful and extremely flexible, but I have a serious complaint and are not sure if this is right place for this post, but the user interface for creating tables IU (and some other UI options) extremely confused. You have a green check mark that usually indicates that something has been selected an option that is not selected on a red bar that usually means stop or inactive. Then when you turn on the bar turns green and the symbol changes from a green check mark to a red X. A convention or another user needs to be chosen as this current behavior is very confusing.

Hi gjazz35,

Sono d'accordo.
I agree.

Bob

Si prega di inviare una traduzione in inglese, nonché la versione italiana.
Please post an English translation as well as the Italian version.