Moroni Pickering

Gender Not specified
Age Not specified
Member since November 20th, 2015
Last seen 8 years ago
Topics 2
Replies 1
Points 3
About Moroni Pickering: No information provided.

Recent activity
  • Moroni Pickering created new topic Display Unread Topics/Replies.

    November 21 at 2:23 am

    Hi! Your forum component is very slick I'm liking it so far. A key thing we need, is the ability for users to see the number of unread topics and replies in a category/sub-category. Is this something you could easily add or do you have any timeframe if it's already in the plans? thanks, Moroni

    8 years ago

  • Moroni Pickering replied to the topic Error: 1146 social_cjforum_topics doesn't exist.

    November 20 at 10:44 pm

    I created two categories and then reinstalled the cjforum zip package and now it's fixed :)

    8 years ago

  • Moroni Pickering created new topic Error: 1146 social_cjforum_topics doesn't exist.

    November 20 at 10:25 pm

    When accessing  /administrator/index.php?option=com_cjforum&view=topics I get this error: 1146 Table 'rtssocia_social.social_cjforum_topics' doesn't exist SQL=SELECT u.id AS value, u.name AS text FROM social_users AS u INNER JOIN social_cjforum_topics AS c ON c.created_by = u.id GROUP BY u.id, u.name ORDER BY u.name My public page is showing the same error code: http://social.ruletheseas.com/ 1146 Table 'rtssocia_social.social_cjforum_topics' doesn't exist SQL=SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM social_categories as c LEFT JOIN (SELECT cat.id as id FROM social_categories AS cat JOIN social_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_cjforum' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN `social_cjforum_topics` AS i ON i.`catid` = c.id AND i.state = 1 WHERE (c.extension='com_cjforum' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft   Please advise! thanks, Moroni

    8 years ago

Powered by CjForum