Home Forums Support Credit Cards and Banks problem

This topic contains 28 replies, has 2 voices, and was last updated by  Hillel Coren 3 years, 1 month ago.

Viewing 29 posts - 1 through 29 (of 29 total)
  • Author
    Posts
  • #2460

    Anonymous

    Please help .When I click on Credit Cards & Banks I am being redirected to

    /public/settings/bank_accounts and i get message

    Whoops, looks like something went wrong.

    Selfhost , v2.5.0.3 White labeled.

    thanks

    #2461

    Hillel Coren
    Keymaster

    Can you please check storage/logs/laravel.log for details about the error

    #2462

    Anonymous

    [2015-11-17 04:39:13] production.ERROR: exception ‘PDOException’ with message ‘SQLSTATE[28000] [1045] Access denied for user ‘ninja’@’localhost’ (using password: YES)’ in /MY WEBSITE/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:47
    Stack trace:
    is this the problem ? everything else is working fine so invoice ninja has access to database.
    I don’t see any other errors

    #2464

    Anonymous

    I am guessing this function
    public function createConnection($dsn, array $config, array $options)
    {
    $username = array_get($config, ‘username’);

    $password = array_get($config, ‘password’);

    return new PDO($dsn, $username, $password, $options);
    }
    should bring my database username and password from .env file ? not ‘ninja’@’localhost ?

    #2465

    Hillel Coren
    Keymaster

    I’m not sure how likely it is that this is the problem.

    Try clicking the link again and then checking the last line of the log file.

    #2466

    Anonymous

    [2016-03-09 08:39:36] production.ERROR: exception ‘PDOException’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘databse.bank_accounts’ doesn’t exist’ in

    #2467

    Anonymous

    so there is not table bank_accounts in my database and I don’t know why ?

    #2468

    Hillel Coren
    Keymaster

    Please run the SQL query select * from migrations to see which database migrations have run

    #2469

    Anonymous

    and ? what am I looking for ?

    #2470

    Hillel Coren
    Keymaster

    You can compare it against the list of files in database/migrations to see if any migration haven’t been run.

    If there are any missing you can run the migrations manually using the following command

    php artisan migrate

    This can also be done through the app by loading /update

    #2471

    Anonymous

    please can you be more specific on the command . I would love to do it by loading /update but when i type
    mywebsite.com/invoiceninja/update I get 404

    #2472

    Hillel Coren
    Keymaster

    Is this the link for your dashboard page

    mywebsite.com/invoiceninja/dashboard

    #2473

    Anonymous

    mywebsite.com/invoice/public/dashboard

    I don’t know why I have public folder

    #2474

    Hillel Coren
    Keymaster

    Try mywebsite.com/invoice/public/update

    You may be able to remove ‘public/’ by uncommenting a line in .htaccess. Note: you’ll also need to update the APP_URL in the .env file.

    #2475

    Anonymous

    I was unable to use mywebsite.com/invoice/public/update . I did go to softaculous.com and updated my install to 2.5.0.4 but still Credit Cards & Banks gives me error

    #2476

    Hillel Coren
    Keymaster

    Had any migrations not been run?

    #2477

    Anonymous

    I just went to softaculous.com and clicked update icon thats it .I don’t know whats been run whats not . I was unable to run /update . Now I see I have version 2.5.0.4 not 2.5.0.3 but problem is still there . Thats the only thing that is not working . everything else works fine .

    #2478

    Hillel Coren
    Keymaster

    If you run the SQL command listed above it will tell you which have been run

    #2479

    Anonymous

    I do not see anything about credit cards or banking . The latest is 2016_01_04_175228_create_vendors_table

    #2480

    Anonymous

    2013_11_05_180133_confide_setup_users_table 1
    2013_11_28_195703_setup_countries_table 1
    2014_02_13_151500_add_cascase_drops 1
    2014_02_19_151817_add_support_for_invoice_designs 1
    2014_03_03_155556_add_phone_to_account 1
    2014_03_19_201454_add_language_support 1
    2014_03_20_200300_create_payment_libraries 1
    2014_03_23_051736_enable_forcing_jspdf 1
    2014_03_25_102200_add_sort_and_recommended_to_gateways 1
    2014_04_03_191105_add_pro_plan 1
    2014_04_17_100523_add_remember_token 1
    2014_04_17_145108_add_custom_fields 1
    2014_04_23_170909_add_products_settings 1
    2014_04_29_174315_add_advanced_settings 1
    2014_05_17_175626_add_quotes 1
    2014_06_17_131940_add_accepted_credit_cards_to_account_gateways 1
    2014_07_13_142654_one_click_install 1
    2014_07_17_205900_support_hiding_quantity 1
    2014_07_24_171214_add_zapier_support 1
    2014_10_01_141248_add_company_vat_number 1
    2014_10_05_141856_track_last_seen_message 1
    2014_10_06_103529_add_timesheets 1
    2014_10_06_195330_add_invoice_design_table 1
    2014_10_13_054100_add_invoice_number_settings 1
    2014_10_14_225227_add_danish_translation 1
    2014_10_22_174452_add_affiliate_price 1
    2014_10_30_184126_add_company_id_number 1
    2014_11_04_200406_allow_null_client_currency 1
    2014_12_03_154119_add_discount_type 1
    2015_02_12_102940_add_email_templates 1
    2015_02_17_131714_support_token_billing 1
    2015_02_27_081836_add_invoice_footer 1
    2015_03_03_140259_add_tokens 1
    2015_03_09_151011_add_ip_to_activity 1
    2015_03_15_174122_add_pdf_email_attachment_option 1
    2015_03_30_100000_create_password_resets_table 1
    2015_04_12_093447_add_sv_language 1
    2015_04_13_100333_add_notify_approved 1
    2015_04_16_122647_add_partial_amount_to_invoices 1
    2015_05_21_184104_add_font_size 1
    2015_05_27_121828_add_tasks 1
    2015_05_27_170808_add_custom_invoice_labels 1
    2015_06_09_134208_add_has_tasks_to_invoices 1
    2015_06_14_093410_enable_resuming_tasks 1
    2015_06_14_173025_multi_company_support 1
    2015_07_07_160257_support_locking_account 1
    2015_07_08_114333_simplify_tasks 1
    2015_07_19_081332_add_custom_design 1
    2015_07_27_183830_add_pdfmake_support 1
    2015_08_13_084041_add_formats_to_datetime_formats_table 1
    2015_09_04_080604_add_swap_postal_code 1
    2015_09_07_135935_add_account_domain 1
    2015_09_10_185135_add_reminder_emails 1
    2015_10_07_135651_add_social_login 1
    2015_10_21_075058_add_default_tax_rates 1
    2015_10_21_185724_add_invoice_number_pattern 1
    2015_10_27_180214_add_is_system_to_activities 1
    2015_10_29_133747_add_default_quote_terms 1
    2015_11_01_080417_encrypt_tokens 1
    2015_11_03_181318_improve_currency_localization 1
    2015_11_30_133206_add_email_designs 2
    2015_12_27_154513_add_reminder_settings 2
    2015_12_30_042035_add_client_view_css 3
    2016_01_04_175228_create_vendors_table 4

    #2481

    Hillel Coren
    Keymaster

    Thanks, that’s helpful. It looks like you have some migrations that need to be run.

    What happens when you load mywebsite.com/invoice/public/update

    #2482

    Anonymous

    if I am loged in then it redirects me to invoice/public/dashboard if not loged in the to login page

    #2483

    Hillel Coren
    Keymaster

    Please check the last error in the log after loading /update when logged in.

    #2484

    Anonymous

    Nothing . clean .

    #2485

    Hillel Coren
    Keymaster

    Are you able to SSH into the server?

    Please run the following SQL queries

    describe fonts;
    describe accounts;

    #2486

    Anonymous

    I would appreciate if i can contact you tomorrow via email .Its is 5 AM here . lol

    #2487

    Hillel Coren
    Keymaster

    Of course.

    Sorry for the trouble, we’ll work with you until it’s resolved.

    #2492

    Anonymous

    still was unable to fix it please use email [email protected]

    #2493

    Hillel Coren
    Keymaster

    Thanks, we’ve reached out via email.

Viewing 29 posts - 1 through 29 (of 29 total)

You must be logged in to reply to this topic.

Posted in: