Ron, It's a known bug for 4.1.13 and up. It seems to be fixed in 4.1.15 and 5.0.13. http://bugs.mysql.com/bug.php?id=12325
Cheers, Vincent 2005/9/21, Ron Grabowski <[EMAIL PROTECTED]>: > A and C are drives but I have a also have a "D:\" drive on my system. > I'll try installing other versions inside virtual machines and see if I > can reproduce the problem. Apparently I'm the only one to experience > this so far: > > http://dev.mysql.com/doc/mysql/en/news-4-1-x.html > > Thanks everyone for running testing the CREATE TABLE scripts for me. > > --- Larry Meadors <[EMAIL PROTECTED]> wrote: > > > By any chance, are those drive letters on your system? > > > > Larry > > > > > > On 9/18/05, Ron Grabowski <[EMAIL PROTECTED]> wrote: > > > Whenever I try and run the StatementTest group in NUnit I get the > > > following error message: > > > > > > > > > IBatisNet.DataMapper.Test.NUnit.SqlMapTests.StatementTest.TestCustomTypeHandler > > > : IBatisNet.Common.Exceptions.IBatisNetException : Unable to > > execute > > > the sql: other-init.sql > > > ----> ByteFX.Data.MySqlClient.MySqlException : Can't find file: > > > '.\ibatisnet\c.frm' (errno: 13) > > > > > > 'ibatisnet' is the name of the table in MySql, not a file path > > relating > > > to the IBatisNet source code. > > > > > > If I comment out this line from StatementTest: > > > > > > InitScript(sqlMap.DataSource, ScriptDirectory + "other-init.sql"); > > > > > > All the tests pass except for the one or two that rely on > > > other-init.sql. > > > > > > When I try to run other-init.sql from a mysql prompt the file > > starts > > > out ok: > > > > > > mysql> use IBatisNet; > > > Database changed > > > mysql> > > > mysql> drop table if exists Others; > > > Query OK, 0 rows affected (0.03 sec) > > > > > > mysql> drop table if exists A; > > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > > > > > mysql> drop table if exists B; > > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > > > > > mysql> drop table if exists C; > > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > > > > > mysql> drop table if exists D; > > > Query OK, 0 rows affected (0.05 sec) > > > > > > mysql> drop table if exists E; > > > Query OK, 0 rows affected (0.04 sec) > > > > > > mysql> drop table if exists F; > > > Query OK, 0 rows affected (0.04 sec) > > > > > > But eventually I see the same error that I see in NUnit: > > > > > > mysql> > > > mysql> CREATE TABLE C ( > > > -> ID varchar(50) NOT MULL , > > > -> C_Libelle varchar(50) NULL , > > > -> primary key (ID) > > > -> ) TYPE=INNODB; > > > ERROR 1017 (HY000): Can't find file: '.\ibatisnet\c.frm' (errno: > > 13) > > > > > > The statement after that is executed fine: > > > > > > mysql> CREATE TABLE B ( > > > -> ID varchar(50) NOT NULL , > > > -> C_ID varchar(50) NULL , > > > -> D_ID varchar(50) NULL , > > > -> B_Libelle varchar(50) NULL , > > > -> primary key (ID) > > > -> ) TYPE=INNODB; > > > Query OK, 0 rows affected, 1 warning (0.09 sec) > > > > > > If I change the names of the tables from: > > > > > > A, B, C, D, etc. > > > > > > to: > > > > > > AA, BB, CC, DD, etc. > > > > > > everything works fine. Could it be that those table names are > > reserved? > > > > > > I'm using MySql 4.1.14-nt on a Windows Home machine. > > > > > > Could someone else running MySql 4.1 run these commands and report > > > their output: > > > > > > DROP TABLE IF EXISTS A; > > > DROP TABLE IF EXISTS B; > > > DROP TABLE IF EXISTS C; > > > DROP TABLE IF EXISTS D; > > > DROP TABLE IF EXISTS E; > > > DROP TABLE IF EXISTS F; > > > DROP TABLE IF EXISTS G; > > > DROP TABLE IF EXISTS H; > > > DROP TABLE IF EXISTS I; > > > DROP TABLE IF EXISTS J; > > > DROP TABLE IF EXISTS K; > > > DROP TABLE IF EXISTS L; > > > DROP TABLE IF EXISTS M; > > > DROP TABLE IF EXISTS N; > > > DROP TABLE IF EXISTS O; > > > DROP TABLE IF EXISTS P; > > > DROP TABLE IF EXISTS Q; > > > DROP TABLE IF EXISTS R; > > > DROP TABLE IF EXISTS S; > > > DROP TABLE IF EXISTS T; > > > DROP TABLE IF EXISTS U; > > > DROP TABLE IF EXISTS V; > > > DROP TABLE IF EXISTS W; > > > DROP TABLE IF EXISTS X; > > > DROP TABLE IF EXISTS Y; > > > DROP TABLE IF EXISTS Z; > > > > > > CREATE TABLE A (ID varchar(50) NOT NULL); > > > CREATE TABLE B (ID varchar(50) NOT NULL); > > > CREATE TABLE C (ID varchar(50) NOT NULL); > > > CREATE TABLE D (ID varchar(50) NOT NULL); > > > CREATE TABLE E (ID varchar(50) NOT NULL); > > > CREATE TABLE F (ID varchar(50) NOT NULL); > > > CREATE TABLE G (ID varchar(50) NOT NULL); > > > CREATE TABLE H (ID varchar(50) NOT NULL); > > > CREATE TABLE I (ID varchar(50) NOT NULL); > > > CREATE TABLE J (ID varchar(50) NOT NULL); > > > CREATE TABLE K (ID varchar(50) NOT NULL); > > > CREATE TABLE L (ID varchar(50) NOT NULL); > > > CREATE TABLE M (ID varchar(50) NOT NULL); > > > CREATE TABLE N (ID varchar(50) NOT NULL); > > > CREATE TABLE O (ID varchar(50) NOT NULL); > > > CREATE TABLE P (ID varchar(50) NOT NULL); > > > CREATE TABLE Q (ID varchar(50) NOT NULL); > > > CREATE TABLE S (ID varchar(50) NOT NULL); > > > CREATE TABLE R (ID varchar(50) NOT NULL); > > > CREATE TABLE T (ID varchar(50) NOT NULL); > > > CREATE TABLE U (ID varchar(50) NOT NULL); > > > CREATE TABLE V (ID varchar(50) NOT NULL); > > > CREATE TABLE W (ID varchar(50) NOT NULL); > > > CREATE TABLE X (ID varchar(50) NOT NULL); > > > CREATE TABLE Y (ID varchar(50) NOT NULL); > > > CREATE TABLE Z (ID varchar(50) NOT NULL); > > > > > > I was able to create most of the tables ok but I wasn't able to > > create > > > the tables mentioned in the subject: > > > > > > mysql> CREATE TABLE K (ID varchar(50) NOT NULL); > > > Query OK, 0 rows affected (0.18 sec) > > > > > > mysql> CREATE TABLE L (ID varchar(50) NOT NULL); > > > ERROR 1017 (HY000): Can't find file: '.\ibatisnet\l.frm' (errno: > > 13) > > > > > > mysql> CREATE TABLE M (ID varchar(50) NOT NULL); > > > Query OK, 0 rows affected (0.08 sec) > > > > > > Thanks, > > > Ron > > > > > > >
