|
From: Scott M. <as...@ho...> - 2023-03-28 16:46:36
|
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 |