Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 23 Dec 2020, 21:23
marc276 marc276 is offline
 
Join Date: Dec 2020
Arrowchat + Vbulletin encoding issue

I've vbulletin 4.2.0, where arabic usernames are written to mysql in wrong chars but vb displays them correctly.

last week I added arrowchat, where they display them like how they are written into database.

Their support don't want to support me in this unless I give them FULL access to my database + full access to the file manager (to fix encoding in arrowchat files)

I asked why they want that, and provided FTP to their arrowchat directory but refused to help without accessing my database and vb files !!!!!

anyone faces such issue and know how to fix it? + I started to have doubts in arrowchat support who are not reasonable and asking for full access to a customer db ! (the weirdest request ever)
Reply With Quote
  #2  
Old 23 Dec 2020, 22:50
yilmaz's Avatar
yilmaz yilmaz is offline
 
Join Date: Sep 2004
To change the utf8mb4 character encoding in the config.php file, you need ftp access.
__________________
Donations always appreciated.
vByilmaz.com
vBulletin-forum.de
Nobody has a monopoly on vBulletin templates. Stay away from selfish, self-righteous and parasitic.
Reply With Quote
  #3  
Old 24 Dec 2020, 13:02
marc276 marc276 is offline
 
Join Date: Dec 2020
Hello,
Of course it needs ftp access, and that what I provided to them FTP access to arrowchat directory but they refused and asked for the full access to vb + arrowchat + phpmyadmin !!

Anyway they can tell me which encoding I need to make it works (change the utf8 to what), as they refuse to tell me ! also I tried many other encodings but not working.

Last edited by marc276; 24 Dec 2020 at 13:08.
Reply With Quote
  #4  
Old 24 Dec 2020, 17:01
yilmaz's Avatar
yilmaz yilmaz is offline
 
Join Date: Sep 2004


Identifies arabic letters if you save the comparison setting for phpMyAdmin arrowchat tables as utf8_unicode_ci or utf8mb4_unicode_ci

It is enough to change the comparison of the names and texts in which field.
__________________
Donations always appreciated.
vByilmaz.com
vBulletin-forum.de
Nobody has a monopoly on vBulletin templates. Stay away from selfish, self-righteous and parasitic.
Reply With Quote
  #5  
Old 25 Dec 2020, 20:35
marc276 marc276 is offline
 
Join Date: Dec 2020
the table is already utf8_unicode_ci



the user is shown like this as created by vbulletin 4.2.0


Vbulletin convert it and shows it correctly in my forum but Arrowchat showing it as is.
Reply With Quote
  #6  
Old 26 Dec 2020, 12:29
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Change the table to utf8mb4 as well, doubt that will fix it.

The arrowchat code may be incorrect as well.
Reply With Quote
  #7  
Old 28 Dec 2020, 11:49
marc276 marc276 is offline
 
Join Date: Dec 2020
Originally Posted by snakes1100 View Post
Change the table to utf8mb4 as well, doubt that will fix it.

The arrowchat code may be incorrect as well.
no it won't..
Arrowchat the worst support ever.
Reply With Quote
  #8  
Old 31 Dec 2020, 15:31
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
 
Join Date: Sep 2008
Real name: Michael Miller Jr
What version of vBulletin (if 4, then 4.2.1 or 4.2.3 etc) and what version of the mod are you using? You could possibly be using a mod version not compatible with your version of vBulletin.

If there is a thread here for this mod, you should post there asking for assistance as well.
__________________
Daddy Does Dios and Figs!

Search - Use the search feature to find similar issues/answers.
Information - Include screenshots, copy/pasted error codes, url etc.
Fixed - Please return to your thread/post and let us know how it was fixed!
Thanks - For participating! Click the "Like" on a post if someone helped you!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:25.

Layout Options | Width: Wide Color: