Hello,
I have been trying to import related products for a while but it never worked.
Template import:
First attempt
Action: Import
Component: Virtuemart
Operation: Related products
Fields:
1 product_sku
2 related_sku
My csv:
1 product_sku
2 related_sku separated by |
Attached the log1
Second attempt:
Action: Import
Component: Virtuemart
Operation: Products
Fields:
1 product_sku
2 related_products
Same csv
I attached the log file as well and
I have this error message.
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT p1.virtuemart_product_id AS virtuemart_product_id,p2.virtuemart_product_id AS customfield_value FROM d7bxh_csvi_related_products AS r LEFT JOIN d7bxh_virtuemart_products AS p1 ON r.product_sku = p1.product_sku LEFT JOIN d7bxh_virtuemart_products AS p2 ON r.related_sku = p2.product_sku
Can you please please help?
Hello,
First attempt
Action: Import
Component: Virtuemart
Operation: Related products
Fields:
1 product_sku
2 related_sku
My csv:
1 product_sku
2 related_sku separated by |
Attached the log1
This is the correct way of doing the import but your log file is missing to check on the issue. Also attach the file you used for import so i can test it.
Regarding the SQL error, you can ask your hosting provider. They will be able to modify the database configuration file to fix this.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
its the same file.
I attach it here again.
What exactly should I say to my host provider?
Hello,
Your log file is still missing in the message. If the file is too big please compress and post it.
MYSQL determines whether or not a query is large based on the value of MAX_JOIN_SIZE variable. Since your query is returning more than this number of rows, you are seeing the error. To solve this you can ask your hosting provider to turn on SQL_BIG_SELECTS variable if it is off in mysql configuration file.
Also, one more way to prevent this error is by adding indexes to your table.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
None of the related product are uploaded.
I have tried a million time.
:angry: :(
Hello,
Can you PM us your site login details and db access? I will have a look at the site and check the issue, related products functionality in general is working.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
Please also include FTP login details so we can check what is happening with your import.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.