Forum Activity for @emdiamond

alt=
@emdiamond
08/04/22 11:07:00AM
103 posts

New account appear with signups turned off


Using Jamroom

They were new sign ups. It may have been from the All in on social module. I just turns off the log in and sign up networks for that module. That may have been the way they signed in?
updated by @emdiamond: 08/04/22 11:07:31AM
alt=
@emdiamond
08/03/22 03:42:38PM
103 posts

New account appear with signups turned off


Using Jamroom

I just found some new accounts (USERS)
Just wondering how this is possible because I have turned off user signups in all quotas?

updated by @emdiamond: 11/03/22 06:19:22AM
alt=
@emdiamond
06/15/22 10:20:57AM
103 posts

Mass Deleting of Accounts


Using Jamroom

Ok down to the final clean up.
Blogs.

There are Blogs: 17296 of them. I can delete them from the table. And,
I can see them in the nova skin but there is no way to delete them there. It has the maintenance gear in the upper right corner but when clicked it just goes to the blogs page.

This will be the last thing to clean up.
updated by @emdiamond: 06/15/22 12:56:11PM
alt=
@emdiamond
06/02/22 11:01:16AM
103 posts

Mass Deleting of Accounts


Using Jamroom

That worked. I can get in as the new admin and continue shrinking the site info.

Funny the original Admin account still shows in Jamroom. However, there is no info in the jr_jruser_item_key table.
alt=
@emdiamond
06/01/22 02:50:04PM
103 posts

Mass Deleting of Accounts


Using Jamroom

Michael, I did see the post from Paul. The problem is the site is in maintenance mode. So I can't login to create a new user without admin privilege's I have checked the table " jr_jruser_item_key ". Not seeing a number 1 profile.
alt=
@emdiamond
06/01/22 02:30:26PM
103 posts

Mass Deleting of Accounts


Using Jamroom

I just found out that my hosting provider is currently moving my DB to another server. Hopefully this is the issue and it will start working.

If not, still would need away to recreate master admin account. I thought there was away to do this, At least years ago there was.
alt=
@emdiamond
06/01/22 01:34:32PM
103 posts

Mass Deleting of Accounts


Using Jamroom

I have been able to decrease my DB size. Did not have to touch the tables. Did everything through the admin account profiles pages.

However, I think I deleted the admin account. I did this while deleting profiles.

I thought there was away to recreate it but I can't find the link.

I do have access to the DB and FTP access.

I looked at table jr_jruser-item_key table. But not in there.

There used to be a repair.php file. Can't remember if this is the file to reset it.

If not is there away to recreate the admin account and password?
alt=
@emdiamond
05/18/22 03:07:32PM
103 posts

Mass Deleting of Accounts


Using Jamroom

I got it down to 6.1 gig. Still have allot of spam accounts.
Is the away to mass delete active accounts?
alt=
@emdiamond
05/18/22 11:57:42AM
103 posts

Mass Deleting of Accounts


Using Jamroom

pending.png pending.png • 295KB

This helped, Still have allot to clean up
alt=
@emdiamond
05/18/22 11:18:24AM
103 posts

Mass Deleting of Accounts


Using Jamroom

Yea, there were 71000 of them. So far, doing it this way I got it down to 66000.

My main issue is my SQL database is over 10 gigs. My host provider isn't happy. I need to get it under 3 gigs.

The optimize won't work on tables larger than 600 meg

I just need to clear some of the dead stuff up. Any ideas on which tables I can clear without breaking things.

IE jr_jraction_item_key Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~4,585,801 InnoDB utf8_unicode_ci 788.4 MiB

jr_jrblog_item_key Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~1,655,530 InnoDB utf8_unicode_ci 642.1 MiB

jr_jrcomment_item_key Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~2,617,490 InnoDB utf8_unicode_ci 1.1 GiB
1