aussie2
-
Posts
4 -
Joined
-
Last visited
Posts posted by 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.
-
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 ?
-
I am getting the same error ... my API info is all correct ... we have not changed anything on the site config and the server has not had any Apache or PHP updates done ....
Just started doing this after running for months OK ... any answers out there ????
Is it possible the "token" is not being created for some reason and it does the else include for APIError.php?
Otherwise would expect to get some error info returned from PayPal. ?????
The PayPal API has returned an error!
Ack:
Correlation ID:
Version:
Error Number:
Short Message:
Long Message:
Multiple System Errors
in Technical Help
Posted
I am getting thousands of system errors each day - more than a thousand each hour.
The store does appear to be working fine however.
Any suggestions as to what the problem may be?
I am using v5.2.2 and want to upgrade to v5.2.14 - should I fix this problem first?
Examples:
File: [hookloader.class.php] Line: [418] "SELECT * FROM `cc_CubeCart_code_snippet` ;" - Table 'cheapam_cube323.cc_CubeCart_code_snippet' doesn't exist
File: [products.index.inc.php] Line: [1033] "SELECT A.option_id, A.value_id ,V.value_name, G.option_name FROM `cc_CubeCart_option_assign` AS `A` INNER JOIN `cc_CubeCart_option_value` AS `V` ON A.value_id = V.value_id INNER JOIN `cc_CubeCart_option_group` AS `G` ON A.option_id = G.option_id WHERE `product` = 3967 AND `set_enabled` = 1 AND `matrix_include` = 1 ORDER BY A.option_id, A.value_id ASC" - Unknown column 'matrix_include' in 'where clause'
File: [products.index.inc.php] Line: [1091] "UPDATE `cc_CubeCart_option_matrix` SET `status` = 0 WHERE `product_id` = 3967 AND `options_identifier` NOT IN ('')" - Table 'cheapam_cube323.cc_CubeCart_option_matrix' doesn't exist
File: [catalogue.class.php] Line: [478] "SELECT * FROM `cc_CubeCart_option_matrix` ;" - Table 'cheapam_cube323.cc_CubeCart_option_matrix' doesn't exist