mySQL overwrites records - Post ID...

User 1953598 Photo


Registered User
12 posts

No, I'm not getting new tables created. From the little mySQL that I know, it appears that the form is doing an "update" when it should be doing an "insert".
User 2022022 Photo


Registered User
2 posts

I believe that I have found my problem. I was looking through the php code and found a function called archiveOld table. That's exactly what is happening to me and it's because my form fields do not exactly match my database fields so the program creates a new table to match the form fields. I think maybe an error might have been more appropriate! But anyhow, I'm going to try to fix this and see what happens.
User 187934 Photo


Senior Advisor
20,193 posts

I think when I set up my first one I made the data base on the server and let the form create the table fields.:)
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 382699 Photo


Registered User
9 posts

Just to let you know that downloading the latest version build 4591 seems to have fixed my problem regarding mysql last entry being overwritten.
User 187934 Photo


Senior Advisor
20,193 posts

That's great Michael! Have fun with your new discovery.:)
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.