Date: Tuesday June 17, 2025
Time: 2025-06-17
System Error: General Search SQL Query execution failed
SQL statement: SELECT citemno, cdescript, nprice, nspprice, dspstart, dspend, onhand, nbook, nonorder, cclass,zweb, zccategory, zcauthor, zcbooktype, category, size_display, zsize, nweight, nlistprice, flagpromo, promodesc, ( (1.3 * (MATCH(cdescript_index) AGAINST (? IN BOOLEAN MODE))) + (.6 * MATCH(citemno_search, accessory_keywords, case_keywords, string_keywords, book_keywords, instrument_keywords, size_search) AGAINST (? IN BOOLEAN MODE))) AS score FROM smusicsearch WHERE MATCH(citemno_search, cdescript_index, accessory_keywords, case_keywords, string_keywords, book_keywords, instrument_keywords, size_search) AGAINST (? IN BOOLEAN MODE) and zweb != 'N' and nprice > 0 and cprodline = 'NS' ORDER BY itemonsale DESC, score DESC
DBI::err: 1146
DBI::errstr: Table '73880_1.smusicsearch' doesn't exist