Error on database check

  • Posts: 31
  • Thank you received: 0
7 years 7 months ago #267277

-- HikaShop version -- : 3.0.1
-- Joomla version -- : 3.6.5

HI,

I did a "check database", I got the errors as shown in the attached pic.

Attachments:

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 7 months ago #267288

Hello,

Can you please check your database for the table "hikashop_order" you should find some (or maybe one) orders with an empty order status.
About the second message, please edit the hikashop/acymailing plugin and replace the line

'User emails not synchronized with AcyMailing'
by
'User emails not synchronized with AcyMailing ('.$e->getMessage().')'
it should then give you the database error message related to the problem.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 31
  • Thank you received: 0
7 years 7 months ago #267333

Hi Jerome,

1) all order_status are filled
2) where exactly do I find that? ('User emails not synchronized with AcyMailing')

Last edit: 7 years 7 months ago by Jim.

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 7 months ago #267339

Hello,

As I wrote : In the HikaShop Acymailing plugin.
plugins/hikashop/acymailing/acymailing.php

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 31
  • Thank you received: 0
7 years 7 months ago #267368

HI,

Error User emails not synchronized with AcyMailing (Table 'id885160_kpcdb.ww3b8_acymailing_subscriber' doesn't exist SQL=INSERT IGNORE INTO `ww3b8_acymailing_subscriber` (`email`,`userid`,`created`) SELECT `user_email`, `user_cms_id`,1492119509 FROM `ww3b8_hikashop_user`)

regards,

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
7 years 7 months ago #267380

Hi,

Thanks. If you add the code:

		$helper = rtrim(str_replace('/',DS,JPATH_ADMINISTRATOR),DS).DS.'components'.DS.'com_acymailing'.DS.'helpers'.DS.'helper.php';
		if(!file_exists($helper)) return;
after the line:
function onHikashopAfterCheckDB(&$ret){
in that same file, that will fix the problem.

Last edit: 7 years 7 months ago by nicolas.

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

  • Posts: 31
  • Thank you received: 0
7 years 7 months ago #267434

HI Nicolas,

fixed. All green now. Thx.

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

Time to create page: 0.064 seconds
Powered by Kunena Forum