4.0 update error

(2 posts) (2 voices)
  1. tkuisma, Member

    When we try to update to MyDBR 4.0 version, the install script gives an error:

    Incorrect syntax near ';'.

    update #mydbr_languages_tmp
    set date_format = 'Y-m-d', time_format = 'H:i:s', thousand_separator = ' ', decimal_separator = ','
    where lang_locale in ('sv_SE', 'lt_LT');

    The database is Sybase ASE 15.5. Might this be because of an incorrect SQL command separator?

  2. myDBR Team, Key Master

    Yes,
    the Sybase DB script had extra semicolons. You can remove them from the install/db_creation/mydbr_create_sybase.sql.

    We've created a new build without the extra semicolons for Sybase.

    Thank you for reporting the issue.
    --
    myDBR Team


Reply

You must log in to post.