Forum Activity for @emdiamond

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

Mass Deleting of Accounts

Using Jamroom

Is there a quick way to delete all pending users at once?
And Also mass delete dead accounts?

Just trying to clean up site
updated by @emdiamond: 12/05/22 11:59:11AM

ISSUE from Last update 6.5.0

Using Jamroom


Ok,will do

ISSUE from Last update 6.5.0

Using Jamroom

Cleared cache in the data/cache/jrCore folder.
Ran Repair.php again.
No Fix

ISSUE from Last update 6.5.0

Using Jamroom

Is there away to fix this? The issue with jQuery.
updated by @emdiamond: 05/15/20 06:08:04AM

ISSUE from Last update 6.5.0

Using Jamroom

Mike,
I sent you the log in info. Let me know if it works. I am unable to log into site from other browsers or computers.
I still have admin access trough my computer which is logged in as current admin. I think I will lose it if I logout

ISSUE from Last update 6.5.0

Using Jamroom

Maybe this is the issue?

Memory Cache functions are missing Ensure APCu functions have been enabled in your PHP install

ISSUE from Last update 6.5.0

Using Jamroom

Found the spot to change the skin in the DB:
jr_jrcore_setting - (admin_skin - profile_skin)
Changed the skin but to no avail.
Weird issue!
Maybe one of the JR modules?

ISSUE from Last update 6.5.0

Using Jamroom

Since I'm in the DB. Can I change the skin there?
I found jr_jrcore_skin` in the DB, but don't see a box to toggle active skin on and off.

ISSUE from Last update 6.5.0

Using Jamroom

Well that was fun. No Banana.
I turned off all non Jamroom modules. Cleared the cache as you said in the DB.
Then went ahead and again cleared skin cache again.
Then ran repair again.