SyntaxError: Unexpected token < in JSON at position 0
Please Log in to join the conversation.
Please Log in to join the conversation.
<title>Error: 1062 Duplicate entry '852-activity.asset-' for key 'asset'</title>
Please Log in to join the conversation.
SELECT `user_id`, `type`, `asset`, GROUP_CONCAT( `id` ) AS ids, COUNT(*) AS total
FROM `jos_comprofiler_plugin_activity_hidden`
WHERE `asset` IS NOT NULL
GROUP BY `user_id`, `type`, `asset`
HAVING total > 1;
Please Log in to join the conversation.
+---------+----------------+-------+-------+-------+
| user_id | type | asset | ids | total |
+---------+----------------+-------+-------+-------+
| 852 | activity.asset | | 1,2,3 | 3 |
+---------+----------------+-------+-------+-------+
+----+---------+----------------+--------+-------+
| id | user_id | type | object | asset |
+----+---------+----------------+--------+-------+
| 1 | 852 | activity.asset | 0 | |
| 2 | 852 | activity.asset | 0 | |
| 3 | 852 | activity.asset | 0 | |
| 4 | 852 | activity | 82 | |
+----+---------+----------------+--------+-------+
Please Log in to join the conversation.
Please Log in to join the conversation.