Mix of collations utf8_unicode_ci
Oops!
Something went wrong and we couldn’t process your request.
Please go back to the previous page and try again.
If the problem persists, please contact us.
Back to Homepage
For additional assistance, please reference the WHMCS TroubleShooting Guide »
PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation ‘like’ in /home/xxx/public_html/whmcs/vendor/illuminate/database/Connection.php:331
Stack trace:
#0 /home/xxx/public_html/whmcs/vendor/illuminate/database/Connection.php(331): PDO->prepare(‘select * from `…’)
#1 /home/xxx/public_html/whmcs/vendor/illuminate/database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}(‘select * from `…’, Array)
Today encountered this error after upgrading MySQL and WHMCS as well. As this is the error related to collations, you will get suggestions to update tables and all ! Developer’s job !
However, a simple temporary fix to this is update your configuration file by commenting $mysql_charset = ‘utf8’; line.
You are done !
Category: Setup
Categories
Remove ClamAV in cPanel WHM?
In few steps you will be able to disable or remove ClamAV virus scanner.
Login to you WHM.
Go to Home »Service Configuration »Service Manager.
Look for ClamAV Scanner.
Deselect a service to disable it.
Save and you are Done.
To setup a new email account on your Android or Smartphone…
Select “Add account” from Email tab.
Enter “Email Address”
Enter the password for “Email Address”
Press “Next”
Type of email account
You have the choice to choose the type of account you will be using on your android or smartphone.
POP3: Selecting this type will download and store emails on phone from the server.
IMAP: (Recommended) This will show a cached copy of email on your phone, emails will be stored on server.
Exchange: Exchange type is supported only for MSExchange type of server.
Email Account Setup
for Incoming Server Settings
Username: Enter your email address.
Password: Existing Password for your email account.
IMAP server: “mail.yourdomain.com”
Port:
NonSecure(No SSL): 143
Secure (SSL): 993
Security Type: Use “SSL/TLS – Accept all certificates” for best compatibility.
IMAP Path: INBOX (This will allow for you to store your Sent, Drafts and Deleted emails on the server.)
Press Next.
for Outgoing Server Settings
SMTP server: mail.yourdomainname.com
Port:
NonSecure (No SSL): 25 or 26
Secure (SSL): 465
Security Type: “SSL/TLS – Accept all certificates” for best compatibility.
Require sign-in Check this for authentication with the mail server.
Username: Enter email address
Password: Password for email address.
Press Next.
Other Account Options
1. “Inbox Check Frequency” – Every 15 min. You may increase this to 30 to save you on battery.
2. “Notify me when email arrives” – Yes.
3. “Sync emails from this account” – Yes.
4. “Automatically download attachments when connected to wi-fi” – Yes.
Press Next.
Final Screen to finish email account setup
Give a name to your account. (if you have multiple accounts on the one device, it will be better to give name for each email account, Business, personal etc.)
Enter the name (Senders name displayed on outgoing messages) All outgoing emails that you send from this device it will show this name to recipient.
We are Done!
Related: Email Hosting, Email Server, EMail on Mobile Setup
Creating HTML signature on Webmail, Squirrel, Roundcube Other Mail clients
You must be wondering how people add their company logo in the email signature! Just follow the steps given below and you will be able to add image in your email signature as well!
1. Log in to your webmail
2. Select Roundcube webmail application
3. Click on the Personal Settings on the Right Top Panel
4. Select on Identities Tab.
5. Double Click on the Display name.
6. Click on the HTML editor to enter your HTML signature
7. Click Save after you are done.
8. Go to Preference tab and check on the box for Compose HTML message.
9. Click Save and Done.
If you are not comfortable with the code then you might want to try the below given sample code and customize it as per your requirement:
Your name goes here
Your position goes here
Your Company Name
Your Tag Line
yourname@yourdomainname .com
Your phone number goes here
You will want to change all the highlighted areas to the appropriate settings for your environment prior to placing in the signature area.
Note: If you are looking for the html signature in ‘SquirrelMail’ then you might get dissapointed as there is no html signature available in ‘Squirrel Webmail’. For html signature, you can start using ‘RoundCube’.
PHP Warning: PHP Startup: Suhosin Extension
does not officially support PHP 5.2 and below anymore, because it is
discontinued. Use it at your own risk. in Unknown on line 0
Since the php upgrade, you might have noticed these type of errors in your server logs. Must be wondering a perfect solution for this.
Actually you should be able to use the latest build, however some older scripts or applications might get in trouble, unless they are ready for latest php version. You need not to worry any more, as you have jumped to right place for it. Just follow the below given steps and you will be at rest.
What to do?
Easy enough, downgrade suhosin from 0.9.33 to 0.9.31 :
# remove suhosin from easyapache php config
/usr/local/cpanel/scripts/phpextensionmgr uninstall PHPSuHosin
# download and install older suhosin
wget http://download.suhosin.org/suhosin-0.9.31.tgz
tar zxf suhosin-0.9.31.tgz
cd suhosin-0.9.31
phpize
./configure
make
make install
#open php.ini and add line loading suhosin
vi /usr/local/lib/php.ini
#Add following line into extensions section:
extension=”suhosin.so”
Save and close the file, restart apache and you are done. You can also verify if everything is ok with the command php -v from the prompt.
Related: Web Server, Virtual Server, PHP Host, cPanel Host