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
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
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.