Error on database check

Jim
Topic Author
Offline

9 years 5 months ago #267277 by Jim

Error on database check was created by Jim

-- 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.

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

Jerome
Offline
HikaShop core developer

9 years 5 months ago #267288 by Jerome

Replied by Jerome on topic Error on database check

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

Code:

'User emails not synchronized with AcyMailing'

Code:

'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.

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

Jim
Topic Author
Offline

9 years 5 months ago - 9 years 5 months ago #267333 by Jim

Replied by Jim on topic Error on database check

Hi Jerome,

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

Last edit: 9 years 5 months ago by Jim.

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

Jerome
Offline
HikaShop core developer

9 years 5 months ago #267339 by Jerome

Replied by Jerome on topic Error on database check

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.

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

Jim
Topic Author
Offline

9 years 5 months ago #267368 by Jim

Replied by Jim on topic Error on database check

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.

nicolas
Away

9 years 5 months ago - 9 years 5 months ago #267380 by nicolas

Replied by nicolas on topic Error on database check

Hi,

Thanks. If you add the code:

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:

Code:

function onHikashopAfterCheckDB(&$ret){

in that same file, that will fix the problem.

Last edit: 9 years 5 months ago by nicolas.

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

Jim
Topic Author
Offline

9 years 5 months ago #267434 by Jim

Replied by Jim on topic Error on database check

HI Nicolas,

fixed. All green now. Thx.

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

Time to create page: 0.214 seconds