SQL error or missing database after update to v7

Started by Lurchi

SQL error or missing database after update to v7   06 May 2022, 02:48

Hello

When I install version 7, I get the following error right the first time I start it:

Quote

SQL error or missing database: attached databases must use the same test encoding as main database

Attachments:
open | download – Screenp_IHK_0001_Datum_2022-05-05__18-45-38.jpg (60.7 KB)
SoftPerfect Support forum - Andrew avatar image

Re: SQL error or missing database after update to v7   06 May 2022, 09:07

This error means somehow the data conversion from version 6 to version 7 did not go to plan. You can simply continue using version 7 without the old data.

Alternatively, if you'd like us to investigate this issue, please compress the contents of C:\ProgramData\SoftPerfect\NetWorx to a ZIP file and upload it here.

Re: SQL error or missing database after update to v7   06 May 2022, 16:29

Thank you. I can't upload my zip-file. Because the file size is 49 MB.
I have the same problem.

My ZIP-File is18.2 MB and can't be sent. I made another compressions to RAR (14.5 MB) und 7z (11.1 MB) and could send it to SoftPerfect.

I hope, I get back a conversion to db3.
SoftPerfect Support forum - Andrew avatar image

Re: SQL error or missing database after update to v7   07 May 2022, 18:52

Thanks guys, we have found what was causing this.

Some really old NetWorx databases were creating using UTF-16 text encoding, while the newer ones use UTF-8 for compactness. The current conversion routine can't handle two databases in different encodings, but we will get this fixed shortly. Your data will be saved (except for the per-application usage breakdown).
SoftPerfect Support forum - Andrew avatar image

Re: SQL error or missing database after update to v7   07 May 2022, 19:39

We have just fixed the database conversion routine and now it should handle very old NetWorx databases as well. Please do the following:
  1. Download a fresh copy of NetWorx.
  2. Install it over your current installation and reboot if asked.
  3. To initiate the conversion, quit NetWorx after it starts.
  4. From C:\ProgramData\SoftPerfect\NetWorx delete all the files that have the DB3 extension, including DB3-SHM and DB3-WAL.
  5. Start NetWorx again. It will create a new database and perform the conversion from DB to DB3.

Re: SQL error or missing database after update to v7   08 May 2022, 18:15

Yea, thank you very much. Now the conversion has worked. But the size difference is 1:100. Can this be possible?
SoftPerfect Support forum - Andrew avatar image

Re: SQL error or missing database after update to v7   08 May 2022, 19:09

Not all data are imported. In particular, when converting usage records, it will not convert per-application usage breakdown. Usually this information takes most of the space, that's why the size became much smaller.

If you enabled application tracking in the welcome dialog of version 7, it will be recorded from then on.

Re: SQL error or missing database after update to v7   09 May 2022, 02:34

OK. Thank you very much. One last question: How can I back up NetWorx's settings?
SoftPerfect Support forum - Andrew avatar image

Re: SQL error or missing database after update to v7   09 May 2022, 15:08

In both version 6 and version 7 the Backup button under Usage Reports will back up the entire database, including all settings and usage records.

SoftPerfect support forum

Re: SQL error or missing database after update to v7   10 May 2022, 17:19

Thank you so much.

Reply to this topic

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

 **      **  **     **  ********  **     **  **    ** 
 **  **  **  **     **  **        ***   ***   **  **  
 **  **  **  **     **  **        **** ****    ****   
 **  **  **  **     **  ******    ** *** **     **    
 **  **  **  **     **  **        **     **     **    
 **  **  **  **     **  **        **     **     **    
  ***  ***    *******   ********  **     **     **    

Message: