Forums

Problem restoring forms from 2.5 J1.5 RC1 naar 3.0 beta2

luykmhm 01 Sep, 2008
I backuped my forms from version 2.5 J1.5RC1. Removed chronoforms 2.5 and installed 3.0 beta2. When I restore the backuped forms I get the following messages:
======================================================================================================================================
Restoring the whole form failed Failed, error : Unknown column 'extraemail' in 'field list' SQL=INSERT INTO jos_chrono_contact (id,name,html,scriptcode,redirecturl,emailresults,extraemail,emailsubject,onsubmitcode,onsubmitcodeb4,attformtag,submiturl,emailtemplate,paramsall,titlesall,autogenerated,published) VALUES ('','Jouw_aanmeldgegevens','

Jouw aanmeldgegevens



email; // set up the database query $sql = \"SELECT * FROM #__chronoforms_3 WHERE email=\'$email\' order by Naam,recordtime DESC ;\"; $database->setQuery($sql); // retrieve the data from the database $rows = $database->loadObjectList(); ?> Naam Datum aanmelding Emailadres Aantal personen
\"; foreach ( $rows as $record ) { echo \" \".$record->Naam.\" \".$record->recordtime.\" \".$record->email.\" \".$record->aant_pers.\"
\"; } ?> ','','','0','','','','','','','','ccemail= bccemail= formmethod=post omittedfields= recip=Yes from_email= from_name= replyto_email= replyto_name= email_type=1 debug=0 mysql_type=1 enmambots=No emailfield= subjectfield= ccfield= bccfield= fromemailfield= fromnamefield= uploads=No uploadfields= uploadmax= uploadmin= dvfields= imagever=No validate=No val_required= val_validate_number= val_validate_digits= val_validate_alpha= val_validate_alphanum= val_validate_date= val_validate_email= val_validate_url= val_validate_date_au= val_validate_currency_dollar= val_validate_selection= val_validate_one_required=','','','0')
=====================================================================================================================================
What went wrong?????????
Max_admin 01 Sep, 2008
V2.5 forms can't be restored on V3.0 and vice versa!

Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
danieli 04 Sep, 2008
Wow... I hope you are kidding... because I shouldn't have to recreate my chronoforms all over again to move up a version.

That's a pretty harsh migration path.
Max_admin 04 Sep, 2008
Hi danieli,

unfortunately the whole database table structure and email data and file uploads have been changed, pretty hard to get a converter but may be I make one if I got time for this, if you checked how V3.0 looks then you will see how much things have changed.

Regards,

Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
danieli 04 Sep, 2008
Thanks for the reply Max.

I do have a "non-live" version of my site that I could load the new version in to have a look at it. But exactly how much might I be loosing?
[list=1]
  • Will my form tables remain intact?
  • Can I repoint the "migrated" form to the old tables?
  • If I have 2 versions of my site, could I simply copy/paste the form code from the "old" version to the new version?
  • [/list:o]
    Max_admin 04 Sep, 2008
    #1- yes, you will not lose saved data on uninstall (records)
    #2- yes, much easier in the new version, just 2 dropdowns to select your table and enable connection.
    #3- yes of course, you can copy and paste code from here to there.

    Regards.

    Max
    Max, ChronoForms developer
    ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
    ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
    danieli 04 Sep, 2008
    Awesome... then no form needs to be "recreated", just re-added manually... not as bad as I thought.

    Thanks Max.
    niels77 21 Sep, 2009
    sorry, but how is this done ? I've got several forms made in V2.5.Now I want to add a date picker...only available in V3.x ...so i need to migrate the forms. I noticed that simply updating Chronoforms wont work (table structure).
    Copy past of the old code into the new version also gives # errors.

    I there a manual ? Please ?
    danieli 21 Sep, 2009
    neils77,

    Pretty hard to know why you might be getting errors without knowing what's on your chronoform.

    Basically, this was my process...
    [list]
  • Used a non-live Joomla to do all my testing before moving to live
  • Spent some time creating forms from scratch in the new version, getting used to some of the changes and advancements
  • Paid special attention to the new email config/options
  • setup one "wizard" form with each form type so I could see the code and adapt it to my non-wizard forms
  • recreated a simple form of mine manually before moving to one that was more complex
  • etc...
  • [/list]
    Basically, make sure you build some comfort with the new version before trying to migrate old code; it is different, and for the better, IMHO. While email options will need to be rethought/reworked, the form body from the old version should just plug in (I was able to remove some variables/code I was using to try create my own "dynamic" e-mail options before)... after all, it's still the same html/php based form.

    If you don't have a second joomla install for "test"... now is a good time to set one up.
    GreyHead 21 Sep, 2009
    Hi niels77,

    danieli's advice is spot on.

    If you just want to add a datepicker then you can do that in the old version but you have to add the code by hand. There must be examples here of how to do it - I forget now, it's been many months since I looked at it :-(

    Bob
    niels77 21 Sep, 2009
    Thanks guys,

    If you could help me on my way with the datepicker for the old version, please.

    Niels
    danieli 21 Sep, 2009
    I think if you want to approach your situation that way, you should open a new thread with a snippet of your form code, and a clear statement of where you want to add the datepicker.
    niels77 22 Sep, 2009
    And how do I start a thread ?
    niels77 22 Sep, 2009
    Gentlemen,

    where do I upload my calendar script in order for my form to find it ? which is the right folder/path ?

    niels.
    This topic is locked and no more replies can be posted.