DB Errors during install #7145

Hello,

I moved your topic to it's own thread because "Same problem" doesn't apply when you respond to a thread with 2 problems. Nor do I see any similarities between your issue and the one posted in the other thread.

You did not post the debug log a requested at the top under Looking for a useful answer? so I can't help you to see where the problem is. Nor do I know what your problem is or if you get an error.

Please post what is requested under Looking for a useful answer? and we can see how to solve it. It may have to do with the delimiters you have chosen, you can just use comma and double-quotes instead of these odd ones.

Hello,

Just to be sure, you did select a template before you start the import, correct? You can verify that by looking at the URL, it should have the template_id=xx set.

Something else you can check is if there are any JavaScript errors. The Using Firebug to analyze import problems explains how to do that. Let's see if that gives any information.

No I was not selecting a template.

In that case CSVI has no clue what you want to do :)

Do I still need to add those fields in the template configuration?

Not if you set to use headers as configuration but check the Image tab if you have set Image processing to Yes, otherwise post the debug log.

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.

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

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?

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?

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.

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.

• patch_category_20150220.zip

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.

• patch_category_20150221.zip

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.

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.

Please see the patch in your other thread.