Missing records again
I may have a clue to what caused the missing records. I was entering a simple option and went to edit it and the edit and delete links would not work. The rollover highlight worked, but it did not send a new URL to the browser. The entry for the option was Petite: 20.5-21.5"
I thought about the quote sign being used to display inches being the culprit. Sure enough I made an entry without the quote symbol and then I could edit it. I made one with the quote symbol and then it would not edit.
I went to edit older records and I found that all my options were missing from the store database. This is the second time I have lost all the options in this database. Doesn't give me a lot since of reliability with this application. I looked at the database and about 3500 records are missing in the options table, all but the last few entries. This happened at the same time as my above problem. Is it possible that this anomaly in the application could cause the deletion of all data within a certain table? I need two make sure of what is causing this problem before going live with this site. Or for that matter spending anymore time working on the site until I can find an answer to my problem. HELP :-)