Edit User Subscription and Other Things

[johnathanamber]

Hello everyone,

Thank you so much for making jComments work for Joomla 1.7+.

I had used JComments for my 1.5x site but sadly forgot to check JComments for 1.7x after I had already migrated.

So I eventually migrated to use UdjaComments until JComments caught up. I then installed JComments after it was available. Everything went great except all of the comments were doubled. So I when through all of them and disabled the copy. No big deal really since it was easy to spot the duplicates.

SUBSCRIPTION ISSUE AND OLD SUBSCRIBERS
I did notice that one of my most popular articles had no subscriptions. I can't seem to figure out how to add the already commented users to the article comment subscription. Is there some sort of frontend or backend that would allow me to check those users on that article to change them to subscribe to newer comments?

For the future I've 'checked' the notification checkbox in the form so all new users will get notifications unless they purposefully uncheck it.

UNINSTALL & REINSTALL
Also, I think I might have accidently removed some of the plugins for my current JComments setup, I thought I was removing the older ones when I installed the previous 1.5x version. If I uninstall JComments and then reinstall, will all my settings and comments remain?

Lastly, I think this is in reference to the last topic, when I go into Plugins and I try to edit anything related to JComments, I get the following error:
"The file jcomments.xml could not be found."

However, I have checked the administrator/components/com_jcomments path and the components/com_jcomments path and the jcomments.xml is in the 1st path and not the 2nd.

Any help and advice would be greatly appreciated.

This is a great extension for Joomla.

Thank you,
Johnathan

[johnathanamber]

Hello everyone,

The subscription issue is still persistent.

However, I have resolved the other issues by uninstalling and reinstalling.

Any further help would be greatly appreciated,
Johnathan

[smart]

Do you want to subscribe all comments' authors who has post at least one comment to article?

[johnathanamber]

Hello smart,

That would work. I figured I could remove who responds back and does not want to be subscribed.

Thanks for the reply!
-Johnathan

[smart]

You can remove users' subscriptions in JComments backend (see Subscriptions section).

[johnathanamber]

Smart,

Sorry, I am confused, I want to subscribe users, not remove them.

Am I missing something?

Thank you very much,
Johnathan

[smart]

If you want to subscribe any user you can also do this in same section. Just press create and fill fields in form.  In component field type 'com_content', in Object Id - Article's Id in name and email fields - user name and email.

If you want to subscribe all users who post at least one comment - this could be done via simple SQL query.

[johnathanamber]

Smart,

Since I want to add all users, is the subscription handles per article, or is it handled per user?

Do you know of the SQL script to do this?

Thanks,
Johnathan

[smart]

Since I want to add all users, is the subscription handles per article, or is it handled per user?

Per user and per article Any user can subscribe for comments for any article.

Do you know of the SQL script to do this?

Of course Try next (but I suggest to backup jos_jcomments_subscriptions table before execution this query - so you will be able to revert changes):

Code: (sql)

INSERT INTO jos_jcomments_subscriptions (
`object_id`
, `object_group`
, `lang`
, `userid`
, `name`
, `email`
, `hash`
, `published`)

SELECT DISTINCT `object_id`
, `object_group`
, `lang`
, `userid`
, `name`
, `email`
, md5(concat(`object_id`,`object_group`,`userid`,`email`,`lang`))
, 1
FROM `jos_jcomments` AS c
WHERE `published` = 1
AND NOT EXISTS
(
SELECT * FROM `jos_jcomments_subscriptions` AS s
WHERE s.`object_id` = c.`object_id`
AND s.`object_group` = c.`object_group`
AND s.`lang` = c.`lang`
AND s.`userid` = c.`userid`
AND s.`email` = c.`email`
)

[johnathanamber]

Hello,

Looking at the Subscriptions section, what is the hash? Does that have to be generated for each subscription?

Also, I ran the above SQL, I went from 201 subscriptions down to 175, why is that? I am working on gathering all the emails, names, etc. and working on another SQL script to add all of them in, just not sure of that hash bit.

Thank you for your help,
Johnathan

[johnathanamber]

Would the following SQL statement work with creating the subscriptions:

Code:

INSERT INTO 'jom_jcomments_subscriptions' WHERE object_id = 163 (`object_id`,`object_group`,`lang`,`userid`,`name`,`email`,`hash`,`published`)VALUES
(163,'com_content','en-GB','0','name','email@email.com',md5(concat(`object_id`,`object_group`,`userid`,`email`,`lang`),1),
(163,'com_content','en-GB','0','name','email@email.com',md5(concat(`object_id`,`object_group`,`userid`,`email`,`lang`),1);

The object_id = 163 is the particular article that I want to assign subscriptions to.

[johnathanamber]

So, will the above SQL assign subscriptions for that article or am I missing something?

Thank you,
Johnathan