Forums

hi, i have a problem with "show data"
when i click the "show data" button i can't see the list but i have seen this message

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.promozioniaudionova.it/home/libraries/joomla/database/database/mysqli.php on line 727

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.promozioniaudionova.it/home/administrator/components/com_chronoforms/admin.chronoforms.php on line 401

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.promozioniaudionova.it/home/administrator/components/com_chronoforms/views/list_data.php on line 11

What can i do?

loste

I have seen this before after I had deleted or copied or done something to one of my forms and it messed things up. Try creating a new DB table with a different name or deleting the DB Save action and then put a new one in and select the db table. Hope this helps. Gabe

Whats the table name you are trying to view its data ? does it have a primary key ?

Regards,
Max

@ gabedaly
I have tryed to delay the table and built a new one but nothing has changed

@ admin
The table name is "Data-CVO-form-03", and what's the primary key? please look the sreenshot attacced.
To build the table i have followed the tutorial "CFV4_db_save.pdf"

I'm waiting your advice… thanks

loste

Hi loste,

Try to replace "-" by "_" in the table name then create a new one and connect to it, let me know!🙂

Regards,
Max

Nothing i have change with "-" but the rusult is the same.

Can you help me?

loste

I have check the file
Warning: Invalid argument supplied for foreach() in /web/htdocs/www.promozioniaudionova.it/home/libraries/joomla/database/database/mysqli.php on line 727

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.promozioniaudionova.it/home/administrator/components/com_chronoforms/admin.chronoforms.php on line 401

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.promozioniaudionova.it/home/administrator/components/com_chronoforms/views/list_data.php on line 11
#
and in the first file "…/mysqli.php on line 727" don't exist the line n°727
The same thing in the second file "…/admin.chronoforms.php on line 401"
and doesn't exist the third file "…/list_data.php on line 11"

What can i do?

loste

Hi loste,

All of these files exist in my Joomla! 1.7 installation.

All of the errors suggest that you are executing a query on a table with no columns; or a table that doesn't exist.

Bob

Hi Bob, i work with joomla 1.6.6 and i think that i have created the table, because when I want check the data, i put a flag on the form name, and in the colum "Tables Connected" i can choose the name of table that i have created (look the attaced file).

While about the columns, how can i check if i built it? and if there aren't built, how can i built it?

loste

Hi loste,

Please change the name of your forms and of the database table so that they don't use dashes e.g. Data_CVO or DataCVO instead of Data-CVO. There are still some problems with the database queries when dashes are used.

Bob

Ok now the table works, but when i have submited the form i don't have the record
loste

Make sure you have changed to save the data in the correct "new" table in the database save action. Now that your table is named differently you have to reselect that table on the db save action.

Hi, i have checked the name of the new table and it's right.
Could it be a problem if i have 2 events in "on submit area"? (look the attaced file)
loste

Try placing th DB Save before the redirect

Hi loste,

Please do as Gabe suggests. The actions are processed one after the other and the ReDirect User action redirects the user wasy from the form so any events after that are ignored.

Bob

i have placed the DB Save befor the redirect event but i have receved this error

Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /web/htdocs/www.promozioniaudionova.it/home/administrator/components/com_chronoforms/form_actions/db_save/db_save.php(63) : eval()'d code on line 10

Fatal error: Call to a member function bind() on a non-object in /web/htdocs/www.promozioniaudionova.it/home/administrator/components/com_chronoforms/form_actions/db_save/db_save.php on line 86
and the redirect event doesn't works

loste

Hi loste,

The most likely problem is tha one of the column names / input names in your table / form has space or some other special cahracter in it.

Bob

hi bob, do you receved my email?
loste

Hi loste,

Yes I got it - had to take my wife to the station to get a train to Paris. That took priority :-)

It's fixed now. The problem was the dash in the name of the 'e-mail' input. I changed the name to 'email'; created a new table* and the data is now saving OK.

Bob

* There was nothing saved and that's simpler than editing the old one.

Thank you very much!
i never imagined that also the dash in field name could create a problem.

Thank
loste