Database query error
Query:
SELECT `Profiles`.`ID`, `Profiles`.`NickName`, `Profiles`.`Pic_0_addon`, `Profiles`.`Picture` FROM `FriendList` LEFT JOIN `Profiles` ON (`Profiles`.`ID` = `FriendList`.`Profile` AND `FriendList`.`ID` = ‘9′ OR `Profiles`.`ID` = `FriendList`.`ID` AND `FriendList`.`Profile` = ‘9′) WHERE (`FriendList`.`Profile` = ‘9′ OR `FriendList`.`ID` = ‘9′) AND `FriendList`.`Check` = ‘1′ ORDER BY `Profiles`.`Picture` DESC
Mysql error:
Unknown column ‘Profiles.Pic_0_addon’ in ‘field list’
Found error in file /home/demoz/public_html/dolphin/demo/beta/viewFriends.php
at line 67. Called db_res function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/demoz/public_html/dolphin/demo/beta/viewFriends.php
[line] => 67
[function] => db_res
[args] => Array
(
[0] => SELECT `Profiles`.`ID`, `Profiles`.`NickName`, `Profiles`.`Pic_0_addon`, `Profiles`.`Picture` FROM `FriendList`
LEFT JOIN `Profiles` ON (`Profiles`.`ID` = `FriendList`.`Profile` AND `FriendList`.`ID` = ‘9′ OR `Profiles`.`ID` = `FriendList`.`ID` AND `FriendList`.`Profile` = ‘9′)
WHERE (`FriendList`.`Profile` = ‘9′ OR `FriendList`.`ID` = ‘9′) AND `FriendList`.`Check` = ‘1′ ORDER BY `Profiles`.`Picture` DESC
) )
[2] => Array
(
[file] => /home/demoz/public_html/dolphin/demo/beta/viewFriends.php
[line] => 51
[function] => getfriendlist
[args] => Array
(
[0] => 9
)
)
[3] => Array
(
[file] => /home/demoz/public_html/dolphin/demo/beta/viewFriends.php
[line] => 43
[function] => pagecomppagemaincode
[args] => Array
(
)
)
)
Make Meaning Or Die
I think it would be a little more helpful to the Boonex Team if you told them what you were doing when this error occurred. It will eliminate wasted time trying to see if they can recreate the error, if they know what you were doing when you received it.
Already fixed. Thanks for report.