[Kexi] Kexi tries to convert MySQL project

[Jarosław Staniek]

Jan Gromadzki said the following, On 2007-10-18 10:48:

>> Does the second box have acces to he same database or to a copy? 
> 
> Literally, it is a set of the same databases stored on 2 unconnected
> boxes (but the OS and MySQL are in the same version on both). Long time
> it worked correctly.
> 
>> If this is a 
>> copy, maybe you could perform a mysqldump of both copies and compare them?
> 
> I have a zip archive of the bases from working system and in the case
> of database used dellow the files are identical.
> 
>> You could look at tables having prefix kexi__ in name - [1] absence of these 
>> tables or [2] removed/edited records (e.g. using external tools) could lead to 
>> the problem you describe.
> 
> I do not any  editing in these tables, they seem to be the same like in
> working system.
> 
>> Specifically, the error appears when there is no result in the following query:
>>
>> mysql>
>>
>> SELECT db_value FROM kexi__db WHERE db_property='kexidb_major_ver';
>>
>> result: 1
>>
> 
> mysql> use HomeInfo
> Database changed
> mysql> SELECT db_value FROM kexi__db WHERE db_property='kexidb_major_ver';
> ERROR 1017 (HY000): Can't find file: './HomeInfo/kexi__db.frm' (errno:
> 13)
> 
> but 'kexi__db.frm' exists and is the same like in working system.
> 
> I have no idea what is wrong.
> 
> 
> with best regards

I now believe we have identified a problem at MySQL level, not Kexi.
Are the file(s) readable for mysql?

A quick search returned me http://ubuntuforums.org/showthread.php?t=443371
and http://bugs.mysql.com/bug.php?id=16802

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org