Please help to solve DB query error

Hi

I did made changes to my website but none very recently.

and today just discovered this when I tried to visit the user profile (www.sitename.com/username), and got  database query error:

and line 506 has:

return (int)db_value($sqlQuery);

Would someone please please give me a hand?

many thanks

can you pm me your site url and cpanel..Ill help you...

Hey, How you have solved this problem? I am getting exactly this error after upgrade to 7.3.2

Try to check sys_albums table if there is Uri field exists. If it doesn't exists then I would suggest to restore your site from backup. 

Hi AlexT,

Thanks for your reply. Actually Uri is exist but sys_albums not adding in the join query. would you kindly check the following query:

SELECT COUNT(*) FROM `bx_photos_main` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` WHERE 1 AND `bx_photos_main`.`Owner` ='20524' AND `sys_albums`.`Uri` ='liquidcash-s-photos'

So Unknown column 'sys_albums.Uri' in 'where clause'

Please help

I would suggest to compare the following files with the originals:

templates/base/scripts/BxBaseSearchResultSharedMedia.php
modules/boonex/photos/classes/BxPhotosSearch.php 

Thanks. But still getting the issue.

SELECT COUNT(*) FROM `bx_photos_main` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` WHERE 1 AND `bx_photos_main`.`Owner` ='20680' AND `sys_albums`.`Uri` ='Patrick-s-photos'

When i changed the owner id in the sys_albums then fixed for this user but getting issue for another user.

Please help

It maybe some modification cause this, I would suggest to disable custom modifications/modules to find the cause of the problem.