Buy Now
Sign in

Table seems to disappear

mburkart01 , April 28 at 03:04
m
mburkart01

I have a really strange problem that has occurred twice in the last year. I have a form that stores data into the database, then it is retrieved for user to view. There has been no form edits to this set of forms in over a year.

The problem is that the data in the table has disappeared, it is complete empty. As of a week ago, we could successfully retrieve data, but today we cannot. Any thoughts as to why the data was there last week, then it is gone today?

Mike

GreyHead

Hi Mike,

None at all. Please check with your web host. If you have a database backup you can presumably restore the table from the last backup.

Bob

ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much

m
mburkart01

Bob,

I restored the table for the form and now I can see the data using a view I had previously created using Chrono Connectivity. The problem is that the data doesn't show up in a web page like it did before. Here is a link to a web page that has the problem.

Link to page with the problem

Can you tell me why the data is not populating into the form?

Thanks,
...Mike

GreyHead

Hi Mike,

I can't see anything useful from the form. How is the data supposed to load? There is nothing in the URL you posted to identify a record to be loaded.

Bob

ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much

m
mburkart01

Bob,

With your little hint, I was able to solve the problem. I was using the {chronoforms5} {/chronoforms5} plugin in my web page, but it appears the editor used by that component was converting the

&

to

&amp

. I switched the editor source code and manually edited the code to replace

&amp

with

&

, then saved. That appears to have fixed the problem

Mike

GreyHead

Hi MIke,

That makes sense - good to see you found a fix. There is a CF hack in the forums here somewhere to change the CF code to make that change.

Bob

ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much

m
mburkart01

Bob,

I have had the hack in place for quite a while. For some reason the hack does not work with this particular 3rd party component, Joomdonation - Event Bookings. When I get some time, I'll try track it down.

...Mike