Magento: SQLSTATE[42000]: Syntax error or access violation: 1318 Incorrect number of arguments for PROCEDURE

Concluído Postado Apr 26, 2016 Pago na entrega
Concluído Pago na entrega

Hi,

i am receiving this error on website when filtring the products in category

There has been an error processing your request

SQLSTATE[42000]: Syntax error or access violation: 1318 Incorrect number of arguments for PROCEDURE smartch1_smc1.filter_sinch_products_s; expected 6, got 7

Trace:

#0 /var/www/vhosts/[login to view URL](228): PDOStatement->execute(Array)

#1 /var/www/vhosts/[login to view URL](110): Zend_Db_Statement_Pdo->_execute(Array)

#2 /var/www/vhosts/[login to view URL](291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)

#3 /var/www/vhosts/[login to view URL](480): Zend_Db_Statement->execute(Array)

#4 /var/www/vhosts/[login to view URL](238): Zend_Db_Adapter_Abstract->query('CALL filter_sin...', Array)

#5 /var/www/vhosts/[login to view URL](428): Zend_Db_Adapter_Pdo_Abstract->query('CALL filter_sin...', Array)

#6 /var/www/vhosts/[login to view URL](347): Varien_Db_Adapter_Pdo_Mysql->query('CALL filter_sin...')

#7 /var/www/vhosts/[login to view URL](101): Varien_Db_Adapter_Pdo_Mysql->raw_query('CALL filter_sin...')

#8 /var/www/vhosts/[login to view URL](117): Bintime_Sinchimport_Model_Resource_Mysql4_Layer_Filter_Feature->_prepareSearch(Object(Bintime_Sinchimport_Model_Layer_Filter_Feature), 'over 2.5 TB')

Administração de Bancos de Dados Magento MySQL SQL

ID do Projeto: #10333003

Sobre o projeto

22 propostas Projeto remoto Ativo em Apr 28, 2016

Concedido a:

netgreater

Hi, I have experience in fixing similar issue in an magento store, SO I assure you that I will get it fixed as per your requirements and the expectations. Please give me the chance to work with you on this projec Mais

£23 GBP em 1 dia
(2 Comentários)
4.0

22 freelancers estão ofertando em média £61 nesse trabalho

sapotacorp

Hi sir. What is your website? From your message log, I see the problem from Bintime plugin. What version of Bintime are you using? I can start immediately to help you. I'm Minh.

£27 GBP em 1 dia
(939 Comentários)
8.8
uhjk

Hello, If you provide me ftp details, I can fix this problem immediately. I'm online now. Thank you v much.

£18 GBP em 1 dia
(442 Comentários)
7.5
dannv

Hi, I was working with magento from 2008. I have exp with upgraded, import data, themes, tax, payment, sales, shipping, SEO, etc... Also I often provide Magento extension and Magento theme. Please see my profile fo Mais

£18 GBP em 1 dia
(294 Comentários)
7.2
SmileadeR

Ready fix that help you right now ! Please check my profiles for previous jobs (all of my projects is MAGENTO, all good feedback) ! Thanks !

£35 GBP em 1 dia
(287 Comentários)
7.3
op2i

Hi, I can fix the error with category filter. The error seems with Bintime_Sinchimport module. Lets fix it. Thanks

£33 GBP em 1 dia
(108 Comentários)
7.0
tikumishra

Hi I can work on fixing this issue right away. You may need to provide me Cpanel access, because I have to check the PHPMYADMIN for database to debug the issue. Let me know, if you are interested. Thanks

£18 GBP em 1 dia
(32 Comentários)
5.0
dpeter

Grant access to database to check the stored procedure. The error is obvious. I can fix this today. Best regards

£23 GBP in 0 dias
(9 Comentários)
5.0
Hardik3477

Hello, This is Kevin Kathro here from TheWebTechies Web Services. We are a reputed IT firm specialising in creating and maintaining websites and other individual project related services in various platforms includi Mais

£18 GBP in 0 dias
(4 Comentários)
2.0