Jump to content

iHelpersLLC

Senior Member
  • Content count

    60
  • Joined

  • Last visited

Everything posted by iHelpersLLC

  1. I have suspended a hosting package on an account (for non-billing reasons) and was surprised when an invoice went out as the next due date approached. Are invoices supposed to still go out for a suspended package? How can I suppress any invoices for a package while it's suspended ?
  2. iHelpersLLC

    Does 'Suspending' a hosting package stop invoicing?

    Great, thank you very much!
  3. We have added a few new hosting packages in cPanel (WHM) but when we try to configure them in WHMCS, they arent showing on the WHM Package Name list. We've beat that poor little refresh-button to death, but the list is still not updating. The server is active and set as default in WHMCS (has the * next to it in the server list) Are there any troubleshooting documents or tips on what to check/how to resolve this? thanks! Using WHMCS V7.6.1, cPanel/WHM 82.0.17 EDIT: Fixed! For anyone else having this issue, in our case it was the naming of the packages that was causing the problems. The packaged were inadvertently named somthing_package1, something_package2, etc.. The "something_" was hiding the reseller account and WHMCS from seeing them. Created new packages with out "something_" at the beginning and everything is working perfectly. For
  4. I am going to be moving some customers accounts (whmcs and cpanel) from my WHMCS to another webhost that is also using WHMCS and cpanel/WHM. is there any documentation on how to best get these accounts to the new server and sync'd up in the new server?
  5. Version 7.6.1 I'm having a problem where some customers are not getting invoices or reminders generated and sent.. It's not they they aren't being delivered, it looks like the system is never generating item, based on looking at the email log list for the customers. Most invoices/reminders are being generated for the majority of customers, even other reminders & invoices for these particular customers that sometimes are not getting them. These customers have multiple services/products and it looks like some are just getting invoices/reminders, and others simply arent.. As far as I can see the particular products are all configured correctly (but, i could be missing something) -- How can I troubleshoot this?
  6. iHelpersLLC

    Some Invoice & Reminder Emails Not Generated

    Yes? Everything else has been working fine on PHP7.2, but the cron was dying before getting to generating the invoices and reminders.. Never dug deep enough to get the actual failure errors/messages because I had a client on my back screaming about how no invoices going out means no money for him or some such thing, so as soon as I realized it was PHP7.2 I hastily went back to 7.0 ..
  7. iHelpersLLC

    Some Invoice & Reminder Emails Not Generated

    Confirmed.. The WHMCS V7.6.1 install did not play well with PHP V7.2 .. Reverted PHP to 7.0 and all is right with the world again..
  8. iHelpersLLC

    Some Invoice & Reminder Emails Not Generated

    Thanks @WHMCS ChrisD that article got me looking in the right direction.. Looks like there may be a problem with the newer version of PHP (7.2) that we upgraded to a few weeks ago..
  9. On the WHMCS admin login page, even when I click the "remember me" box, if I come back just a little while later, I have to log-in all over again.. I understand that this is important for security, but it seems to have a very short memory.. What is the "remember me" length of time and can it be adjusted?
  10. I have a client that signed up and ordered hosting with a domain that they never used (wrongdomain.com).. They created an add-on domain (correctdomain.com) that they now use. The hosting product-list, invoices, etc, all show “wrongdomain.com”. Is changing their ‘primary’ domain from wrongdomain.com to correctdomain.com as easy as going into the Products/Services screen for their hosting package and changing the domain? Will this affect anything other than what shows on their bills, etc? ie; wont change/break anything in their cPanel account?
  11. iHelpersLLC

    Change domain associated with hosting ?

    and not cause any other issues?
  12. iHelpersLLC

    I can not disable captcha

    Was having the same issue.. Using 7.7, but had customized copy of "Six" that I was using (not even sure how/why).. Switched to "Six" and the Captcha settings started to do what they were supposed to do.
  13. This is the 3rd or 4th of these missing column issues I've had in the last few months. It seems that somewhere along the line an upgrade went sideways.. This is the error I got today when trying to update domain pricing: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'grace_period' in 'field list' (SQL: update `tbldomainpricing` set `dnsmanagement` = 0, `emailforwarding` = 0, `idprotection` = 1, `eppcode` = 1, `grace_period` = -1, `grace_period_fee` = 0.00, `redemption_grace_period` = -1, `redemption_grace_period_fee` = 0.00, `updated_at` = 2018-11-26 11:02:06 where `id` = 1) In all previous cases adding the column was a quick easy fix, and each time I got the exact SQL statement needed or the data-type/info so I could manually add it in PHPMyAdmin from the experts here, so looking forward to more expert help. TIA !
  14. iHelpersLLC

    Oops! Column not found

    Thank you, i didnt even know those were there in the /resources directory and as you mentioned there were several others columns missing. Added them all and now no more OOPS!
  15. Is it possible to automatically run and email a specific report every day/week/month? If so, what is involved/how?
  16. iHelpersLLC

    Column not found error

    Woot!
  17. I got this error today (below, and edited for brevity) when trying to add a new customer. It created/added the customer but i'm guessing it was just this one record that didnt get added.. I'm hoping this table just needs to be added into the database or something easy like that? PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marketingemailsoptin' in 'field list' in /home/vendor/illuminate/database/Connection.php:462 WHMCS\User\Client->marketingEmailOptOut('71.x.x.210', false) Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marketingemailsoptin' in 'field list' (SQL: update `tblclients` set `updated_at` = 2018-09-04 16:25:26, `marketingemailsoptin` = 0 where `id` = 104) in /home/
  18. iHelpersLLC

    Column not found error

    Thanks.. I just opened a support ticket, but if you can give me that SQL I'll add it and make the support-guy's lives easier!
  19. iHelpersLLC

    Column not found error

    Ok, after some coffee i added the column, but now i get this error, which tells me something went wrong/was missed at some point during one of the upgrades: Base table or view not found: 1146 Table 'whmcs.tblmarketing_consent' doesn't exist
  20. iHelpersLLC

    Column not found error

    Duh.. thank you. Can anyone else confirm the name the column? In my error it's shown as "marketingemailsopin" but in @brian! 's post its shown as marketing_emails_opt_in .. Would i just create the name that the error indicates it's looking for?
  21. iHelpersLLC

    Column not found error

    I guess i dont know how to add a table in PHPMyadmin (although i've done it many times in the past) .. if anyone could post the SQL for this, that would be much helpful. BTW - the board/community appears to be borked today so hopefully this posts..
  22. iHelpersLLC

    Column not found error

    Just checked and it's not there, this is very similar to an issue I had upgrading 7.5.2->7.6 which also had missing entries: So now i'm sure that adding that column will fix it - but I need the syntax.. If @string isnt around I'll contact support.
  23. iHelpersLLC

    Column not found error

    Thanks.. I ran the conversion process but i'm still seeing the same error when adding a new client.
  24. iHelpersLLC

    7.5.2->7.6 Failed

    Tried to run the update and got this error: Unable to complete incremental updates: Unable to import the 7.6.0 Alpha1 database file. Unable to import /home/xx/public_html/ihexx/resources/sql/upgrade760alpha1.sql: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ihexx_ihelxxs_whmcs5.tblioncube_file_log' doesn't exist Error log says: [2018-07-31 10:55:19][WHMCS Installer] DEBUG: Installer bootstrapped [] [2018-07-31 10:55:29][WHMCS Installer] DEBUG: Installer bootstrapped [] [2018-07-31 10:55:30][WHMCS Installer] INFO: Previous install detected [] [2018-07-31 10:55:31][WHMCS Installer] DEBUG: An upgrade from 7.5.2-release.1 to 7.6.0-release.1 will be attempted. [] [2018-07-31 10:55:52][WHMCS Installer] DEBUG: Installer bootstrapped [] [2018-07-31 10:55:52][WHMCS Installer] INFO: Applying incremental updates to existing installation [] [2018-07-31 10:55:52][WHMCS Installer] INFO: Applying Updates for 7.6.0-alpha.1 [] [2018-07-31 10:55:52][WHMCS Installer] ERROR: Unable to complete incremental updates: Unable to import the 7.6.0 Alpha1 database file. Unable to import /home/ihexx/public_html/ihxx/resources/sql/upgrade760alpha1.sql: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ihexx_ihxx_whmcs5.tblioncube_file_log' doesn't exist [] [2018-07-31 10:56:04][WHMCS Installer] ERROR: Upgrade process terminated due to error. [] [2018-07-31 10:57:16][WHMCS Installer] DEBUG: Installer bootstrapped [] [2018-07-31 10:57:19][WHMCS Installer] DEBUG: Installer bootstrapped [] [2018-07-31 10:57:19][WHMCS Installer] INFO: Previous install detected [] [2018-07-31 10:57:19][WHMCS Installer] DEBUG: An upgrade from 7.5.2-release.1 to 7.6.0-release.1 will be attempted. [] [2018-07-31 10:57:23][WHMCS Installer] DEBUG: Installer bootstrapped [] [2018-07-31 10:57:23][WHMCS Installer] INFO: Applying incremental updates to existing installation [] [2018-07-31 10:57:23][WHMCS Installer] INFO: Applying Updates for 7.6.0-alpha.1 [] [2018-07-31 10:57:23][WHMCS Installer] ERROR: Unable to complete incremental updates: Unable to import the 7.6.0 Alpha1 database file. Unable to import /home/ihxx/public_html/ihxx/resources/sql/upgrade760alpha1.sql: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ihxx_ihelxx_whmcs5.tblioncube_file_log' doesn't exist [] [2018-07-31 10:57:23][WHMCS Installer] ERROR: Upgrade process terminated due to error. [] Easy way forward ?
  25. iHelpersLLC

    7.5.2->7.6 Failed

    That did the trick, thank you!
×

Important Information

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