Jump to content

agarzon

Member
  • Content Count

    44
  • Joined

  • Last visited

  • Days Won

    2

agarzon last won the day on August 10

agarzon had the most liked content!

Community Reputation

9 Neutral

About agarzon

  • Rank
    Level 2 Member
  1. I had to reinstall from scrath everything again and import sql backup. Was the only way to fix it after trying all kind of solutions including to reupload all the files from the whmcs_v802_full.zip
  2. I'm having the same issue right now, luckly on my "dev" copy. Linux, PHP 7.4, WHMCS 8.02. (the same docker container I've been using for years) I did reupload all from .zip, still having the same error.
  3. No, that option is not related with the template, but how to process the incoming emails.... so is the right solution .
  4. The code is generated and injected dynamically from JS not from any tpl file... nothing to do with viewticket.tpl. So no experienced coders will find the way to hide that non-optional feature. (optional when comes with a variable or setting that we can control from the panel or configuration.php)
  5. Once again WHMCS is forcing us to use what they think is a good idea and once again they forgot to add an option to allow us to decide if we want that feature or not. For those who does not want to use the new "CC Recipients" in the ticket system, you can get rid of it by adding this to your custom css: #sidebarTicketCc { display: none; } I hope this helps you.
  6. Update: I just updated to 7.7.1 and all issues (so far) are fixed. However, we are still forced to show that ugly and useless icon and we still don't have any control or power to just say: I don't want/need that SSL status in my system
  7. I did not heard from WHCMS in a while and has been weeks since the bug was reported.
  8. I believe (as software engineer I am). WHCMS should make this new SSL monitoring feature fully optional and allowing easy enable/disable settings in the configuration panel or in the configuration.php file in the simplest case. And that is because adding invasive new features must be done with quirurgical precision and always having in mind: maybe some customers does not want what we think they want. No mentioning that evidently the feature was not fully tested before released as stable. Recommending customer to edit files in your theme is not a smart move, since the new SSL monitoring bug is not only estetical problem, there are some backend processes involved... and also because mostly of your customers are not coders and expect a "working product". Next time guys you think in adding a new invasive feature, please consider giving us (your customers) the power to enable/disable as will any idea that maybe WHMCS think is good, but ends being a bad idea. I've been with WHMCS since almost 8 years ago.
  9. And another bug to the list: 😂 SslSync cron task is going through ALL hosting and domains including anything terminated decades ago, also all marked as fraud, cancelled, closed, etc... my tblsslstatus table is going already for 3000 records and still counting. (probably will hit 25000 records and if that is the case the cron task will take 10 hours tom complete (everyday????).
  10. and BTW, even when (again) this is not documented, I figured out the filter for cron is: cron.php do --SslSync
  11. I start to believe the problem is not the cron task, the SSL monitor can perform a check even without the CRON and save the result in the table tblsslstatus as a "live action". The problem is not even the collation (I've move everything to utf8_unicode_ci according recommended here: https://docs.whmcs.com/System_Health_Status)... which btw the Database Collations check is not part of Health report but documentation says it does ¿? Anyways, the problem is the SSL monitor is not reading the SSL information properly.
  12. I don't see any SSL sync listed here: https://docs.whmcs.com/Crons It is possible to filter the cron task to only SSL sync? just like cron.php do --UpdateServerUsage ? I don't want to force ALL task each time until I figured out whats the problem with mix of collation
  13. Even when this is not documented at ALL. I suspected maybe there is a cron task related with the new SSL monitor. So I went to check and executed (https://help.whmcs.com/m/64751/l/683269) cron.php all -F -vvv And I saw that indeed there SSL monitor and cron are related. But it failed. WHMCS Automation Task Utility: all ================================== Daily Cron Automation Mode Queuing Tasks ------------- Force run any tasks: ignore "in progress" and "is due" Task queues ready Executing Application Queue --------------------------- 0/27 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 0% < 1 sec/< 1 sec 22.0 MiB Currency Exchange Rates 1/27 [▓░░░░░░░░░░░░░░░░░░░░░░░░░░░] 3% < 1 sec/< 1 sec 22.0 MiB Product Pricing Updates 2/27 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░] 7% < 1 sec/< 1 sec 22.0 MiB Invoices 3/27 [▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░░] 11% < 1 sec/< 1 sec 24.0 MiB Late Fees 4/27 [▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░] 14% 1 sec/7 secs 24.0 MiB Credit Card Charges 5/27 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░] 18% 1 sec/5 secs 24.0 MiB Invoice & Overdue Reminders 6/27 [▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░] 22% 4 secs/18 secs 40.0 MiB Domain Renewal Notices 7/27 [▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░] 25% 4 secs/15 secs 40.0 MiB Cancellation Requests 8/27 [▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░] 29% 4 secs/14 secs 40.0 MiB Overdue Suspensions 9/27 [▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░] 33% 5 secs/15 secs 40.0 MiB Overdue Terminations 10/27 [▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░] 37% 5 secs/14 secs 40.0 MiB Fixed Term Terminations 11/27 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░] 40% 5 secs/12 secs 40.0 MiB Inactive Tickets 12/27 [▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░] 44% 5 secs/11 secs 42.0 MiB Delayed Affiliate Commissions 13/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░] 48% 6 secs/12 secs 42.0 MiB Affiliate Reports 14/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░] 51% 6 secs/12 secs 42.0 MiB Email Marketer Rules 15/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░] 55% 6 secs/11 secs 42.0 MiB Credit Card Expiry Notices 16/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░] 59% 7 secs/12 secs 42.0 MiB SSL Sync [ERROR] PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' in /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php:335 Stack trace: #0 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(335): PDOStatement->execute(Array) #1 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(706): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select `userid`...', Array) #2 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select `userid`...', Array, Object(Closure)) #3 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select `userid`...', Array, Object(Closure)) #4 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select `userid`...', Array, true) #5 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect() #6 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1813): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/www.venehosting.com/vendor/illuminate/database/Eloquent/Builder.php(442): Illuminate\Database\Query\Builder->pluck('userid', 'domain') #8 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Task/SslStatusSync.php(0): Illuminate\Database\Eloquent\Builder->pluck('userid', 'domain') #9 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Task/SslStatusSync.php(0): WHMCS\Cron\Task\SslStatusSync->getNewDomains() #10 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/AbstractTask.php(0): WHMCS\Cron\Task\SslStatusSync->__invoke() #11 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/AbstractTask.php(0): WHMCS\Scheduling\Task\AbstractTask->execute() #12 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Command/AbstractCronCommand.php(0): WHMCS\Scheduling\Task\AbstractTask->run() #13 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Command/AbstractCronCommand.php(0): WHMCS\Cron\Console\Command\AbstractCronCommand->executeCollection(Object(WHMCS\Scheduling\Task\Collection)) #14 /var/www/www.venehosting.com/vendor/symfony/console/Command/Command.php(259): WHMCS\Cron\Console\Command\AbstractCronCommand->execute(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(844): Symfony\Component\Console\Command\Command->run(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRunCommand(Object(WHMCS\Cron\Console\Command\AllCommand), Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(123): Symfony\Component\Console\Application->doRun(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/www.venehosting.com/crons/cron.php(0): Symfony\Component\Console\Application->run(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' (SQL: select `userid`, `domain` from `tblhosting` where `domain` != and domain NOT IN (SELECT domain_name FROM tblsslstatus)) in /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php:713 Stack trace: #0 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select `userid`...', Array, Object(Closure)) #1 /var/www/www.venehosting.com/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select `userid`...', Array, Object(Closure)) #2 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select `userid`...', Array, true) #3 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/www.venehosting.com/vendor/illuminate/database/Query/Builder.php(1813): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/www.venehosting.com/vendor/illuminate/database/Eloquent/Builder.php(442): Illuminate\Database\Query\Builder->pluck('userid', 'domain') #6 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Task/SslStatusSync.php(0): Illuminate\Database\Eloquent\Builder->pluck('userid', 'domain') #7 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Task/SslStatusSync.php(0): WHMCS\Cron\Task\SslStatusSync->getNewDomains() #8 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/AbstractTask.php(0): WHMCS\Cron\Task\SslStatusSync->__invoke() #9 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/AbstractTask.php(0): WHMCS\Scheduling\Task\AbstractTask->execute() #10 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Command/AbstractCronCommand.php(0): WHMCS\Scheduling\Task\AbstractTask->run() #11 /var/www/www.venehosting.com/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Command/AbstractCronCommand.php(0): WHMCS\Cron\Console\Command\AbstractCronCommand->executeCollection(Object(WHMCS\Scheduling\Task\Collection)) #12 /var/www/www.venehosting.com/vendor/symfony/console/Command/Command.php(259): WHMCS\Cron\Console\Command\AbstractCronCommand->execute(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(844): Symfony\Component\Console\Command\Command->run(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRunCommand(Object(WHMCS\Cron\Console\Command\AllCommand), Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/www.venehosting.com/vendor/symfony/console/Application.php(123): Symfony\Component\Console\Application->doRun(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/www.venehosting.com/crons/cron.php(0): Symfony\Component\Console\Application->run(Object(WHMCS\Cron\Console\Input\CliInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} 17/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░] 62% 7 secs/11 secs 42.0 MiB Server Usage Stats 18/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░] 66% 20 secs/30 secs 46.0 MiB Overage Billing Charges 19/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░] 70% 21 secs/30 secs 46.0 MiB Client Status Update 20/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░] 74% 21 secs/28 secs 46.0 MiB Domain Expiry 21/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░] 77% 21 secs/27 secs 46.0 MiB Ticket Escalation Rules 22/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░] 81% 22 secs/27 secs 46.0 MiB Data Retention Pruning 23/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░] 85% 22 secs/26 secs 46.0 MiB WHMCS Updates 24/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░] 88% 25 secs/28 secs 54.0 MiB Run Jobs Queue 25/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░] 92% 25 secs/27 secs 54.0 MiB Domain Transfer Status Synchronisation 26/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░] 96% 26 secs/27 secs 56.0 MiB Domain Expiry Synchronisation 27/27 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% 38 secs/38 secs 56.0 MiB Sending Daily Cron Digest email Executing System Queue ---------------------- 4/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% < 1 sec/< 1 sec 58.0 MiB [WARNING] 1 tasks failed to complete But my upgrade to 7.7.0 was successful with no errors according the installer.log [2019-01-29 15:46:35][WHMCS Installer] DEBUG: Installer bootstrapped [] [2019-01-29 15:46:37][WHMCS Installer] DEBUG: Installer bootstrapped [] [2019-01-29 15:46:37][WHMCS Installer] INFO: Previous install detected [] [2019-01-29 15:46:37][WHMCS Installer] DEBUG: An upgrade from 7.6.2-release.1 to 7.7.0-release.1 will be attempted. [] [2019-01-29 15:46:42][WHMCS Installer] DEBUG: Installer bootstrapped [] [2019-01-29 15:46:42][WHMCS Installer] INFO: Applying incremental updates to existing installation [] [2019-01-29 15:46:42][WHMCS Installer] INFO: Applying Updates for 7.7.0-alpha.1 [] [2019-01-29 15:46:49][WHMCS Installer] INFO: Performing Update Action: addPrimaryKeysToTables [] [2019-01-29 15:46:59][WHMCS Installer] INFO: Performing Update Action: migrateEUVatAddon [] [2019-01-29 15:46:59][WHMCS Installer] INFO: Performing Update Action: createInvoiceDataTable [] [2019-01-29 15:47:00][WHMCS Installer] INFO: Performing Update Action: correctSpamExpertsEmailTemplate [] [2019-01-29 15:47:00][WHMCS Installer] INFO: Performing Update Action: migrateStorageConfigurations [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Performing Update Action: updateRecaptchaOptions [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Performing Update Action: createSslStatusTable [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Performing Update Action: createTransactionHistoryTable [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Removing any obsolete file and directories [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Applying Updates for 7.7.0-beta.1 [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Performing Update Action: updateSpamExpertsWelcomeEmail [] [2019-01-29 15:47:01][WHMCS Installer] INFO: Performing Update Action: createCodeGuardWelcomeEmail [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Removing any obsolete file and directories [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Applying Updates for 7.7.0-rc.1 [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Performing Update Action: removeUnusedLegacyModules [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Removing any obsolete file and directories [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Applying Updates for 7.7.0-release.1 [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Performing Update Action: registerSslStatusSyncCronTask [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Removing any obsolete file and directories [] [2019-01-29 15:47:02][WHMCS Installer] INFO: Upgrade process completed. [] Who knows what else is broken... I guess I will be better to change the template and hide that icon, I don't want my customers to get confused.
  14. All my hosted domains are SSL protected by letsencrypt automatically. However looks like they don't according the new SSL monitor (7.7.0) Already checked the https://help.whmcs.com/m/85428/l/1035090-troubleshooting-red-ssl-monitoring-padlock-icons and doesn't help. Running CURL from the same server my WHCMS is installed always success with no errors at all. Tested different domains, this one is just one of hundred of samples: curl -v https://aldeavalleencantado.com * Rebuilt URL to: https://aldeavalleencantado.com/ * Trying 173.208.145.134... * TCP_NODELAY set * Connected to aldeavalleencantado.com (173.208.145.134) port 443 (#0) * Initializing NSS with certpath: sql:/etc/pki/nssdb * CAfile: none CApath: none * loaded libnssckbi.so * ALPN, server accepted to use h2 * SSL connection using TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 * Server certificate: * subject: CN=aldeavalleencantado.com * start date: Dec 17 15:34:50 2018 GMT * expire date: Mar 17 15:34:50 2019 GMT * common name: aldeavalleencantado.com * issuer: CN=Let's Encrypt Authority X3,O=Let's Encrypt,C=US * Using HTTP2, server supports multi-use * Connection state changed (HTTP/2 confirmed) * Copying HTTP/2 data in stream buffer to connection buffer after upgrade: len=0 * Using Stream ID: 1 (easy handle 0x23abdf0) > GET / HTTP/2 > Host: aldeavalleencantado.com > User-Agent: curl/7.57.0 > Accept: */* > * Connection state changed (MAX_CONCURRENT_STREAMS updated)! < HTTP/2 200 < server: nginx < date: Tue, 29 Jan 2019 17:12:47 GMT < content-type: text/html < content-length: 5531 < last-modified: Mon, 17 Dec 2018 16:34:04 GMT < vary: Accept-Encoding < etag: "5c17cffc-159b" < x-powered-by: PleskLin < accept-ranges: bytes < ......
  15. Good idea... I'm taking it. 😀 For anyone else willing to go straight to it: The file is in templates/{yourtheme}/header.tpl Search this line: <span class="label label-info">{lang key='notificationsnew'}</span> And replace it with: <span class="label label-info">{count($clientAlerts)}</span>
×
×
  • 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