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
- fatelettronica
- RO CSVI
- Sunday, 17 September 2023
- Subscribe via email
Attachments (1)
0
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.
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)
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
"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
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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.
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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)
Accepted Answer
Pending Moderation
Hello Lorenzo,
How did the ICECat index load? Did it go without any error?
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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?
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)
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
I'm sorry but there is still the error:
"Data too long for column 'model_name' at row 6467"
Regards
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?
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »