centralnicgroup-opensource / rtldev-middleware-whmcs

CentralNic's WHMCS Software Bundle
https://centralnicreseller.com
Other
39 stars 15 forks source link

Hexonet TLD Import & Pricing Sync not working #279

Closed Showfom closed 3 months ago

Showfom commented 3 months ago

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

  1. Go to '/utilities/tools/tldsync/import'
  2. Click on 'Hexonet logo'
  3. Wait
  4. See error
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8mb3' (SQL: create table `ispapi_tblrelations` (`relation_subclass` varchar(255) not null, `relation_value` varchar(255) not null, `relation_category` varchar(255) not null, `relation_subcategory` varchar(255) not null, `relation_type` varchar(255) not null, `relation_period` tinyint null) default character set utf8 collate 'utf8mb4_general_ci')

Context (please complete the following information):

NOTE: HX = HEXONET, CNR = CentralNic Reseller, IBS = internet.bs, TPP = TPP Wholesale

KaiSchwarz-cnic commented 3 months ago

We had been in touch with WHMCS Support in the past as we noticed such issues on our customer's systems, but usually conflicting with latin_swedish_ci (or similar). We asked about the right way of creating DB Tables via the DB Class, so which charset and collation to define and use. We did not receive a clear response, just that charset utf8 is fine (what they use as well). That's right, install.sql of WHMCS is showing that as well. Still, it looks like we're conflicting with the collation of existing DB Tables when creating a new one as the collation is either completely different and by that, we even notice that customers have an issue with their DB in general (they drive with latin_swedish_ci instead of utf8) and your case is even different. I decided now to entirely disable any character set / collation setting when creating tables on our end. Hopefully this finally helps.

v23.8.3 will be released asap.

KaiSchwarz-cnic commented 3 months ago

released.