Resolved DB Errors during install

Hi again,

I made a mistake and imported data with ids. Is there any way to delete just the products and categories, but nothing else in VM and perform the import again?

Thanks in advance.

Yep, set Image processing to Yes resolved it.
Best support in Joomla community. I will review the extension in Joomla.org
Thanks a million!

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.

You got me! No I was not selecting a template. As soon as I did it worked. Thanks a lot! However, although I have selected to use the headers as configuration, it did not get the images. Do I still need to add those fields in the template configuration?

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.

Hi Roland,

I am trying to import a VM categories export file.
The error I get is: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 SQL=SELECT name FROM pkbsj_csvi_template_settings WHERE id =
Although I activate the collect debug information, I don't see any further error. (No log entries found)

Please advise.

Thanks in advance!

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.