Jump to content

persis

Member
  • Content Count

    27
  • Joined

  • Last visited

Community Reputation

0 Neutral

About persis

  • Rank
    Newbie

Recent Profile Visitors

378 profile views
  1. It is not acceptable to reduse the number of TLDs! I did some optimization on the server network like remove ipv6 and changeing dns from 8.8.8.8 to my datacenter DNS, and now the TTFB is 2.5s (it wase 3.5s befor theas optimizations!) total loading time is: 3.21 s! the problem is not the sql (Slow query logs show 0.03s for query ) any one can help for optimizing the TTFB on SSD Drives, 20GB Ram , 23core CPU, Cpanel, Litespeed~
  2. me too with 780 domains in domain pricing , very slow performance. when i empty tbldomainpricing , the speed is very good. I think this is not database problem ! Slow query logs show 0.03s for query ! But TTFB for whmcs homepage is : 3.5s!!!! Changing back to six theme cant solve the problem for some pages in the up topic!! Maybe whmcs in version 8 need some new settings for server (PHP or webserver!) I use : mariadb 10.3, litespeed, PHP 7.4, whmcs 8.2.1 @brian! Please take a look!
  3. Array( [result] => error [message] => SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where `id` = ?' at line 1 (SQL: update `tbldomains` set where `id` = 3))
  4. I manualy hide the ID when copying and pasting for you! I think whmcs codes in this api cant work with mariadb 10.3! I am moving from mariadb to mysql for test...
  5. array(2) { ["result"]=> string(5) "error" ["message"]=> string(267) "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where `id` = ?' at line 1 (SQL: update `tbldomains` set where `id` = xxx)"}
  6. me too with 780 domains in domain pricing , very slow performance. when i empty tbldomainpricing , the speed is very good. please help me!!!
  7. With 780 domain , this pages are very slow!!! TTFB very slow please help now in Whmcs version 8.2.1
  8. Hello every one this code not work with updateclientdomain.php (v8.2.1) but worked with updateclientdomain.php(v8.1.2) updateclientdomain.php in Version:8.2.1 (8.2.1-release.1) not work updateclientdomain.php in Version:8.1.3 (8.1.3-release.1) working https://developers.whmcs.com/api-reference/updateclientdomain/ This code update client domains with Domain pricing every day by cron(very helpful) <?php use WHMCS\Database\Capsule; add_hook('AfterCronJob', 1, function($vars) { $adminUsername = ''; // Optional for WHMCS 7.2 and later foreach (Capsule::table('tbldomains')->pluck('id') as $v) { localAPI('UpdateClientDomain', array('domainid' => $v, 'autorecalc' => true), $adminUsername); } }); can any body help me to resolve this problem? updateclientdomain(v8.2.1).php updateclientdomain (v8.1.3).php
  9. Version:8.2.0 (8.2.0-release.1) not work Version:8.1.3 (8.1.3-release.1) working
  10. this code not work with updateclientdomain.php (v8.3) but work with updateclientdomain.php(8.1.2) <?php use WHMCS\Database\Capsule; add_hook('AfterCronJob', 1, function($vars) { $adminUsername = ''; // Optional for WHMCS 7.2 and later foreach (Capsule::table('tbldomains')->pluck('id') as $v) { localAPI('UpdateClientDomain', array('domainid' => $v, 'autorecalc' => true), $adminUsername); } });
  11. <?php use WHMCS\Database\Capsule; add_hook('AfterCronJob', 1, function($vars) { $adminUsername = ''; // Optional for WHMCS 7.2 and later foreach(Capsule::table('tblhosting')->pluck('id') as $v) { localAPI('UpdateClientProduct', array('serviceid' => $v, 'autorecalc' => true), $adminUsername); } foreach (Capsule::table('tbldomains')->pluck('id') as $v) { localAPI('UpdateClientDomain', array('domainid' => $v, 'autorecalc' => true), $adminUsername); } });
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated