payment problem after update

-- url of the page with the problem -- : ontwikkel.waarheenmetvakantie.nl
-- HikaShop version -- : 2.2.2 starter
-- Joomla version -- : 2.5.14
-- PHP version -- : 5.3.3
-- Browser(s) name and version -- : firefox most recent
-- Error-message(debug-mod must be tuned on) -- : I cannort save a change

I made an update to Hikashop 2.2.2 starter and Joomla 2.5.14; I use iDeal Platform for Ideal payments version 2.7.3 but after this update I cannot make a payment method (iDeal) or make changes in this plugin.
Please advise me how to handle this problem

Hi,
I'll need more information to understand your problem, can you show me some screenshots of the issue that you are having with your payment method ?

some screenshots

Ok, so can you :
- Active the joomla debug mode ("Administration->Global configuration->System->Debug System/Language")
- Set the "error reporting" option of the joomla configuration to "maximum"
- Try to do edit/save your payment method and tell me if it display an error message.

this is the error mesage:
JDatabaseMySQLi::query: 1054 - Unknown column 'plugin.payment_ordering' in 'order clause' SQL=SELECT COUNT(*) FROM c67hb_hikashop_payment AS plugin ORDER BY plugin.payment_ordering asc

**Terug naar controlepaneel**

Call stack
# Function Location
1 JAdministrator->dispatch() /data/www/waarheenmv2/public_html/administrator/index.php:46
2 JComponentHelper::renderComponent() /data/www/waarheenmv2/public_html/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /data/www/waarheenmv2/public_html/libraries/joomla/application/component/helper.php:351
4 require_once() /data/www/waarheenmv2/public_html/libraries/joomla/application/component/helper.php:383
5 hikashopController->execute() /data/www/waarheenmv2/public_html/administrator/components/com_hikashop/hikashop.php:54
6 JController->execute() /data/www/waarheenmv2/public_html/administrator/components/com_hikashop/helpers/helper.php:1298
7 PluginsController->listing() /data/www/waarheenmv2/public_html/libraries/joomla/application/component/controller.php:761
8 hikashopController->display() /data/www/waarheenmv2/public_html/administrator/components/com_hikashop/controllers/plugins.php:140
9 JController->display() /data/www/waarheenmv2/public_html/administrator/components/com_hikashop/helpers/helper.php:1310
10 PluginsViewPlugins->display() /data/www/waarheenmv2/public_html/libraries/joomla/application/component/controller.php:722
11 PluginsViewPlugins->listing() /data/www/waarheenmv2/public_html/administrator/components/com_hikashop/views/plugins/view.html.php:21
12 hikashopView->getPageInfoTotal() /data/www/waarheenmv2/public_html/administrator/components/com_hikashop/views/plugins/view.html.php:79
13 JDatabase->loadResult() /data/www/waarheenmv2/public_html/administrator/components/com_hikashop/helpers/helper.php:1537
14 JDatabaseMySQLi->execute() /data/www/waarheenmv2/public_html/libraries/joomla/database/database.php:1138
15 JError::raiseError() /data/www/waarheenmv2/public_html/libraries/joomla/database/database/mysqli.php:396
16 JError::raise() /data/www/waarheenmv2/public_html/libraries/joomla/error/error.php:251

Ok, and can you download the last Hikashop version through our website, install it, and test it again ?
Thank you.

I have already installed the latest version Hikashop 2.2.2 starter; after that the problem started

Hi,

It seems that some columns are missing in your database.
Thanks to try to execute these sql requests in your phpMyAdmin panel:

ALTER TABLE `#__hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1';
ALTER TABLE `#__hikashop_payment` DROP INDEX payment_type;

Ok, done and the logo off iDeal is showm on the site. However I can't go to the next step when I push the button "next" (volgende in Dutch).

error messages are displayed; screenshot made (attachment)

I'm sorry but when I activate the debug mode the frontend does not shown anymore.
I think that the only solution is to update the ccideal component???? This is a lot of work for a small webshop ....

Hi,

If you disable the Joomla debug mode and set the error reporting to maximum, do you have any error messages returned ?

As temporary solution, you can try to re-install an older version of HikaShop starter.

We don't have developed ccideal, thanks to ask to the team who developed that plugin.