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 _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
