Forums

Hi there,

thought you may be interested in the following. I'm getting the folling error code on a J 1.5.3 site when using the ChronoConnectivity admin page.

Parse error: syntax error, unexpected '$', expecting T_VARIABLE in {HomeDirectory}/public_html/administrator/components/com_chronoconnectivity/admin.chronoconnectivity.php(28) : eval()'d code on line 45

Only seems to occur once a Connection has been created. Could this be a problem with my database table, or is this just a Joomla version problem?

Interestingly, the Connection seems to work fine from the Front-End, but I can't get Show Date to work. I'm trying to replicate this on my test system (J 1.5.6) to check my database table is good!

OK, I've just copied the data table to my J 1.5.6 server, and I'm getting the same error, so I guess it's my data. 😟

The table was generated by Chronoforms, and has 44 text fields, plus the automatically added CF_ID, UID etc.

Any Ideas what I've done wrong with the data to cause this? 😶

Hi Jim, please apply this patch and we can go from there!

http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=13&t=10935#p12487

let me know how it works after this!

Thanks for your always quick support! 😀

I've applied the patch from the other thread, and I'm still getting the same Parse error.

Not good, I believe its an issue with your table or the fields names, can you backup your table structure and attach it here ? SQL so I can add it to my machine and test!

Cheers

Max

Yes, no problem at all! 😀

I've attached the file, with a ZIP, as your forum UPLOAD will not allow *.SQL files as attachments.

good, you have a field called 8ball, make it ball8 and all will be good, you can't have numbers as the first digit!

Cheers

Max

that's brilliant!

I didn't realise there was an issue with a field name beginning with a numeric. 😶

Ok, can you confirm with me the process for renaming the field?
I'm assuming:
1) rename field in phpmyadmin
2) rename field name in chronoform (and again in my email template)
3) rename field in the AutoGenerated code, so new entries go to the new field name.

Is that all of it? Obviously I need to do this while no one is using the submission form!

Hi Jim,

#1 correct
#2 rename in HTML code of form, and save the form, it will make the necessary changes in autogenerated, assuming u have BETA 2
#3 open your connection and save it again so its reinitialized!

Cheers

Max

Thanks again Max,

actually, I've not upgraded the live site to the latest Chronoform, I'm still on 2.5 RC3.1

I think I've made a mess of applying all this to my live site...

I made the mistake of creating a new field called "eightball" in phpmyadmin first, then changing and testing for form pointing to the new DB field, but this stopped the record being created in the table. 😲

I had to remove the new field, and rename the old to get it to work. Not sure why, maybe something like the form not creating an entry for the extra field?!? 🤨
OK, so the form is working now.

Next problem is, that I tried to go into the 2 ChronoConnectivity entries and re-save them, having "forgotten" to update the live site with the 2 files from the patch. This has given me the "Cannot redeclare class Tablechronoforms_4" error, and still does after I've updated the files.

Is there any way I can fix this without losing the Connectivity items I've already created?

Thanks again!
Jim

Scrap that,

I logged into PHPMYADMIN, and browsed the jos_chronoconnectivity table to retrieve my original code.

Then an uninstall and reinstall of Chronoconnectivity (with updated files in the ZIP) allowed me to jump in and put the entries back.

Thanks for all your help today Max,

Jim

PS, very impressed, I have reviewed at Joomla Extensions Directory

Thanks Jim, for anybody else, you can clean the dbclass field if you got stuck at the same situation like Jim!🙂

Regards,

Max