Apache Friends Support Forum

hi all,
I am new to php and web development.

I have a webbased tool and while accessing one of the tables from database I get a strange behaviour some times it runs and some times it gives error.

the error is as follows:

Query: SHOW COLUMNS FROM teamAssignments Error: Can't create/write to file 'C:\Temp\#sql_8a4_0.MYI' (Errcode: 13)
URL: /ppts/ppts/CTeamsAssignmentsOverviewHandler.php

i am running xampp on windows XP pro service pack 2, and accessing it locally from same machine. I use default root account to access the database without any password.

Some how some times my querry go fine and then next time not. even if i don't change any thing in query. very strange behavior.

Any help would be great. already spent very good time on trying to figure it out.

best regards

note: sorry previously put this message worngly in linux section

Take a look at your file "/ppts/ppts/CTeamsAssignmentsOverviewHandler.php".
Find the line containing "SHOW COLUMNS FROM teamAssignments" and change the path pointing to C:\Temp into a valid path on your server (for example /ppts/ppts/), but also check how the file to be written to is named - I don't think a filename can start with "#".

I think I have found the solution.

Question - why do I get this error *sometimes* :

> SHOW COLUMNS FROM sometable
> Error: Can't create/write to file 'C:\Temp\#somefile.MYI' (Errcode: 13)

Solution - shut off the anti-virus software on the server.