ERROR: DBIx::Class::ResultSet::next(): DBI Exception: DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQL-40001) [for Statement " SELECT ID, Department, Category, Features, Brand, Model, Description1, Price, New, Popular, Sale, NumBrand, Length, Width, Stock, Cost, Bestselling, UPC, Popularity FROM ( SELECT ID, Department, Category, Features, Brand, Model, Description1, Price, New, Popular, Sale, NumBrand, Length, Width, Stock, Cost, Bestselling, UPC, Popularity, ORDER__BY__1, ROW_NUMBER() OVER( ORDER BY ORDER__BY__1 DESC ) AS rno__row__index FROM ( SELECT me.ID, me.Department, me.Category, me.Features, me.Brand, me.Model, me.Description1, me.Price, me.New, me.Popular, me.Sale, me.NumBrand, me.Length, me.Width, me.Stock, me.Cost, me.Bestselling, me.UPC, me.Popularity, popularity AS ORDER__BY__1 FROM Product me WHERE ( CONTAINS((department, category, features), ? ) AND CONTAINS((department, category, features), ? ) AND CONTAINS((department, category, features), ? ) AND CONTAINS((features), ? ) AND category != ? AND stock > ? ) ) me ) me WHERE rno__row__index >= ? AND rno__row__index <= ? " with ParamValues: 1='a.d.u.l.t.', 2='s.e.x.', 3='t.o.y.s.', 4='i.n._.s.t.o.c.k.', 5='s.e.r.v.i.c.e.', 6='0.', 7='1.', 8='1.0.'] at C:/websites/http/dearladyus/modules/WMAG/Base.pm line 2070