[ic] Odd search behavior

[DB]

> I'm migrating an existing (modified foundation, 5.4.2, mysql) catalog to 
> a new server. I've copied all of the templates, pages, database tables etc.
> 
> Old server: http://domain.com/cgi-bin/store/index.html
> 
> I changed the variables.txt such that the new server runs on: 
> http://test.domain.com/cgi-bin/store/index.html
> 
> The new catalog runs fine except for one strange thing. On the old 
> server, the following URL will display matches as expected:
> 
> http://domain.com/cgi-bin/store/scan/se=ST123/sf=sku
> 
> but on the new server,
> 
> http://test.domain.com/cgi-bin/store/scan/se=ST123/sf=sku
> 
> brings up no matches. Searching for ST123 on the "Small search box" 
> however does work. The data in the tables appears to be identical 
> between the two servers. The catalog and main error logs show nothing.
> 
> Can anyone help me figure out why this might be happening?
> 
> DB

I fixed this issue by removing the products.sql file then restarting IC. 
Maybe it had something to do with different versions of MySQL between 
the servers. That's just a guess, but the problem did go away.

DB