Corrupted database

[Mark Schonewille]

Hi Francois,

I'm having similar problems all the time. I use Valentina for 
development only. Every now and then, it appears something is wrong. 
Today, after executing "USE DATABASE databasename" in Valentina Studio, 
I got error 0x71000.

Beats me wha 0x71000 means. I really would like to see more verbose 
errors or at least a simple way to look up meanings and possible causes 
of these cryptical error codes.

I spent several ours checking my database, my programming code and my 
SQL syntax until I finally decided to delete the master database. After 
deleting the master database, everything worked fine.

Apparently, the master database is extremely prone to getting corrupt. 
"Extremely" because in all those years, mabe a decade, that I use MySQL 
and SQLite, this has never happened to me, but with Valentina this 
happens to me continuously.

Unfortunately, I have no idea what causes Valentina databases to be 
corrupted that easily.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other 
colour spaces. http://www.color-converter.com

Buy my new book "Programming LiveCode for the Real Beginner" 
http://qery.us/3fi

Fill out this survey please
http://livecodebeginner.economy-x-talk.com/survey/

Munten verzamelen op Facebook
https://www.facebook.com/groups/numismatiek.nl/

On 12/9/2014 14:38, François Van Lerberghe wrote:
> Thank you Ivan for your explanations.
> Have you some for this corruption ?
> I don't understand how this can happen.
>
> François Van Lerberghe
> Rue Thier Monty, 15 A
> 4570 Marchin
> +32 (0)85 25 08 25
>
>
> le 9/12/14 10:02, Ivan Smahin <ivan_smahin at paradigmasoft.com> a écrit :
>
>> On Dec 9, 2014, at 8:38, François Van Lerberghe <frvanlerberghe at gmail.com>
>> wrote:
>>
>>> Hello,
>>>
>>> After many month using my database, yesterday, Valentina return me an error
>>> in its structure, shown in a Diagnose report :
>>>
>>>    ==========> Field: Notes , type Text
>>>        .RecID: 1516. Segment: 249. already in use.
>>>    .....> SegmentFile:
>>>
>>>    All right!  ( SegmentFile: )
>>>
>>>
>>>    Problems found!  ( Field: Notes , type Text )
>>>
>>>
>>> I use Valentina 5.6 (V4RB v5.6) on MacOS 10.6.8
>>> Do someone have an idea on what can give me this corruption ?
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>