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

Mysql Restore Error

forums › forums › SQLyog › Using SQLyog › Mysql Restore Error

Tagged: 

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • July 29, 2015 at 11:26 am #13396
      Menon
      Member

      Hi 

       

      When am trying to restore the database using  sqlyog . I get the error as attached below 

       

      Error occured at:2015-07-29 11:02:49

      Line no.:10516

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

      erpreferencenumber  = var_erprefnum,

      created = var_created,’ à la ligne 60

       

      Wamp version: 2.4 32 bit

      Apache version:2.4.9

      Php version : 5.5.12

      Mysql version : 5.6.17

    • July 30, 2015 at 7:37 am #35444
      peterlaursen
      Participant

      You posted the same in the “SQLyog” category (the right place), and I replied there.

    • July 30, 2015 at 7:53 am #35445
      Menon
      Member

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

    • July 30, 2015 at 12:03 pm #35446
      peterlaursen
      Participant

      I asked you to show line 60 of your script (take lines 55-65 for instance). I also asked with what tool/program this dump was created.

    • July 30, 2015 at 12:03 pm #35447
      peterlaursen
      Participant

      And now I am moving this to SQLog category. 

    • July 31, 2015 at 8:17 am #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 31, 2015 at 8:19 am #35449
      Menon
      Member

      The version of mysql is 5.6.17 

    • July 31, 2015 at 10:32 am #35450
      peterlaursen
      Participant

      This looks extremely stange. No constants in the INSERT statement. This is not from an SQL dump but from a script of some(other) kind. Are you sure that you are not mismatching files (or maybe had overwritten a dump/backup with a script)?

  • Author
    Posts
Viewing 7 reply threads
  • You must be logged in to reply to this topic.