Checkout error

  • Posts: 26
  • Thank you received: 0
11 years 3 months ago #117093

Hi

I've the following error after hikashop update today ....

0 - SQL=SELECT * FROM jos_hikashop_payment WHERE (payment_currency IN ('','_','all') OR payment_currency LIKE '%,6,%') AND (payment_access = 'all' OR payment_access LIKE '%,9,%') ORDER BY payment_ordering ASC

error from Payment Method as well

An error has occurred.

0 SQL=SELECT COUNT(*) FROM jos_hikashop_payment AS plugin ORDER BY plugin.payment_ordering asc

Any suggestion will be helpful?

Regards,
N

Last edit: 11 years 3 months ago by nlthein.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13378
  • MODERATOR
11 years 3 months ago #117109

Hi,

These queries are correct. So it means that your database is missing some columns because there was an issue during the update.
Here is documentation page which gives more information on that:
www.hikashop.com/support/support/documen...lity-issues.html#SQL

Looking at the queries, it seems that you're missing the payment_ordering and payment_published columns in the hikashop_payment table.
You can add them with a query:
ALTER TABLE `jos_hikashop_payment` ADD `payment_ordering` int(10) unsigned NOT NULL DEFAULT '0', ADD `payment_published` tinyint(4) NOT NULL DEFAULT '1';

Or you can also add them directly via the phpmyadmin interface when you open the structure of the table.

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
11 years 3 months ago #117128

Thanks Nicolas.

I have access to MySQL server and didn't find any database in relate to Hikashop. What is the database name so that I can add them directly.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13378
  • MODERATOR
11 years 3 months ago #117143

I can't tell you your database name. You configured it yourself in the settings of your joomla configuration so you can get it there if you don't remember it.

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
11 years 3 months ago #117147

ok Thanks.

Found it.

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum