aussie2 Posted May 22, 2013 Share Posted May 22, 2013 I have just upgraded to 5.2.2 from 5.1.5 via the admin panel. The categories in the store now show 'no products' (in the front end). I can still see product in 'Popular Product', 'Latest Product' and 'On Sale', and can find a product by searching. The products are all there still in admin and assigned to categories though. There are a lot of errors showing in the log, eg: File: [hookloader.class.php] Line:  "SELECT * FROM `cc_CubeCart_code_snippet` ;" - Table 'cheapam_cube323.cc_CubeCart_code_snippet' doesn't exist File: [catalogue.class.php] Line:  "SELECT MAX(stock_level) AS `stock_level` FROM `cc_CubeCart_option_matrix` ;" - Table 'cheapam_cube323.cc_CubeCart_option_matrix' doesn't exist File: [catalogue.class.php] Line:  "SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_inventory` WHERE `product_id` IN (151,152,931,930,934,767,768,769,770,771,811,812,813,814,815,816,818,819,820,826,822,823,824,825,827,828,829,830,831,832,833,834,835,836,837,838,878,879,880,843,844,845,859,860,861,862,863,864,865,867,874,891,892,893,894,895,925,1050,1051,1052,1061,1063,1065,1068,1069,1513,1071,1072,1073,1074,1075,1076,1078,1079,1083,1087,1090,1091,1092,1094,1097,1100,1101,1102,1103,1104,1105,1106,1107,1108,1044,1054,1144,1148,1149,1150,1151,1152,1156,1157,1158,1159,1161,1162,1163,1165,1183,1184,1211,1236,1280,1303,1444,1449,1455,1460,1461,1462,1463,1464,1465,1473,1492,1514,1517,1518,1519,1531,1532,1533,1534,1543,1544,1545,1546,1585,1588,1589,1650,1677,1680,1681,1703,1800,1825,1852,1853,1854,1855,1856,1857,1858,1859,1863,1864) AND cc_CubeCart_inventory.status = '1' ORDER BY `0` LIMIT 20 OFFSET 60;" - Unknown column '0' in 'order clause' File: [catalogue.class.php] Line:  "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `cc_CubeCart_option_matrix` LIMIT 1;" - Table 'cheapam_cube323.cc_CubeCart_option_matrix' doesn't exist I did do a full store and database backup before installing. What should I do ? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.