Jump to content

iHelpersLLC

Members
  • Content count

    51
  • Joined

  • Last visited

Community Reputation

10 Good

About iHelpersLLC

  • Rank
    Member

Recent Profile Visitors

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

  1. iHelpersLLC

    Change domain associated with hosting ?

    and not cause any other issues?
  2. 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?
  3. 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.
  4. 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!
  5. iHelpersLLC

    Oops! Column not found

    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 !
  6. iHelpersLLC

    Automatically run & email a report?

    Is it possible to automatically run and email a specific report every day/week/month? If so, what is involved/how?
  7. iHelpersLLC

    Column not found error

    Woot!
  8. 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!
  9. 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
  10. 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?
  11. 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..
  12. 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.
  13. iHelpersLLC

    Column not found error

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

    Column not found error

    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/
  15. 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