| create table pmsg [message #31455] |
Wed, 26 April 2006 03:29  |
lloydm
Messages: 20
Registered: April 2006
Karma: 0
|
Junior Member |
|
|
Installed the latest version of fudforum and it appears private messages are not working because of table "pmsg" missing in database.
(/magma/users/u43/bytown1/public_html/forum/index.php:76
/magma/users/u43/bytown1/public_html/forum/index.php:136
/magma/users/u43/bytown1/public_html/forum/theme/default/pmsg.php:285
/magma/users/u43/bytown1/public_html/forum/theme/default/pmsg.php:869
/magma/users/u43/bytown1/public_html/forum/index.php:1191
) 1146: Table 'bytown1.pmsg' doesn't exist
Query: SELECT length FROM pmsg WHERE id=1 AND foff=-1
_GET: array ( 't' => 'pmsg', )
_POST: array ( 'S' => '8055ab1b099fb02450f8221669787852', 'SQ' => 'b3d47a43a0576831def59ff4707b2a8e', 'folder_id' => '5', 'sel' => array ( 0 => '7', 1 => '5', 2 => '1', ), 'moveto' => '1', 'old_folder_id' => '5', 'btn_trash' => 'Empty Trash', ) Server Version: 4.0.25 [Referring Page]
I tried running 'create table pmsg' but I get a column missing error.
any ideas.
|
|
|
|
| Re: create table pmsg [message #31471 is a reply to message #31455] |
Wed, 26 April 2006 21:39  |
lloydm
Messages: 20
Registered: April 2006
Karma: 0
|
Junior Member |
|
|
Ok, this is a weird one. I create table with scripts listed below and now I don't get any error message and all PMSG function work except for one.
Whenever anyone send a message it's always the same message "Your avatar has being ap"
Any ideas,
******************modified create table script*************
CREATE TABLE pmsg
(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
to_list TEXT,
ouser_id INT NOT NULL DEFAULT 0,
duser_id INT NOT NULL DEFAULT 0,
pdest INT NOT NULL DEFAULT 0,
ip_addr VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
host_name VARCHAR(255),
post_stamp BIGINT NOT NULL DEFAULT 0,
read_stamp BIGINT NOT NULL DEFAULT 0,
icon VARCHAR(100),
subject VARCHAR(100) NOT NULL DEFAULT '',
attach_cnt INT NOT NULL DEFAULT 0,
foff BIGINT NOT NULL DEFAULT 0,
length INT NOT NULL DEFAULT 0,
ref_msg_id VARCHAR(11),
fldr INT NOT NULL DEFAULT 0,
pmsg_opt INT NOT NULL DEFAULT 49
);
CREATE INDEX pmsg_i_dfr ON pmsg (duser_id, fldr, read_stamp); # general message retrival
CREATE INDEX pmsg_i_dfi ON pmsg (duser_id, fldr, id); # used for the previous/next links on drawpmsg
DROP TABLE IF EXISTS fl_pm;
CREATE TABLE fl_pm (id INT);
[Updated on: Wed, 26 April 2006 21:40] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]