brianlovelace

@millionleaves I actually have pretty loose permissions on those types of folders since I run a WebP Plugin that needs a lot of access to generate the converted files. Bitnami made it pretty easy to run CLI commands, but it took too long so I had to come up with another solution…

The solution that worked better for me was to run some SQL Commands to get rid of all of the excess lines, then ran a database optimization plugin to help clean up the databases when I was done. Here are the commands for those interested:

Delete WooCommerce Admin Importer Scheduled Action Lines:

DELETE FROM wp_posts
WHERE post_type = ‘scheduled-action’
AND post_title = ‘wc-admin_import_order’

Delete WooCommerce Admin “Unsnooze Admin Notes” Lines:

DELETE FROM wp_posts
WHERE post_type = ‘scheduled-action’
AND post_title = ‘wc_admin_unsnooze_admin_notes’

Delete WooCommerce Admin “Action Scheduler” Comment Logs:

DELETE FROM wp_comments
WHERE comment_author = ‘ActionScheduler’
AND comment_type = ‘action_log’

Sorry, the code tag keeps making the SQL selectors highlighted in the code tag and I can’t get it to not do that… Here’s a PasteBin link that should be more helpful.

Hopefully this helps some others that were in the same predicament as I was. It also works a LOT faster than the CLI command which was deleting a line every 5-10 seconds or so… these actions took around 4 minutes to delete over 105,000 useless lines.

• This reply was modified 5 years, 2 months ago by brianlovelace. Reason: code tags were messed up
• This reply was modified 5 years, 2 months ago by brianlovelace. Reason: code not displaying properly

@Those who ran the CLI command. How long did it take? I seem to have about 105k entries in the site I’m trying to fix from this awful feature. It’s taking forever and I’m not sure if it’s actually deleting anything, that’s the main issue. How do you know if it’s working or not? thanks!

Bump!

The problem was for my site was that my theme was hard-coding the jquery-ui script into the page, making it breaking the player… try switching to the default theme and seeing if it works in that… then if it doesn’t, start searching through the theme php’s for the jquery-ui script and delete what’s hard coding it… I don’t know shizz about coding, but I started testing by deleting and adding back lines that included the jquery-ui script until I found something that didn’t break my site, but fixed the mp3 player problem. It ended up being something to do with Google AdSense on my site…

Here is the issue I’m having right here… it shows up, but there are no songs in the playlist… but when you open up the external player in the separate window it works just fine? Hmmm..

Blah… frustrating!

Ugh I’m having the same problem! Does yours work when you use the popout window? Mine works when I open the popout but it just doesn’t work when it’s in the post or page.

So here’s the actual theme zip if you’re interested in snooping around a bit… https://www.mediafire.com/?0g1rg2pu53spmi1

Thanks so much again!

Ahhh… I was looking for this! Thank you! All I saw before was the ‘WP-Members’ plugin before. Cheers, mate!

Nevermind… Word Formatting… ‘Paste From Word’… I’m retarded. Thanks ya’ll haha

Update: It’s cutting off at words with Apostrophes… what the heck?