help with error code 13 mysql using xampp 1.6.7

Problems with the Windows version of XAMPP, questions, comments, and anything related.

help with error code 13 mysql using xampp 1.6.7

Postby nadismad » 04. August 2008 16:04

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
nadismad
 
Posts: 1
Joined: 04. August 2008 15:40

Postby guw » 05. August 2008 09:18

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 "#".
guw
 
Posts: 15
Joined: 22. July 2008 10:49

Solution

Postby hellolindsay » 04. September 2008 15:09

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.
hellolindsay
 
Posts: 1
Joined: 04. September 2008 15:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 39 guests