Corrupted database

[Mark Schonewille]

Hi Ivan,

Is it possible that something unexpected causes the 0x71000 error?

Why doesn't Valentina Studio look up the error code in the XML file and 
show me a readable message? I should not have to look this up myself!

Yes, I am using Valentina Server. My hard disk is in perfect condition.

In never do anything with the master database. I have no idea what it is 
for. I guess Valentina uses it for some management tasks. I just know 
that deleting it usually fixes problems. However, before I can delete 
it, I have to stop Valentina Studio and the Valentina service process.

When Valentina Studio gets into this state, I can't execute any SQL 
anymore. SHOW VERRORS; wouldn't work either.

--
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/12/2014 13:41, Ivan Smahin wrote:
>
> On Dec 11, 2014, at 12:26, Mark Schonewille <m.schonewille at economy-x-talk.com> wrote:
>
>> 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.
>>
>
> It is ERR_SQL_PARSER_ERROR.
> It means sql-parser was not able to parse your sql-statement. It is not semantic but syntax error.
>
>
> BTW, you can get error descriptions (and more) via SQL:
> SHOW VERRORS;
>
> If you see no error messages there then something wrong with Valentina resources:
> Valentina Studio.app/Contents/vcomponents/vresources/en/kernel_errors.xml
> Valentina Studio.app/Contents/vcomponents/vresources/en/sql_errors.xml
>
> Probably it was deleted or changed?
> What vStudio version do you use?
>
>
>> 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.
>>
>
> So we are speaking of database under vServer?
> It sounds weird. Are you sure your HDD is ok?
>
>
>> 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.
>>
>
> What are you doing with master?
> Could you be more specific?
>