[Skip to main content](#vessel-content)

#   UPDATE Unknown column 'mjd.remaining' in 'field list'

##

- **[komir](/forum/user/2810-komir "View komir's Profile")**
- [![komir's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2810-komir "View komir's Profile") Topic Author
- [ Offline](/forum/user/2810-komir)

Less More

- Posts: 127
- Thank you received: 2
- [](https://montaza-namjestaja.com.hr/)
-

7 years 9 months ago [\#303071](#303071) by [komir](/forum/user/2810-komir "View komir's Profile")  *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#303071 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")* was created by *[komir](/forum/user/2810-komir "View komir's Profile")*

-- HikaShop version -- : 4.01
-- Joomla version -- : v 3.9
-- PHP version -- : 7.1
-- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'

Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop.
After that try to start migration and after step 3 get an error
"Unknown column 'mjd.remaining' in 'field list' "

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[komir](/forum/user/2810-komir "View komir's Profile")**
- [![komir's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2810-komir "View komir's Profile") Topic Author
- [ Offline](/forum/user/2810-komir)

Less More

- Posts: 127
- Thank you received: 2
- [](https://montaza-namjestaja.com.hr/)
-

7 years 9 months ago [\#303072](#303072) by [komir](/forum/user/2810-komir "View komir's Profile")  Replied by *[komir](/forum/user/2810-komir "View komir's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#303072 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

In error log have
[27-Jan-2019 12:18:35 Etc/GMT] PHP Warning: constant(): Couldn't find constant JPATH_ in /home/ecoqlsbx/public_html/******/libraries/src/Installer/Adapter/ModuleAdapter.php on line 214

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) 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: 86556
- Thank you received: 14305
-
-

7 years 9 months ago [\#303084](#303084) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#303084 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

Hi,

Can you check the table mijoshop_download in your database via your phpmyadmin. Normally, there should be a column "remaining".
Could you provide a screenshot of the structure of that table ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[komir](/forum/user/2810-komir "View komir's Profile")**
- [![komir's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2810-komir "View komir's Profile") Topic Author
- [ Offline](/forum/user/2810-komir)

Less More

- Posts: 127
- Thank you received: 2
- [](https://montaza-namjestaja.com.hr/)
-

7 years 9 months ago [\#303145](#303145) by [komir](/forum/user/2810-komir "View komir's Profile")  Replied by *[komir](/forum/user/2810-komir "View komir's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#303145 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

Thank you. I am looking inside the table: j16yr_hikashop_download but it is empty ![:(](/media/kunena/emoticons/22.png ":(")
Here is the structure of the download
[ ![screenshot-162.222.225.153-2083-2019.01.29-08-25-52.png](/forum/attachment/45962) ](/forum/attachment/45962 "...9-08-25-52.png")

- [ ![screenshot-162.222.225.153-2083-2019.01.29-08-25-52.png](/forum/attachment/45962) ](/forum/attachment/45962 "...9-08-25-52.png") [ ](/forum/attachment/45962?download=1 "...9-08-25-52.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) 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: 86556
- Thank you received: 14305
-
-

7 years 9 months ago [\#303158](#303158) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#303158 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

Hi,

That's the hikashop_download table. I was talking about the mijoshop_download table in my previous message. Could you check on that table please?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[komir](/forum/user/2810-komir "View komir's Profile")**
- [![komir's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2810-komir "View komir's Profile") Topic Author
- [ Offline](/forum/user/2810-komir)

Less More

- Posts: 127
- Thank you received: 2
- [](https://montaza-namjestaja.com.hr/)
-

7 years 9 months ago [\#303188](#303188) by [komir](/forum/user/2810-komir "View komir's Profile")  Replied by *[komir](/forum/user/2810-komir "View komir's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#303188 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

Sorry, my mistake. I look Mijoshop and it is also empty
[ ![screenshot-162.222.225.153-2083-2019.01.29-19-25-57.png](/forum/attachment/45968) ](/forum/attachment/45968 "...9-19-25-57.png")

Here is structure of the table
[ ![screenshot-162.222.225.153-2083-2019.01.29-19-27-50.png](/forum/attachment/45969) ](/forum/attachment/45969 "...9-19-27-50.png")

- [ ![screenshot-162.222.225.153-2083-2019.01.29-19-25-57.png](/forum/attachment/45968) ](/forum/attachment/45968 "...9-19-25-57.png") [ ](/forum/attachment/45968?download=1 "...9-19-25-57.png")
- [ ![screenshot-162.222.225.153-2083-2019.01.29-19-27-50.png](/forum/attachment/45969) ](/forum/attachment/45969 "...9-19-27-50.png") [ ](/forum/attachment/45969?download=1 "...9-19-27-50.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) 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: 86556
- Thank you received: 14305
-
-

7 years 9 months ago [\#303212](#303212) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#303212 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

Hi,

The remaining column has apparently been removed from that table in your mijoshop.
Remove the line: Code:

'download_number' =&gt; '(' . $dl_limit . '- mjd.remaining)'

from the file administrator/components/com_hikashop/helpers/import/mijo.php and run the import again and you should not have the problem.
We'll change the code there as well to avoid the problem for others in the future.

The following user(s) said Thank You: [komir](/forum/user/2810-komir "View komir's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[komir](/forum/user/2810-komir "View komir's Profile")**
- [![komir's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2810-komir "View komir's Profile") Topic Author
- [ Offline](/forum/user/2810-komir)

Less More

- Posts: 127
- Thank you received: 2
- [](https://montaza-namjestaja.com.hr/)
-

7 years 9 months ago [\#303240](#303240) by [komir](/forum/user/2810-komir "View komir's Profile")  Replied by *[komir](/forum/user/2810-komir "View komir's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#303240 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

Hello now, import is OK.
Thank you

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[komir](/forum/user/2810-komir "View komir's Profile")**
- [![komir's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2810-komir "View komir's Profile") Topic Author
- [ Offline](/forum/user/2810-komir)

Less More

- Posts: 127
- Thank you received: 2
- [](https://montaza-namjestaja.com.hr/)
-

7 years 9 months ago [\#303241](#303241) by [komir](/forum/user/2810-komir "View komir's Profile")  Replied by *[komir](/forum/user/2810-komir "View komir's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#303241 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

Hello again now notice, product images and category images are not imported in Hikashop :huh:
Thank you

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) 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: 86556
- Thank you received: 14305
-
-

7 years 9 months ago [\#303242](#303242) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#303242 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

Hi,

If you edit the products/categories in the backend of HikaShop, do you see the image entries there or you just get the message that says that you can drag n drop images there ?
If you do get the image entries, but without the images, it means that the files couldn't be copied. In that case, you can move the files of the images from the upload folder of Mijoshop to images/com_hikashop/upload and it should then find the files.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[komir](/forum/user/2810-komir "View komir's Profile")**
- [![komir's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2810-komir "View komir's Profile") Topic Author
- [ Offline](/forum/user/2810-komir)

Less More

- Posts: 127
- Thank you received: 2
- [](https://montaza-namjestaja.com.hr/)
-

7 years 8 months ago [\#304074](#304074) by [komir](/forum/user/2810-komir "View komir's Profile")  Replied by *[komir](/forum/user/2810-komir "View komir's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#304074 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

> nicolas wrote: Hi,
>
> If you edit the products/categories in the backend of HikaShop, do you see the image entries there or you just get the message that says that you can drag n drop images there ?
> If you do get the image entries, but without the images, it means that the files couldn't be copied. In that case, you can move the files of the images from the upload folder of Mijoshop to images/com\_hikashop/upload and it should then find the files.

This is what I have [ nimb.ws/9CTg1j](https://nimb.ws/9CTg1j)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) 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: 86556
- Thank you received: 14305
-
-

7 years 8 months ago [\#304114](#304114) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#304114 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

So indeed, that means that the link between the products and the images is there.
However, the image files themselves couldn't be copied over.
So take the images you had in MijoShop and copy them in the images/com_hikashop/upload folder and you'll get your images associated with your products automatically.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[komir](/forum/user/2810-komir "View komir's Profile")**
- [![komir's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2810-komir "View komir's Profile") Topic Author
- [ Offline](/forum/user/2810-komir)

Less More

- Posts: 127
- Thank you received: 2
- [](https://montaza-namjestaja.com.hr/)
-

7 years 8 months ago [\#304472](#304472) by [komir](/forum/user/2810-komir "View komir's Profile")  Replied by *[komir](/forum/user/2810-komir "View komir's Profile")* on topic *[Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#304472 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

> nicolas wrote: So indeed, that means that the link between the products and the images is there.
> However, the image files themselves couldn't be copied over.
> So take the images you had in MijoShop and copy them in the images/com\_hikashop/upload folder and you'll get your images associated with your products automatically.

I did that, but, seems to me that problem is Mijoshop saving images in folders related to categories.
Example; have product Child bike and that product is category Vehicles -&gt; bikes -&gt;child bikes
The image for that product is located in folder Mijoshop-&gt; Categories -&gt; Vehicles -&gt; bikes -&gt;child bikes

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[komir](/forum/user/2810-komir "View komir's Profile")**
- [![komir's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2810-komir "View komir's Profile") Topic Author
- [ Offline](/forum/user/2810-komir)

Less More

- Posts: 127
- Thank you received: 2
- [](https://montaza-namjestaja.com.hr/)
-

7 years 8 months ago [\#304474](#304474) by [komir](/forum/user/2810-komir "View komir's Profile")  Replied by *[komir](/forum/user/2810-komir "View komir's Profile")* on topic *[UPDATE Unknown column 'mjd.remaining' in 'field list'](/forum/37-import-export-csv-xls/896762-update-unknown-column-mjd-remaining-in-field-list#304474 "-- HikaShop version -- : 4.01 -- Joomla version -- : v 3.9 -- PHP version -- : 7.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'mjd.remaining' in 'field list'  Hello, I have using Mijoshop v3.2.1 and decide to make the migration to MijoShop. For starters, I have installed the free version, to see is it possible to make import MijoShop to HikaShop. I am using the Croatian language so first install Croatian for HikaShop. After that try to start migration and after step 3 get an error &quot;Unknown column 'mjd.remaining' in 'field list' &quot;")*

Solved. Moved images from every Mijoshop category folder to /images/com_hikashop/upload folder

The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTY3NjItdXBkYXRlLXVua25vd24tY29sdW1uLW1qZC1yZW1haW5pbmctaW4tZmllbGQtbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.107 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
