new message not working

hey, my new message,poke,kiss,and guestbook not working, shows you have new message waiting, but when you click on it you get error  database guery error and when i check it this is what i get,

 

Database error in my-chatspace.com
Query:
SELECT `Profiles`.`ID` AS pID, `Profiles`.`NickName`, `Profiles`.`Status`,
`Messages`.`ID` AS mID, `New`, DATE_FORMAT( `Date`, '%m-%d-%y %H:%i') as 'Date',
`Subject`, LEFT( `Text`, 25 ) AS Preview FROM `Messages` LEFT JOIN `Profiles` ON
`Messages`.`Recipient` = `Profiles`.`ID` WHERE `Sender` = '1' AND `Recipient` = '27'
ORDER BY `Date` DESC

Mysql error:
Column 'New' in field list is ambiguous

Found error in file /home/wsb44/public_html/messages_inbox.php
at line 161. Called db_res function 
with erroneous argument #0

Debug backtrace:
Array
(
    [1] => Array
        (
            [file] => /home/wsb44/public_html/messages_inbox.php
            [line] => 161
            [function] => db_res
            [args] => Array
                (
                    [0] => SELECT `Profiles`.`ID` AS pID, `Profiles`.`NickName`,
`Profiles`.`Status`, `Messages`.`ID` AS mID, `New`, DATE_FORMAT(
`Date`, '%m-%d-%y %H:%i') as 'Date', `Subject`, LEFT( `Text`, 25
) AS Preview FROM `Messages` LEFT JOIN `Profiles` ON
`Messages`.`Recipient` = `Profiles`.`ID` WHERE `Sender` = '1'
AND `Recipient` = '27' ORDER BY `Date` DESC
                )

        )

    [2] => Array
        (
            [file] => /home/wsb44/public_html/messages_inbox.php
            [line] => 142
            [function] => PageCorespondence
            [args] => Array
                (
                    [0] => 1
                    [1] => 27
                )

        )

    [3] => Array
        (
            [file] => /home/wsb44/public_html/messages_inbox.php
            [line] => 56
            [function] => PageCompPageMainCode
            [args] => Array
                (
                )

        )

)


Called script: /messages_inbox.php

Request parameters:
Array
(
    [message] => 30
    [ZP_CAL] =>
\'fdow\':null,\'history\':\"2009/03/15/00/00,2009/01/15/20/50,2009/07/02/13/34,2009/01/01/13/34,2009/05/28/19/36,2008/12/31/19/36,2009/08/28/19/03,2009/12/30/23/05\",\'sortOrder\':\"asc\",\'hsize\':9
    [profile_polls_question_1] => 1
    [profile_polls_question_3] => 1
    [profile_polls_question_4] => 1
    [logintheme] => 
    [cprelogin] => no
    [cpsession] => closed
    [webmailsession] =>
admin@my-chatspace.comyHtx1Rp6E1tM8QPbIKsm3cQXky8xD2E9ceLG_B4UKEXoXioNZ3cqWHLNhPLiRWGh
    [langedit] => 
    [lang] => 
    [webmailrelogin] => no
    [SQMSESSID] => a119fae83abdfd5fadfd5c0fd2aa7350
    [memberID] => 1
    [memberPassword] => 6967cabefd763ac1a1a88e11159957db
)


--
Auto-report system

 
Quote · 19 Jan 2009

have you made any changes in messages_inbox.php file? If so - I suggest you to restore it.

Regards

Artur

Quote · 20 Jan 2009

no, i have not made any chagees to the file

Quote · 20 Jan 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.