1. emperor
  2. RO CSVI
  3. Wednesday, 14 March 2018
  4.  Subscribe via email
Hello! I am trying to import some virtuemart products but when i do the import, my front page gets destroyed and instead of my normal front end i get a page with only these displayed:

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 'OR CATEGORY.VIRTUEMART_CATEGORY_ID = 2 OR CATEGORY.VIRTUEMART_CATEGORY_ID = 18 O' AT LINE 39


I found that when i remove category_id field the site wont crash. All categories are already created in the site, so the IDs are copy-pasted from there. Products have multiple categories each. Please have a look at the attached file.

Could you understand what is causing the crash?
Accepted Answer Pending Moderation
Hello,
Checking the debug log, there is no problem i could see with import of categories into the database. So i ran the import with your file and having categories already entered in database with ids as in your file and don't see the SQL error on frontend. I am thinking if this has something to do with your VirtueMart code loading on frontend. One other thing you can check is that when you go to VirtueMart products page on backend do you see the categories for the product in Product categories field?
Kind regards,

Tharuna

=========================
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
Accepted Answer Pending Moderation
Hello sorry. I've posted the wrong csv file. The one i've posted is not crashing the DB.
The correct CSV:
yannicollections-products-exports-forum.csv

On the csv file you can see that each product has multiple categories.

The image i've posted is the home page of the website. Instead of the normal slider, images text etc, i get this.

yannicollections-products-exports-forum.csv Capture.JPG



This is the debug log:
com_csvi.log.22.zip
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
I am trying to import some virtuemart products but when i do the import, my front page gets destroyed and instead of my normal front end i get a page with only these displayed:

Can you post a screenshot on where you see this error?

I found that when i remove category_id field the site wont crash. All categories are already created in the site, so the IDs are copy-pasted from there. Products have multiple categories each. Please have a look at the attached file.


The import file you have posted don't have a category_id field. There is a related_categories field and that is empty. Is this the file you used for import? Also, can you post your import debug log to check? To know on how to get the debug log check Where to get debug information? document.
Kind regards,

Tharuna

=========================
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. # 3
  • Page :
  • 1


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