ok, disregard this, i worked out what i did wrongly. > -----Original Message----- > From: > Sent: Sunday, March 10, 2002 2:38 AM > To: [EMAIL PROTECTED] > Subject: bad table in fields list; mysql fails to update > > > >Description: > When selecting from multiple recently added tables, mysql > returned a "table does not exist error". > table blatantly exists, i recently added it. > > nb: output from mysql (and mysqlbug) sanitized to protect IP. > >How-To-Repeat: > mysql> show tables; > +---------------+ > | Tables_in_dba | > +---------------+ > | co_info | > | doc_user_info | > +---------------+ > 15 rows in set (0.00 sec) > > mysql> select doc_user_info.id as did, co_info.id as cid, > co_info.name as cname, doc_user_info.username from doc_user_info > du,co_info co where co.id=du.id and du.id > 150 and du.id < 200 > order by du.id; > ERROR 1109: Unknown table 'doc_user_info' in field list > mysql> > > >Fix: > no idea. > > >Submitter-Id: <submitter ID> > >Originator: root > >Organization: > Wherewithal inc > >MySQL support: none - yet > >Synopsis: mysql fails to recognise tables > >Severity: critical > >Priority: high > >Category: mysql > >Class: sw-bug > >Release: mysql-4.0.1-alpha (Official MySQL binary) > > >Environment: > System: Linux <host sanitized> 2.4.8-26mdkenterprise #1 SMP Sun > Sep 23 16:36:00 CEST 2001 i686 unknown > Architecture: i686 > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake > /usr/bin/gcc /usr/bin/cc > GCC: Reading specs from > /usr/lib/gcc-lib/i586-mandrake-linux-gnu/2.96/specs > gcc version 2.96 20000731 (Mandrake Linux 8.1 2.96-0.62mdk) > Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' > CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' > LIBC: > lrwxrwxrwx 1 root root 13 Feb 21 20:07 > /lib/libc.so.6 -> libc-2.2.4.so > -rwxr-xr-x 1 root root 1285480 Sep 9 19:57 /lib/libc-2.2.4.so > -rw-r--r-- 1 root root 27487418 Sep 9 19:30 /usr/lib/libc.a > -rw-r--r-- 1 root root 178 Sep 9 19:30 /usr/lib/libc.so > Configure command: ./configure --prefix=/usr/local/mysql > '--with-comment=Official MySQL binary' > --with-extra-charsets=complex --with-server-suffix= > --enable-thread-safe-client --enable-assembler > --with-mysqld-ldflags=-all-static > --with-client-ldflags=-all-static --disable-shared > > --------------------------------------------------------------------- > 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 >
--------------------------------------------------------------------- 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
