Jump to content

iHelpersLLC

Members
  • Content count

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

    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!
  2. 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 !
  3. 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?
  4. iHelpersLLC

    Column not found error

    Woot!
  5. 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!
  6. 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
  7. 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?
  8. 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..
  9. 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.
  10. iHelpersLLC

    Column not found error

    Thanks.. I ran the conversion process but i'm still seeing the same error when adding a new client.
  11. 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/
  12. iHelpersLLC

    7.5.2->7.6 Failed

    That did the trick, thank you!
  13. 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 ?
  14. iHelpersLLC

    Update Message Validation Issue

    Thanks, i literally JUST saw that post right after i posted this..
  15. What does this mean? (see attached)
×

Important Information

By using this site, you agree to our Terms of Use & Guidelines