Forums

Simple case: I am using Version 6.1.2 on the Joomla 3.9.6 platform. I have a form with a Table field that is Type VARCHAR(255). I want to change it to Type VARCHAR(50).
Action: I use the "Data tables" dropdown for the form. I select the table to open it. I use the blue button "Modify Table". I scroll to the field in question and change VARCHAR(255) to VARCHAR(50). I use the black "Save Table" button. I then re-open the table as above. The field's Type has not changed: it is VARCHAR(255)
​
We have been doing these Type changes for years in Chronoforms... now they no longer work. Am I missing something?

Clear cache, and use PHPMyAdmin instead.

Of course PHPMyAdmin works...but not for my clients who have neither cPanel access nor expertise. And changes of this nature are required on a weekly basis on multiple fields.
​
So are you saying that, in this version, "Modify Table" no longer works?

No I'm not saying that at all....
​
You might also have to check if your host is cacheing the data tables too, that happens sometimes. Also why do you need to make multiple changes to tables every week?

I actually am the host - the tables are not cached.
Changes are made to this on-line order form weekly because the inventory changes weekly.

okay well I'm not going to tell you how to design your tables but that sounds a bit weird.
​
Do any of your save data actions have the "auto manage table" option checked?

It's not at all weird in organic farming.
​
Yes, that option is checked. I have tried turning it off but "Modify Table" still doesn't work.

Dunno sorry. If you have the latest version and you've cleared the cache it should allow it. You could try PHPMyJoomla and use MYSQL to change the table directly.
​
And just for my own curiosity can you show me your table setup? Interested to know how organic farming means you have to make weekly changes to table structure.