Categories
View Replies (11)

Resolved ICECAT data loading stops

  1. fatelettronica
    fatelettronica
  2. RO CSVI
  3. Sunday, 17 September 2023
  4.  Subscribe via email
Dear Tharuna
ICECAT data loading stops with this error:
"Data too long for column 'model_name' at row 493"
The number of lines loaded is 2120000 instead of 3608621.
the file is from the "OPEN" subscription

RO CSVI 8.8.0
Joomla 4.3.4
VirtueMart 4.0.12 10777
PHP 8.1.17
Attachments (1)
Icecat_493.pdf
0
Responses (11)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The field model_name must be having data longer than as defined in database.

1. Load the attached patch file
2. In CSVI About page click on Verify database
3. Run ICECat loading and check.

If you still have problem send us the ICECat details you are using and we can check.
Attachments (1)
patch_icecat_2023_09_18.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 1
fatelettronica
fatelettronica
Accepted Answer Pending Moderation
I followed your instructions but the error is still there:
"Data too long for column 'model_name' at row 355"

This time it stopped at 2105000 lines.

The file used is the "open icecat" one

Greetings

Lorenzo
  1. 6 days ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Lorenzo,
Please post the ICECat link details you are using. We can run the ICEcat indexing in our test site and check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 5 days ago
  2. RO CSVI
  3. # 3
fatelettronica
fatelettronica
Accepted Answer Pending Moderation
Hi Tharuna
These are the links used.
http://data.icecat.biz/export/freexml.int/it/files.index.csv
http://data.icecat.biz/export/freexml.int/it/supplier_mapping.xml
Greetings
  1. 5 days ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Lorenzo,
Thank you for the links. With these ICECat links I see 211000 loaded and without any error. That is with the change sent in patch file. See attached screenshot.

Can you please check #__csvi_icecat_index table and see what is defined for model_name field? See attached screenshot.
Attachments (2)
Screenshot 2023-09-20 at 7.23.31 PM.png Screenshot 2023-09-20 at 7.23.31 PM.png
Screenshot 2023-09-20 at 7.26.21 PM.png Screenshot 2023-09-20 at 7.26.21 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 5 days ago
  2. RO CSVI
  3. # 5
fatelettronica
fatelettronica
Accepted Answer Pending Moderation
dear Tharuna

I checked the "model name" field. it is defined as per your screenshot.
Now I'll try to load the database again
regards
Attachments (1)
model_name.pdf
  1. 5 days ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Lorenzo,
How did the ICECat index load? Did it go without any error?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 4 days ago
  2. RO CSVI
  3. # 7
fatelettronica
fatelettronica
Accepted Answer Pending Moderation
dear Tharuna

It ended with the usual error at 2,100,000 lines
The Icecat xml file contains about 3,000,000 lines if I'm not mistaken.
In the afternoon I will try to reload the patch.

regards
  1. 4 days ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Lorenzo,
We found that a product in ICECat file with text enclosure is the cause for this problem. Can you please load the attached modified patch file and run the ICEcat index again?
Attachments (1)
patch_icecat_2023_09_21.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 4 days ago
  2. RO CSVI
  3. # 9
fatelettronica
fatelettronica
Accepted Answer Pending Moderation
Dear Tharuna

I'm sorry but there is still the error:
"Data too long for column 'model_name' at row 6467"
Regards
  1. 4 days ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Lorenzo,
Just to confirm, Did you load the modified patch file sent with my last reply and ran the ICECat index?
Kind regards,

Tharuna

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


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