Jump to content

WHMCS Lawrence

WHMCS Technical Analyst
  • Content count

  • Joined

  • Last visited

  • Days Won


WHMCS Lawrence last won the day on July 19

WHMCS Lawrence had the most liked content!

Community Reputation

4 Neutral

About WHMCS Lawrence

  • Rank
    WHMCS Technical Analyst

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. 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.
  2. 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.
  3. We are glad to hear that our team was able to help 🙂
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. WHMCS Lawrence

    Order Accept Encountered Problems

    That's good to hear. Hopefully it worked 🙂
  12. 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.
  13. 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.
  14. 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
  15. 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.

Important Information

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