Running 2.8.2 build 23072, I'm seeing this in my logs regularly during rebuilds. Looks like it is not substituting $mysqlTable with the correct table name when sending the SQL command?

Mar-28-23 05:17:09 [Worker_10001] PreventBulkImport is set to ON - can't drop table hmmdb - need to move records
Mar-28-23 05:17:09 [Worker_10001] Clearing table hmmdb
Mar-28-23 05:17:09 [Worker_10001] Move data from hmmdbtmp to hmmdb
Mar-28-23 05:17:09 [Worker_10001] Database copyhmmdb statement failed (hmmdb): Can't Execute Command 'INSERT INTO $mysqlTable SELECT * FROM hmmdbtmp'

      Package    : DBD::ADO::st
      Filename   : C:/Perl/perl/vendor/lib/DBD/ADO.pm
      Line       : 1244
      Last error : -2147217900

    OLE exception from "Microsoft SQL Server Native Client 11.0":

    Incorrect syntax near '$mysqlTable'.

    Win32::OLE(0.1712) error 0x80040e14
        in METHOD/PROPERTYGET "Execute"

            Description : Incorrect syntax near '$mysqlTable'.
            HelpContext :
               HelpFile :
            NativeError : 102
                 Number : -2147217900
                 Source : Microsoft SQL Server Native Client 11.0
               SQLState : 42000






_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test

Reply via email to