#1 - Can't create/write to file 'C:\Program Files\xampp\tmp\#sql_24c_0.MYI' (Errcode: 2)
gleble - November 19, 2006 - 19:51
I get this error when trying to create a first account and when I do just about anything using phpadmin.
What does it mean? How do I get past it?
I am using drupal 4.7.4 , PHP 5.1.6 , MySQL 5.0.24a , Apache 2.23 and Xampp Windows version 1.5.4a
SOmeone else was having this
SOmeone else was having this problem using Xampp and it turned out that they just had to change the permissions on their drupal.cofig.php file to writeable.
Since you are having the same problem he was having I'd suggest you check the permissions of your config.php file.
config.php
Excuse my ignorance but where do I find config.php and how do I change permissions?
In your main drupal folder
In your main drupal folder there should be a file called drupal.config.php and you change permissions by using chmod or from file manager, depending on what tools you're using. The permissions of the file should be 777 while installing and setting up the admin login. Once you successfully log in you should change the permissions back to what they were originally.
I'm not familiar with Xampp, so I'm not sure exactly what methods you are using to do things.
drupal.config.php
This file doesn't seem to exist???????????????
Hrmmm...let me check out
Hrmmm...let me check out that download and see if I can find a config file. I'll update this post when I find out.
Hrmmm...you're right...there
Hrmmm...you're right...there is no config.php file. Let me do some digging and see if I can find a fix for your problem. I assumed that there would be a config.php file since I've never seen a CMS without one. o_O
I'll be back to let you know if I find something that might help.
Here is something that may
Here is something that may help. I'll add as many links as I can find for you.
http://drupal.org/node/75545
http://buildownwebsite.blogspot.com/2005/11/how-to-install-drupal-cms-in...
http://www.freeme.in/node/14
Xammp
Thanks I'll digest that lot and get back tomorrow
lost
Tried all the above and it got worse
user warning: Can't create/write to file 'C:\Program Files\xampp\tmp\#sql_670_0.MYI' (Errcode: 2) query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.picture, u.data, c.score, c.users, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 1 GROUP BY c.cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, u.picture, c.homepage, u.uid, u.name, u.picture, u.data, c.score, c.users, c.thread, c.status ORDER BY c.thread DESC LIMIT 0, 50 in C:\Program Files\xampp\xampp\htdocs\example\drupal-4.7.4.tar\drupal-4.7.4\includes\database.mysql.inc on line 121.
I think it might be my settings.php thats the problem
$db_url = 'mysql://root:***********@localhost/drupal';
$db_prefix = '';
/**
* Base URL (optional).
*
* If you are experiencing issues with different site domains,
* uncomment the Base URL statement below (remove the leading hash sign)
* and fill in the URL to your Drupal installation.
*
* You might also want to force users to use a given domain.
* See the .htaccess file for more information.
*
* Examples:
* $base_url = 'http://www.example.com';
* $base_url = 'http://www.example.com:8888';
* $base_url = 'http://www.example.com/drupal';
* $base_url = 'https://www.example.com:8888/drupal';
*
* It is not allowed to have a trailing slash; Drupal will add it
* for you.
*/
#$base_url = 'http://localhost/example/drupal-4.7.4.tar'; // NO trailing slash!
Any ideas
I honestly am not sure...but
I honestly am not sure...but have seen a number of "fixes" posted for various problems with installing Drupal 4.7
I'll look around on the forum and see if I can find something that will help you. I always use web hosting for Drupal, so I haven't run into these types of problems myself. I wish more people who knew what they were doing would post to help people. I try to help, but can't offer much to people who are using things I'm not familiar with. Off to search...
Oh...are you sure that Xampp is working properly and it's not a problem with that?
Think so
It's very good of you helping this much. Ill try installing from scratch on another machine tomorrow. Fingers crossed
Well...trying to help, lol.
Well...trying to help, lol. I have to go buy stuff for our holiday meal in a little bit anyway...so I really didn't have much time to search anyhow. Sometimes a fresh installation attempt makes all the difference. Hopefully it will work for you...(crossing fingers over here, too.)