I tried running 'create table pmsg' but I get a column missing error.
any ideas.]]>lloydm2006-04-26T03:29:22-00:00Re: create table pmsg
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=31471&th=6464#msg_31471
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);
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /magma/users/u43/bytown1/FUDforum/include/compiler.inc on line 709
Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /magma/users/u43/bytown1/FUDforum/include/compiler.inc on line 709
Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /magma/users/u43/bytown1/FUDforum/include/compiler.inc on line 709
]]>lloydm2006-05-03T16:18:34-00:00Re: create table pmsg
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=31527&th=6464#msg_31527
Checking smilies against disk files
OK
Checking disk files against smilies
Warning: Invalid argument supplied for foreach() in /magma/users/u43/bytown1/public_html/forum/adm/consist.php on line 439
OK
Rebuild Smiley Cache