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

Home » FUDforum » FUDforum Installation Issues » create table pmsg
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
create table pmsg [message #31455] Tue, 25 April 2006 23:29 Go to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 17:39 Go to previous messageGo to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 17:40]

Report message to a moderator

Re: create table pmsg [message #31512 is a reply to message #31471] Mon, 01 May 2006 22:07 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
add to buddy list
ignore all messages by this user
Try running the upgrade script.

FUDforum Core Developer
Re: create table pmsg [message #31526 is a reply to message #31512] Wed, 03 May 2006 12:18 Go to previous messageGo to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ran the upgrade script and it failed with message.

Upgrade.
Beginning SQL Upgrades
SQL Upgrades Complete
Adding GLOBAL Variables
Compiling theme default

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
Re: create table pmsg [message #31527 is a reply to message #31526] Wed, 03 May 2006 12:19 Go to previous messageGo to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Consistency check failed with Error message.

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



Re: create table pmsg [message #31528 is a reply to message #31527] Wed, 03 May 2006 12:20 Go to previous message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Finally message still does not work. All message still the same message.

Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Can't upload files more then 2MB
Next Topic: System ERROR whereas upload
Goto Forum:
  

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

Current Time: Thu Sep 20 22:23:49 EDT 2018

Total time taken to generate the page: 0.00664 seconds