FUDforum: FUDforum Installation Issues

Home » FUDforum » FUDforum Installation Issues » create table pmsg

Show: Today's Messages :: Polls :: Message Navigator

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:

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

[Message index]

		create table pmsg By: lloydm on Wed, 26 April 2006 03:29
		Re: create table pmsg By: lloydm on Wed, 26 April 2006 21:39
		Re: create table pmsg By: Ilia on Tue, 02 May 2006 02:07
		Re: create table pmsg By: lloydm on Wed, 03 May 2006 16:18
		Re: create table pmsg By: lloydm on Wed, 03 May 2006 16:19
		Re: create table pmsg By: lloydm on Wed, 03 May 2006 16:20

Previous Topic:	Can't upload files more then 2MB
Next Topic:	System ERROR whereas upload

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 22:27:03 GMT 2024

Total time taken to generate the page: 0.04610 seconds