List:MySQL on Win32« Previous MessageNext Message »
From:Peter WR Date:August 20 1999 12:58am
Subject:Re: Error caused by ORDER BY clause
View as plain text  
I would appreciate all parameter mentioned in proper order in the
"cnf-file", but disabled. This is a very good clue for solving problems on
You own.

Best regards
Peter



----- Original Message -----
From: Leon Atkinson <leon@stripped>
To: Peter WR <pwr@stripped>; <win32@stripped>
Sent: 20. august 1999 00:22
Subject: RE: Error caused by ORDER BY clause


>Yeah! That did it!  Thanks!
>
>Maybe that line should make it's way into my-example.cnf.  AFAIK, c:\temp
is
>the default temp directory for NT.
>
>Thanks again, everybody.
>
>Leon
>
>
>> -----Original Message-----
>> From: Peter WR [mailto:pwr@stripped]
>> Sent: Thursday, August 19, 1999 2:37 PM
>> To: leon@stripped; win32@stripped
>> Subject: Re: Error caused by ORDER BY clause
>>
>>
>> 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 <pwr@stripped> 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
>>
>>
>>
>>
>> ----- Original Message -----
>> From: Leon Atkinson <leon@stripped>
>> To: <win32@stripped>
>> Sent: 19. august 1999 20:20
>> Subject: Error caused by ORDER BY clause
>>
>>
>> >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
>> >
>> >
>> >---------------------------------------------------------------------
>> >Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
before
>> >posting. To request this thread, e-mail win32-thread371@stripped
>> >
>> >To unsubscribe, send a message to the address shown in the
>> >List-Unsubscribe header of this message. If you cannot see it,
>> >e-mail win32-unsubscribe@stripped instead.
>> >
>>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail win32-thread374@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail win32-unsubscribe@stripped instead.
>


Thread
Error caused by ORDER BY clauseLeon Atkinson19 Aug
  • Re: Error caused by ORDER BY clauseDaniel C. Heidebrecht19 Aug
Re: Error caused by ORDER BY clausePeter WR19 Aug
  • RE: Error caused by ORDER BY clauseLeon Atkinson20 Aug
Re: Error caused by ORDER BY clausePeter WR20 Aug
  • Re: Error caused by ORDER BY clauseMichael Widenius23 Aug