error in your SQL syntax

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `sender_id` = 0, `recipient_id` = ' at line 7

i get thing when trying to view members profile

how can i fix this thanks

anyone?

Can you provide more?  There are a lot of sql calls in Dolphin.

Do you have any 3rd party modules that also put blocks on the profile page? You can go into the Profile Page Builder and start moving the boxes down to the 'inactive' area until you find the culprit causing the problems.

 Where are all the quotes in the query? Did someone edit the code for you or you did?

 Post the code in BxSpyDb.php' at line 359.

sorry what quotes?

line 341     // execute query;
            $sQuery =
            "
                INSERT INTO
                    `{$this->sTablePrefix}data`
                SET
                    `alert_unit`    = '{$sAlertUnit}',
                    `alert_action`    = '{$sAlertAction}',
                    `object_id`        = {$iObjectId},
                    `comment_id`    = {$iCommentId},
                    `sender_id`     = {$iSenderId},
                    `recipient_id`  = {$iRecipientId},
                    `lang_key`      = '{$sLangKey}',
                    `params`        = '{$aParameters}',
                    `date`          = TIMESTAMP( NOW() ),
                    `type`          = '{$sActivityType}'
            ";

         line 359   $this -> query($sQuery);
            return $this -> lastId();
        }

        function deleteActivityByObject($sUnit, $iObjectId, $iCommentId = 0)
        {
            $sWhereAddon = "";
            if($iCommentId != 0)
                $sWhereAddon = "AND `comment_id`='" . $iCommentId . "'";

            $sSql = "DELETE FROM
                    `" . $this->sTablePrefix . "data`
                WHERE
                    `alert_unit`='" . $sUnit . "' AND
                    `object_id`='" . $iObjectId . "' " . $sWhereAddon;

            return $this->query($sSql);
   line 376     }

Fixed