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