Unanswered: SELECT DISTINCT ERROR - Table '#sql_fc_0' is read only
SELECT DISTINCT ERROR keep getting an error that says
Table '#sql_fc_0' is read only
when I try to use the SELECT keyword I have tried reinstalling mysql using different versions etc etc buit same result so I am thinking it has something to do with permissions I don't know much about permissions or how to set them is there some special user that mysql uses or something I am on windows server 2003 running mysl 4.0.23 and php 4.3.10 tried using mysql 4.1.9 also same thing worked fine before so I don't know whats wrong something changed but I don't know what does anyone have an idea of what may be causing this?
I can select update insert and delete just fine but when I try to use the distinct keyword it gives me an error it think it has something to do with temp tables or something maybe I have been trying to fix for 3 days please help