Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 19Feb 19 Dear all,some (only a few modewrators) of my users are encountering the following problem:It happens with the default theme. I switched off every plugin without success.I also see this reoccurring error. I am running PHP Version 8.1.31 with MariaDB 10.5.27Do you have any ideas?SELECT COUNT(*) FROM mf_core_rc_index AS core_rc_index WHERE (( ( class='IPS\\core\\Messenger\\Conversation' AND ( perm_id IN(2,1574,1573,641,853,857,851,852,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,639,640,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,973,974,975,976,977,978,1233,1234,1235,1462,1463,1464,1465,1466,1467,1468,1539,1614,1615,1686) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Messenger\\Message' AND ( perm_id IN(2,1574,1573,641,853,857,851,852,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,639,640,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,973,974,975,976,977,978,1233,1234,1235,1462,1463,1464,1465,1466,1467,1468,1539,1614,1615,1686) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Statuses\\Status' AND ( perm_id IN(2,1574,1573,641,853,857,851,852,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,639,640,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,973,974,975,976,977,978,1233,1234,1235,1462,1463,1464,1465,1466,1467,1468,1539,1614,1615,1686) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Statuses\\Reply' AND ( perm_id IN(2,1574,1573,641,853,857,851,852,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,639,640,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,973,974,975,976,977,978,1233,1234,1235,1462,1463,1464,1465,1466,1467,1468,1539,1614,1615,1686) ) OR perm_id IS NULL )) OR ( ( class='IPS\\forums\\Topic' AND ( perm_id IN(10,11,14,17,18,19,20,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,59,60,61,62,63,64,67,69,71,72,74,75,78,80,81,82,83,84,85,89,90,92,93,94,95,100,101,102,103,104,107,110,111,112,113,114,116,117,1180,119,120,121,122,123,125,129,131,132,136,138,140,143,146,152,155,156,173,179,180,185,187,188,190,195,197,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,223,229,230,231,239,243,244,245,246,247,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,268,269,273,280,281,282,283,1114,295,296,297,298,300,302,303,304,306,311,313,315,316,317,318,319,320,321,322,323,326,327,328,329,330,331,332,333,338,405,1152,516,443,1138,490,493,491,500,1142,1137,1141,1153,294,58,912,1083,1115,1116,1196,1292,1263,1273,1281,1314,1358,1360,1385,1416,1417,1443,1474,1475,1492,1693,1519,1538,1566,1567,1613,1617,1620,1621,1623,1650,1675,1718,1701,1710,1719,1723,1729,1724,1725,1738,1739) ) OR perm_id IS NULL ) AND ( node_id IN(887,1040,1046) )) OR ( ( class='IPS\\forums\\Topic\\Post' AND ( perm_id IN(10,11,14,17,18,19,20,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,59,60,61,62,63,64,67,69,71,72,74,75,78,80,81,82,83,84,85,89,90,92,93,94,95,100,101,102,103,104,107,110,111,112,113,114,116,117,1180,119,120,121,122,123,125,129,131,132,136,138,140,143,146,152,155,156,173,179,180,185,187,188,190,195,197,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,223,229,230,231,239,243,244,245,246,247,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,268,269,273,280,281,282,283,1114,295,296,297,298,300,302,303,304,306,311,313,315,316,317,318,319,320,321,322,323,326,327,328,329,330,331,332,333,338,405,1152,516,443,1138,490,493,491,500,1142,1137,1141,1153,294,58,912,1083,1115,1116,1196,1292,1263,1273,1281,1314,1358,1360,1385,1416,1417,1443,1474,1475,1492,1693,1519,1538,1566,1567,1613,1617,1620,1621,1623,1650,1675,1718,1701,1710,1719,1723,1729,1724,1725,1738,1739) ) OR perm_id IS NULL ) AND ( node_id IN(887,1040,1046) )) OR ( ( class='IPS\\forums\\Topic\\ArchivedPost' AND ( perm_id IN(10,11,14,17,18,19,20,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,59,60,61,62,63,64,67,69,71,72,74,75,78,80,81,82,83,84,85,89,90,92,93,94,95,100,101,102,103,104,107,110,111,112,113,114,116,117,1180,119,120,121,122,123,125,129,131,132,136,138,140,143,146,152,155,156,173,179,180,185,187,188,190,195,197,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,223,229,230,231,239,243,244,245,246,247,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,268,269,273,280,281,282,283,1114,295,296,297,298,300,302,303,304,306,311,313,315,316,317,318,319,320,321,322,323,326,327,328,329,330,331,332,333,338,405,1152,516,443,1138,490,493,491,500,1142,1137,1141,1153,294,58,912,1083,1115,1116,1196,1292,1263,1273,1281,1314,1358,1360,1385,1416,1417,1443,1474,1475,1492,1693,1519,1538,1566,1567,1613,1617,1620,1621,1623,1650,1675,1718,1701,1710,1719,1723,1729,1724,1725,1738,1739) ) OR perm_id IS NULL ) AND ( node_id IN(887,1040,1046) )) OR ( class='IPS\\blog\\Entry' ) OR ( class='IPS\\blog\\Entry\\Comment' ) OR ( ( class='IPS\\cms\\Pages\\PageItem' AND ( perm_id IN(6,560,555,574,565,495,864,536,531,532,533,534,535,537,538,539,540,541,542,543,544,545,546,549,551,552,553,554,556,557,558,559,561,562,563,564,566,567,568,569,570,572,573,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,893,913,1191,1192,1195,1206,1207,1210) ) OR perm_id IS NULL )) OR ( ( class='IPS\\cms\\Records1' AND ( perm_id IN(6,560,555,574,565,495,864,536,532,533,534,535,537,538,539,540,541,542,543,544,545,546,549,551,552,553,554,556,557,558,559,561,562,563,564,566,567,568,569,570,572,573,913,1191,1192,1206,1207) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\cms\\Records\\Comment1' AND ( perm_id IN(6,560,555,574,565,495,864,536,532,533,534,535,537,538,539,540,541,542,543,544,545,546,549,551,552,553,554,556,557,558,559,561,562,563,564,566,567,568,569,570,572,573,913,1191,1192,1206,1207) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\cms\\Records3' AND ( perm_id IN(6,560,555,574,565,495,864,536,532,533,534,535,537,538,539,540,541,542,543,544,545,546,549,551,552,553,554,556,557,558,559,561,562,563,564,566,567,568,569,570,572,573,913,1191,1192,1206,1207) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\cms\\Records\\Comment3' AND ( perm_id IN(6,560,555,574,565,495,864,536,532,533,534,535,537,538,539,540,541,542,543,544,545,546,549,551,552,553,554,556,557,558,559,561,562,563,564,566,567,568,569,570,572,573,913,1191,1192,1206,1207) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\cms\\Records4' AND ( perm_id IN(6,560,555,574,565,495,864,536,532,533,534,535,537,538,539,540,541,542,543,544,545,546,549,551,552,553,554,556,557,558,559,561,562,563,564,566,567,568,569,570,572,573,913,1191,1192,1206,1207) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\cms\\Records\\Comment4' AND ( perm_id IN(6,560,555,574,565,495,864,536,532,533,534,535,537,538,539,540,541,542,543,544,545,546,549,551,552,553,554,556,557,558,559,561,562,563,564,566,567,568,569,570,572,573,913,1191,1192,1206,1207) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\cms\\Records\\Review4' AND ( perm_id IN(6,560,555,574,565,495,864,536,532,533,534,535,537,538,539,540,541,542,543,544,545,546,549,551,552,553,554,556,557,558,559,561,562,563,564,566,567,568,569,570,572,573,913,1191,1192,1206,1207) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\downloads\\File' AND ( perm_id IN() ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\downloads\\File\\Comment' AND ( perm_id IN() ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\downloads\\File\\Review' AND ( perm_id IN() ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\calendar\\Event' AND ( perm_id IN(1181,522,481) ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event\\Comment' AND ( perm_id IN(1181,522,481) ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event\\Review' AND ( perm_id IN(1181,522,481) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Image' AND ( perm_id IN(344,1227,1652,1653,1654,1655,1656,1657) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Image\\Comment' AND ( perm_id IN(344,1227,1652,1653,1654,1655,1656,1657) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Image\\Review' AND ( perm_id IN(344,1227,1652,1653,1654,1655,1656,1657) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Album\\Item' AND ( perm_id IN(344,1227,1652,1653,1654,1655,1656,1657) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Album\\Comment' AND ( perm_id IN(344,1227,1652,1653,1654,1655,1656,1657) ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\gallery\\Album\\Review' AND ( perm_id IN(344,1227,1652,1653,1654,1655,1656,1657) ) OR perm_id IS NULL ) AND 1=0) OR ( class='IPS\\nexus\\Package\\Item' ) OR ( class='IPS\\nexus\\Package\\Review' )) AND status IN( 1,2 ) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ) OR perm_id IS NULL ) AND 1=0) OR ( ( class='IPS\\downloads\\File\\Comment...' at line 1
February 19Feb 19 Community Expert Please switch to an unmodified theme and try again. If you're still having issues:We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.