Post by michael2820 » Sat Jan 14, 2017 6:45 pm

No line breaks in review: This has been annoying me for years. Lately I have learned a bit about phpMyAdmin, so I looked for the field in the DB. I found table "reviews_description" and edited "email_message" to type = MEDIUMTEXT by clicking CHANGE.

if you trust me :D it is easier to click SQL and execute:

Code: Select all

ALTER TABLE  `reviews_description` CHANGE  `email_message`  `email_message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
it works for me version 2.1.0.2

--- please reply only with verified data, that is: no 'I think', 'maybe' etc. ---


User avatar
Active Member

Posts

Joined
Sun May 15, 2011 8:16 pm
Location - Denmark ver. 2.1.0.2

Post by OSWorX » Sat Jan 14, 2017 8:10 pm

Must be a custom extension because OC native has no reviews_description.

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Guru Member
Online

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by michael2820 » Sun Jan 15, 2017 6:56 am

I just copied the message after I had done it. As far as I know, I have no ext. doing anything with reviews.

Image

--- please reply only with verified data, that is: no 'I think', 'maybe' etc. ---


User avatar
Active Member

Posts

Joined
Sun May 15, 2011 8:16 pm
Location - Denmark ver. 2.1.0.2

Post by OSWorX » Sun Jan 15, 2017 5:49 pm

Quite strange, because the reviews structure is since 1.5.x always the same:
review.png

review.png (4.52 KiB) Viewed 2342 times

review_structure.png

review_structure.png (14.5 KiB) Viewed 2342 times


Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Guru Member
Online

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by michael2820 » Sun Jan 15, 2017 10:13 pm

I have installed - and tried to remove them - some themes like ShopMe and Journal, and maybe some stuff is hanging in my DB ;-) I am not as good as you are in the techn. stuff. Greetings from DK

--- please reply only with verified data, that is: no 'I think', 'maybe' etc. ---


User avatar
Active Member

Posts

Joined
Sun May 15, 2011 8:16 pm
Location - Denmark ver. 2.1.0.2
Who is online

Users browsing this forum: No registered users and 15 guests