Jump to content

WHMCS Lawrence

WHMCS Technical Analyst
  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by WHMCS Lawrence

  1. Hey everyone, If anyone is still experiencing this issue and hasn't opened a ticket, could you please do so and provide temporary login details so we can investigate this further. Thanks!
  2. Apologies for any confusion. That's the correct query.
  3. Hey everyone, Digging into this further, the overage billing you've noticed isn't occurring specifically due to this change from case CORE-13060. The instances I've seen of this have been due to an unexpected value of "0" in the overagesenabled field in the tblproducts database table - we expect it to be empty when the Overages Enabled setting is disabled on a product. Myself and my colleague are investigating how this happens. In the meantime, the result is that unexpected value appears to be causing the product to get included in the overage billing process. I've tested locally and editing and re-saving products without making any changes corrects the value in the database as needed to prevent this from occurring going forward. If you wish to update all products at once, the following SQL query should do the job: UPDATE tblproducts SET overagesenabled = '' WHERE overagesenabled = '0';
  4. WHMCS Lawrence

    WHMCS UTF8 problem

    Hello, Most likely the data in your database tables is in latin1 (which is/was the MySQL default for some time), which (simply put) isn't compatible with utf-8 and will need a manual conversion to fix this. In my experience, the instructions at https://docs.moodle.org/31/en/Converting_your_MySQL_database_to_UTF8#Linux_.26_Mac are a good starting point. I would recommend searching and replacing any references to "utf8mb4" with "utf8" to help ensure that the end result is compatible with WHMCS. As you will be modifying the database directly, I'd strongly recommend making a backup of it before proceeding and contacting your system administrator if you are unsure of how to do the above.
  5. WHMCS Lawrence

    WHMCS Promotion Not saved

    A 404 error on saving in the admin area is generally going to be caused by a malfunctioning mod_security rule on the server and would need to be investigated and corrected (or disabled) by your system administrator to resolve it.
  6. We are glad to hear that our team was able to help 🙂
  7. WHMCS Lawrence

    Cannot save product descriptions

    Most likely it was probably set a long time ago and only noticed now. As for the line in the configuration.php file, I'd strongly recommend adding it - otherwise it can lead to other unexpected issues with saving data.
  8. WHMCS Lawrence

    Cannot save product descriptions

    Hello, Please make sure the System Charset under Setup > General Settings > Localisation tab is set to utf-8 and the configuration.php file has this line: $mysql_charset = 'utf8'; Without those, you may see some weird issues with saving data due to how MySQL works by default with latin1 instead of utf-8.
  9. Those are configuration files for PHP - not MySQL. Generally the MySQL configuration can only be modified by the root user on the server and resides in the /etc/my.cnf file.
  10. WHMCS Lawrence

    What is the safe and proper way to remove addon modules?

    It would depend on the type of module. Generally for an addon, it will create any needed database tables during activation and remove them during deactivation. However this is up to the author to implement. Once the addon is deactivated under Setup > Addon Modules, deleting the files under the /modules/addons folder and then checking to ensure it removed any database tables it created is usually the best option. For other module types (server, domain, etc), you would first need to edit the applicable items using them and then delete their files and manually remove any database tables that they created.
  11. WHMCS Lawrence

    Stripe Changes

    Hi everyone, as mentioned by John in that feature request, we expect 7.8 to reach beta status later this month, so the general release of 7.8 should be available in advance of the deadline. Rest assured that we are aware of the impact of this change and are working to get it taken care of.
  12. If deleting currencies helped, this is likely a MySQL issue as doing so would reduce the number of queries needed to display the pricing and process the request. The likely next step would be a general tuneup of MySQL on your server. As a starting point, you may want to set max_connections to a low value like 50 and increase based on your available RAM. Other important setting are wait_timeout (at least 600, so MySQL doesn't drop connections too soon), table_definition_cache (at least 5000), sort_buffer (2-4M seems to be good), read_buffer (2-4M seems to be good) and max_allowed_packet (16M is usually fine). Note: in MySQL, "M" means megabytes. Once this has been done, restart MySQL and let it run for at least 48 hours. Then you can look into something like MySQLTuner to do an automatic check and see if it makes any suggestions on improvements: http://mysqltuner.com/ As always with MySQL, the above are just general starting guidelines. Ultimately, the best possible performance will require a thorough review and optimization by a qualified database administrator, but this should at least be a good start.
  13. WHMCS Lawrence

    POP3 Connection Error

    If your hosting provider has ruled out a DNS resolution issue on the server (as the error messages suggest there is), please feel free to open a ticket with our support team so this can be investigated further.
  14. WHMCS Lawrence

    Order Accept Encountered Problems

    That's good to hear. Hopefully it worked 🙂
  15. WHMCS Lawrence

    POP3 Connection Error

    If using localhost works, that would normally confirm a DNS issue as advised in my last reply, and may be a symptom of a larger issue on the server that will need to be corrected by your system administrator.
  16. WHMCS Lawrence

    Some domain renewals not getting invoiced

    I'd recommend ensuring that the domain wasn't previously invoiced for the current Next Due Date value, as that can cause WHMCS to not invoice for the renewal. A simple way to confirm and correct that is to edit the Next Due Date on the domain and set back backwards by 1 day. Then save your change and use the Invoice Selected Items function on the Client Summary page for the client to generate the renewal invoice.
  17. WHMCS Lawrence

    POP3 Connection Error

    It sounds like the DNS resolvers on your server may be malfunctioning, as IntoDNS reports no issues that should be causing that: https://intodns.com/danumhost.co.uk
  18. WHMCS Lawrence

    POP3 Connection Error

    It would seem that your Zimbra server is returning an "internal server error" message and would need to be investigated and corrected by your system administrator to resolve that. This is unrelated to the other issues in this thread.
  19. WHMCS Lawrence

    Order Accept Encountered Problems

    This would suggest that the product in question was set to use the AutoRelease module instead of cPanel at some point, and still had those values for the advanced settings after switching. If this occurs again, I'd recommend using the Advanced Mode option on the Module Settings for the affected product to correct as needed.
  20. WHMCS Lawrence

    Knowledgebase Tags

    If you use a truncate SQL query on the applicable tables, it should be fine. If you continue to experience issues like this, please contact our support team so we can investigate them further.
  21. WHMCS Lawrence

    Google reCAPTCHA

    If your template is only showing the default captcha, that means it hasn't been updated for the changes needed for captcha in WHMCS 7.7 and having your developer correct that should resolve it: https://docs.whmcs.com/Version_7.7.0_Release_Notes#Template_Changes
  22. WHMCS Lawrence

    Stripe Changes

    3DSecure is only for payments initiated by clients themselves - renewal payments will be handled as they are currently and treated as authorized renewal payments. I'd recommend asking Stripe about how they handle chargeback protection, as that would be part of their own policies and not specific to our module.
  23. WHMCS Lawrence

    Stripe Changes

    This is planned to be in 7.8, along with SCA, which is currently in development and should be available well in advance of Stripe's deadline.
  24. WHMCS Lawrence

    Paypal Subscriptions Changes

    That's correct 🙂 thanks for pointing that out!
  25. WHMCS Lawrence

    Invoice Unpaid Reminder

    If domain reminders are being sent and the domain falls within the invoicing settings (but hasn't been invoiced yet), this suggests that "Disable Auto Renew" is enabled on the domain. Disabling it will allow WHMCS to generate a renewal invoice during the next daily cron tasks run. Alternatively, an invoice can be generated immediately using the "Invoice Selected Items" function on the Client Summary page for the client in the admin area.

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated