>Description:
For some reason the numeric fields in the middle ('sessionfid', 'ipfid') are not
putting values in there even though
it says it went through fine.
mysql> DESC phpss_log;
+------------+------------------+-----------+------+-----+---------------------+----------------+
| Field | Type | Collation | Null | Key | Default | Extra
| |
+------------+------------------+-----------+------+-----+---------------------+----------------+
| id | int(10) unsigned | binary | | PRI | NULL |
|auto_increment |
| timestamp | datetime | latin1 | | | 0000-00-00 00:00:00 |
| |
| sessionfid | int(10) unsigned | binary | YES | | NULL |
| |
| accountfid | int(10) unsigned | binary | YES | | NULL |
| |
| ipfid | int(10) unsigned | binary | | | 0 |
| |
| module | varchar(64) | latin1 | | | |
| |
| message | varchar(255) | latin1 | | | |
| |
+------------+------------------+-----------+------+-----+---------------------+----------------+
7 rows in set (0.00 sec)
mysql> INSERT INTO phpss_log ( `timestamp`, `sessionfid`, `accountfid`, `ipfid`,
`module`, `message` ) VALUES ( '2003-01-31
12:07:51', '2', '0', '1', 'phpss', 'Successful user login' );
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM phpss_log;
+----+---------------------+------------+------------+-------+--------+-----------------------+
| id | timestamp | sessionfid | accountfid | ipfid | module | message
| |
+----+---------------------+------------+------------+-------+--------+-----------------------+
| 1 | 2003-01-31 12:06:41 | 0 | 0 | 0 | phpss | Successful
|user login |
| 2 | 2003-01-31 12:07:51 | 0 | 0 | 0 | phpss | Successful
|user login |
| 3 | 2003-01-31 12:07:51 | 0 | 0 | 0 | phpss | Successful
|user login |
+----+---------------------+------------+------------+-------+--------+-----------------------+
3 rows in set (0.00 sec)
Timothy M. Crider
>How-To-Repeat:
Try to insert data
>Fix:
Don't know of any fixes
>Submitter-Id: <submitter ID>
>Originator: root
>Organization:
Timothy M. Crider
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: Unable to insert proper data in MySQL 4.1
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-4.1.0-alpha (Source distribution)
>C compiler: gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
>C++ compiler: g++ (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
>Environment:
System: Linux towely 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux
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/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking
--host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Dec 13 06:53 /lib/libc.so.6 ->
libc-2.2.93.so
-rwxr-xr-x 2 root root 1235468 Sep 5 19:12 /lib/libc-2.2.93.so
-rw-r--r-- 1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 5 18:50 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Dec 13 17:00 /usr/lib/libc-client.a ->
c-client.a
Configure command: ./configure '--prefix=/usr/local/mysql'
'--libexecdir=/usr/local/libexec' '--libdir=/usr/local/lib'
'--includedir=/usr/local/include' '--enable-local-infile'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-mysqld-username=mysql'
'--with-vio' '--without-isam' '--with-openssl=/usr/local' '--without-innodb'
---------------------------------------------------------------------
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
