Upgrade Problem 5.2.2 - Lost Products from Categories

[aussie2]

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: [418] "SELECT * FROM `cc_CubeCart_code_snippet` ;" - Table 'cheapam_cube323.cc_CubeCart_code_snippet' doesn't exist

 

File: [catalogue.class.php] Line: [778] "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: [474] "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: [282] "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 ?

[aussie2]

I found a solution to the problem in the forums.

 

All I needed to do was, in the admin panel,  change the skin to another then back again, all the products now display in the categories.

[bsmither]

The "Table doesn't exist" error tells me to check to see if those tables were actually created. If not, let us know.