[Dxspider-support] MYSQL duplication/mass insertion on restart

Jason R Begley jayray at digitalgoat.com
Thu Feb 16 02:34:07 GMT 2012


I apologize, I spoke to soon. After upgrading to the current CVS tarball 
it is still doing the same things... I forgot that I needed to modify 
the perl/DXSql.pm and change line 46 to "my $newclass = "DXSql::mysql";" 
because it will not pick up my settings from the DSN string "$dsn = 
"DBI:mysql:database=dxspider;127.0.0.1:3306";". The issue still remains 
as it reloads all the spots into sql at startup and I end up with 
duplicated spots in my db. Does it cleanup the spots as it inserts them, 
or not insert old spots if the table exists?
Thanks & 73
KY9J





More information about the Dxspider-support mailing list