Jump to content

iHelpersLLC

Members
  • Content count

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

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

    Column not found error

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

    Column not found error

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

    7.5.2->7.6 Failed

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

    Update Message Validation Issue

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

    Extending due-date with PayPal subscription does not work?

    Thanks guys.. I ended up manually cancelling the subscription - didnt realize i could also "suspend" it which would have been the better option.
  15. I have found that if a customer has a paypal subscription for payments and I extend their due-date (for example, free month of service or whatever), the Paypal subscription payment is still made each month, even though the service is not due and, worse, the due-date is not extended for their payment; Example: Paypal subscription payment made May 1, next due date now = June 1 On may 5 I extend the due date manually to September 1 On June 1, Paypal subscription payment is made again (even though not due until Sept) and the Next Due date remains September 1 (should be bumped out 1 month!) Is this a bug/issue, or am I extending due dates/giving credit wrong?
×

Important Information

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