Results 1 to 4 of 4

Thread: AdvancedSearch weightedattributes?

  1. #1
    Junior Member
    Join Date
    Aug 2014
    Posts
    3

    AdvancedSearch weightedattributes?

    Magento version 1.7.0.2
    AdvancedSearch 3.1.1 installed and active.
    and Activos CatalogSearch installed and active.

    Magentos Catalog search settings set to Combine (Like and Fulltext)

    AdvancedSearch settings:
    Enable Search Refinement? - Yes
    Enable Search Similarity? - Yes
    Search Similarity Level - 1

    Weighted attribs
    Name 200
    Keywords 200
    Description 2

    Still when I search the order of the results(relevance) is totally random.

    1 - a product with "searchword" in Name, Keyword and Description(2 times) (Weight: 200+200+2+2=404 correct?)
    2 - a product with "searchword" in Description (1 time) (weight: 2)
    3 - a product with "searchword" in Name, Keyword and Description(4 times) (Weight: 408)
    4 - a product with "searchword" in Keyword and Description(1 time) (Weight: 202)
    5 - a product with "searchword" in Description(2 times) (Weight: 4)

    How is weighted attributes work? Does it work on top of the normal search or replaces it completely?

    Cache has been flushed, even disabled, indexes has been reindexed, searchwords/phrases has been deleted.
    Last edited by fredrik; 08-27-2014 at 07:19 AM.

  2. #2
    Team Member
    Join Date
    Dec 2011
    Location
    Los Angeles, CA
    Posts
    61
    The weighted attributes, once configured will replace completely the previous logic (which is basic logic at best). Your calculations are probably similar to how the results should show. Make sure you have uninstalled our free extension or any other search extension. If you are still having an issue, open a support ticket.

    Sincerely,
    Ron

  3. #3
    Junior Member
    Join Date
    Aug 2014
    Posts
    3

    Thanks

    Quote Originally Posted by ronpeled View Post
    ... Make sure you have uninstalled our free extension or any other search extension.
    Yes, that did the trick. Just inactivate the free extension did not help.
    / Fredrik

  4. #4
    Junior Member
    Join Date
    Aug 2014
    Posts
    3

    Problem with deadlocks

    When trying to run the advancedsearch-index it deadlocks sometimes, too often to ignore.
    Here is the error msg:

    a:5:{i:0;s:111:"SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to
    get lock; try restarting transaction";i:1;s:4253:"#0
    /mnt/ebs/var/www/html/mv0004/lib/Varien/Db/Statement/Pdo/Mysql.php(110):
    Zend_Db_Statement_Pdo->_execute(Array)
    #1 /mnt/ebs/var/www/html/mv0004/lib/Zend/Db/Statement.php(300):
    Varien_Db_Statement_Pdo_Mysql->_execute(Array)
    #2 /mnt/ebs/var/www/html/mv0004/lib/Zend/Db/Adapter/Abstract.php(479):
    Zend_Db_Statement->execute(Array)
    #3 /mnt/ebs/var/www/html/mv0004/lib/Zend/Db/Adapter/Pdo/Abstract.php(238):
    Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
    #4 /mnt/ebs/var/www/html/mv0004/lib/Varien/Db/Adapter/Pdo/Mysql.php(419):
    Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
    #5 /mnt/ebs/var/www/html/mv0004/app/code/community/Activo/AdvancedSearch/Model/Resource/Fulltext.php
    (176):
    Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...', Array)
    #6 /mnt/ebs/var/www/html/mv0004/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(136):
    Activo_AdvancedSearch_Model_Resource_Fulltext->prepareResult(Object(Mage_CatalogSearch_Model_Full tex
    t),
    'olja', Object(Mage_CatalogSearch_Model_Query))
    #7 /mnt/ebs/var/www/html/mv0004/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext/Collection.
    php(55):
    ...

    The deadlocks appeared right after advanced search was installed.

    A solution might be https://github.com/magendooro/magento-fulltext-reindex but does this not go well with Activos code?
    / Fredrik

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •