Jump to content

Chad

Level 2 Member
  • Content count

    197
  • Joined

  • Last visited

Everything posted by Chad

  1. I have an add running 24/7 for specific product group on Google Ads but I cannot for the life of me figure out how to track sales conversion, in this case being any sales from ad clicks. I'm logged into my Ads account in the Tools > Conversions section. See attached. Then I choose "install the tag yourself" option after that. See attached. Where does this go for new sales specifically? Should it be "page load" or "snippet" option?
  2. I don't see any possible option to use Microsoft Authenticator for my admin account's 2FA. Are DuoMobile and Yubikeys the only options?
  3. Ok, but don't you think it's ridiculous WHMCS charges us a monthly fee to secure our billing software?
  4. It's pathetic that we have to pay a fee to secure our billing software login with 2FA (our choice app instead of their method). Really shameless on WHMCS's part.
  5. Curious what most of you are using for merchant / gateway services. I've been using the CDG Commerce / Quantum Gateway bundle for quite some time. It's getting expensive now as revenue increases. Not only that, their websites (both) are pathetically outdated and not mobile friendly even. They look like they were designed in 1998. I was looking at https://fattmerchant.com but see no module for WHMCS. Any feedback would be appreciated.
  6. Enabled this add-on in setup and also enabled widget view in staff management area. Where do I get the API "signature" in my PayPal account? Do I use my PayPal username (email) and password to or something else? I went here too: https://www.paypal.com/businessmanage/credentials/apiAccess I don't know which option to use. If I click on Grant API Permission link, I see attached and have no idea what to put there. I'm confused.
  7. Chad

    Paypal Transaction Lookup Addon

    That was it, thanks for your help. It would be nice if their addon section actually mentioned that.
  8. I just upgraded to 7.6 now and everything now loads very slowly, even using default Blend theme. This is not normal. I emptied template cache, optimized database via phpMyAdmin. Same thing.
  9. After upgrading to 7.6, I utilized the Maxmind features added. I added my license key, which matches my email/key in my Maxmind account. I get this error on new orders, attached. My settings are also attached. Any changes, recommendations for Maxmind settings at least?
  10. Agreed and their support denies any slowness. Liars.
  11. Let me re-summarize: Slowness happened immediately after upgrading to 7.6. Prior on 7.5 and before, any page load in admin panel was lightning fast. Now, 2 seconds average any page at all in admin panel. Client side remains normal otherwise. Using default Blend theme. Already ran database repair, optimize via phpMyAdmin. Already ran "empty template cache" and cleared browser cache as well. Problem replicated in Firefox on Windows 10 and Safari on iPhone. Same slowness in admin panel. Adding below line to config file did not fix the problem at all. $disable_admin_ticket_page_counts = true; Server specs: 2 x Hex Core with 72GB RAM, SSD drives and only 2 domains hosted on the box. PHP 7.2 with MySQL/MariaDB 10.2 MySQL settings: [root@server ~]# cat /etc/my.cnf [mysqld] performance-schema=0 # GENERAL # local-infile=0 default-storage-engine = MyISAM # MyISAM # key-buffer-size = 16G myisam-recover = FORCE,BACKUP # SAFETY # max-allowed-packet = 16M max-connect-errors = 1000000 max_connections = 300 #sql-mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GR$ sysdate-is-now = 1 # BINARY LOGGING # #log-bin = /var/lib/mysql/mysql-bin expire-logs-days = 14 sync-binlog = 1 # CACHES AND LIMITS # tmp-table-size = 512M max-heap-table-size = 512M query_cache_type = 0 query-cache-size = 0 query_cache_limit = 0 join_buffer_size = 1M max-connections = 500 thread-cache-size = 50 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 10240 wait_timeout = 600 sort_buffer = 8M read_buffer = 8M # INNODB # innodb-flush-method = O_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 1G innodb-flush-log-at-trx-commit = 1 innodb-file-per-table = 1 innodb-buffer-pool-size = 8G innodb_buffer_pool_instances = 8 performance_schema = ON # LOGGING # log-error = /var/lib/mysql/mysql-error.log slow_query_log = 1 long_query_time = 1 slow_query_log_file = /var/lib/mysql/mysql-slow.log log-queries-not-using-indexes = 1 max_allowed_packet=268435456 open_files_limit = 50000 bind-address=127.0.0.1 MySQL Slow Query Logs: # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.000140 Lock_time: 0.000031 Rows_sent: 5 Rows_examined: 5 # Rows_affected: 0 use user_billing; SET timestamp=1533245423; select 0, `title` from `tblticketstatuses`; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.000131 Lock_time: 0.000026 Rows_sent: 5 Rows_examined: 10 # Rows_affected: 0 SET timestamp=1533245423; select `title` from `tblticketstatuses` order by `sortorder` asc; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.000137 Lock_time: 0.000020 Rows_sent: 5 Rows_examined: 10 # Rows_affected: 0 SET timestamp=1533245423; select `id`, `name` from `tblticketdepartments` where `id` in ('6', '3', '12', '4', '2') order by `order` asc, `order` asc; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.000078 Lock_time: 0.000015 Rows_sent: 1 Rows_examined: 4 # Rows_affected: 0 SET timestamp=1533245423; select `title` from `tblorderstatuses` where `showpending` = '1'; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.003381 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 3968 # Rows_affected: 0 SET timestamp=1533245423; select count(*) as aggregate from `tblorders` inner join `tblclients` on `tblclients`.`id` = `tblorders`.`userid` where `tblorders`.`status` in ('Pending'); # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.009275 Lock_time: 0.000022 Rows_sent: 3 Rows_examined: 3950 # Rows_affected: 0 SET timestamp=1533245423; select count(id) as count, status from `tblclients` group by `status`; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.009296 Lock_time: 0.000029 Rows_sent: 6 Rows_examined: 5110 # Rows_affected: 0 SET timestamp=1533245423; select count(id) as count, domainstatus from `tblhosting` group by `domainstatus`; # User@Host: user_dbuser[user_dbuser] @ localhost [] # Thread_id: 11513 Schema: user_billing QC_hit: No # Query_time: 0.001413 Lock_time: 0.000025 Rows_sent: 8 Rows_examined: 800 # Rows_affected: 0 SET timestamp=1533245423; select count(id) as count, status from `tbldomains` group by `status`;
  12. @yggdrasil As I already stated, only admin side.
  13. No help from support in my case. They deny the slowness despite the obvious that others replicated this and it happened immediately after upgrading to 7.6 The server I'm running on has 2x Hex-Core with 72GB RAM, SSD and Mariadb 10.2. Sure isn't a server or hardware issue at all. It's their bugs.
  14. Didn't solve for me. Only happens on admin side, not client side. Takes 2 seconds to load pages.
  15. You mean it should look like this? $disable_admin_ticket_page_counts = 'true;' Anyway, both formats didn't do it for me.
  16. Curious if someone can explain how to apply some CSS to a custom field (dedicated server) order page. I want the description to have some basic CSS style applied. The custom field ID is: customfield283 The specific line: <span class="field-help-text"> Right below this line: <input name="customfield[283]" id="customfield283" value="" size="30" class="form-control" type="text">
  17. Can someone please explain an easy way to apply 3% credit card / PayPal convenience fee on select customers that have invoices above $2,000 (for example)? Thank you.
  18. Chad

    Update 7.5.0

    First enabled Ioncube Loader 10x per WHMCS update instructions. Updated WHMCS to 7.5.0. Now, WHMCS admin panel shows just this: Starting Loaded English Language File Loaded Other Language Files Updated arabic Updated czech Updated dutch Updated farsi Updated french Updated hebrew Updated hungarian Updated italian Updated portugues Updated russian Updated spanish Updated turkish Updated portugues-br Cleared cache, retried. Same thing. Also emptied templates_c cache files.
  19. Chad

    Domain Transfer Notice?

    Due to end user / customer confusion and lack of knowledge, I'd like to put a notice for ALL domain transfer attempts (to and from my company) when they order such service that: Domain must be unlocked first Privacy protection must be removed first Using ENOM module here. How can we put this global notice for such service (transfers in/out)?
  20. Chad

    Domain Transfer Notice?

    The hook? Please explain how I can create a basic hook that only appears if they're ordering a domain transfer. As for the template, the closest and only template would be the domain transfer initiated one, which gets sent after they pay and initiate the transfer. Doesn't make sense, since they need to be warned prior to initiating the transfer to unlock their domain and remove the privacy (if there).
  21. Upgraded a few days ago. I just noticed now in admin > products page (configproducts.php) I get this What is this about? System health all good too.
  22. I tried that, gives no additional info at all. What vendor folder are you referring to?
  23. Deactivated the only 3 addons, same issue.
  24. Hello, Trying to accomplish this conditional in the "Total Due Today" section (/cart.php?a=confproduct&i=1) Assuming the chosen monthly cycle, display a message using an if conditional with the actual date range being invoiced for. Apply this only to select product group #7. Would appreciate help on this. I'm referring to ordersummary.tpl file.
×

Important Information

By using this site, you agree to our Terms of Use & Guidelines