Corrupted database

Thu Dec 11 07:25:18 CST 2014

Hello Mark,

Thank you for your answer.
This happen far too many times to me too.
I use Valentina since v2 standalone. This happened "only" 2 or 3 times to
me, but also to some of my clients.
Now I'd want to jump to the client/server mode. During my tests, this happen
too !
I'm a bit afraid and anxious to go to this market with this problem...

François Van Lerberghe
Rue Thier Monty, 15 A
4570 Marchin
+32 (0)85 25 08 25

le 11/12/14 11:26, Mark Schonewille <m.schonewille at economy-x-talk.com> a
écrit :

> 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
>> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina