Hi,
I recently had to migrate our site from one web server to another. After the migration, it seems we last the Chronoforms component. I re-installed our version V3.1_RC5.5 but when I did this, the 10 forms I had in Form Manager were no longer visible. I tried upgrading to V3.2 as well and hitting the SQL upgrade tool link.
I have checked in the database and all the forms are there with the jos_chronoforms extension.
Can any suggest how to make my forms visible again in Forms Manager?
Hi jross,
If the forms are still present as records in the jos_chronoforms table then ChronoForms houdl find them OK.
Can you dump the three jos_chronoforms tables from the database usign PHPMyAdmin and send the dump files to me (zip and then PM or email them) and I'll see if I can recover the forms.
Bob
Hi, thanks for that. With your advise, I think I can see where the main issue is. All my forms use the jos_chronoforms tables but the component is using jos_chrono_contact tables.
My problem is I can't marry the two together. I've zipped all the tables and attached them as requested.
Thanks very much for you help and hopefully you can re-create the index table
Jonathan
Hi Jonathan,
The jos_chronoforms tables are ChronoForms v3 data files*; the jos_chrono_contact tables contain the forms themselves.
Will try to reinstall shortly.
Bob
*In ChronoForms v4 they are the form tables - just to confuse.
Hi Jonathan,
Sorry for the delay.
There is nothing except the standard Demo form in jos_chrono_contact. If that is still true then I suggest that you rename it to jos_chrono_contact_empty and then rename jos_chrono_contact_old to jos_chrono_contact
The other form tables are empty so shouldn't need changing. With luck that will do the trick.
Bob
Hi thanks for the advise. That worked well.
Unfortunately I'm getting the following error when trying to edit or save a form.
TableChronoContact::store failed - Unknown column 'fieldsnames' in 'field list' SQL=UPDATE `jos_chrono_contact` SET `name`='vic_demoboat',`html`='
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Any suggestions how to fix this? Should I just do a total backup of the existing forms and do a new installation of ChronoForms and then restore the forms?
Jonathan