Categories
View Replies (6)

Resolved Error 1064

  1. london_may
    london_may
  2. RO CSVI
  3. Wednesday, 24 June 2015
  4.  Subscribe via email
Hello. When trying to do a simple product import, I keep getting the following message:

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 idaew_csvi_template_settings WHERE id =

This is a brand new install on a brand new site. I am using:

CSVI 5.21.2
Joomla 3.4.1
Virtuemart 3.0.8

I have been using CSVI for a number of years and I have never seen such an error before.

Any help would be most appreciated. Thank you.
0
Responses (6)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

CSVI is missing the template ID. The question then becomes did you select a template from the process page and choose Load?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
london_may
london_may
Accepted Answer Pending Moderation
Hello. Thank you for the quick reply. No, I didn't select a template, I never have had the need to use a template, I simply selected product import, selected my file and did everything as per usual. Thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 2
london_may
london_may
Accepted Answer Pending Moderation
Hello. Can I please get some assistance with this issue? As mentioned, I didn't actually select a template at all, I just simply selected product import and then selected the import file. This is my first attempt at using CSVI with Joomla 3/VM 3. I have been using the product for around 5 years and have never really had any issues at all, until now. Any help would be most appreciated. Thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Apologies, I was under the impression you got it working again. Since this is not the case, let's see what is going on. First, can you create a template by selecting the import as you usually do just don't select your file for import but click on Save as new and enter a template name. After that select the file you want to import and run the import.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
london_may
london_may
Accepted Answer Pending Moderation
Thank you for your help. That works fine - I've been able to process the import successfully. Does this mean though, that each time I want to process a new import, I have to setup a template? I normally never use templates and just process the import straight from the file. I would not want to setup a new template each time I was to perform an import of different types? Thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Does this mean though, that each time I want to process a new import, I have to setup a template?
No, that doesn't mean this. You would just have 1 template for product import, select that and hit Load. Then select your file and hit Import.

I would not want to setup a new template each time I was to perform an import of different types?
You can have 1 template for product import, 1 template for category import etc. From what I understand you just do different kinds of product imports, for that you can just reuse the template you have created.

Does that help?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!