Re: Error caused by ORDER BY clause - Peter WR - com.mysql.lists.win32

6 messages in com.mysql.lists.win32Re: Error caused by ORDER BY clause

From	Sent On	Attachments
Leon Atkinson	19 Aug 1999 11:20
Daniel C. Heidebrecht	19 Aug 1999 13:06
Peter WR	19 Aug 1999 14:36
Leon Atkinson	19 Aug 1999 15:22
Peter WR	19 Aug 1999 17:58
Michael Widenius	22 Aug 1999 23:06

Subject:	Re: Error caused by ORDER BY clause
From:	Peter WR (pw...@post4.tele.dk)
Date:	08/19/1999 02:36:15 PM
List:	com.mysql.lists.win32

I have had the same error when using TEXT- type of fields.

I got a fix from Monty - create a ..

[mysqld] tmpdir=c:/temp/

and now it is working.

I have included my whole email and reply below ....

*** START

"Peter" == Peter WR <pw...@post4.tele.dk> writes:

Peter> Hi, Peter> I get below errormeassage when SELECTING a LONGTEXT field in ASP. When Peter> changing the field back to VARCHAR everything goes fine.

Peter> Error message ... Peter> Microsoft OLE DB Provider for ODBC Drivers error '80004005' Peter> [TCX][MyODBC]Can't create/write to file '\\sql7_0.ism' (Errcode: 2)

Peter> /dgh002m.asp, line 296

The above means that MySQL can't create a file at your root disk

How did you start MySQL?

Try restarting MySQL, but set the --tmpdir option to point at some writable directory. Another option is to add to your c:\\my.cnf file:

[mysqld] tmpdir=c:/temp/

(assuming you have a c:\temp directory)

Regards, Monty *** END

This is with version 3.22.24-debug on Windows NT 4.0. It does it in version 3.22.22, too.

mysql> select * -> from invoice_status x, invoice i -> where x.invoice = i.ID; {snip} 8 rows in set (0.01 sec)

mysql> select * -> from invoice_status x, invoice i -> where x.invoice = i.ID -> order by i.ID; ERROR 1: Can't create/write to file '\\sql127_0.ism' (Errcode: 2)

C:\mysql>perror 1

C:\mysql>

I don't get this behavior with an identical (using mysqldump) database on Solaris and MySQL 3.22.21.

Anyone have any ideas?

TIA, Leon