Forums

Undefined variable when creating table

?
Guest 12 Aug, 2011
hi all,

I just tried creating my first table but get the following error:

Notice: Undefined variable: row in ../administrator/components/com_chronoforms/admin.chronoforms.php on line 531

Fatal error: Call to a member function getError() on a non-object in ../administrator/components/com_chronoforms/admin.chronoforms.php on line 531


could somebody please help me out?

J1.5.23, CF 4 RC1.9
Max_admin 13 Aug, 2011
Hi Gabriela,

I think that I have already sent you the latest insatller for the V4 RC2.0 yesterday ? did you test it yet ? it should have this issue fixed.

regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
?
Guest 13 Aug, 2011
Hi Max,

thanks for sending me RC2.0.

However I still cannot create tables. what I get now is the red error icon with the reddish error background but without any error message.

J1.5.23, CF4RC2.0
Max_admin 13 Aug, 2011
Hi Gabriela,

Please send me a backup for your form which you are using for creating the table through our email, I need to test this myself.

regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Nico97 15 Aug, 2011
Hello everyone.
I made a new installation of my joomla web site to start working with Chronoforms.
yesterday I downloaded the last version of Chronoforms and try to create my first table. I get the same error.

PHP Fatal error: Call to a member function getError() on a non-object in ...\\site web\\administrator\\components\\com_chronoforms\\admin.chronoforms.php on line 531


I uses the CF wizard to create my database. I'm very interested in the solution to this problem.
Thanks.

Joomla 1.5.23
Chronoforms Chronoforms J1.5 V4 RC1.9.
PHP5
MySql 4.1.14
GreyHead 15 Aug, 2011
Hi Nico97,

There's a bug in the Admin Table Saving code. Line 531 (in Joomla! 1.5) / line 534 (in Joomla! 1.6) is JError::raiseWarning(100, $row->getError()); but $row is not defined, it needs to be JError::raiseWarning(100, $database->getError());

Bob
Nico97 15 Aug, 2011
Hello Bob,

Thanks for your answer.
I made change to the code as you mentionned but the database table has already not been created. I'm redirected on the form manager page (OK!) but with an error icon (forbidden) with a blank message. Neigther on my SQL database manager nor on ChronoForm connectivity plugin I can't see my new table. I paid attention to avoid special caracters, limit table field size, even use the default table names...

Any idea?
Max_admin 15 Aug, 2011
Hi Nico,

Please contact me through the contact us page to send you the latest installer with all fixes and you can test it from there.

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
pcheng 21 Aug, 2011
I got the same error in my Joomla 1.6 installation.

I made the change to the code and now no table is created and all I get is a one way sign at the Forms Manager and no table created.

Could you please tell me what might be wrong?

Thanks,

Pericles
Max_admin 22 Aug, 2011
Hi Gabriela,

I have checked your form.

Your form has a field named "cf_id", this overrides the cf_id field settings and makes it lose the "primary key" and "extra" choices, you should reselect them manually, or change your form field name to something else (not cf_id).

I have added a check for that in the new version!

@Pericles, is this the same issue as yours ? please send a screenshot for your table creation screen.

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
pcheng 22 Aug, 2011


My table has the cf_id field as well but that was automatically inserted using the create table option in chronoforms. The form only has one field namely the type field.

I copied another form that worked fine and simply changed the names of the values. I will try and recreate the form from scratch to see if the copying made any problems.
pcheng 22 Aug, 2011
I guess copying the form makes the problem. I made a new one and everything works fine.

Thanks,

Pericles
?
Guest 22 Aug, 2011

Your form has a field named "cf_id", this overrides the cf_id field settings and makes it lose the "primary key" and "extra" choices, you should reselect them manually, or change your form field name to something else (not cf_id).



Hi Max,

You are referring to the hidden field aren't you? If I'm not supposed to use cf_id on a field how could I then use this form for editing entries ?
would I need to add back the hidden field after creating the table then?
GreyHead 22 Aug, 2011
Hi gabrielaH,

It's probaby enough to un-check the second cf_id line in the Create Table form.

Bob
pcheng 22 Aug, 2011
One idea would be what I did. I created the table without the hidden field and then added the field after the table was created.

This is due to the fact that the auto generation looks at the fields in the form and then creates them.

Pericles
Max_admin 24 Aug, 2011
@Pericles,

I don't think copying the form would cause this, there is a problem with the cf_id field.

You can create the table first then add the cf_id field, this is a good workaround for now as you mentioned until the new version is out!🙂

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.