Categories
View Replies (20)

Resolved Issue when trying to assign images to products?

  1. Dtorr1981
    Dtorr1981
  2. RO CSVI
  3. Friday, 01 July 2016
  4.  Subscribe via email
Hi Rolandd,

I have finally got my site onto a new server, so to celebrate i thought i would completely redevelop it so i know there are no existing issues being propagated over. So, I am creating test imports before i format and import all my product details. I have tried to run a simple product_sku - file_url import, but the last server response just continues counting and nothing gets imported (no time outs). I then attempted a product import with custom fields, but this is having the same behaviour?
The error message for the product import is:
An error has occured during the import. Below the information received from the server.
Status error: 200
Status message: OK

Fatal error: Maximum execution time of 120 seconds exceeded in /home/ladyloving/public_html/staging/administrator/components/com_csvi/helper/image.php on line 844


The code around this line is:

while ($this->file_out_width < 1 || $this->file_out_height < 1)

		{

			$this->file_out_width *= 2;

			$this->file_out_height *= 2;

		}


The error message for the product_sku/file_url is:

An error has occured during the import. Below the information received from the server.
Status error: 0
Status message: error


I have attached the log files for your review? I'm guessing this is an issue with the images but i cant for the life of me figure out what?

Regards
Donna
0
Responses (20)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Donna,
I see that you have set the option Override system limits?: Yes in your template settings and given a value of 120. What happens if you set this option to No and run the import?
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
Dtorr1981
Dtorr1981
Accepted Answer Pending Moderation
Thanks for your swift response.

I still get the same behaviour? It did run yesterday a couple of times, so im really not sure what is causing the issue.It just keeps counting?

The image import throws an error 0? Its all very odd. I have attached the image import csv files and have exported the template to help with trouble shooting
  1. more than a month ago
  2. RO CSVI
  3. # 2
Dtorr1981
Dtorr1981
Accepted Answer Pending Moderation
The saga continues, I am trying to test a stockable custom field import and im getting the following error.

Status error: 200
Status message: OK

Fatal error: Uncaught TypeError: Argument 1 passed to Com_VirtuemartHelperCom_Virtuemart::__construct() must be an instance of CsviHelperTemplate, none given, called in /home/ladyloving/public_html/staging/administrator/components/com_csvi/helper/template.php on line 222 and defined in /home/ladyloving/public_html/staging/administrator/components/com_csvi/addon/com_virtuemart/helper/com_virtuemart.php:105 Stack trace: #0 /home/ladyloving/public_html/staging/administrator/components/com_csvi/helper/template.php(222): Com_VirtuemartHelperCom_Virtuemart->__construct() #1 /home/ladyloving/public_html/staging/administrator/components/com_csvi/addon/com_virtuemart/model/import/product.php(710): CsviHelperTemplate->get('language') #2 /home/ladyloving/public_html/staging/administrator/components/com_csvi/rantai/import/model.php(426): Com_VirtuemartModelImportProduct->loadTables() #3 /home/ladyloving/public_html/staging/administrator/components/com_csvi/rantai/rantai.php(118): RantaiImportModel->runImport() #4 /home/ladyloving/pub in /home/ladyloving/public_html/staging/administrator/components/com_csvi/addon/com_virtuemart/helper/com_virtuemart.php on line 105


I have attached the import file for this import too. I did not add the fields into the template for this import, i let it recognise them its self. I followed the tutorial also.

I am going to attempt to reinstall the component and try again.
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

For this particular error, check your template on the Options tab. See if there is a language selected and save the template again. This looks like the issue with not having a language set in the template.
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
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Donna,
For the stockable custom field import, can you try setting a language on options tab in your template and see if it solves the error?
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. # 5
Dtorr1981
Dtorr1981
Accepted Answer Pending Moderation
Hello,

For this particular error, check your template on the Options tab. See if there is a language selected and save the template again. This looks like the issue with not having a language set in the template.


Ah Silly oversight on my part. The import ran but i had a front end error occur so am now doing restore. I'll post back once i've tested it fully?

Any ideas about the Image import issue?

Regards
Donna
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Donna,
Any ideas about the Image import issue?

I see something in your import file, you are trying to add images to one product with multiple rows. You can add multiple images to a product using | symbol. So value will be like image1|image2|image3. Can you try to change this and try the import?
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. # 7
Dtorr1981
Dtorr1981
Accepted Answer Pending Moderation
Hello Donna,
Any ideas about the Image import issue?

I see something in your import file, you are trying to add images to one product with multiple rows. You can add multiple images to a product using | symbol. So value will be like image1|image2|image3. Can you try to change this and try the import?


Yes not a problem, i'll give it a go. I will need to be away from my computer for a while but will try it when i get back.

Additionally, my stockable variants import and the backend is fine however, when i visit the front end im getting : 0 - Class 'CurrencyDisplay' not found

I have restored the site once already after the first attempt and thought it was a joomla/VM issue but it has occurred again after the import.

Regards
Donna
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Donna,
One more thing I need from you is the images you are trying to import.I doubt the issue could be with size of the images. Can you send a private message of the images you have in your import file? I will test the import here and see what happens.
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. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Donna,
Thank you for sending your images and as i guessed it seems to be problem with your images. The import doesn't get through for me with your images. I am checking on it, will keep you posted on what i find.
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. # 10
Dtorr1981
Dtorr1981
Accepted Answer Pending Moderation
Hello Donna,
Thank you for sending your images and as i guessed it seems to be problem with your images. The import doesn't get through for me with your images. I am checking on it, will keep you posted on what i find.


