Jump to content

Linuc82

Member
  • Content Count

    10
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Linuc82

  • Rank
    Junior Member
  1. 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.
  2. 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.
  3. 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.
  4. Thanks, this is the way I was doing it. I was looking for a way using the local API.
  5. 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.
  6. 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.
  7. So, I am the only one using MyISAM on some tables and concerned about converting them to InnoDB?
  8. 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.
  9. 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?
  10. Welcome to WHMCS.Community Linuc82! We're glad you're here please take some time to familiarise yourself with the Community Rules & Guidelines and take a moment to introduce yourself to other WHMCS.Community members in the Introduce Yourself Board.

×
×
  • 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