Linuc82

The server time, php time and whmcs configuration time is set to the exact same time. So, I monitoring the Activity logs very closely over the last few days. As mentioned, my Daily Cron starts off at the correct time, 2am. But during the cron run it changes 1 hour back. Monitoring the Activity Log I noticed that it happens every time during the "CreateInvoices" function run. I "skip --CreateInvoices" during my 5 minute cron and moved it to it's own "do --CreateInvoices" set to 3am. Bam, the Daily Cron finished without any errors. The issue is definitely with "CreateInvoices". Checking the Activity Logs again at 3am the system start off creating new invoices at 3am, but after 10 invoices or so, the time changed again from 03:01 to 02:01. 09/11/2022 02:01 Email Sent to O**** A****** (Domain Renewal: xxxxx) 09/11/2022 02:01 Domain Renewed Successfully - Domain ID: 200300 - Domain: xxxx 09/11/2022 03:01 Running Automatic Domain Renewal on Payment 09/11/2022 03:01 Invoice Marked Paid - Invoice ID: xxxx At this point in time I don't think it is a timezone issue at all, rather that whmcs cron starts recording the incorrect time at some point during the "CreateInvoices" function run.

Update: I just discovered something very weird. Right in the middle of the WHMCS Daily Cron run, the time changes 1 hour back: 07/11/2022 01:06 Email Sent to ***** (Domain Renewal 07/11/2022 01:06 Domain Renewed Successfully - Domain ID 07/11/2022 02:06 Invoice Marked Paid - Invoice ID 07/11/2022 02:06 Running Automatic Domain Renewal on Payment My Daily Cron is set to run at 2am. See how mid-automation tasks the time changes from 2am to 1am. This causes other issues, such as the cron reporting that it did finish.

I have a strange issue that started last week. My whmcs daily cron is set to execute at 00:00 in the automation settings. For some strange reason it runs at 23:00 and then again at 0:00. Every single night. This is on an established system that has been running for years without any issues. I've check the PHP Timezone as well as the server timezone. also added date_default_timezone_set('America/Los_Angeles'); in the configuration.php file just in case. I cannot find any reasonable explanation as to why it would run exactly 1 hour before the actual scheduled time, and then again at the time set in the automation settings. If it was a timezone issue, it would then just execute at the wrong time, but in this case it runs twice, which is causing cron errors. Running the cron by force in CLI it completes without an issue.

Fantastic, works! Many thanks.

The "Order Confirmation" email template is a system default email template under "General Messages". I need to use the {$invoice_num} variable associated with the order in the "Order Confirmation" email template. However, it seems that {$invoice_num} cannot be accessed because it is available for "Invoice Messages" and not "General Messages". Any help appreciated.

We are now having the exact same issue. Clients pay for services, but the invoice's next due date is not updated to the next month. Nothing in the logs.

I was wondering if anyone else also have issues with a massive tblemails. At this time mine sits at 20.6GB and about 845,000 rows. I honestly wish I could just keep mails for the last 30 days, but that will not work as we sometime have to give clients proof that we sent them a message 7 months ago. If you have a similar issue and have fixed it, please share.

I was just wondering if anyone has info about possible new themes for both client and admin in future? We've been running WHMCS since Matt personally coded addon modules for clients, which I guess is about 10 years. I just recently thought to myself, my word "Six" and "Blend" has been with us forever, it would be refreshing to get a new look and feel. Maybe it's just me.

I have an issue with Friendly URLs. When I enable "Full Friendly rewrite" it messes up the announcements and knowledgebase URLs. By mess-up I mean my images are no longer working. The system is trying to load them from: www.mydomain.com/knowledgebase/1/assets/img/logo.png instead of www.mydomain.com/assets/img/logo.png AND www.mydomain.com/announcements/3/assets/img/logo.png Please advise if someone has had this issue before and if it can be fixed.

Perhaps I should give you some more information here. See, our company situation is a bit unique. All new domains registered on our system has "Auto Renew" Disabled by default. BUT when a hosting service is ordered, we want the associated domain to have Auto Renew Enabled. To accomplish this, I have created the following hook: <?php #WHMCS DB Connection Manager use Illuminate\Database\Capsule\Manager as Capsule; add_hook('AfterModuleCreate', 1, function ($vars) { $domain = $vars['params']['domain']; try { $updateAutorenew = Capsule::table('tbldomains') ->where('domain', $domain) ->update( [ 'donotrenew' => 0, ] ); echo "Updated {updateAutorenew} domain renewal status"; } catch (\Exception $e) { echo "I was unable to update the domain renewal status. {$e->getMessage()}"; } }); This issue we have is that when a manual payment is added to an order, the page hangs on "Unpaid" and does not forward to "Paid". I've narrowed the issue down to this hook, but cannot determine why it is doing that.

Thanks, this is the way I was doing it. I was looking for a way using the local API.

Hi Guys, I am writing a hook that uses "AfterModuleCreate" point. This point will only return the actual domain name parameter "domain" as per https://developers.whmcs.com/provisioning-modules/module-parameters/ I actually need the domainid parameter. Any ideas? I cannot find a function for the local API to get the domainid from a domain parameter.

The error I got went away after setting the MySQL mode to nothing in my.cnf In other words, adding the following entry: sql_mode="" What issues did I have? Well, I decided to change the tables in a staggered approach. First, changing the engine for a few smaller tables, like tbltodo I did not have any issues with the smaller tables that had only a few row entries. BUT, for some reason when I do big tables I see some row losses that I can't explain. Example, my tblactivitylog had 305,000 entries before the engine change, but only 295,000 after the engine change. I still cannot figure out why this would be the case. I certainly don't want to lose rows altering the tbldomains or tblclients.

So, I am the only one using MyISAM on some tables and concerned about converting them to InnoDB?

Good day, So, I seem to have an issue and can't figure it out. Been using WHMCS since they opened for business. Back in those days, the installation automatically created all tables using MyISAM. We now want to install a specific module from ModulesGarden and they say the tbldomains must use InnoDB for their module to work. So this means converting from one engine to the other. Some tables convert without an issue, but many of them have "Created at" or "Updated at" values of 0000-00-00 00000 and when you run something like this: ALTER TABLE tblemailtemplates ENGINE=InnoDB; You will get: Error MySQL said: Documentation #1067 - Invalid default value for 'created_at' Since MyISAM is getting depreciated in MySQL 8 it would be a good idea to start converting these old tables, am I correct? Any help would be much appreciated.

We have an intermittent issue where when we are on an invoice, and click "Add Payment" for a bank transfer eg. it will just spin and the page hangs. Funny enough, the actual payment is added to the invoice, but it sometimes hangs and not refresh to the next screen, which states "Invoice Paid". Any ideas?