Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Emoji Problem. Rate Topic   - - - - -

 
  • webus
  • Member
  • Members
  • Join Date: 13-Jul 13
  • 49 posts

Posted 05 April 2018 - 09:23 AM #1

There are text fields on product pages. 

Clients sometimes add emojis to those fields (for example, to gift note) 
and then when they go to their carts, cart looks empty. 

Try this a emoji as sample. 
😀
 
How can we fix this? 
 
Best Regards.


 
  • ikoshkin
  • Tech Writer
  • CS-Cart Architects
  • Join Date: 25-Nov 15
  • 474 posts

Posted 05 April 2018 - 11:14 AM #2

There are text fields on product pages. 

Clients sometimes add emojis to those fields (for example, to gift note) 
and then when they go to their carts, cart looks empty. 

Try this a emoji as sample. 

 
How can we fix this? 
 
Best Regards.


Please refer to this comment, it might help. Note that the comment describes adding emojis to email templates, but a similar method should work for other tables and fields in the database.

 
  • webus
  • Member
  • Members
  • Join Date: 13-Jul 13
  • 49 posts

Posted 05 April 2018 - 11:59 AM #3

@ikoshkin

When we do this process, you say it should fix fields,  right?
 
************
 
1. Open the app/Tygh/Database/Connection.php file.
 
2. Find this part of the code:
 
if (empty($params['names'])) {
     $params['names'] = 'utf8';
}
3. Replace it with:
 
if (empty($params['names'])) {
     $params['names'] = 'utf8mb4';
}
4. Change the collations of the relevant columns from utf8_general_ci to utf8mb4_general_ci. For example, to be able to save emojis in email templates, I had to alter the collation of the subject and template columns in the cscart_template_emails table.


 
  • webus
  • Member
  • Members
  • Join Date: 13-Jul 13
  • 49 posts

Posted 07 April 2018 - 09:46 AM #4

How can we block using emojis in fields section ?



 
  • sahibpkrbw
  • Advanced Member
  • Members
  • Join Date: 16-Aug 12
  • 68 posts

Posted 19 March 2020 - 03:51 PM #5

Hi

 

i have problem to add emojis in description kindly let me know if the solutions is same for that , because when i save the description with the emojis its change to "???????"

 

 

Kindly let me know how to solve it 

 

Thanks



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20672 posts

Posted 20 March 2020 - 05:16 AM #6

Did you try the solution from bug tracker?

 

http://forum.cs-cart...indpost&p=27351


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • sahibpkrbw
  • Advanced Member
  • Members
  • Join Date: 16-Aug 12
  • 68 posts

Posted 20 March 2020 - 08:08 AM #7

Did you try the solution from bug tracker?

 

http://forum.cs-cart...indpost&p=27351

 

bug tracker?

 

is the link is for solution i requested? if yes i understand 1-3 numbers 

but how to do exactly number 4? do you have any video Tutorial`? 

 

4. Change the collations of the relevant columns from utf8_general_ci to utf8mb4_general_ci. For example, to be able to save emojis in email templates, I had to alter the collation of the subject and template columns in the cscart_template_emails table.

 
After that I was able to paste and save emojis to the subject and body of an email template.
 
Many Thanks


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20672 posts

Posted 20 March 2020 - 01:33 PM #8

It can be done, for example, in phpMyAdmin

 

https://prnt.sc/rjncd6

 

https://prnt.sc/rjncv3


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • sahibpkrbw
  • Advanced Member
  • Members
  • Join Date: 16-Aug 12
  • 68 posts

Posted 20 March 2020 - 06:34 PM #9

It can be done, for example, in phpMyAdmin

 

https://prnt.sc/rjncd6

 

https://prnt.sc/rjncv3

 

Hi

 

 

Many thanks for your kind reply, i have changed as you said, i also changed it  to the app/Tygh/Database/Connection.php file. but nothing happend. ive cleard cache, nothing happend!

 

please see the screenshot!

 

https://prnt.sc/rjtnvx

 

any other Suggestion?

 

Thanks



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20672 posts

Posted 23 March 2020 - 05:47 AM #10

Did you change correct table in the database?


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • sahibpkrbw
  • Advanced Member
  • Members
  • Join Date: 16-Aug 12
  • 68 posts

Posted 23 March 2020 - 02:01 PM #11

Did you change correct table in the database?

Hi thanks for the reply please check the screenshot  here i uploaded  https://prnt.sc/rjtnvx



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20672 posts

Posted 24 March 2020 - 05:20 AM #12

Do you want to add emoji to text banners?


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • sahibpkrbw
  • Advanced Member
  • Members
  • Join Date: 16-Aug 12
  • 68 posts

Posted 24 March 2020 - 07:05 PM #13

Do you want to add emoji to text banners?

 

I want to add emoji in title item description and any other text field



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20672 posts

Posted 25 March 2020 - 05:17 AM #14

So you should not change the cscart_banners table. Change the table where the required data is stored


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)