Skip to content
This repository has been archived by the owner on Nov 29, 2018. It is now read-only.

Syntax error or access violation in DB #3

Open
ghost opened this issue Jul 24, 2017 · 0 comments
Open

Syntax error or access violation in DB #3

ghost opened this issue Jul 24, 2017 · 0 comments

Comments

@ghost
Copy link

ghost commented Jul 24, 2017

Another GREAT plugin....compliments!
It seems working fine with most users except for some for which error log reports:

Exception at time 1500885572: exception 'DatabaseException' with message 'An exception occurred while executing 'SELECT DISTINCT n_table., n.string as name, v.string as value FROM elgg_metadata n_table JOIN elgg_entities e ON n_table.entity_guid = e.guid JOIN elgg_metastrings n on n_table.name_id = n.id JOIN elgg_metastrings v on n_table.value_id = v.id WHERE (n_table.id IN (1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,) AND ((n_table.access_id = -2\n\t\t\t\tAND n_table.owner_guid IN (\n\t\t\t\t\tSELECT guid_one FROM elgg_entity_relationships\n\t\t\t\t\tWHERE relationship = 'friend' AND guid_two = 8992\n\t\t\t\t) OR n_table.owner_guid = 8992 OR n_table.access_id IN (2,1,6,7,8,13,15,50,77,95,98,118,119,154,160,172,174,183,185,211,258,280,293,295,297,298,301,305,306,307,310,311,312,321,322,323,324,325,330,334,342,343,346,347,348,351,353,354,355,359,360,362,365,367,372,377,378,379,380,381,382,383,384,385,386,391,393,394,395,396,400,464,465,466,468,471,472,473,481,484,485,486,487,488,489,520,528,533,567,812,821,824,825,826,829,830,831,832,1134,1136,1146,1159,1165,1174,1176,1177,1178,1179,1182,1183,1222,1545,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1650,1651,1652,1653,1654,1655,1656,1657,1846,1850,1852,1854,1861,1862,1864,1868,1872,1873,1874,1945,1949,1950,1956,1958,1959,1960,1964,1965,1968,1977,1978,1979,1980,1981,1982,1983,1984,1985,1989,1996,1999,2002,2013,2015,2056,2064,2066,2070,2093,2094,2095,2096,2097,2099,2100,2101,2105,2109,2111,2112,2120,2121,2122,2123,2137,2139,2140,2141,2330,2370,2371,2374,2401,2402,2443,2588,2589,2593,2594,2596,2604,2606,2607,2618,2621,2738,2753,3009,3116,3118,3120,3121,3233,3235,3237,3239,3246,3252,3273,3277,3284,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3305,3317,3958,3963,3975,3979,3985,3990,3993,4000,4013,4014,4016,4017,4018,4102,4103,4104,4105,4112,4113,4117,4154,4162,4167,4187,4190,4191,4195,4206,4207,4209,4210,4212,4218,4220,4234,4237,4243,4248,4257,4263,4266,4267,4269,4270,4272,4273,4288,4300,4303,4304,4305,4307,4308,4309,4310,4311,4316,4326,4336,4356,4358,4372,4375,4384,4391,4396,4410,4415,4419,4427,4428,4430,4431,4432,4433,4436,4446,4449,4452,4455,4459,4460,4469,4488,4490,4497,4500,4501,4503,4511,4520,4523,4562,4566,4567,4575,4576,4578,4580,4585,4587,4589,4594,4595,4596,4601,4615,4621,4628,4631,4641,4650,4651,4652,4654,4658,4664,4666,4667,4672,4673,4683,4684,4686,4687,4688,4693,4696,4698,4700,4702,4704,4708,4709,4718,4742,4749,4750,4753,4755,4758,4761,4770,4791,4798,4802,4809,4812,4819,4834,4838,4846,101)) AND (n_table.enabled = 'yes'))) AND ((e.access_id = -2\n\t\t\t\tAND e.owner_guid IN (\n\t\t\t\t\tSELECT guid_one FROM elgg_entity_relationships\n\t\t\t\t\tWHERE relationship = 'friend' AND guid_two = 8992\n\t\t\t\t) OR e.owner_guid = 8992 OR e.access_id IN (2,1,6,7,8,13,15,50,77,95,98,118,119,154,160,172,174,183,185,211,258,280,293,295,297,298,301,305,306,307,310,311,312,321,322,323,324,325,330,334,342,343,346,347,348,351,353,354,355,359,360,362,365,367,372,377,378,379,380,381,382,383,384,385,386,391,393,394,395,396,400,464,465,466,468,471,472,473,481,484,485,486,487,488,489,520,528,533,567,812,821,824,825,826,829,830,831,832,1134,1136,1146,1159,1165,1174,1176,1177,1178,1179,1182,1183,1222,1545,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1650,1651,1652,1653,1654,1655,1656,1657,1846,1850,1852,1854,1861,1862,1864,1868,1872,1873,1874,1945,1949,1950,1956,1958,1959,1960,1964,1965,1968,1977,1978,1979,1980,1981,1982,1983,1984,1985,1989,1996,1999,2002,2013,2015,2056,2064,2066,2070,2093,2094,2095,2096,2097,2099,2100,2101,2105,2109,2111,2112,2120,2121,2122,2123,2137,2139,2140,2141,2330,2370,2371,2374,2401,2402,2443,2588,2589,2593,2594,2596,2604,2606,2607,2618,2621,2738,2753,3009,3116,3118,3120,3121,3233,3235,3237,3239,3246,3252,3273,3277,3284,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3305,3317,3958,3963,3975,3979,3985,3990,3993,4000,4013,4014,4016,4017,4018,4102,4103,4104,4105,4112,4113,4117,4154,4162,4167,4187,4190,4191,4195,4206,4207,4209,4210,4212,4218,4220,4234,4237,4243,4248,4257,4263,4266,4267,4269,4270,4272,4273,4288,4300,4303,4304,4305,4307,4308,4309,4310,4311,4316,4326,4336,4356,4358,4372,4375,4384,4391,4396,4410,4415,4419,4427,4428,4430,4431,4432,4433,4436,4446,4449,4452,4455,4459,4460,4469,4488,4490,4497,4500,4501,4503,4511,4520,4523,4562,4566,4567,4575,4576,4578,4580,4585,4587,4589,4594,4595,4596,4601,4615,4621,4628,4631,4641,4650,4651,4652,4654,4658,4664,4666,4667,4672,4673,4683,4684,4686,4687,4688,4693,4696,4698,4700,4702,4704,4708,4709,4718,4742,4749,4750,4753,4755,4758,4761,4770,4791,4798,4802,4809,4812,4819,4834,4838,4846,101)) AND (e.enabled = 'yes')) ORDER BY n_table.time_created ASC, n_table.id ASC, n_table.id LIMIT 0, 100':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 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 ') AND ((n_table.access_id = -2\n\t\t\t\tAND n_table.owner_guid IN (\n\t\t\t\t\tSELECT guid_' at line 1\n\nQUERY: SELECT DISTINCT n_table., n.string as name, v.string as value FROM elgg_metadata n_table JOIN elgg_entities e ON n_table.entity_guid = e.guid JOIN elgg_metastrings n on n_table.name_id = n.id JOIN elgg_metastrings v on n_table.value_id = v.id WHERE (n_table.id IN (1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,1527330,) AND ((n_table.access_id = -2\n\t\t\t\tAND n_table.owner_guid IN (\n\t\t\t\t\tSELECT guid_one FROM elgg_entity_relationships\n\t\t\t\t\tWHERE relationship = 'friend' AND guid_two = 8992\n\t\t\t\t) OR n_table.owner_guid = 8992 OR n_table.access_id IN (2,1,6,7,8,13,15,50,77,95,98,118,119,154,160,172,174,183,185,211,258,280,293,295,297,298,301,305,306,307,310,311,312,321,322,323,324,325,330,334,342,343,346,347,348,351,353,354,355,359,360,362,365,367,372,377,378,379,380,381,382,383,384,385,386,391,393,394,395,396,400,464,465,466,468,471,472,473,481,484,485,486,487,488,489,520,528,533,567,812,821,824,825,826,829,830,831,832,1134,1136,1146,1159,1165,1174,1176,1177,1178,1179,1182,1183,1222,1545,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1650,1651,1652,1653,1654,1655,1656,1657,1846,1850,1

Cheers!

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

0 participants