Posts Not Displaying on Front-End: Insane SQL Query
Problem: Posts not displaying on front-end
Our website using BeBuilder - Blog Component - stopped showing posts on the front end. We have "Public" posts and "Members Only" posts for our paying members, and I use post categories to handle the logic.
Site: https://www.thequartering.com
Either way, no posts display on the front end - they DO show up when in BeBuilder edit mode.
In looking at the logs, there are some wicked queries happening. I may have to write special code to fetch posts. But before I do that, is this a known issue?
Below are two examples that I suspect are causing the issue.
Example 1:
{ "installName": "thequarteringc", "environment": "PROD", "type": "error", "date": "2025-03-20T18:06:28.549Z", "severity": null, "client": null, "message": "KILLED QUERY (20991 characters long generated in /nas/content/live/thequarteringc/wp-content/plugins/woocommerce-payments/vendor/automattic/jetpack-sync/src/sync-queue/class-queue-storage-table.php:307): SELECT event_id AS id, event_payload AS value#012#011#011#011#011FROM thequartering_jetpack_sync_queue#012#011#011#011#011WHERE queue_id = 'sync' AND event_id IN ( 'jpsq_sync-1742440199.752823-376893-1', 'jpsq_sync-1742440199.759210-376893-2', 'jpsq_sync-1742440199.763089-376893-3', 'jpsq_sync-1742440199.765633-376893-4', 'jpsq_sync-1742440199.767544-376893-5', 'jpsq_sync-1742440199.773052-376893-6', 'jpsq_sync-1742440199.774882-376893-7', 'jpsq_sync-1742440199.777683-376893-8', 'jpsq_sync-1742440199.780561-376893-9', 'jpsq_sync-1742440199.782537-376893-10', 'jpsq_sync-1742440199.785311-376893-11', 'jpsq_sync-1742440199.787202-376893-12', 'jpsq_sync-1742440199.789960-376893-13', 'jpsq_sync-1742440199.800076-376893-14', 'jpsq_sync-1742440199.803193-376893-15', 'jpsq_sync-1742440199.806001-376893-16', 'jpsq_sync-1742440199.808963-376893-17', 'jpsq_sync-1742440199.810932-376893-18', 'jpsq_sync-1742440199.813696-376893-19', 'jpsq_sync-1742440199.816593-376893-20', 'jpsq_sync-1742440199.821973-376893-21', 'jpsq_sync-1742440199.824573-376893-22', 'jpsq_sync-1742440199.859438-376893-23', 'jpsq_sync-1742440199.872923-376893-24', 'jpsq_sync-1742440199.874936-376893-25', 'jpsq_sync-
Cutting it short here due to character limit but goes on
Example 2:
{ "installName": "thequarteringc", "environment": "PROD", "type": "error", "date": "2025-03-20T18:06:26.702Z", "severity": null, "client": null, "message": "KILLED QUERY (21967 characters long generated in /nas/content/live/thequarteringc/wp-content/themes/betheme/muffin-options/theme-options.php:96): SELECT thequartering_posts.*#012#011#011#011#011#011 FROM thequartering_posts #012#011#011#011#011#011 WHERE 1=1 AND thequartering_posts.ID NOT IN (11485,11486,11503,11504,11505,11539,11570,11618,11633,11724,11992,12163,12191,12329,12341,12395,12437,12451,12524,12526,12569,12628,12643,12680,12682,12774,12776,12870,12872,12883,13003,13005,13076,13152,13169,13590,13780,13841,14040,14116,26,30,31,33,61,64,66,68,70,72,74,90,92,94,96,98,100,102,104,106,112,114,116,128,130,132,134,136,138,140,142,150,152,154,156,158,160,168,170,172,174,176,178,192,194,196,198,200,202,208,210,212,214,216,218,220,222,230,232,234,236,238,240,242,250,252,255,257,266,268,270,272,274,282,284,286,288,290,292,294,300,302,304,306,308,310,319,321,323,326,328,331,334,336,338,342,346,348,352,355,357,360,363,365,367,371,376,380,383,385,390,392,394,397,399,402,404,406,409,412,414,418,420,428,430,432,438,440,443,445,449,451,455,457,459,461,464,467,469,471,473,481,484,487,491,493,499,501,503,506,510,513,516,518,520,525,530,534,537,540,542,544,549,552,556,559,561,565,567,569,571,573,575,577,579,583,586,588,591,593,596,598,600,603,605,608,610,615,617,619,622,624,627,629,631,634,636,638,640,642,647,649,651,653,656,658,660,663,665,667,672,675,682,684,686,692,694,697,699,704,706,709,711,714,718,721,723,725,727,730,732,734,736,739,741,745,748,750,753,755,757,759,764,767,775,777,783,786,792,795,798,800,804,807,810,813,817,820,823,826,829,832,834,837,840,845,847,850,852,855,858,860,862,865,868,870,872,875,878,880,882,885,888,890,892,894,896,898,901,906,908,911,913,915,917,919,922,925,927,929,931,934,937,939,941,943,948,951,953,956,958,960,962,965,967,971,973,975,978,980,985,988,990,992,994,996,998,1000,1003,1006,1008,1010,1012,1015,1017,1019,1021,1023,1025,1027,1030,1032,1034,1036,1039,1041,1043,1045,1047,1050,1052,1054,1056,1059,1063,1066,1068,1071,1073,1076,1079,1081,1083,1085,1088,1090,1093,1096,1098,1102,1104,1106,1110,1113,1115,1118,1120,1122,1124,1127,1129,1131,1134,1137,1139,1141,1143,1145,1147,1149,1151,1153,1156,1159,1161,1163,1165,1167,1170,1172,1174,1176,1178,1180,1182,1184,1186,1188,1193,1196,1198,1200,1202,1204,1206,1208,1210,1212,1214,1217,1219,1221,1223,1225,1227,1229,1231,1233,1235,1237,1239,1241,1243,1245,1247,1250,1252,1254,1256,1258,1260,1264,1266,1268,1270,1275,1277,1279,1281,1283,1285,1287,1290,1295,1297,1300,1306,1308,1310,1314,1316,1318,1320,1323,1325,1327,1329,1331,1333,1335,1337,1339,1341,1343,1346,1348,1350,1353,1356,1358,1360,1364,1366,1369,1371,1373,1375,1378,1381,1384,1386,1388,1390,1392,1394,1396,1398,1400,1402,1404,1406,1408,1410,1412,1414,1416,1418,1420,1422,1425,1427,1429,1432,1435,1439,1441,1443,1446,1448,1450,1452,1454,1456,1458,1460,1462,1464,1466,1468,1470,1472,1474,1476,1478,1482,14}
Again, this goes on much longer...
Front End:
Logged-in BeBuilder Editing:
Any help?
Comments
Hello,
Please turn off all of the plugins, refresh your cache, and check if the problem persists.
Moreover, if you use a child theme, switch to parent, and recheck it.
Thanks