RESOLVED: PM Does not work

[DrAhmed]

hello

PM System does not work when i use ajax view it give action failed error and in normal mode give database driver error

also Auto welcome member mod does not work

===================================================

Date: Fri, 23 Oct 2009 23:58:12 +0000

Error Number: 1054

Error: Unknown column 'map_last_topic_reply' in 'field list'

IP Address: 62.135.106.104

Page: /forums/index.php?&app=members&module=ajax&secure_key=eca77c668a24b08a0e4d3754cd07c9f9&section=messenger&do=PMSend&toMemberID=1

Debug: array (

1 =>

array (

'file' => '/home/egyextr1/public_html/forums/ips_kernel/classDb.php',

'line' => 1093,

'function' => 'query',

'class' => 'db_driver_mysql',

),

3 =>

array (

'file' => '/home/egyextr1/public_html/forums/admin/applications/members/sources/classes/messaging/messengerFunctions.php',

'line' => 1855,

'function' => 'insert',

'class' => 'db_main_mysql',

),

4 =>

array (

'file' => '/home/egyextr1/public_html/forums/admin/applications/members/modules_public/ajax/messenger.php',

'line' => 151,

'function' => 'sendNewPersonalTopic',

'class' => 'messengerFunctions',

),

5 =>

array (

'file' => '/home/egyextr1/public_html/forums/admin/applications/members/modules_public/ajax/messenger.php',

'line' => 71,

'function' => '_PMSend',

'class' => 'public_members_ajax_messenger',

),

6 =>

array (

'file' => '/home/egyextr1/public_html/forums/admin/sources/base/ipsController.php',

'line' => 410,

'function' => 'doExecute',

'class' => 'public_members_ajax_messenger',

),

7 =>

array (

'file' => '/home/egyextr1/public_html/forums/admin/sources/base/ipsController.php',

'line' => 89,

'function' => 'execute',

'class' => 'ipsAjaxCommand',

),

)

mySQL query error: INSERT INTO message_topic_user_map (map_user_id,map_topic_id,map_folder_id,map_user_active,map_is_starter,map_has_unread,map_read_time,map_is_system,map_last_topic_reply) VALUES(1,1,'myconvo',1,0,1,0,0,1256342292)

[DawPi]

In your profile i see that you have 3.0.1 version. Please update to 3.0.4 and then check it.

[DrAhmed]

i already updated to 3.0.4 before i post this topic

[DawPi]

Check this tool:

ACP > Support > Diagnostics:

• Database Checker
  
• Database Index Checker
  

And fix any errors if will be anything wrong with your database.

[DrAhmed]

profile_portal

* pp_member_id

* Missing index: pp_status

Click here to fix this table's indexes, or you can run the following queries manually:

* ALTER TABLE profile_portal DROP INDEX pp_status, ADD INDEX pp_status (pp_status( 128 ),pp_status_update)

When i fix it , the error return again although my copy is new and fresh and the database is new also

Also i run it manually and the issue still exsit

[DawPi]

Yeah,

one man from IPS ( i don't remember right now who is it ), but he wrote that this error isn't important and board should works fine.

If you haven't any other code this must be another reason to this situation.

Let's think...

Could you run this query and check then:

ALTER TABLE message_topic_user_map ADD map_last_topic_reply INT(10) NOT NULL default '0';

[DrAhmed]

Working fine now

Thanks

[DawPi]

The issue this topic was opened for has now been resolved.