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
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.
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
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.