thought about it, but i can't control any of this from the lycos web interface to mysql. If you know how to do it, please add more details on how to add this temporary space to a user on mysql.
* - * - * Tzahi Fadida [EMAIL PROTECTED] Technion Email: [EMAIL PROTECTED] Fax (+1 Outside the US) 240-597-3213 My Cool Site: HTTP://WWW.My2Nis.Com * - * - * - * - * - * - * - * - * - * WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Herouth Maoz > Sent: Saturday, May 25, 2002 3:09 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: mysql error > > > At 19:40 +0200 on 24/5/2002, Tzahi Fadida wrote: > > > > p.s: i searched the net and they say error 28 is "not enough > >space", but i don't think it is connected to space since most of my > >phpnuke queries works fine, and the error only happens with order by. > > That's where you're wrong, buddy. It may well be a space problem. You > see, without the order by, all it has to do is a join on three table, > meaning that it doesn't need any temporary space for the result. It > just scans the three tables, matches records to your conditions, and > when they match, out they go to the caller. > > Whereas, when you have an order-by clause, you need some temporary > storage, where you store all the results from the query, and then > sort them. > > Space problem it is - trust the error message, this is not a > Microsoft product... > > Herouth > -- > EMAIL: [EMAIL PROTECTED] > HOME PAGE: http://herouth.port5.com/ > > ================================================================= > To unsubscribe, send mail to [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] > > > > > ================================================================To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
