Forums Forums Community Discussion sphinx integration

Tagged: 

This topic contains 7 replies, has 3 voices, and was last updated by  tamilamuthan15 1 year, 5 months ago.

  • Author
    Posts
  • #1537

    bogomil
    Participant

    Hi,

    the stable version is great!
    Now I am trying to install sphinx but I keep on getting errors.

    So I wonder if the instroctions for OpenCats https://github.com/opencats/OpenCATS/wiki/Latest-Sphinx-search also work for candidats ?

    Greetz

  • #1541

    tamilamuthan15
    Keymaster

    bogmil,

    yes. It has to work. If any errors occurring, let me know the step to reproduce the error. I will check.

    with regards,
    R. Tamil Amuthan
    Auieo Software Private Limited

  • #1547

    bogomil
    Participant

    Hey Tamil,

    I managed to install sphinx.
    But I got a bug. When I search it always returns all the data from my db.
    It still highlights the keyword but it also shows profiles which doesnt match the search..

    So My DB has 10.000 Profiles and it alwas returns 10.000 hits.

    Do you have an idea ?

    Greetz

  • #1552

    tamilamuthan15
    Keymaster

    bogomil,

    Can you show the issue in skype?

    with regards,
    R. Tamil Amuthan
    Software Consultant
    Auieo Software Private Limited

  • #1559

    bogomil
    Participant

    Yes of course!

    Which time is convinient for you ?

    Greetz

  • #1564

    tamilamuthan15
    Keymaster

    bogomil,

    I am available from 12.30 AM EST to 8.00 AM EST and 10.00 AM EST to 3.00 PM EST. Please inform me one day before.

    withr regards,
    R. Tamil Amuthan
    Software Consultant
    Auieo Software Private Limited

  • #2170

    vikrant
    Participant

    Hi,
    After a long fight i was able to install sphinx, initially it keeps on returning connection refused error, when i installed search.php file. now the search results in following error. Please help.

    thanks

    PDOException Object ( [message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘java’ in ‘where clause’ [string:Exception:private] => [code:protected] => 42S22 [file:protected] => /var/www/html/candidats/lib/ClsNaanalPDO.php [line:protected] => 124 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/html/candidats/lib/ClsNaanalPDO.php [line] => 124 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( ) ) [1] => Array ( [file] => /var/www/html/candidats/lib/ClsNaanalPDO.php [line] => 555 [function] => query [class] => ClsNaanalPDO [type] => -> [args] => Array ( [0] => SELECT COUNT(*) AS count FROM attachment LEFT JOIN candidate ON attachment.data_item_id = candidate.candidate_id AND attachment.data_item_type = 100 AND attachment.site_id = candidate.site_id LEFT JOIN user AS owner_user ON candidate.owner = owner_user.user_id WHERE resume = 1 AND (java and angular and hibernate) AND (ISNULL(candidate.is_admin_hidden) OR (candidate.is_admin_hidden = 0)) AND (ISNULL(candidate.is_active) OR (candidate.is_active = 1)) AND attachment.site_id = 1 ) ) [2] => Array ( [file] => /var/www/html/candidats/lib/DatabaseConnectionPDO.php [line] => 149 [function] => setQuery [class] => ClsNaanalPDO [type] => -> [args] => Array ( [0] => SELECT COUNT(*) AS count FROM attachment LEFT JOIN candidate ON attachment.data_item_id = candidate.candidate_id AND attachment.data_item_type = 100 AND attachment.site_id = candidate.site_id LEFT JOIN user AS owner_user ON candidate.owner = owner_user.user_id WHERE resume = 1 AND (java and angular and hibernate) AND (ISNULL(candidate.is_admin_hidden) OR (candidate.is_admin_hidden = 0)) AND (ISNULL(candidate.is_active) OR (candidate.is_active = 1)) AND attachment.site_id = 1 ) ) [3] => Array ( [file] => /var/www/html/candidats/lib/DatabaseConnectionPDO.php [line] => 285 [function] => query [class] => DatabaseConnection [type] => -> [args] => Array ( [0] => SELECT COUNT(*) AS count FROM attachment LEFT JOIN candidate ON attachment.data_item_id = candidate.candidate_id AND attachment.data_item_type = 100 AND attachment.site_id = candidate.site_id LEFT JOIN user AS owner_user ON candidate.owner = owner_user.user_id WHERE resume = 1 AND (java and angular and hibernate) AND (ISNULL(candidate.is_admin_hidden) OR (candidate.is_admin_hidden = 0)) AND (ISNULL(candidate.is_active) OR (candidate.is_active = 1)) AND attachment.site_id = 1 ) ) [4] => Array ( [file] => /var/www/html/candidats/lib/Search.php [line] => 2218 [function] => getAssoc [class] => DatabaseConnection [type] => -> [args] => Array ( [0] => SELECT COUNT(*) AS count FROM attachment LEFT JOIN candidate ON attachment.data_item_id = candidate.candidate_id AND attachment.data_item_type = 100 AND attachment.site_id = candidate.site_id LEFT JOIN user AS owner_user ON candidate.owner = owner_user.user_id WHERE resume = 1 AND (java and angular and hibernate) AND (ISNULL(candidate.is_admin_hidden) OR (candidate.is_admin_hidden = 0)) AND (ISNULL(candidate.is_active) OR (candidate.is_active = 1)) AND attachment.site_id = 1 ) ) [5] => Array ( [file] => /var/www/html/candidats/modules/candidates/CandidatesUI.php [line] => 2430 [function] => __construct [class] => SearchByResumePager [type] => -> [args] => Array ( [0] => 20 [1] => 1 [2] => 1 [3] => java and angular and hibernate [4] => lastName [5] => ASC ) ) [6] => Array ( [file] => /var/www/html/candidats/lib/ModuleUtility.php [line] => 196 [function] => onSearch [class] => CandidatesUI [type] => -> [args] => Array ( ) ) [7] => Array ( [file] => /var/www/html/candidats/index.php [line] => 350 [function] => loadModule [class] => ModuleUtility [type] => :: [args] => Array ( [0] => candidates ) ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column ‘java’ in ‘where clause’ ) ) ;

    Total Errors:0
    PDO Query execution failed prematurely. Error: 1
    1) file:/var/www/html/candidats/lib/ClsNaanalPDO.php function:trace Container Function:query line:128
    Array
    (
    [0] => PDO Query execution failed prematurely. Error: 1
    )
    2) file:/var/www/html/candidats/lib/ClsNaanalPDO.php class:ClsNaanalPDO type:-> function:query Container Function:setQuery line:555
    3) file:/var/www/html/candidats/lib/DatabaseConnectionPDO.php class:ClsNaanalPDO type:-> function:setQuery Container Function:query line:149
    4) file:/var/www/html/candidats/lib/DatabaseConnectionPDO.php class:DatabaseConnection type:-> function:query Container Function:getAssoc line:285
    5) file:/var/www/html/candidats/lib/Search.php class:DatabaseConnection type:-> function:getAssoc Container Function:__construct line:2218
    6) file:/var/www/html/candidats/modules/candidates/CandidatesUI.php class:SearchByResumePager type:-> function:__construct Container Function:onSearch line:2430
    7) file:/var/www/html/candidats/lib/ModuleUtility.php class:CandidatesUI type:-> function:onSearch Container Function:loadModule line:196
    8) file:/var/www/html/candidats/index.php class:ModuleUtility type::: function:loadModule Container Function: line:350

  • #2187

    tamilamuthan15
    Keymaster

    vikrant,

    what search keyword you used. Can you describe the step in detail to get this issue?

    with regards,
    R. Tamil Amuthan
    Software Cosultant
    Auieo Software Private Limited

You must be logged in to reply to this topic.