1054 Unknown column 'mjd.remaining' in 'field list'

Hello,

Can you please indicate which Mijoshop version is installed in the website ?

Regards,

Hi,

Apparently something changed in the mijoshop_download table in your database since normally that column shouldn't be missing.
Could you check that table in your database via your phpmyadmin ? What do you have there ?

As a quick fix, you can remove the code:

$sql = 'INSERT IGNORE INTO `#__hikashop_download` (`'.implode('`,`',array_keys($data)).'`) '.
			'SELECT '.implode(',',$data).' FROM `#__mijoshop_download` AS mjd '.
			'INNER JOIN `#__mijoshop_download_description` mjdd ON mjd.download_id = mjdd.download_id '.
			'INNER JOIN `#__hikashop_file` AS hkf ON ( CONVERT(hkf.file_name USING utf8) = CONVERT(mjdd.name USING utf8) )'.
			'INNER JOIN `#__mijoshop_product_to_download` AS mjpd ON mjd.download_id = mjpd.download_id '.
			'INNER JOIN `#__mijoshop_order_product` AS mjop ON mjpd.product_id = mjop.product_id '.
			'INNER JOIN `#__hikashop_order` AS hko ON hko.order_mijo_id = mjop.order_id '.
			'WHERE mjd.download_id > '.$this->options->last_mijo_pfile;

		$this->db->setQuery($sql);
		$this->db->query();
		$total = $this->db->getAffectedRows();

Hello,

In which field exactly the date is incorrect ?
I checked the code for the import of orders and it copy the value directly from Mijo ; so I assume that it is (or was) using timestamp like we do.

Regards,

Hello,

Sorry, I think that I was not clear enough.
What are the exact field names and what is the exact content that you can see in the database ?

Please understand that with your current screenshot we can't understand what is wrong except that we can see a date in a far future we can't even know if the rest of the date is good, or completely wrong. So please be extremely precise.

Regards,

Hello,

So it means that Mjioshop do not use anymore "timestamp" but switch to "date" fields.
And you cannot put a date into a timestamp, the result is (as you can see) chaotic.

In the Mijoshop import file, you will find these lines

'order_created' => 'mjo.date_added',

'order_modified' => 'mjo.date_modified',

'order_created' => 'UNIX_TIMESTAMP(mjo.date_added)',

'order_modified' => 'UNIX_TIMESTAMP(mjo.date_modified)',