Something really weird is happening, I have been testing my app daily for the past week and it has not shown any issue but today, and this evening something weird is happening.
Basically, I dropped all tables (like I have been doing all week) from my database tables, and rand the query...
select * from SITEMAPLINKS;
As expected it shows 0 results.
Now when I did this process and then added things back into the app I noticed the results were doubling (these were ones I had already tested). I then ran the above again and along with the expected results we also ones that were in there from a week ago.
My app is powered by a script that runs in the background - this is currently NOT running, yet just now while trying to find the issue I cleared the database by running the creation script that first of all drops the table, I then ran a delete command in the sql console again the results were as expected 0.
I then added into the app the link and then queried the database again and there were all the links again, but the backend script isn't running so there should be nothing there yet. The submit from the app goes into a separate table.
Any thoughts on what might be happening?