Hi All,
I have an OpenBSD box running mysql-3.23.47, php4.1.1 & Apache 1.3.22.
I have been using php-nuke on it for some time now without incident
until today...
I have tried to create a new database in order to add another nuke based
site to this server and I can't seem to import the sql file. This file
is the same one I used to create the original (nuke 5.3.1) database. I
have tried importing it in the shell and through phpMyAdmin-2.2.3
I always get an error stating that mysql cannot modify a .frm file. I
downloaded a new copy of the sql file in case it was corrupt but I get
the same error in a different .frm file. I then dumped a backup of the
functioning db through phpMyAdmin and tried to import this sql file into
a new db with the same results.
An example of a table create that frequently fails and the error message
is as follows:
CREATE TABLE nuke_authors (
aid varchar(30) NOT NULL default '',
name varchar(50) default NULL,
url varchar(60) default NULL,
email varchar(60) default NULL,
pwd varchar(13) default NULL,
counter int(11) NOT NULL default '0',
radminarticle tinyint(2) NOT NULL default '0',
radmintopic tinyint(2) NOT NULL default '0',
radminuser tinyint(2) NOT NULL default '0',
radminsurvey tinyint(2) NOT NULL default '0',
radminsection tinyint(2) NOT NULL default '0',
radminlink tinyint(2) NOT NULL default '0',
radminephem tinyint(2) NOT NULL default '0',
radminfilem tinyint(2) NOT NULL default '0',
radminfaq tinyint(2) NOT NULL default '0',
radmindownload tinyint(2) NOT NULL default '0',
radminreviews tinyint(2) NOT NULL default '0',
radminnewsletter tinyint(2) NOT NULL default '0',
radminsuper tinyint(2) NOT NULL default '1',
admlanguage varchar(30) NOT NULL default '',
PRIMARY KEY (aid)
) TYPE=MyISAM;
INSERT INTO nuke_authors VALUES
('God','God','http://phpnuke.org','http://phpnuke.org','Password',0,0,0,
0,0,0,0,0,0,0,0,0,0,1,'');
MySQL said:
Can't create/write to file './test/nuke_authors.frm'
I have even tried to manually copy the files in the db
ie: cp -R /usr/local/mysql/var/db1/ /usr/local/var/db2/
When done this way, mysql crashes when I query the db:
SQL-query :
SHOW TABLE STATUS FROM `sample`
MySQL said:
Can't read dir of './sample/' (Errcode: 9)
The console is reporting the following error:
020122 10:50:35 Error in accept: Bad file descriptor
mysql then crashes and I need to restart it.
I am running mysql with the following command:
/usr/local/mysql/libexec/mysqld --no-defaults --user=mysqld &
the mysqld user owns all the files including the var dir.
Anyone experience this type of malfunction before?
Todd Ratson
System Administrator
Canadian Mental Health Association for the East Kootenay
[EMAIL PROTECTED]
icq# 132791172
(250) 426-5222
Give a person a fish and it will feed them for a day. Teach a person to
fish and it will feed them for a lifetime.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
