Post by Fabienlolo » Thu Oct 04, 2018 7:06 am

Hi everybody,
i am running OC 3.0.2 at https://www.vacacionandocancun.com/tours/
As you can see here on my shop and this specific page, https://www.vacacionandocancun.com/tour ... la-Mujeres, i manage 3 different languages so far.
In english and french, full descriptions reach respectively 4425 and 4806 characters (including space, MS Word counting). No issues.
But on my spanish page, description is truncated and limited at 3549 characters (including space, MS Words counting). Truncated because when i first edit my product, full description of 4478 characters is fitting in description field. But after saving and editing a second time it is not. It is truncated at the same character as the front-end view.
If i have different questions (why the difference between the languages ? Is this limitation from SQL database type as read it for other fileds?), the main one is:
Does anyone know how to solve my issue?
Thanks for your support,
Fabien
Last edited by Fabienlolo on Fri Oct 05, 2018 2:11 am, edited 1 time in total.

New member

Posts

Joined
Fri Jun 29, 2018 7:24 am
Location - Q.Roo, Mexico

Post by IP_CAM » Thu Oct 04, 2018 8:37 am

MS Word counting
I would strongly advise you, NOT to use MS-Word, if you create
Content, to be 'shown' in OpenCart. Only clean Text-Editors, like
Notepad ++, should be used for such Tasks.
Just to have it mentioned, WORD is known to implant funny Code ... :D
Ernie
https://notepad-plus-plus.org/news/note ... eased.html

Please don't send Personal OC Forum Messages, contact: jti@jacob.ch
---
Test Site: http://www.bigmax.ch/shop/
Github OC Downloads: https://github.com/IP-CAM
2'200+ FREE OC Extensions from the World's largest Github OC Repository Archive.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by Fabienlolo » Thu Oct 04, 2018 10:21 am

Hi Ernie,
thank you for your advice. I just used MS Word to count characters as i am editing my text in MS NotePad, and my codes with Brackets.
Any clue on what could be the limitations in spanish?
I am not mentioning the short product description on a category page as i know that some settings in the admin interface can do the job.
I am talking about the product page description tab. All 3 languages have been edited with the same MS NotePad (notepad.exe), copied from there and then pasted in the product description, in the admin interface.
I am wandering, is this something similar to this viewtopic.php?t=55502 as i understood that text type in sql is limited to 64KB? Spanish have some specific characters that could weight a few extra bytes. Although i have myself limited knowledge in both in sql query and character weighting.
Any idea?
Thanks all for reading and participating
Fabien.

New member

Posts

Joined
Fri Jun 29, 2018 7:24 am
Location - Q.Roo, Mexico

Post by IP_CAM » Thu Oct 04, 2018 1:23 pm

Well, since spanish uses a lot of special ASCII Code, to display your funny Characters :D
you'll probably have to enlarge the DB Product Description Table Section, with a QUERY like this:

Code: Select all

ALTER TABLE `oc_product_description` CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
I assume at least, since I am far from beeing a DB-Insider. :-\
Found here: ( The oc_ Table Prefix might look different in your Setup!)
http://forum.opencart.com/viewtopic.php?f=20&t=53652
search.php?keywords=Description+Limitation
Good Luck !
Ernie

Please don't send Personal OC Forum Messages, contact: jti@jacob.ch
---
Test Site: http://www.bigmax.ch/shop/
Github OC Downloads: https://github.com/IP-CAM
2'200+ FREE OC Extensions from the World's largest Github OC Repository Archive.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by Fabienlolo » Fri Oct 05, 2018 2:02 am

Hi,
i can divide my experience in 2 steps, as your own solution could be one them
1. From previous post and searches i was thinking that I have to change database product description type from TEXT to MEDIUM TEXT. Unfortunately i did not know how to do that, so I went through more searches and youtube tutorials. This lead me to use my website 'phpMyadmin' interface to access my database.
I found out, that instead of creating a query, I could just modify the field type just using a dropdown menu. (don't have any url for image sorry). Good when your description is actually very, very long and you need extra size.

2. But now that accessed my database i could check product description weight. And i could confirm that a few of them were over 64KB. But why? The notepad file i used for the description in my example in my first post, was barely 5KB when the database was showing me that i was reaching the 64KB. The good thing is that in the 'phpMyadmin' interface i could edit these fields and saw that there was actually plenty of extra code, meaning that in some moment i used some editor (for translation, correction, etc..) that added code when copying from it and pasting it in my product, just like Ernie suggested. So actually, I moved back to original type field and deleted all extra code, whether re-editing from OC admin interface (deleting the invisible code in front of my text, some time the little extra space i did not notice), or deleting product description data directly in database when re-editing was not enough.

Conclusion: beware of your text editor (wether it is for some corrections, translations, etc..), and before changing your database field type, make sure that you don't have unncessary code over-weighting it. And if you actually need to do so, i guess you might find a way in your database admin interface with a tool that avoid you to add a query in some place you don't even know where and how.

Thank you Ernie for your support,
And everyone who posted similar issues and tutorial around the net.
Fabien.

New member

Posts

Joined
Fri Jun 29, 2018 7:24 am
Location - Q.Roo, Mexico
Who is online

Users browsing this forum: No registered users and 25 guests