There has been an error processing your request

[Cookie467]

Hi,

I am getting the following error when I look in the exception log. The front end displays 'There has been an error processing your request' with an error number.  Any ideas please?

'Mage_Core_Exception' with message 'Invalid webservice adapter specified.' in /var/www/vhosts/xxxxxxx.com/httpdocs/app/Mage.php:595
Stack trace:
#0 /var/www/vhosts/xxxxxxxx.com/httpdocs/app/code/core/Mage/Api/Model/Server.php(127): Mage::throwException('Invalid webserv...')
#1

[Damian Culotta]

Hi @Cookie467,

Can you check this thread?

https://stackoverflow.com/questions/13932908/magento-api-invalid-webservice-adapter-specified

[Cookie467]

It doesn't unfortunately resolve anything.  Do you have any other ideas please?

[Damian Culotta]

Hi @Cookie467,

I don't have a new idea but:

1. Is it possible to disable any 3rd-party module?
2. is this issue habppening on sompe specific url/section/area?

[Cookie467]

Thanks for your response. I have been renaming files on the server and I get a blank screen when I rename config.xml in the app/etc folder. 

Any help would be appreciated. Thanks

[Cookie467]

I have enabled errors and getting this now:

SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB', query was: SELECT `main_table`.* FROM `core_store` AS `main_table` ORDER BY CASE WHEN main_table.store_id = 0 THEN 0 ELSE 1 END ASC, main_table.sort_order ASC, main_table.name ASC

Trace:

#0 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/Varien_Db_Statement_Pdo_Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

#1 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(65519): Varien_Db_Statement_Pdo_Mysql->_execute(Array)

#2 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(54710): Zend_Db_Statement->execute(Array)

#3 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(55747): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)

#4 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(56683): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)

#5 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(54967): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)

#6 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(32321): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)

#7 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(32951): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)

#8 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(32157): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()

#9 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(33676): Varien_Data_Collection_Db->load(false, false)

#10 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(31527): Mage_Core_Model_Resource_Store_Collection->load()

#11 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(21354): Varien_Data_Collection->count()

#12 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(21196): Mage_Core_Model_App->_initStores()

#13 /var/www/vhosts/mywebsite.com/httpdocs/includes/src/__default.php(21079): Mage_Core_Model_App->_initCurrentStore('', 'store')

#14 /var/www/vhosts/mywebsite.com/httpdocs/app/Mage.php(684): Mage_Core_Model_App->run(Array)

#15 /var/www/vhosts/mywebsite.com/httpdocs/index.php(89): Mage::run('', 'store')

#16 {main}

[Damian Culotta]

Hi @Cookie467,

I guess I will follow this recomednation: https://stackoverflow.com/questions/10451644/sqlstate42000-syntax-error-or-access-violation-1286-unk...

After knowing which is the problem maybe you will be able to fix it.

This kind of solutions https://stackoverflow.com/questions/27257191/magento-syntax-error-or-access-violation-1286-unknown-t... sounds a little bit radical and I prefer to understand first why is happening.

(If you follow the last option rememeber to do backups first)