Witam,
Problem: po wybraniu komunikatora pojawia sie błąd: There appears to be an error with the database.
Logi:
===================================================
Date: Sat, 10 Oct 2009 07:50:39 +0000
Error Number: 1054
Error: Unknown column 'mm.map_last_topic_reply' in 'order clause'
IP Address: *********
Page: /forumz/index.php?app=members&module=messaging
Debug: array (
1 =>
array (
'file' => '/users/h4ze/www/forumz/ips_kernel/classDb.php',
'line' => 1010,
'function' => 'query',
'class' => 'db_driver_mysql',
),
3 =>
array (
'file' => '/users/h4ze/www/forumz/admin/applications/members/modules_public/messaging/view.php',
'line' => 762,
'function' => 'getPersonalTopicsList',
'class' => 'messengerFunctions',
),
4 =>
array (
'file' => '/users/h4ze/www/forumz/admin/applications/members/modules_public/messaging/view.php',
'line' => 143,
'function' => '_showFolder',
'class' => 'public_members_messaging_view',
),
5 =>
array (
'file' => '/users/h4ze/www/forumz/admin/sources/base/ipsController.php',
'line' => 291,
'function' => 'doExecute',
'class' => 'public_members_messaging_view',
),
)
mySQL query error: SELECT mm.*,mt.*,msg.*,mem.members_display_name FROM ipbmessage_topic_user_map mm LEFT JOIN ipbmessage_topics mt ON ( mm.map_topic_id=mt.mt_id )
LEFT JOIN ipbmessage_posts msg ON ( msg.msg_id=mt.mt_last_msg_id )
LEFT JOIN ipbmembers mem ON ( mt.mt_to_member_id=mem.member_id ) WHERE mm.map_user_id=1 AND mm.map_user_active=1 AND mm.map_folder_id='myconvo' ORDER BY mm.map_last_topic_reply DESC LIMIT 0,50
Jakieś rozwiązanie ?
IPB 3.0.4
Pozdrawiam
ROZWIAZANIE:
Dodać w kolumnie map_last_topic_reply tabele message_topic_user_map.