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.my
sql.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
_______________________________________________
Kexi mailing list
Kexi kde.org
https://ma
il.kde.org/mailman/listinfo/kexi
|
