Need help: CHS database is broken.

[chashnniel]

I use CHS portable version. Today I download CHS from here, and I overwrite it to the latest version 2.46.01

I launch the new version 2.49. Everything is fine at first, then it shows me pop-up errors. All of the clips are gone and all the right click menu is broken(555.jpg)... I can't open "Option and Preference" page, so I can't even export my database.
I also tried to go back to the previous version(re-overwrite it with 2.46.01), but it also shows me the same errors.

What should I do to get my database/clips back??

[mouser]

I'm sorry this happened -- I don't know why it has, the new version should be able to run on the old database fine, but with all the recent changes I may have broken something.  Probably an easy fix.

BUT

First thing first, exist CHS (terminate if need be), and then go find your CHS Database directory, and zip it up so you have a backup of it.
Then do the same with your CHS Backups directory.
These should both be under your documents/DonationCoder/ClipboardHelpAndSpell directories.

CHS is pretty good about making backups so you should see recent backups in those directories.  You need to make a zip/copy of these backups so that they are preserved safely.

Once you have that backed up I'll help figure out whats going on.

[chashnniel]

thx for the quick reply.

I have zipped and backup these two folders

DO YOU Mean...
Redownload and unzip CHS to any new folder then unzip database and backup to the CHS folder???
---add: I tried this but I doesn't work and shows me the same errors.

PS: I'm using Portable version.

I have a Google Drive backup. so if you don't wanna look into this bug, you can forget about it since I can use the backup version. If you wanna figure it out, just tell me what to do next...

[mouser]

I was just saying I wanted you to make copies of the CHS backups so that you had those safe with no chance of overwriting them, before trying to fix the problem.

[chashnniel]

OK, I have made a copy of CHS backup. what's next??

[mouser]

Next would be, look in the Backups directory, see when your most recent backup is from, and confirm its recent.
Then, assuming so, you could delete the files in your Database directory (after you have backed it up just in case!)
Note that the Files/ subdirectory is image files captured, so you probably don't want to delete that.

(and some of the files in the Database directory are themselves alternate backup files, but let's ignore that for now).

After you delete the files in that Database directory (ClipTable.* and GroupTable.*) try restarting CHS and letting it start with a blank database.
Then go to the options and the maintenance tab and try to restore a recent backup in your Backups directory.

Meanwhile I will test the latest version here on my old database to see if I broke the upgrade process recently.

[chashnniel]

thx, everything is fine now.

Easy fix, I guess that's because IDK much about CHS...

BTW, if you have plan on adding localization to CHS, I can do some help.

[mouser]

I just wish I knew what happened that caused the corruption in the first place.. I tried using the new version with my old database and it didn't have any trouble, so it's a bit of a mystery why the problem happened in your case.

[chashnniel]

I replaced 2.46 with 2.49, then I launch 2.49 wothout errors.
After about several hours, I received the error message. I didn't close or restart CHS in the meanwhile.

And I didn't change any settings or move/delete any clips. the only thing I can remember is that I checked "Main Window - tools - launch clipboard multi-format blob...."

OK, maybe this can help...(I just figure it out )

Go to "Main Window - tools - launch clipboard multi-format blob...."
Under "Clipboard" -- click any entry -- then switch to "Database"
You will get the error in pic blow.

[mouser]

I am having a hard time reproducing the error but I feel you must be on to something... I hope you will keep hunting and see if there is some other additional piece to the puzzle!