Well, after writing a very significant ajax api process in a blank application’s On Execute yesterday, today when I opened it the content of an unrelated blank form had ‘magically’ replaced the content of my api code. If I’m not wrong, SC is storing the content of the On Execute in a database and it’s screwed up somehow. Now I’m going to have to remember every nuance of my code and spend another few hours rewriting it. To be honest, I’m at my last with SC after this sort of thing happening. It’s not worth the low dollars to have to spend hours redoing things. My last back up was 2 days ago, and for the life of me I shouldn’t have to back up more than than that in the off chance something like this happens. Not good enough.
That’s not good! Did this happen on version 9.8?
Yep, 9.8.007 (7) to be precise. After doing some probing on this forum, my issue isn’t unique. Others in the past have commented about SQLite’s and or SC’s unreliability in relation to code management.
https://forum.scriptcase.net/t/application-with-no-name-showed-up-in-project
https://forum.scriptcase.net/t/error-while-create-project
…I’m sure there are more.
Anyhow, it’s a big lesson to have learned the hard way and it has definitely knocked my confidence around a bit. I can certainly put up with issues and bugs every now and then, but not this sort of issue. Not sure what path I’m going to take to be honest as I’ve invested a great deal of time so far in developing my application using SC.
1 Like
Were the blank Applications named similarly?
Nope, only thing similar was I use b_ in front of the app name to denote it’s a blank app. Apart from that they’re all unique names.
What I’ve done is when I install SC, I choose MariaDB to install Scriptcase, instead of SQLite. And never faced this kind of problem.
1 Like
I wasn’t aware I could use MariaDB at install. Do you know if I can I reinstall SC with MariaDB and import my project?
Yes, but you need to export and import. Just in case (but you already do that) make a full binary backup before you do (just in case 
) Btw, I managed to have a project that corrupted also, which is why I always export my project before I close SC.
2 Likes
Thanks @aducom. I’ve also found a past post that sheds light on the process of migrating to MariaDB.
https://forum.scriptcase.net/t/conversion-of-scriptcase-9-from-using-sqlite-to-mariadb
I’ll set aside time to get this done.
Thanks to everyone that chipped in on this little rant of mine.
2 Likes
theres is a scriptcase option on the main menu (i dont remmember by memory) but
- dont touch anything
- go to a menu function and restore your blank application (it is something like windows trashcan) if you are lucky you could “undo” the damage.
let me know if you find it (i dont have my scriptcase laptop with me now)
best regards
fer
1 Like
menu application \ restore applications then select the application and version you want to restore
in menu options \ settings \ system settings the “Number of automatic application copies” affects the backup retention
2 Likes