Warning: Missing argument 15, 16, 17

(3 posts) (2 voices)
  • Started 12 months ago by Aardvark
  • Latest reply from myDBR Team

Tags:

No tags yet.

  1. Aardvark, Member

    Hi,

    I'm Getting the following errors, when running an import on two seperate imports.

    Warning: Missing argument 15 for Import::process(), called in /var/mydbr/lib/import.php on line 91 and defined in /var/mydbr/lib/import.php on line 186

    ( ! ) Warning: Missing argument 16 for Import::process(), called in /var/mydbr/lib/import.php on line 91 and defined in /var/mydbr/lib/import.php on line 186

    ( ! ) Warning: Missing argument 17 for Import::process(), called in /var/mydbr/lib/import.php on line 91 and defined in /var/mydbr/lib/import.php on line 186

    ------------------------------

    DROP PROCEDURE IF EXISTS sp_DBR_Import_Receipt_Bank
    $$
    CREATE PROCEDURE `sp_DBR_Import_Receipt_Bank`()
    BEGIN

    select 'dbr.import.options', 'format', 'csv';
    select 'dbr.import.options', 'csv_delimiter', ',';
    select 'dbr.import.options', 'csv_enclosure', '"';
    select 'dbr.import.options', 'skip_header', 1;

    select 'dbr.import', 'sp_DBR_Import_Receipt_Bank_Data_do' ,'https://reports.shopaardvark.com/user/receipts.csv', 'now';

    END
    $$

    ------------------------------

    DROP PROCEDURE IF EXISTS sp_DBR_Import_Receipt_Bank_Data_do
    $$
    CREATE PROCEDURE `sp_DBR_Import_Receipt_Bank_Data_do`(

    receipt_bank_id varchar(100),
    invoice_type varchar(20),
    invoice_date datetime,
    invoice_due_date datetime,
    invoice_number varchar(100),
    supplier varchar(100),
    category_nominal varchar(100),
    client_sage_supplier_code varchar(100),
    project_t_code varchar(100),
    payment_method varchar(100),
    bank_account varchar(100),
    vat decimal(10,2),
    net decimal(10,2),
    total decimal(10,2),
    currency varchar(10),
    vat_gbp decimal(10,2),
    net_gbp decimal(10,2),
    total_gbp decimal(10,2),
    rb_status varchar(20),
    notes varchar(20),
    description varchar(20)

    )

    begin

    SET max_sp_recursion_depth = 15;

    /* Do some checking / modifications here */

    INSERT INTO c93_icon_live.aardvark_purchase_invoices (receipt_bank_id, invoice_type, invoice_date, invoice_due_date, invoice_number, supplier, category_nominal, client_sage_supplier_code, project_t_code, payment_method, bank_account, vat, net, total, currency, vat_gbp, net_gbp, total_gbp, rb_status, notes, description)

    VALUES (receipt_bank_id, invoice_type, invoice_date, invoice_due_date, invoice_number, supplier, category_nominal, client_sage_supplier_code, project_t_code, payment_method, bank_account, vat, net, total, currency, vat_gbp, net_gbp, total_gbp, rb_status, notes, description)

    ON DUPLICATE KEY UPDATE

    receipt_bank_id=VALUES(receipt_bank_id),
    invoice_type=VALUES(invoice_type),
    invoice_date=VALUES(invoice_date),
    invoice_due_date=VALUES(invoice_due_date),
    invoice_number=VALUES(invoice_number),
    supplier=VALUES(supplier),
    category_nominal=VALUES(category_nominal),
    client_sage_supplier_code=VALUES(client_sage_supplier_code),
    project_t_code=VALUES(project_t_code),
    payment_method=VALUES(payment_method),
    bank_account=VALUES(bank_account),
    vat=VALUES(vat),
    net=VALUES(net),
    total=VALUES(total),
    currency=VALUES(currency),
    vat_gbp=VALUES(vat_gbp),
    net_gbp=VALUES(net_gbp),
    total_gbp=VALUES(total_gbp),
    rb_status=VALUES(rb_status),
    notes=VALUES(notes),
    description=VALUES(description);

    end
    $$

    ------------------------------

    Any help is appreciated.

    Best Regards

    John

    Posted 12 months ago #
  2. Aardvark, Member

    Using 4.8

    Posted 12 months ago #
  3. myDBR Team, Key Master

    Could you run the updater and try again. There was a problem with immediate imports (now-option). The problem is fixed in the latest build.

    --
    myDBR Team

    Posted 12 months ago #

Reply

You must log in to post.