Ok, thank you. I have tested again today, and the image import worked (very odd) however, im now having an issue with a product import with custom fields. It just freezes one processed reaches 950? The server response counter freezes and the page just stays like that (no error message.

I'm starting to wonder if this is some sort of issue with the server, seeing as the problems tend to be intermittent. This particular issue seems to occur when trying to run a delete query:

DELETE  FROM `jos_virtuemart_product_customfields` WHERE `virtuemart_product_id` = 2021 AND `virtuemart_custom_id` = 9


Again I have attached the logfile and template. Its all very odd from my point of view.

Best Regards
Donna
  1. more than a month ago
  2. RO CSVI
  3. # 11
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Donna,
Ok, thank you. I have tested again today, and the image import worked (very odd)

The issue i found was that you had set Resize large image to Yes in your template settings on images tab and also Full image width and Full image height fields are empty. By default these width and height field values are taken as 0, and so the while loop was going infinite checking these values as 0 < 1 in the code you posted on other day. If you need to resize your images, you need to have Full image width and Full image height field values set.

im now having an issue with a product import with custom fields. It just freezes one processed reaches 950? The server response counter freezes and the page just stays like that (no error message.

I'm starting to wonder if this is some sort of issue with the server, seeing as the problems tend to be intermittent. This particular issue seems to occur when trying to run a delete query:

I just tested your file with your template and import went good. Can you check your server logs if there is any error which is logged once 950 is reached?
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. # 12
Dtorr1981
Dtorr1981
Accepted Answer Pending Moderation
Thank you again, My server logs are empty, (even with debugging enabled, log_erros = on) so i'm going to request an apache restart. In the meantime, could this have anything to do with max_execution_time/max_input_time in my php.ini? If so what would be the recommended settings?

Regards
Donna
  1. more than a month ago
  2. RO CSVI
  3. # 13
Dtorr1981
Dtorr1981
Accepted Answer Pending Moderation
Ok,

I'm still not getting any errors reported, however, in all of the log files the import stops on a Delete query, and it seems the field that is common in all is where the `virtuemart_custom_id` = 9. This seems to refer to the custom field 'Size (Met):' from my import, which has a value of 69.1mm × 69.1mm × 166.4mm. In this particular example, the product which caused the failure had a sku of N10007, custom_title = Size (Imp):~Size (Met):~Power:~Material:, custom_value = 2.7" x 2.7" x 6.55"~69.1mm × 69.1mm × 166.4mm~None Required ~Tpe.

Could there be some DB restrictions for the field, preventing it being processed maybe?

Regards
Donna
  1. more than a month ago
  2. RO CSVI
  3. # 14
Dtorr1981
Dtorr1981
Accepted Answer Pending Moderation
Ok, i seem to be getting somewhere, I am using " to denote Inches, thus it appears that anything after the first " is not imported. Looking at this, the product where is stops has 2.7" x 2.7" x 6.55" as the Size (Imp): value, on check ing the product in the backend it seems the value for Size (Imp): has been imported as 2.7 (the rest is omitted) so i'm guessing i may need to set the delimiters manually in the import, rather than allow them to be identifed from the file.

I'll post back.

Regards
Donna
  1. more than a month ago
  2. RO CSVI
  3. # 15
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Donna,

Just a note about using " to denote inches. That is all fine but you will need to duplicate them according to the CSV standard. See this example:
"product_sku","Size"
"ABC","2.7"" x 2.7"" x 6.55""~69.1mm × 69.1mm × 166.4mm"

Now PHP knows that your " belong to the value and are not the actual delimiters.
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. # 16
Dtorr1981
Dtorr1981
Accepted Answer Pending Moderation
Hello Donna,

Just a note about using " to denote inches. That is all fine but you will need to duplicate them according to the CSV standard. See this example:
"product_sku","Size"
"ABC","2.7"" x 2.7"" x 6.55""~69.1mm × 69.1mm × 166.4mm"

Now PHP knows that your " belong to the value and are not the actual delimiters.


Hi Rolandd, i have now replaced the " with an In to denot inches, but the file still gets stuck on the same product. The Size (Imp): field is now imported in its entirity, but the Size (Met): field does not import at all, and again gets stuck before the Query for ProductCustomField line. I have again attached the logfile. This is really confusing me now. I cannot see anything else which could be preventing this product from importing?

Regards
Donna
  1. more than a month ago
  2. RO CSVI
  3. # 17
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Donna,
I was able to replicate your issue with your file. The problem is with X symbol between your custom_values field, it is read as 80.8mm � 80.8mm � 190.3mm. You need to correct these characters for your custom_values to fix the issue. You can UTF-8 encode your import file and try doing the import.
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. # 18
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Donna,
I missed to link the document on how to make a CSV file UTF-8 encoded in my previous post. Please check the document here.
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. # 19
Dtorr1981
Dtorr1981
Accepted Answer Pending Moderation
Hello Donna,
I was able to replicate your issue with your file. The problem is with X symbol between your custom_values field, it is read as 80.8mm � 80.8mm � 190.3mm. You need to correct these characters for your custom_values to fix the issue. You can UTF-8 encode your import file and try doing the import.


OOooh it works, I UTF-8 encoded the file and the import succeeded. Amazing. Thank you for all your support with this issue, i can now go pack to the image import and test the solution for that also.

Have a great day.

Donna
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1


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