Error Help!

[Xman]

Date: Wed, 14 Oct 2009 04:35:21 +0000
Error Number: 1054
Error: Unknown column 'mm.map_last_topic_reply' in 'order clause'
IP Address:
Page: /index.php?app=members&module=messaging
Debug: array (
1 =>
array (
'file' => '/home/wsunorg/public_html/ips_kernel/classDb.php',
'line' => 1010,
'function' => 'query',
'class' => 'db_driver_mysql',
),
3 =>
array (
'file' => '/home/wsunorg/public_html/admin/applications/members/modules_public/messaging/view.php',
'line' => 760,
'function' => 'getPersonalTopicsList',
'class' => 'messengerFunctions',
),
4 =>
array (
'file' => '/home/wsunorg/public_html/admin/applications/members/modules_public/messaging/view.php',
'line' => 141,
'function' => '_showFolder',
'class' => 'public_members_messaging_view',
),
5 =>
array (
'file' => '/home/wsunorg/public_html/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 ibf_message_topic_user_map mm LEFT JOIN ibf_message_topics mt ON ( mm.map_topic_id=mt.mt_id )
LEFT JOIN ibf_message_posts msg ON ( msg.msg_id=mt.mt_last_msg_id )
LEFT JOIN ibf_members 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



IPB 3.0.4 any ideas on how to fix? PM's don't work with it like this.

Xman Reviewed by Xman on 14th Oct 2009. Error Help! Date: Wed, 14 Oct 2009 04:35:21 +0000 Error Number: 1054 Error: Unknown column 'mm.map_last_topic_reply' in 'order clause' IP Address: Page: /index.php?app=members&module=messaging Debug: array ( 1 => array ( 'file' => '/home/wsunorg/public_html/ips_kernel/classDb.php', 'line' => 1010, Rating: 5

[Xman]

hmmm i dunno what this table is for but it was missing and i looked and I dont have that table in IPB 3.0.3

but it is calling it in 3.0.4

[Sandino]

looks like something got corrupt.
See if you can reinstall IPB. or "Downgrade" if possible, then upgrade again

[Xman]

it was a fresh install and i added that column and all works fine. strange i seen a post about it on invision and they knew nothing about it. That column isnt in 3.0.3 tho.

[Hyperz]

Reinstall? Nice advice .

Go into phpmyadmin, go to your database, select all tables and run a check on them or just do a repair and optimize on them. This problem smells like a partly corrupted DB indeed.

[boris]

i'm having the same problem guy's any ideas? i really dont want to have to re-install cause as soon as i import the database i'm going to have same prob won't i?

[Xman]

under ibf_message_topic_user_map

add this column in phpmyadmin mm.map_last_topic_reply

all will work fine after that

make sure to rebuild templates and cache after you add the column