Forums

Rename connected tables after migration

steven5324 05 Apr, 2015
Happy Easter evening all!

I've used ChronoForms and CC happily the last years and created quite some extensive forms and connections.
Now I (finally) migrated from Joomla 2.5 to 3.4, and had to reinstall CF and CC. I restored all my forms and connections, but then I found out that all tables used in these forms still were the old ones: my tables under J2.5 had a j25_ prefix and my current tables have a j30_ prefix. These table names are used in all db_save and record_loaders actions, as well as in custom actions.

Is there an easy way to replace these table names / prefixes used in my forms (and connections) all at once?
I tried to edit the .cf4bak files to just search j25_ and replace with j30_, but I guess it's encrypted or compressed in some way.

Thanks in advance!

Steven
GreyHead 06 Apr, 2015
Hi Stephen,

There are two options here.

The standard one is to edit each of the forms, open up any DB Save or DB Read actions and 're-connect' the table.

The alternative is to edit the table names in PHPMyAdmin - this is usually the less desirable option. The problem is that Joomla! code using the #__ prefix replacer will than not work with these tables.

For your custom code actions - if they use #__ then they should automatically work with the j30_ tables. If not then it is a search and replace job (or rename the tables).

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