Resolved DB Errors during install

Please see the patch in your other thread.

I hope this debug log would help you more. I created a copy of the environment in order to continue testing and find the problem (j31). I need to deliver the current (j30), so I cannot afford to make any more tests on it.

The categories that are not updated are the subcategories, under "Dog Bows" category, like "Glam Bows 3/4", "Maltese Glam Bows 5/8", etc.

I see, in that case I need a more complete debug log. The log you posted only has the first 5 entries and your first subcategory comes at tline 13. I suggest you change the number of debug lines from 5 to 50 in the Settings of CSVI. After that run your import again and I can check the other rows.

Also, what about the issue about not importing other languages other than the default (Greek)?

I have answered you in the other thread. Should not be mixing questions as it makes it impossible to follow.

The category you mentioned is a main category. The categories that are not updated are the subcategories, under "Dog Bows" category, like "Glam Bows 3/4", "Maltese Glam Bows 5/8", etc.
Also, what about the issue about not importing other languages other than the default (Greek)?

Hello,

The patch has nothing to do with the templates. The patch only concerns 1 file and that is the categoryimport.php file. I have no idea how you managed to do that. Especially since every field is there now 8 times. Well you could select them all and unselect the ones you need and then delete the others. Before you do that, log out first and then login to make sure it is nothing to do with caching or session.

As for the image import, it does look good to me. Check this:

UPDATE `pkbsj_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='',`file_description`='',`file_meta`='',`file_mimetype`='image/jpeg',`file_type`='category',`file_url`='images/stories/virtuemart/category/jpg77854117.jpg',`file_url_thumb`='images/stories/virtuemart/category/resized/jpg77854117_200x200.jpg',`file_is_product_image`='0',`file_is_downloadable`='0',`file_is_forSale`='0',`published`='1' WHERE `virtuemart_media_id`='58'

The image files are set correctly for this category, this is category Hand Painted.

There must be something wrong with the patch, because after I applied it at the J25 installation, were I make the exports, it messed up with all the templates by multiplying the fields. In fact the export file is now bigger, because it contains duplicated information. I attach a screen shot.

Hi Roland,

I tried the patch, but it did not resolve the subcategories images processing issue.
What are the issues the patch resolves?

Hello,

There was a mistake in the patch file, attached is a new one that should fix the issues.

Let me know how it goes.

Thanks Roland,

I applied the patch to the export Joomla installation and to the Import Joomla installation. I emptied the db and reimported.
Although the categories look fine now, the images of the subcategories are still not processed.
I attach the log and the csv.

Thanks in advance.

Hello,

Attached is a patch file you can load via the Maintenance menu -> CSVI Pro -> Load patch. After that run your category import and see if it works for you.

I tried to use your file but it is unreadable here, so I used my own for testing.

Thanks Roland,

By saying that the problems remain, I meant that / change did not affect the problems.

I am waiting for you to check and let me know.

The rest of the problems remain.

What do you mean by "the rest"?

Of course the image problem won't change since I haven't checked yet and I said I will check. The problem with the thumbnail is that you have the full path in your CSV file and CSVI adds the preceding path to it. You can wait for me to get back to you before you try again importing your images.

As for the | separator you can only use that in the category import and not in the product import because it is a reserved character for specifying multiple categories.

I discovered that there were category names that contained forward slash "/" in their names so I replaced the template's "/" with "|". I erased the VM db again and reimported. However, only the names of these categories came up right. The rest of the problems remain. I attach the csvs and the logs.

Thanks in advance.

Edit: I don't know if this helps, but I export from J2.5 & VM2 and import to J3 & VM3.

The category images have a problem, look at this:

UPDATE `pkbsj_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='',`file_description`='',`file_meta`='',`file_mimetype`='image/jpeg',`file_type`='category',`file_url`='images/stories/virtuemart/category/jpg77854117.jpg',`file_url_thumb`='images/stories/virtuemart/category/images/stories/virtuemart/category/resized/jpg77854117_200x200.jpg',`file_is_product_image`='0',`file_is_downloadable`='0',`file_is_forSale`='0',`published`='1' WHERE `virtuemart_media_id`='58'

