migrating a 2.5 table to 3.0

danieli 05 Sep, 2008
It seems that the new CF3.0 db has an "extra" field named uid.

How should I handle this missing field in my old databases?

Is there an equivalent MYSQL query I can run the Query Browser to insert a uid for the existing record?

Can MySQL duplicate the PHP function?
			srand((double)microtime()*10000);
			$inum	=	"I" . substr(base64_encode(md5(rand())), 0, 16);
Max_admin 06 Sep, 2008
Hi danieli,

you just connect to the table and Chronoforms will get familiar with the table structure, you don't have to care about columns, if there is a uid column then it will save the uid value, if not then no uid value will be saved! life is simple!🙂

Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
danieli 08 Sep, 2008
I found my issue.

It seems you can't simply manipulate the database by changing the field names, and then update the form and form settings to match.

jos_chrono_contact has a field named dbclasses... and unless you release and reattach the database to the form, this field does not get updated... which can cause the field mappings to become out of sync and therefore invalid and fail inserts.
Max_admin 08 Sep, 2008
glad u fixed it!🙂
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
danieli 08 Sep, 2008
Well, it took about 5 hours... but I got all of my CF2.5 forms entered into my testbed Joomla using CF3-B2. This should enable me to use the Form Backup/Restore functions to move them all to Live after I update the live server.

... now to start focusing on that awesome looking DatePicker!!
This topic is locked and no more replies can be posted.