Forums

database table names changed and chronforms can no longer find them

jedlad 29 Apr, 2017
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
Max_admin 29 Apr, 2017
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, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
jedlad 29 Apr, 2017
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
Max_admin 30 Apr, 2017
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, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.