CCv5 Delete Cache is not deleting cache

How to resolve ChronoForms v5 cache not clearing after database field changes.

Overview

The issue occurs when field names in the database contain spaces, which prevents the cache from updating correctly.
Ensure all database field names do not include spaces, then use the CF delete cache function to refresh the data.

Answered
go goingtocry 17 Nov, 2014
Hi all

I have searched the forums about deleting the cache on CFV5 if you add a new field to the database. It should delete cache right?

1. The last time I did an edit to the table fields, I clicked "Delete Cache" and it worked. I editited this table below and now it is not working at all.
2. I have clicked delete cache in CF a number of times - not working
3. I selected all the forms in the list and deleted cache - not working
4. I selected all the CCv5 connections, clicked delete cache - not working
5. I deleted the original form, created a new one with the same name - not working
6. I deleted that form, created a new form, renamed the new form - not working
7. I have cleared Joomla cache - not working
8. I have logged out, cleared browser history, rebooted PC, deleted cache, deleted the database, built a new one - still not working
9. I have punched the keyboard, kicked the cat, shouted at the neighbour and started taking drugs to cope... still no change

I am using an script to update the table in the custom code to write this to another table... There is nothing wrong with the update script as I have tested it on another form with CF4 and it did work.

The delete cache worked once before, but not again.
The debug array still shows the following:

Array
(
    [chronoform] => User_Details_Required
    [event] => submit
    [first_name] => TestName
    [last_name] => TestSurname
    [submit] => Save
    [id] => 860
)



The new field names are:
I replaced "first_name" with "sender_first_name" and "last_name" with "sender_last_name" in the table, but it is still not updating only updates when I revert back to the field name. I need to find the issue, as I cannot update fields or add fields in three other forms I am building.

Is there anything I am doing wrong or is there a way to perhaps reset the cache manually?

I am hugely frustrated and am about to cry...

Thanks
go goingtocry 17 Nov, 2014
Oh and I have waited over 24 hours as Max mentioned in one post to reset cache... Still nothing...
go goingtocry 17 Nov, 2014
Answer
OMG!... Ok all is good... I had spaces between my fields. Nevermind, the delete cache worked after all!!!!
This topic is locked and no more replies can be posted.