Error

[Dicheto2302]

Hello, I am using this plugin, but i am getting this error in admin panel after clicking import: We catched some errors during import, please check foc logs!

Errors count - 1

How to see the log?

[RTechSn]

I would like to know where i can read the log too. OpenCart logs page is empty.

[dicheto]

Yesss... No answer at all...the project must be discounted!

[RTechSn]

Well, looks like we have to fix the issue ourselves. Open \model\extension\module\foc_common.php and find the function called writeLog. Add the following code after $this->log->write($msg);

$date = new DateTime('now', new DateTimeZone('Europe/Paris'));
$date = $date->format("y:m:d H:m:s");    
file_put_contents("foc.log", $date . ": " . $msg . "\n", FILE_APPEND | LOCK_EX);

You can find the log file in your admin folder.

[dicheto]

Any ideas what is this error: Error: Subquery returns more than 1 row
Error No: 1242
SELECT IFNULL((SELECT product_id FROM md_product WHERE sku LIKE "3800931053956"), 0) AS id

?