SMF Support > Server Performance and Configuration

MySQL error or something!

(1/4) > >>

TheMajor:
Hi folks,

Sometimes when clicking "Who's online" I get the following error. I also get it when clicking "Permissions" for one of my forum categories. It says something about xampp but I do not have xampp....Please help me.

This is th one I get when trying to change permissions:

Can't create/write to file '\xampp\tmp\#sql_7dc_0.MYI' (Errcode: 2)
File: d:\mijn documenten\websites\themajor-server\forums\smf\Sources\ManagePermissions.php
Line: 151

My server specs:
Apache 1.3.31 W32
PHP 4.3.9
MySQL 4.0.21

Running on FAT32/XP Pro

Oldiesmann:
Make sure the \tmp directory is chmodded to 666 or 777 (preferably 777).

TheMajor:
2 stupid questions:

-where can I find the \tmp folder? is it in the htdocs, mysql or php folders? is it located in \xampp? I cannot find them.
-How do I chmod without FTP?

thanks

Oldiesmann:
Looks like \tmp is in \xampp.

Second question - talk to your host about this since you can't find \xampp and you can't really CHMod stuff on a Windows server anyway...

TheMajor:
I am running the server on my own computer so I can change anything you want.

I searched the apache root folder, the php folder and the mysql folder and the htdocs folder and neither xampp or tmp exist.

I noticed that xampp is entered n my.ini
Should I change anything here?:

# The MySQL client
[client]
# password       = *********************
port            = 3306
socket          = mysql

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = mysql
skip-locking
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=64
set-variable    = sort_buffer=512K
set-variable    = net_buffer_length=8K
set-variable    = myisam_sort_buffer_size=8M
log-bin
server-id       = 1

basedir=D:/Programma's/Apache/mysql
tmpdir=/xampp/tmp
datadir=D:/Programma's/Apache/mysql/data

#bind-address=192.168.1.1
#log-update     = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#set-variable   = bdb_cache_size=4M
#set-variable   = bdb_max_lock=10000

skip-innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /xampp/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /xampp/mysql/
#innodb_log_arch_dir = /xampp/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable    = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

[WinMySQLadmin]
Server=D:/Programma's/Apache/mysql/bin/mysqld-nt.exe

Navigation

[0] Message Index

[#] Next page