Buy Now
Sign in

database table names changed and chronforms can no longer find them

jedlad , April 29 2017
j
jedlad

I tightened security on my site yesterday and one of the effects was to replace 'jos' in all the chronoform table names in the database with another code.

Consequently when I try to access a form in the front end or edit it in the backed I get a message that the form cannot be found. Is there some simple way to tell Chronoforms V4 that the table names have changed and 'jos' should be replaced by 'qqzvl'

For instance what was jos_chronoforms_data_Fox_7 is now qqzvl_chronoforms_data_Fox_7

admin

Hi jedlad,

Chronoforms gets the tables prefix from Joomla, did you change the tables prefix in the Joomla global configuration ?

Are you sure its v4 ?

Best regards,
Max

Max
If your main question got answered then please mark the answer using the button!

j
jedlad

Thanks, I now understand what's happening. I didn't know where table prefixes were defined.

My site was hacked and I used a professional company to help resolve the issue. One of things they did was impose stricter standards on the site, including replacing all 'jos' prefixes with something less common. Obviously they just changed the prefix in the configuration file and in the database without thinking about the impact on applications within the site.

For the existing tables, I can rename them to ...jos... until they are no longer needed. The tables I use are usually only active for three or four weeks.

Any new tables I create will presumably pick up the the new prefix from the configuration file.

I run a golf club site and I'm still using V4 as I reuse all my tables for entering competitions once a year, I just change a little bit of the text each year, clean out the tables and take the new entries. The V4 tables work well. I did look at V5 a couple of years ago, but decided to stick with V4 as I would have had to recreate all the forms. When I looked, V5 didn't seem to like V4 forms.

It's only today when I posted my question that I realised V6 even existed.

Thanks for your help

admin

Hi jedlad,

No problems, I hope you managed to get it working now.

v6 is released about 6 weeks ago or so, there is also Connectivity 6 which you can use to display and manage data in tables.

Best regards,
Max

Max
If your main question got answered then please mark the answer using the button!