Storing Data in Database - Post ID...

User 10077 Photo


Senior Advisor
1,095 posts

Ran into a strange occurrence tonight. I set up a WFB form to store submitted data in a database. I submitted the data, and it stored it in the database just like it was supposed to.

I went back to the form and submitted different data. Instead of adding a new record, it overwrote the old one. If I open a new privacy window in Firefox and submit, it adds a new record.

Why is WFB overwriting records and how do I get it to not do so?
ASK ME ANYTHING
I provide personalized help for Coffeecup Users including training for Site Designer and Web Form Builder via Zoom.
Email me at support@usconsumernet.org or call 865-687-7698.

Did you know that Web Form Builder can be used for both simple and complicated forms and that it's not limited to the default fonts and buttons? Take a look at a form we developed for WindowTinting.com.
https://forms.windowtinting.com/forms/w … ppingcart/
User 187934 Photo


Senior Advisor
20,181 posts

That's very odd. Did you try submitting the form more than twice? FB is setup to only add records to a database.Iit could be a cache issue. A support Topic might be a good choice if you can still replicate the issue.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2942998 Photo


Registered User
74 posts

Assuming this is a SQL DB...Did you try a different browser? FF does some interesting things. I have a SQL back-ending 2 WFB forms, tried FF, Chrome and Edge with no issues in both regular and private. Is it possible the the DB got corrupted? You could try rebuilding / repairing the table. Typically under the maintenance functions.
User 187934 Photo


Senior Advisor
20,181 posts

We did some private testing and it did the same thing to me when I submitted it. I think it's the version of php that's being ran. I'm waiting for Brian to try down grading it.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2942998 Photo


Registered User
74 posts

Just for reference, my server is running PHP 7.3 (ea-php73)
User 187934 Photo


Senior Advisor
20,181 posts

Looks like it's a cache cookie issue. Waiting on test results from Brian after adding a script to the form.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.