FUNCTION pianowpdb.JSON_CONTAINS does not exist

  • Resolved pianoworldguy

    (@pianoworldguy)


    5 years, 9 months ago

    WordPress 5.2.1 running Responsive Pro Child 02 theme

    Getting this error message on home page:

    WordPress database error: [FUNCTION pianowpdb.JSON_CONTAINS does not exist]
    SELECT id FROM wp_sfsi_jobqueue WHERE jobtype = ‘1’ AND JSON_CONTAINS(urls,'[3290,3268,3224,3194,3162,3125,2804,2798,2791,2776,2634,2622,2598,2582,2577,2564,2563,2532,2504,2440,2414,2315,2313,2285,2283,2260,2255,2227,2222,2199,2173,2166,2146,2132,2099,2080,2062,2046,1996,1970,1931,1920,1913,1901,1886,1845,1837,1732,1726,1723,1718,1715,1705,1684,1679,1649,1640,1638,1599,1592,1573,1564,1541,1535,1527,1518,1503,1495,1490,1487,1483,1479,1476,1472,1470,1468,1465,1459,1458,1454,1453,1452,1451,1450,1449,1448,1447,1446,1445,1444,1443,1442,1441,1440,1439,1438,1437,1436,1435,1434,1433,1432,1431,1430,1429,1428,1427,1426,1425,1424,1423,1422,1421,1420,1419,1418,1417,1416,1415,1414,1413,1412,1411,1410,1409,1408,1407,1406,1405,1404,1346,1328,1318,1317,1316,1315,1314,1313,1312,1311,1310,1309,1308,1307,1306,1305,1304,1303,1302,1301,1300,1299,1298,1297,1296,1295,1294,1293,1292,1291,1290,1289,1288,1287,1286,1285,1284,1283,1282,1281,1280,1279,1278,1277,1276,1275,1274,1273,1272,1271,1270,1269,1267,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1111,1110,1109,1108,1107,1106,1105,1104,1103,1102,1101,1100,1099,1098,1096,1095,1094,1093,1092,1091,1090,1089,1088,1087,1086,1085,1084,1083,1082,1081,1080,1079,1078,1077,1076,1075,1073,1070,1058,1020,1013,1010,1007,991,988,983,957,954,951,948,927,925,923,921,919,917,915,913,911,909,907,905,901,899,897,895,893,891,889,887,885,883,881,879,877,875,873,871,869,867,865,863,861,859,857,855,853,851,849,847,845,843,841,829,827,825,823,821,819,815,813,802,800,798,796,794,792,790,788,786,784,782,780,778,776,774,772,770,768,766,764,762,760,758,756,754,752,750,748,743,712,710,708,706,704,702,700,674,672,670,668,666,664,662,660,658,656,654,580,552,549,542,532,511,505,502,496,485,482,476,453,448,439,437,434,429,421,417,414,412,397,377,364,342,338,336,330,324,313,293,282,277,268,258,251,246,241,211,179,104,63,55,47,30,1]’)

    Any idea what would cause this, and where I might look to fix it?

    Many thanks,
    Frank B
    Piano World

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator James Huff

    (@macmanx)

    Since that is a commercial theme, we ask that you please go to their official support channel, so you can get support from the people who know it best: https://cyberchimps.com/help/forum/sub-forum/themes-support/premium-themes/

    Forum volunteers are not given access to commercial products, so they would not know why it is not working properly. Other community members who may have faced your issue might be able to help you but your best bet is your product’s developer. Keep in mind we encourage you to use the official support venues, as it allows the developers to be aware of issues with their code and gives back to the community in a more robust way.

    Thread Starter pianoworldguy

    (@pianoworldguy)

    Thanks James, I’ll check in with the cyberchimps folks.

    MrOG

    (@mrgrownupgeek)

    Just as an FYI – we found 5GB of this (and related) errors in the log files of one of our sites – it does not appear to have anything to do with the theme in use. Instead it appears to be caused by the USM Premium plugin..
    We’ve contacted them (a day ago) and so far have not heard back..

    If you learn anything else please post here.

    • This reply was modified 5 years, 9 months ago by MrOG.
    Thread Starter pianoworldguy

    (@pianoworldguy)

    Thanks MrOG,
    Here is what our IT guy found…

    ===========================
    that you’re using functions not available in older versions of mysql
    (though we’re using percona’s mysql clone ‘mariadb’ since they maintain the free version
    of mysql anyway and have augmented it with better performance under
    the name maria, but it’s plug-compatible)

    we were running 10.0 maria, needed 10.2.3 and higher for those json_
    functions.

    had to add a percona software repository to the server’s software distribution
    subscriptions vs using the debian project’s release (which are up to 6-9
    months behind, or sometimes dont appear in the current version and are
    just included in the next version). Next version of debian requires a whole
    server upgrade, dont want to do that just yet til its burned in
    ===========================================================

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘FUNCTION pianowpdb.JSON_CONTAINS does not exist’ is closed to new replies.