FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Private message bug revisited?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Private message bug revisited? [message #1656] Sat, 20 April 2002 20:08 Go to next message
npetreley is currently offline  npetreley   United States
Messages: 10
Registered: April 2002
Location: Right here.
Karma: 0
Junior Member
I saw the thread below on this, but this started happening to me after I upgraded to 1.2.7. I downloaded the ppost.php that was included in one of the responses in the thread below and tried that, but it didn't fix the problem. Any idea what's going on here?

Here's what I get when I attempt to send a private message:

Query Failed: INSERT INTO fud_pmsg ( ouser_id, duser_id, to_list, ip_addr, host_name, post_stamp, icon, mailed, folder_id, subject, attach_cnt, smiley_disabled, show_sig, track, read_stamp, ref_msg_id ) VALUES( 2, 2, 'jhood', '64.170.109.179', NULL, 1019333244, NULL, 'Y', 'DRAFT', 'Re: Meeting you in person', 0, 'N', 'N', 'N', 1019333244, 'R12' )
Reason: Unknown column 'ref_msg_id' in 'field list'
From: /var/www/petreley/forum/ppost.php
Server Version: 3.23.49-log
Re: Private message bug revisited? [message #1658 is a reply to message #1656] Sat, 20 April 2002 20:21 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
If you downloaded ppost AFTER upgrading you probably reversed the fix in the 1.2.7 release.

Which version of the forum you were ugrading from?

The problem appears to be the fact your fud_pmsg is missing a field....

Can you show me the output of the following MySQL query:

SHOW FIELDS FROM fud_pmsg;


FUDforum Core Developer

[Updated on: Sat, 20 April 2002 20:23]

Report message to a moderator

Re: Private message bug revisited? [message #1697 is a reply to message #1658] Sun, 21 April 2002 07:09 Go to previous messageGo to next message
npetreley is currently offline  npetreley   United States
Messages: 10
Registered: April 2002
Location: Right here.
Karma: 0
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)
Re: Private message bug revisited? [message #1698 is a reply to message #1697] Sun, 21 April 2002 07:17 Go to previous messageGo to next message
npetreley is currently offline  npetreley   United States
Messages: 10
Registered: April 2002
Location: Right here.
Karma: 0
Junior Member
I just looked at the update php script, and I saw the alter table command for that field (under 1.2.5).

I applied the change to the table manually, and private messaging works now.

Is there any other data definition stuff in there that is likely to have failed (or was passed over for some reason) that could cause problems later on?

[Updated on: Sun, 21 April 2002 07:20]

Report message to a moderator

Re: Private message bug revisited? [message #1701 is a reply to message #1698] Sun, 21 April 2002 15:55 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Nope, that was the only query that was ran past 1.2.5....

I am not sure why it wasn't run when you did the update...

I'll assume its a bug and see if I can replicate it.


FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: E-mail Reject Problem
Next Topic: Moderator Options Limited to "Move?"
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 03 14:10:48 GMT 2024

Total time taken to generate the page: 0.02507 seconds