Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • July 31, 2015 at 8:19 am in reply to: Mysql Restore Error #35449
    Menon
    Member

    The version of mysql is 5.6.17 

    July 31, 2015 at 8:17 am in reply to: Mysql Restore Error #35448
    Menon
    Member
    INSERT INTO bearheader SET

    routecode = var_routeid,

    documentnumber = docid,

    salesmancode = var_salesmancode,

    customercode = var_customercode,

    `trantype` = var_trantype,

    amountpaid = var_amount,

    totalinvoiceamount  = @totalinvoiceamount,

    invoicebalance = (@totalinvoiceamount-(@amountpaid+var_amount)),

    transactiondate = STR_TO_DATE(var_trandate,’%d-%m-%Y’),

    transactiontime = CURRENT_TIME(NOW()),

    erpreferencenumber  = var_erprefnum,

    created = var_created,

    modified = var_created,

    cdat = NOW(),

    mdat = NOW(),

    currencycode = curre_code,

    pdcstatus = var_paymode;

    — pdcstatus = if(var_paymode=0,1,1);

    SELECT LAST_INSERT_ID() INTO @last_id;

    SELECT @last_id AS last_id;

    SELECT update_acbodocseq_route(var_routeid);

     

    — set abs on var_amount

    SET var_amount = ABS(var_amount);

     

    Back up was taken with sqlyog tool

    July 30, 2015 at 7:53 am in reply to: Mysql Restore Error #35445
    Menon
    Member

    Sorry , I din get any reply , Can you post here if you don mind plz.

    July 29, 2015 at 11:57 am in reply to: #26062
    Menon
    Member

    HI am facing the same restore error . The error is 

     

    Line no.:10516

    Error Code: 1064 – Erreur de syntaxe près de ‘NOW()),

    erpreferencenumber  = var_erprefnum,

    created = var_created,’ à la ligne 60
  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)