The thumbnail images have a weird path. The folder structure is duplicated. That will be the reason why you don't see thumbnails. The full image you should see unless that path is incorrect.

Also, the site's main language is Greek. I tried to import the English, but it didn't import them. I used the way it's described for VM2. I don't know if there are instruction for VM3.

That still works the same. You need the trans field and language setup correctly in the template.

Let's focus on the images first. I will check what happens with your thumbnail image. Are you still using the same file as you posted in the first thread?

I was talking about the payment ways,

I have uploaded the log as you requested. I emptied the db again and reimported, but still there are no pictures at the subcategories.

Also, the site's main language is Greek. I tried to import the English, but it didn't import them. I used the way it's described for VM2. I don't know if there are instruction for VM3.

Thanks again.

I erased the db, sadly it erased the payment was too.

We must be talking about something else then, not the order payments in that case.

You have error reporting set to the highest possible level, that is not needed. Go to Global Configuration -> Server -> Error Reporting and set it to System default or None.

Edit: I also noticed that the images of the subcategories are not processed.

Where is your debug log?

I erased the db, sadly it erased the payment was too.
When I tried to import again, I get:
Oops something went wrong.

Let me try to show the warning below here. If nothing shows up then I didn't get any data, sometimes this is caused by faulty plugins.

Cancel the import and check if all settings are correct and try the import again. Status error: 200 Status message: OK Strict Standards: Non-static method Com_VirtueMart::createSlug() should not be called statically, assuming $this from incompatible context in /home/dogbowsg/http://dogbows.gr/html/j30/administrator/components/com_csvi/tables/com_virtuemart/manufacturers_lang.php on line 219 Strict Standards: Non-static method Com_VirtueMart::createSlug() should not be called statically, assuming $this from incompatible context in /home/dogbowsg/http://dogbows.gr/html/j30/administrator/components/com_csvi/tables/com_virtuemart/categories_lang.php on line 117 Strict Standards: Non-static method Com_VirtueMart::createSlug() should not be called statically, assuming $this from incompatible context in /home/dogbowsg/http://dogbows.gr/html/j30/administrator/components/com_csvi/tables/com_virtuemart/categories_lang.php on line 117 Strict Standards: Non-static method Com_VirtueMart::createSlug() should not be called statically, assuming $this from incompatible context in /home/dogbowsg/http://dogbows.gr/html/j30/administrator/components/com_csvi/tables/com_virtuemart/categories_lang.php on line 117 Strict Standards: Non-static method Com_VirtueMart::createSlug() should not be called statically, assuming $this from incompatible context in /home/dogbowsg/http://dogbows.gr/html/j30/administrator/components/com_csvi/tables/com_virtuemart/categories_lang.php on line 117 Strict Standards: Non-static method Com_VirtueMart::createSlug() should not be called statically, assuming $this from incompatible context in /home/dogbowsg/http://dogbows.gr/html/j30/administrator/components/com_csvi/tables/com_virtuemart/categories_lang.php on line 117 {"view":"","records":502,"process":false,"url":"http:\/\/dogbows.gr\/j30\/administrator\/index.php?option=com_csvi&task=process.finished&run_id=1424284296"}

Edit: I also noticed that the images of the subcategories are not processed.

The orders and related information like users are all kept. Only product related information is removed.

I need to keep the payments, etc. The thing is that since I made this mistake, I don't see the products in vm, in order to delete them and I get duplicate errors on import, due to duplicated skus. Maybe I should delete them at phpmyadmin. What do you think?

Hello,

You can go to Maintenance and choose VirtueMart and then select Empty database. This will empty the database and you can start clean. It does delete a bit more than that but your shop settings and everything will remain intact.

The other way is of course to list all products/categories and select and delete them.