Tag: WHMCS

Categories
Uncategorized

WHMCS PIPE ERROR – TICKETS NOT CREATED

WHMCS PIPE ERROR – UNABLE TO CREATE TICKETS
A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:
pipe to |/home/***/***/crons/pipe.php
local delivery failed
The following text was generated during the delivery attempt:
—— pipe to |/home/***/***/crons/pipe.php
TypeError: Argument 7 passed to processPipedTicket() must be an instance of WHMCS\Mail\AutoSubmittedHeader, array given, called in /home/***/***/crons/pipe.php on line 0 in /home/***/***/whmcs/includes/ticketfunctions.php:0

SOLUTION:
In recent updates, not all files are replaced. Especially if you have moved crons folder to a different location. Make sure you have manually copied the latest updated files (pipe.php) to the crons folder.

Related: Webhosting billing panel, Whmcs, Ticket System, Email Piping

Categories
MySQL Setup Web-Hosting

WHMCS database error – Mix of collations utf8_unicode_ci

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 !