[Skip to main content](#vessel-content) # 1054 Unknown column 'mjd.remaining' in 'field list' ## - **[renem](/forum/user/47055-renem "View renem's Profile")** - [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author - [ Offline](/forum/user/47055-renem) Less More - Posts: 198 - Thank you received: 7 - - - [](http://www.muldermedia.nl) - 9 years 2 months ago [\#275776](#275776) by [renem](/forum/user/47055-renem "View renem's Profile") *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#275776 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* was created by *[renem](/forum/user/47055-renem "View renem's Profile")* -- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list' Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 2 months ago [\#275777](#275777) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#275777 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* Hello, Can you please indicate which Mijoshop version is installed in the website ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[renem](/forum/user/47055-renem "View renem's Profile")** - [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author - [ Offline](/forum/user/47055-renem) Less More - Posts: 198 - Thank you received: 7 - - - [](http://www.muldermedia.nl) - 9 years 2 months ago [\#275795](#275795) by [renem](/forum/user/47055-renem "View renem's Profile") Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#275795 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* Hi Jerome i'm using 3.2.1 (the latest version) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14277 - - 9 years 2 months ago [\#275810](#275810) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#275810 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* 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: 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(); from the file administrator/components/com_hikashop/helpers/import/mijo.php and that will remove the problem when you launch the import. That query is only to retrieve the number of downloads from orders in MijoShop so in most cases it's actually not needed at all. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[renem](/forum/user/47055-renem "View renem's Profile")** - [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author - [ Offline](/forum/user/47055-renem) Less More - Posts: 198 - Thank you received: 7 - - - [](http://www.muldermedia.nl) - 9 years 2 months ago [\#275826](#275826) by [renem](/forum/user/47055-renem "View renem's Profile") Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#275826 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* Hi Nicolas, the error is gone now. Re-import seems to work correct now, only the order date is not correct an example: 2106-02-07 06:28. Because we work with downloadable products this date may be important for us. Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 2 months ago [\#275829](#275829) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#275829 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* 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, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[renem](/forum/user/47055-renem "View renem's Profile")** - [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author - [ Offline](/forum/user/47055-renem) Less More - Posts: 198 - Thank you received: 7 - - - [](http://www.muldermedia.nl) - 9 years 2 months ago - 9 years 2 months ago [\#275854](#275854) by [renem](/forum/user/47055-renem "View renem's Profile") Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#275854 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* Hi Jerome, See screenshots from the same orders at first MijoShop and the second sho ti from HikaShop: In HikaShop all the date's are the same.... - [ ![MijoShopDogtrainingspecialistDogtrainerDickStaalAdministratie.png](/forum/attachment/39689) ](/forum/attachment/39689 "...inistratie.png") [ ](/forum/attachment/39689?download=1 "...inistratie.png") - [ ![DogtrainingspecialistDogtrainerDickStaalAdministratieBestellingen.png](/forum/attachment/39690) ](/forum/attachment/39690 "...stellingen.png") [ ](/forum/attachment/39690?download=1 "...stellingen.png") Last edit: 9 years 2 months ago by [renem](/forum/user/47055-renem "View renem's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 2 months ago [\#275856](#275856) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#275856 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* 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, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[renem](/forum/user/47055-renem "View renem's Profile")** - [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author - [ Offline](/forum/user/47055-renem) Less More - Posts: 198 - Thank you received: 7 - - - [](http://www.muldermedia.nl) - 9 years 2 months ago - 9 years 2 months ago [\#275981](#275981) by [renem](/forum/user/47055-renem "View renem's Profile") Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#275981 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* Hi Jerome your'e absolutely right. I made two screenshots from the same orders: [ ![MSMijoShopDogtrainingspecialistDogtrainerDickStaalAdministratie.png](/forum/attachment/39722) ](/forum/attachment/39722 "...inistratie.png") [ ![DogtrainingspecialistDogtrainerDickStaalAdministratieBestellingen_2017-08-15.png](/forum/attachment/39723) ](/forum/attachment/39723 "...2017-08-15.png") As you can see the date's are totally different after importing from Mijoshop. - [ ![MSMijoShopDogtrainingspecialistDogtrainerDickStaalAdministratie.png](/forum/attachment/39722) ](/forum/attachment/39722 "...inistratie.png") [ ](/forum/attachment/39722?download=1 "...inistratie.png") - [ ![DogtrainingspecialistDogtrainerDickStaalAdministratieBestellingen_2017-08-15.png](/forum/attachment/39723) ](/forum/attachment/39723 "...2017-08-15.png") [ ](/forum/attachment/39723?download=1 "...2017-08-15.png") Last edit: 9 years 2 months ago by [renem](/forum/user/47055-renem "View renem's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 2 months ago [\#275983](#275983) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#275983 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* 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 Code: 'order_created' => 'mjo.date_added', Code: 'order_modified' => 'mjo.date_modified', And you need to replace them by Code: 'order_created' => 'UNIX_TIMESTAMP(mjo.date_added)', And Code: 'order_modified' => 'UNIX_TIMESTAMP(mjo.date_modified)', Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[renem](/forum/user/47055-renem "View renem's Profile")** - [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author - [ Offline](/forum/user/47055-renem) Less More - Posts: 198 - Thank you received: 7 - - - [](http://www.muldermedia.nl) - 9 years 2 months ago - 9 years 2 months ago [\#276029](#276029) by [renem](/forum/user/47055-renem "View renem's Profile") Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[1054 Unknown column 'mjd.remaining' in 'field list'](/forum/25-install-update/891490-1054-unknown-column-mjd-remaining-in-field-list#276029 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0 I try to re-import Mijoshop so al the data is sync but i get this error: 1054 Unknown column 'mjd.remaining' in 'field list'")* Hi Jerome, Yes this did the trick! Awesome support! Regards René Last edit: 9 years 2 months ago by [renem](/forum/user/47055-renem "View renem's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5MTQ5MC0xMDU0LXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.137 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)