Menu

Cant create/write error in mysql

Help
2004-09-12
2013-04-15
  • Nobody/Anonymous

    Is there anyone who know what this error means:
    "Database Error

    Server Address: localhost
    Server Username: root
    Error Diagnostic:
    Bad query.

    Server Error: (1) Can't create/write to file 'C:\WebServ emp\#sql1e8_d9_0.frm' (Errcode: 22)

    Last SQL Query:"

            CREATE TEMPORARY TABLE

     
    • Nobody/Anonymous

      this sound like the mmcache bug, put
      auto_globals_jit=Off in the php.ini file whitch is in the webserv\apache2\bin directory

       
    • Nobody/Anonymous

      Hmm,cant find any line in php.ini with auto_globals_jit....im using the lates version of webserv,maybe its not included there?

       
    • Nobody/Anonymous

      Btw,there is something wrong in my phpmyadmin to,at the botom of the page it says(translated from swe) something like this: Wrong: The extra function to handle linked tables have being deactivated. Show reason <- And when i click on that,a new page come up: PMA Databace...not ok[documentation] Any know whats wrong? Sorry for my bad eng & maybe stupid questions,but i've started to learn mysql,php,apashe etc. about just 1-2 weeks ago,but i learn fast,only i get a little help on the way ;)

       
    • Nobody/Anonymous

      please someone help me,or do i have to re-install everything? =/

       
    • Nobody/Anonymous

      put
      auto_globals_jit=Off
      somewhere in the php.ini file
      its not there, you have to add it

       
    • Nobody/Anonymous

      Dont help...how can i search this error & whats causing it at mysql homepage? Cause i dont understand a sh*t how to search for errors & stuff there,have tryed :)

       
    • Mike Dessaint

      Mike Dessaint - 2004-09-21

      looks like your code is seeing the temp folder as emp
      someone else mentioned that frontpage causes this error, are you using frontpage?

       
    • Nobody/Anonymous

      Nop,i just use webserv latest version & phpnuke,this is freeking,i have re-installed windows,same with webserv & anything,just keeping get this error with things,modules etc. who seems to have to create,write temp-files,im a beginner on all this,have i configured something wrong maybe,in php.ini,phpmyadmin or something? Im going insane soon if i cant get this to work proper =/

       
    • Nobody/Anonymous

      This should be fixed by editing my.ini and changing the "tmpdir" variable to "C:\webserv/temp". You must stop and restart mysql to have the change take effect.

      Daniel

       
    • Nobody/Anonymous

      This is fixed by editing my.ini and changing the "tmpdir" variable to "C:\webserv/temp". You must stop and restart mysql to have the change take effect.

       
    • Mike Dessaint

      Mike Dessaint - 2004-09-23

      post your results if this works, it would solve a problems a few people are having with the name of the temp folder

      thanks

       
    • Nobody/Anonymous

      Thx you very much ,I had also the problem with "|emp" as tempfolder.
      editing my.ini with C:\webserv/temp" instead of "C:\webserv\temp" has solved the problem.

       
    • Mike Dessaint

      Mike Dessaint - 2004-09-27

      thanks, this fix has ben added to the 1.2.7.0 release

       
    • Nobody/Anonymous

      I thx you for doing the this job. We need only to install and everything is configured. You make our life easier.
      thx
      BILOAGA

       
    • Mike Dessaint

      Mike Dessaint - 2004-10-04

      Its My Pleasure :)

       

Log in to post a comment.