Jump to content

aussie2

Member
  • Posts

    4
  • Joined

  • Last visited

Profile Information

  • Gender
    Male

aussie2's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. 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
  2. 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.
  3. 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 ?
  4. aussie2

    Paypal Error

    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:
×
×
  • Create New...