Subject Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
Author Mr. John
Post date 2019-06-12T14:53:26Z
solved with something like that
thanks


On Wednesday, June 12, 2019, 5:50:52 PM GMT+3, Michel LE CLEZIO mlcvista@... [firebird-support] <firebird-support@yahoogroups.com> wrote:


 

Hello,

May be you build an empty Fb2.5 database with the same structure (Tables, Generators…)
Export the FB3 datas into SQL...
Adapt the sql.. and execute them into FB2.5...

With best regards,
Mikey

Le mercredi 12 juin 2019 à 12:57:08 UTC+2, 'Mr.. John' mr_johnmr@... [firebird-support] <firebird-support@yahoogroups.com> a écrit :


 

I've extracted db into a script,but when restoring got almost the same error: 

 Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 1, column 36.
START.

error is on every generator code:

 CREATE GENERATOR GEN_HT_MENT_ID START WITH 0 INCREMENT BY 1;
  SET GENERATOR GEN_HT_MENT_ID TO 1;

in my app I have no such code,for generators I used this:

CREATE GENERATOR GEN_HT_MENT_ID;
SET GENERATOR GEN_HT_MENT_ID TO 1;


thanks





thanks

On Wednesday, June 12, 2019, 1:25:40 PM GMT+3, Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com> wrote:


12.06.2019 12:20, 'Mr. John' mr_johnmr@... [firebird-support] wrote:
> what other way I could use?

  Create database from scratch, pump data.



--
  WBR, SD.


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

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www..firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoogroups.com
    firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/