Database error does anyone know what this means

Does anyone have any idea what this means? I get this error to my email. Have you ever seen this. This is just an except from the full error. I can send you the full one if you know what this is.

Database error in Freeducate

Query:
SELECT `p`.*, `f`.`ID`, 
if(`DateLastNav` > SUBDATE(NOW( ), INTERVAL 1 MINUTE ), 1, 0) AS `is_online`,
UNIX_TIMESTAMP(p.`DateLastLogin`) AS 'TS_DateLastLogin', UNIX_TIMESTAMP(p.`DateReg`) AS 'TS_DateReg' FROM (
SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '1' AND `Check` =1
UNION
SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '1' AND `Check` =1
) AS `f`
INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID`

WHERE 1 
ORDER BY p.`Avatar` DESC
LIMIT 0, 
Mysql error: 

Found error in the file '/home/jundaj/public_html/inc/profiles.inc.php' at line 385.
Called 'db_res' function with erroneous argument #0.


Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/jundaj/public_html/inc/classes/BxDolDb.php
[line] => 242
[function] => error
[class] => BxDolDb
[type] => ->
[object] => BxDolDb Object
(
[error_checking] => 1
[host] => localhost
[port] => 
[socket] => 
[dbname] => jundaj_jundaj
[user] => *****
[password] => *****
[link] => Resource id #30
[current_res] => 
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
*RECURSION*
[_oCache] => BxDolCacheFile Object
(
[sPath] => /home/jundaj/public_html/cache/
[_error] => 
)

[_sCacheFile] => sys_options_3a05bf847a3e428757538f24e9e3234d.php
[_aParams] => [truncated]
[_error] => 
)

[oDbCacheObject] => BxDolCacheFile Object
(
[sPath] => /home/jundaj/public_html/cache/
[_error] => 
)

[_error] => 
)

[args] => Array
(
[0] => Database query error
[1] => 
[2] => SELECT `p`.*, `f`.`ID`, 
if(`DateLastNav` > SUBDATE(NOW( ), INTERVAL 1 MINUTE ), 1, 0) AS `is_online`,
UNIX_TIMESTAMP(p.`DateLastLogin`) AS 'TS_DateLastLogin', UNIX_TIMESTAMP(p.`DateReg`) AS 'TS_DateReg' FROM (
SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '1' AND `Check` =1
UNION
SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '1' AND `Check` =1
) AS `f`
INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID`

WHERE 1 
ORDER BY p.`Avatar` DESC
LIMIT 0, 
)

)

I've also been getting this error in the last week or so and its one of two things...

1. i removed alot of the blocks from profile and join for in builders admin... or

2. cpanel updated the mysql server and no longer likes that quary anymore...

Will let you know if i find the correct answer.

Well from what i can see it was becuase the view profile page was looking for fields i moved to inactive...

i moved some blocks areound in profile fields builder and the fields are removed from profile view page...   will let you know when my site sends out error report if its fixed.

Thanks hope you figure it out

Ok so I have figured out a little ground on this error.  I get the errorous email when someone tries to hit a members profile directly for example http://freeducate.com/jundaj

If the member is logged in no error is thrown when going to a member page.  If you are not logged in and are considered a "guest" then try to go to http://freeducate.com/jundaj it throws a error "division by zero". 

Does anyone know how to fix this or what the root cause of this is.

-Justin

basicly that one is saying it is trying to divid a value by zero and cant do it for one reason or another.

you will have to look at the code and find the line number its erroring on   might be a few lines above or below the line number.