Re: SQL Error - create temporary table

Hi again. I thought it would be more satisfactory if I found out for myself what MySQL version my ISP is running so I tacked a query on to one of my forms to find out. They are running 3.22.22. That sounds pretty old?? Could that be the problem? It /is/ going to be a problem if it is. I am creating temp tables as a workaround for a subQuery. There are three of them sequentially selecting a smaller and smaller data set. In article <VA.0000004f.00277007@timballo.co.uk>, John Morrison wrote: > Thanks for your reply Tom. I will contact my ISP, although I guess I must > have create table rights because I created the permanent db tables OK. > > I have been browsing through the HTML MySQL manual and found, under "F MySQL > change history/F.2.3 Changes in release 3.23.28", the following entry :- > > "Fixed a fatal bug in CREATE TEMPORARY TABLE ... SELECT .... " > > I always suspect my own code first when something doesn't work but I am > wondering now if that bug may be the culprit? I will phone my ISP now. > > Cheers > John > > In article <3AEFC99D.6E8E876A@st.com>, Tom Mathews wrote: > > Subject: Re: [PHP-WIN] SQL Error - create temporary table > > > > Check with your ISP what access rights you have to the MySQL db - if you > > don't have create table rights, then you won't be able to crete temporary > > tables either. > > > > Tom > > > > John Morrison wrote: > > > > > Hi > > > > > > I have cobbled together my first PHP/MySQL site which > > > checks out OK on "localhost" (a WinMe/Xitami PC). But I > > > just uploaded it to my ISP and I'm getting SQL Error > > > reports when trying to create temp tables. > > > > > > SQL Error near "create temporary table tmptable select > > > p.pic_id, title from picture as p, keycode_link as k where > > > p.pic_id = k.pic_id and k.label_code = 1 and k.keyword_code > > > = 5"; > > > > > > These temp table commands work OK on my setup (MySQL > > > 3.23.30) and I haven't yet figured out what is going wrong. > > > > > > John Morrison > > > > > > --