GLobal search appears to be broken......

http://www.getglobalexposure.com/searchKeyword.php?keyword=9553

 

Please see link any advise would be greatly appreciated........I need this to work..............

Csampson
Quote · 2 Oct 2010

Query:

SELECT COUNT(*) FROM `bx_facebook_advanced_main`  left JOIN `Profiles` ON `Profiles`.`ID`=`bx_facebook_advanced_main`.`author_id` WHERE 1 AND `bx_facebook_advanced_main`.`status` ='approved' AND CONCAT(`bx_facebook_advanced_main`.`title`, `bx_facebook_advanced_main`.`desc`, `bx_facebook_advanced_main`.`tags`, `bx_facebook_advanced_main`.`compensation`, `bx_facebook_advanced_main`.`company`, `bx_facebook_advanced_main`.`location`, `bx_facebook_advanced_main`.`jobtype`, `bx_facebook_advanced_main`.`categories`) LIKE ('%9553%') 

Mysql error: Unknown column 'bx_facebook_advanced_main.jobtype' in 'where clause'

Csampson
Quote · 2 Oct 2010

There is no such bx_facebook_advanced_main table in Dolphin by default. I suppose it is 3rd-party module which cause problem. Please try to find related mod and ask the mod author for the solution.

Query:

SELECT COUNT(*) FROM `bx_facebook_advanced_main`  left JOIN `Profiles` ON `Profiles`.`ID`=`bx_facebook_advanced_main`.`author_id` WHERE 1 AND `bx_facebook_advanced_main`.`status` ='approved' AND CONCAT(`bx_facebook_advanced_main`.`title`, `bx_facebook_advanced_main`.`desc`, `bx_facebook_advanced_main`.`tags`, `bx_facebook_advanced_main`.`compensation`, `bx_facebook_advanced_main`.`company`, `bx_facebook_advanced_main`.`location`, `bx_facebook_advanced_main`.`jobtype`, `bx_facebook_advanced_main`.`categories`) LIKE ('%9553%') 

Mysql error: Unknown column 'bx_facebook_advanced_main.jobtype' in 'where clause'

 

Rules → http://www.boonex.com/terms
Quote · 4 Oct 2010
 
 
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.