Notification issues

[K-fab]

Recently upgraded to vB4.2.3

Many of our forum members are reporting an issue that I'm seeing also.

In the notifications box, there's a 1 that shows up like it would if I had a PM.
When I click on this, it pops up a box that has "1 Reputation Comment" in it
When I click on the link, it takes me to a page that says "Subscribed Threads with New Posts"

I can't remove the darned notification either.

It seems to be cross linking the Reputation Comment with Subscribed Threads.

How do I rectify this?

[K-fab]

bumpity bump.

Anyone have any thoughts?

[Dave]

You should be able to clear it by executing the following query in PHPMyAdmin or at AdminCP > Maintenance > Execute SQL Query:

PHP Code:

UPDATE user SET newrepcount = 0; 


Don't forget to add the table prefix in case you use any.

[K-fab]

Thank you.

And I get this:
"You are not authorized to execute SQL queries"

LOL! My own site won't let me play.
That's got to be some permissions setting in my profile... Must have been from the original owner of the site (it was dropped on me).

[In Omnibus]

Originally Posted by K-fab

Thank you.

And I get this:
"You are not authorized to execute SQL queries"

LOL! My own site won't let me play.
That's got to be some permissions setting in my profile... Must have been from the original owner of the site (it was dropped on me).

You have to add your UserID to the config.php file and set yourself as a SuperAdministrator.

[K-fab]

Okay, so now I can't find the setting to allow me to do that.

Thoughts?

One step forward, three back...

--------------- Added [DATE]1458666144[/DATE] at [TIME]1458666144[/TIME] ---------------

Originally Posted by ProSportsForums

You have to add your UserID to the config.php file and set yourself as a SuperAdministrator.

That's in my forum's directory and not accessible from the admincp, correct?

[Dave]

The config.php file can be found at /includes/config.php.
Add your userid to superadministrators and canrunqueries.

[squidsk]

You should also be able to run that query through your phpmyadmin/cpanel/whatever interface to the db.

[K-fab]

Not finding that directory & file.

Once once again, I ask - this is though my host file management, not through admincp? I want to make sure I'm in the correct spot

--------------- Added [DATE]1458667220[/DATE] at [TIME]1458667220[/TIME] ---------------

Sorry to be so dense - but when you don't know, you have to ask to finally figure it out, right?
We all start at the beginning...

--------------- Added [DATE]1458667463[/DATE] at [TIME]1458667463[/TIME] ---------------

Found it - public_html/forum/includes

Now what do I do with this file? Open it in an editor or is it an executable? I've clicked on it and nothing. right click gives options like download, view, edit, edit code

I'll download and mess with it - see what I can figure out.

[In Omnibus]

Download the file. Open it in a good text editor like Notepad++ or Sublime. Don't use WordPad. Edit only the UserID fields between the brackets. Save the document. Upload it and overwrite the existing config.php file.