netnow

Appears cleaning all the old and no longer needed log, then compacting the database did the trick. Been running for weeks now without issue.

I think its the database backup that using so much memory. I noticed since I started getting the error (3 days now), that I have NOT been sent the database backups. I have done some log maint in the database, and the zipped backup size has gone from 40 MB to 3 mb. We'll see tomorrow if it runs OK. -T

All, I am getting this error as well. It definitely happening with the 10 PM (Daily) cron run. Also, mine is related to PHPMailer as well. START SNIP ------------------------------------------------------- From: "(Cron Daemon)" <xxx@server.mydomain.com> Date: 2020-08-11 10:04 PM (GMT-05:00) To: me@mydomain.com Subject: Cron <xxx@xxx> /opt/cpanel/ea-php72/root/usr/bin/php -q /home/myuser/portaldata/crons/cron.php Whoops\Exception\ErrorException: Allowed memory size of 268435456 bytes exhausted (tried to allocate 33554440 bytes) in /home/myuser/public_html/portal/vendor/phpmailer/phpmailer/src/SMTP.php:657 #0 /home/myuser/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Utility/Error/Run.php(0): WHMCS\Utility\Error\Run->handleError(1, 'Allowed memory ...', '/home/myuser/p...', 657) #1 [internal function]: WHMCS\Utility\Error\Run->handleShutdown() #2 {main} END SNIP--------------------------------------- I have my memory limit set to 256M. [root@server user]# php -i | grep memory_limit memory_limit => 256M => 256M I am curious if/what CRAFT did to fix the error. Another question (if any knows). Is the "memory limit' set for an individual script, or is it the total scrip(s) memory allocation for any given user? -T

Problem Solved. Turns out we had a mail configuration issue in the WHMCS settings. -T

Good Morning, When in the Client Summary or Profile area(s), and click on the "Reset & Send Password" link, it appears a password us being generated, and being set for that client, but no email is being sent. - The "System Activity Log" says the password was reset, and an email has been sent, - The "System Email Message Log" does not show a message being sent. - Using the SIX theme. - WHMCS 7.10.2 Is there a checkbox or other knob somewhere in WHMCS config that might prevent/cause this? Any suggestions to further troubleshoot this? -T

When the Sync tool is activated, results show some WHM/Cpanel accounts that do not yet exist inside WHMCS. When you select one or more of these and click procede you are given the option to send email welcoming the clients to WHMCS . You are alos given the option to "Reset Service Account Password" . WHat password is this resetting exactly.? Is there any downfal to saying NO to this? -H

Brian, Yes, sorry I meant ".. must not be edited..". We are in the position to start updating client info. The first thing will be to get unique email address in the main contact so peeps can log in to the correct accounts. Other than writing an SQL script, it appears to us the easiest way would be to open the tblClients in phpMyAdmin and put them in by hand. Later on, changing the address phone numbers etc. If all these values are simply that, values used in tblClients, and not somehow joined to other tables ... editing should be ok? (And yes, definately not editing columns or table structure in any way). -T

Is it permissible to use phpMyAdmin to edit some basic fields in tblClients? If so, are there fields (other than uid, and uuid) that must name be edited? -T

Has anyone seen this before? We only have received this once (this morning). [PDOException] SQLSTATE[HY000] [2002] No such file or directory all [-F|--force] [--email-report [EMAIL-REPORT]] -T

Brian, Kian, Is there somewhere (short of studying to become a PHP/WHMCS developer), that I go and read 'how' to actually do this? -T

Is it at all possible to turn off functionality if individual features inside WHMCS? The idea here is to have the client portal enabled, allowing them to log in, but for the time being, only have the ticketing / support features enabled. Later on, enabling domain registration, then later on, enabling invoicing/billing. Has this / can this be done? -T

I am looking to connect with current users of the WHMCS - Quick Books Online Sync module users, with the hope if understanding a few basic pre usage issues. Does anyone out there use this module? -T

Out of the box, it appears that the client email address must be a valid single email address, and that address is paired with the imported cPnale password and is used for authentication in WHMCS client are - correct? - putting a second email address in this field with break the WHMCS cleint login sustem? Correct? - changing the client's password (using WHMCS admin system), will only change it for WHMCS client area, (not cPanel access).Correct? -N

We have successfully used the 7.8.3 sync tool to get all the users loaded into the WHMCS database. As I am sure you all know, the firstname Lastname fileds in the WHMCS will now have the unix user name as first name, and admin as the last name. We are currently working an a spreadsheet that will is very close to being saved as a flat text csv file. Before I embark on authoring a a php script to update the WHMCS tblClients from the csv file, I am reaching out to see of one already exists somewhere. The idea of the script would be to: read the unix_user field from the csv and find the exact match in the firstname column of the WHMCS_tblclient. If found, move the firstname data (in tblcliennts) to the NOTES field. then update the firstname, lastname, email, address1 address2, etc. etc. etc. fields in tblsclients from the csv file. Anyone? -N

Using the server sync tool to clean up the clients info this morning. Hundreds of clients synced fine, but have about 50 'pink' ones showing they do not exist on server (WHM/CPanel) . a few of them dont exists so I will delete client account. But many of them do exist, but are not owned as root in WHM but are showing owned as a re seller name. We still bill these clients therefor need them in our WHMCS client database. Is there a way to force or trick the import? Example below, he green strikeouts below in the pink result area DO exist on the WHM server.

OK, thanks Chris. I have set the caching to: MariaDB [(none)]> SHOW VARIABLES LIKE '%query_cache%'; +------------------------------+----------+ | Variable_name | Value | +------------------------------+----------+ | have_query_cache | YES | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 16777216 | | query_cache_strip_comments | OFF | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | +------------------------------+----------+ We'll see if this helps at all. -N

Thanks Chris, Will do.

Is there a script or command somewhere that actually checks data base and table structure to ensure its correct for the version of WHMCS installed?

A moderate amount of research indicates that increasing MariaDB query_cache_size should solve or severely lessen the frequency of the failures. All things being equal, and the system being "Live" we are getting ave of 2 emails a day indicating the the failure shown in the original post. Does anyone here recommend setting the query cache size? (Currently at 0) if so, to what value? A side question is: Are these failures causing any damage, or, just failing and not doing anything? And is the 'work' that they should have done being caught up later? i.e. can we simply ignore these errors? -N

Still getting fails. Interesting that they seem to happen when things (domains, payment portal) are live and not in test mode, -N

Yup, Was able to confirm that if I am adding a ticket as a client in the portal and have WHMCS admin or cookies left over, the email wont be sent to me. -N

Nope, we use a third party mail scanning service with a quarantine area not there either. Seems that I cant submit a ticket from the portal on a machine that uses the same IP as a machine used to be in admin site. Make sense? -N

I have 3 admin users setup. Each of them set to valid off site email addresses, and have the "enable Ticket Notifications" button checked on all three. One account however is NOT getting ticket notification emails. I was wondering if there are other areas of WHMCS/WHM that need to be checked to specifically allow the notification emails to flow? -N

Checking email and errors... The last fail email and error_log entry was at 4:30 PM yesterday. At 5:30 PM ish I added the localhost IP and all the other ifconfig is to the /admin/ directory .htacces allow from statement. No errors since. I am hoping this is fixed ... time will tell. -N

Chris, When I request version from the command line, I get: [root@<SERVER> ~]# mysql -V mysql Ver 15.1 Distrib 10.0.38-MariaDB, for Linux (x86_64) using readline 5.1