Categories
View Replies (5)

Resolved Related products import won't run

  1. itbsltd
    itbsltd
  2. RO CSVI
  3. Friday, 23 January 2015
  4.  Subscribe via email
Joomla: 3.3.6
Virtuemart: 3.0.2
CSVI: 5.20
PHP: 5.3.29
MySQL: 5.1.73

I have exported the file from Joomla 2.5 website trying to import into the new website. Tried on 2 dedicated servers and 2 Joomla installs an old 2.5 website and get an error there as well. I've run another import where I removed the related products column and added cat path & published and that ran fine.

Any ideas?
0
Responses (5)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Can you email or private message me login details and the URL of your site? I will take a look to see if I can find what is happening. Can I import the ideal-related22.csv file you posted earlier?
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
itbsltd
itbsltd
Accepted Answer Pending Moderation
Seems strange that product is listed fine in the database looks fine to me.
Attachments (1)
csvi-3.jpg csvi-3.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Form what I can tell looking at your debug log the product query is not ending successful because it can't find the product in the language table.

SELECT virtuemart_product_id FROM jos_virtuemart_products_en_gb WHERE `virtuemart_product_id` = 6984
This request returns 0 results, because of that no related products are being processed. Does this ID exists in the jos_virtuemart_products_en_gb table? If not, you may need to do a clean import of this product before testing the related 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. # 3
itbsltd
itbsltd
Accepted Answer Pending Moderation
Sorry it didn't give me option.

I've found it now for you.
Attachments (2)
com_csvi.log.1422054755.zip
csvi-2.jpg csvi-2.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
There are a number of issues. First where is the debug log? It looks like you are missing the default custom field for related products that VirtueMart creates on installation. CSVI can't find any entry in the virtuemart_customs table that is of the field_type R. Check to see if this is in your database, if not, you will need to fix this.
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. # 5
  • Page :
  • 1


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