Apache Friends Support Forum

anybody can help me, how toe fix this problem

When i make a table thorugh phpmyadmin...... i found this error messages ...

Error
SQL query:
SHOW FULL FIELDS FROM `latihan` ;
MySQL said:
#mp\#sql_71c_0.MYI' (Errcode: 22)


Please help me, iam new xampp user and newbe in PHP programing
-----------------------------------------------
I use this Xampp version
XAMPP for Windows Version 1.5.3 Beta 3
phpMyAdmin - 2.8.0.3
MySQL - 5.0.21-community-nt

I try to install in different computer... but, the problem same like the first computer.

Oh ya.... when i use PHPtriap, i cannot found that problem.

hi lihatxx,
i had the same problem on my machine.
it seems to be a problem with the internal handling of the path in my.cnf (can be found under [XAMPP_HOME_DIR]\mysql\bin) or similar when using another mysql-configurationfile. the interpreter of the path seems to interprete the \t from \tmp as an tabulator-escapecharacter.

1. open the file my.cnf using any text-editor (open it from inside the editor because for example under XP the *.cnf-files are associated with some messenger-things.

2. go to the [mysqld]-section and edit the line:
tmpdir="C:\Programme\xampp\tmp" (or similar)

3. insert an \ before the \tmp so you will get the result:

tmpdir="C:\Programme\xampp\\tmp"

as an alternative you can create a new directory under your xampp-home like _tmp or so. then you have to change the tempdir-path to the related new directory. but the best way is the first one.

oh, and don't forget to restart your mysql after done this ...

greetings from neu-ulm

chris


p.s: i just saw your installation-path in the title of the thread,
the file my.cnf must be found in

C:\Program Files\xampp\mysql\bin\

the tmp-directory is under

C:\Program Files\xampp\tmp

Thank you for your sollutions, i hove this work in my xampp.

lihatxx wrote::D Thank you for your sollutions, i hove this work in my xampp.

please tell me if it works - thx

chris

I t work...... thank`s verry much