Error on sort by price in search results

Hello,
My site gives an error after you try to sort the search results by price. (error clears only after removing cookies)
“Error on sort by price in search results
You cannot define a correlation name ‘_inventory_table’ more than once”
Site: http://www.amstelbooks.eu/catalogsearch/result/?q=elsken
 
trace:
https://gist.github.com/anonymous/255bfc37aeeba7a1cdd1#file-error_on_sort
 
Can you point me in the right direction on this one?

3 answers

Profile photo of Lara 4810.00 $tone April 30, 2015
Public

Hi,
Could you please provide us the FTP credentials and admin account to access your site, our team mate needs to have closer look to detect the issue!
 
Regards,
Lara

#1
Profile photo of Mall Staff 184060.00 $tone May 1, 2015
Public

Hi Jelcke de Boer,
Our Bookshop theme work fine when sorting by price at http://bookshop.demo.ubertheme.com/catalogsearch/result/index/?dir=asc&order=price&q=memory
and i see the issue as you said come from a third-party extension in your site with named “Mirasvit/SearchIndex”

#11 /home/local/public_html/app/code/local/Mirasvit/SearchIndex/Block/Results.php(189): Mage_Core_Block_Abstract->toHtml()
#12 /home/local/public_html/app/design/frontend/base/default/template/searchindex/results_tabs.phtml(33): Mirasvit_SearchIndex_Block_Results->getCurrentContent()

Please try disabled this extension in your site and test again or you can contact to Mirasvit to get help for this issue.
 
Have a look and contact me if you need further assistance.
Regards,
Mall.
 
 

#3

Please login or Register to Submit Answer

Written By

Comments