Re: Private message bug revisited? [message #1697 is a reply to message #1658] |
Sun, 21 April 2002 07:09 |
|
npetreley
Messages: 10 Registered: April 2002 Location: Right here.
Karma:
|
Junior Member |
|
|
Yes, the ref_msg_id field is definitely missing if it's supposed to be there. I upgraded from 1.2.4 to 1.2.7. Was this field supposed to be added by the update PHP program? If so, perhaps it was prevented from doing so by a locking issue or something like that (although I seem to recall a message during the update about it locking the database).
+-----------------+---------------------------------------------+------+--- --+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------------------------------+------+--- --+---------+----------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | | to_list | text | YES | | NULL | | | ouser_id | int(10) unsigned | | | 0 | | | duser_id | int(10) unsigned | | MUL | 0 | | | ip_addr | varchar(15) | | | 0.0.0.0 | | | host_name | varchar(255) | YES | | NULL | | | post_stamp | int(10) unsigned | | | 0 | | | read_stamp | int(10) unsigned | | | 0 | | | icon | varchar(100) | YES | | NULL | | | mailed | enum('Y','N') | | | Y | | | folder_id | enum('INBOX','SENT','DRAFT','TRASH','PROC') | | | PROC | | | subject | varchar(100) | | | | | | attach_cnt | int(10) unsigned | | | 0 | | | show_sig | enum('Y','N') | | | Y | | | smiley_disabled | enum('Y','N') | | | N | | | track | enum('Y','N','SENT') | | | N | | | offset | int(10) unsigned | | | 0 | | | length | int(10) unsigned | | | 0 | | | nrf_status | enum('N','R','F') | | | N | | +-----------------+---------------------------------------------+------+--- --+---------+----------------+ 19 rows in set (0.00 sec)
|
|
|