Query Error

Hi,
The error occurs when any user (except the master admin) tries to open the page /co_creation (it`s by Aparna module)
Query Error: 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 'LIMIT 10' at line 3
Memory 2.5MB
Data
Array
(
[error] => Query Error: 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 'LIMIT 10' at line 3
[_post] => Array
(
[_uri] => /co_creation
[module_url] => co_creation
[module] =>
)

[query] => SELECT a.`_item_id` AS _item_id FROM jr_dico_creation_item_key a
JOIN jr_dico_creation_item_key pr ON (pr.`_item_id` = a.`_item_id` AND pr.`key` = '_profile_id' AND pr.`value` NOT IN(5, 43, 148, 183, 213, 277, 489, 543, 579, 767, 961, 976, 1137, 1611, 1640, 462, 463, 971, 986, 988, 991, 993, 995, 1006, 1012, 1024, 1028, 1032, 1040, 1041, 1110, 1112, 1147, 1179, 1195, 1202, 1205, 1207, 1209, 1246, 1251, 1253, 1255, 1266, 1271, 1272, 1273, 1276, 1279, 1304, 1318, 1322, 1325, 1331, 1333, 1335, 1353, 1361, 1369, 1371, 1375, 1385, 1395, 1396, 1399, 1412, 1417, 1430, 1431, 1435, 1445, 1449, 1455, 1458, 1459, 1464, 1466, 1471, 1487, 1488, 1491, 1497, 1519, 1521, 1523, 1529, 1530, 1532, 1539, 1540, 1548, 1549, 1550, 1551, 1558, 1577, 1578, 1583, 1593, 1601, 1604, 1617, 1618, 1621, 1622, 1623, 1624, 1627, 1630, 1638, 1642, 1646, 1651, 1654, 1673, 1674, 1680, 1681, 1683, 1686, 1687, 1692, 1701, 1708, 1713, 1715, 1718, 1725, 1730, 1731, 1732, 1734, 1739, 1740))
WHERE LIMIT 10
)
What does it mean?
How can I fix this?
updated by @dim: 12/08/16 12:06:13AM

"MariaDB server version" ??? You're using a custom setup using a non-standard database.

The requirements outlined here

Docs: "Requirements"
https://www.jamroom.net/the-jamroom-network/documentation/appendix-about-jamroom/774/requirements

Call for MySQL database, I'm not familiar with MariaDB and am sure we have not done any testing with it.

So you're question is "How do I fix this custom module running on a custom server?" so the issue could be hard to isolate.

Under a normal system the error your seeing is saying that your missing a value for your WHERE clause, which you are.

Its probably because there is no value for [module] => . Its empty.

Without detailed steps to recreate the issue its hard to say more than that.

Hi Michael,
.....- PHP 5.3+
- MySQL 5.1+ (MariaDB 5.5 or MySQL 5.6.+ is highly recommended).......

I'm using the MariaDB 5.5 (it`s native version in CentOS / CloudLinux 7.2)

Incidentally, the error occurs for normal users only. Master Admin does not see that error on the page.
updated by @dim: 09/06/16 05:49:10AM

If I use the widgets (Item List) to display info from the module co-creation,then a normal user sees this error:

At the same time, the master admin can not see the error.

Post steps on how to setup to see what your seeing please.