On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> > Hi again,
> > I have the following problem:
> >
> > "mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert
>--quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum"
> > ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
> >
> > I have even tried "OPTIMIZE TABLE REP; REPAIR TABLE REP;", no luck.
> > "SHOW COLUMNS FROM REP;" does NOT show any column name `nan'.
> >
> > Even when I use "SELECT * FROM REP;" and search for " nan ", I have no
> > match.
> >
> > see pub/mysql/secret/rep.tgz
> >
> > Thanks for any reply!
> > PS.: Tested still on linux with 3.23.41 binaries from your website, as
> > seen in my previous postings.
> > --
> > Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> > MIPS / Institute for Bioinformatics <http://mips.gsf.de>
> > GSF - National Research Center for Environment and Health
> > Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
>
> Please check what column is in question.
Hmm, but how?
>
> May be you used some special chars in column names. In that case you
> should use instruct mysqldump to use backticks for table and column
> names.
mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f
--extended-insert --tab=/tmp --fields-escaped-by=@ --quick Cmuridarum rep
kulan$ grep "nan" rep.txt
148 148 0 Cmuridarum gi_8163147 346 37252.96
5.02 Membrane 1 nan 97.98 0.00 0'Sequence
MKYSLQIEDLHIEGFEQVLKISCESVQLVAVIAIHQTKVGPALGGIRAFNYSQFDDGLQD@
' - unclassified - - -
'8-amino-7-oxononanoate synthase, putative [Chlamydia muridarum]' no
kulan$
mysql> select id,mw,pI,class,mem,low from rep where id=148;
+-----+----------+------+----------+-----+-----+
| id | mw | pI | class | mem | low |
+-----+----------+------+----------+-----+-----+
| 148 | 37252.96 | 5.02 | Membrane | 1 | nan |
+-----+----------+------+----------+-----+-----+
1 row in set (0.00 sec)
mysql> select id,mw,pI,class,mem,low from rep where id=149;
+-----+----------+------+------------+-----+------+
| id | mw | pI | class | mem | low |
+-----+----------+------+------------+-----+------+
| 149 | 39804.42 | 7.02 | Alpha_Beta | 0 | 0.00 |
+-----+----------+------+------------+-----+------+
1 row in set (0.00 sec)
mysql> select id,mw,pI,class,mem,low from rep where id=150;
+-----+----------+------+------------+-----+------+
| id | mw | pI | class | mem | low |
+-----+----------+------+------------+-----+------+
| 150 | 28805.61 | 9.27 | Alpha_Beta | 0 | 0.00 |
+-----+----------+------+------------+-----+------+
1 row in set (0.00 sec)
But the column names look fine:
DROP TABLE IF EXISTS rep;
CREATE TABLE rep (
id mediumint(8) unsigned NOT NULL default '0',
prot_data_id mediumint(8) unsigned NOT NULL default '0',
contig_data_id mediumint(8) unsigned NOT NULL default '0',
contig_data_code varchar(100) NOT NULL default '',
code varchar(100) NOT NULL default '',
length int(11) NOT NULL default '0',
mw float(10,2) NOT NULL default '0.00',
pI float(10,2) NOT NULL default '0.00',
class varchar(255) NOT NULL default '',
mem int(11) NOT NULL default '0',
low float(10,2) NOT NULL default '0.00',
nonglob float(10,2) NOT NULL default '0.00',
coil float(10,2) NOT NULL default '0.00',
sigp int(11) NOT NULL default '0',
loc varchar(255) NOT NULL default '',
summary text,
geneid varchar(255) NOT NULL default '',
classification varchar(255) NOT NULL default '',
pubmed varchar(255) NOT NULL default '',
comments text,
remarks text,
descr varchar(255) NOT NULL default '',
manual enum('yes','no') default NULL,
PRIMARY KEY (id),
KEY class (class),
KEY loc (loc),
KEY geneid (geneid),
KEY classification (classification),
KEY pubmed (pubmed),
KEY descr (descr),
KEY code (code),
KEY prot_data_id (prot_data_id),
KEY contig_data_id (contig_data_id)
) TYPE=MyISAM PACK_KEYS=1;
How can I check for non-printable characters in columns names?
Anyway, it seems to me that the low column for id=148 contains a value
"nan" instead of number which what is confusing mysql.
It looks like a bug in our application, right? But how did mysql allow
client to enter text instead of value?
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics <http://mips.gsf.de>
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
---------------------------------------------------------------------
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
