Tom

Exact same issue, all data is completely screwed.

Did not work, I even tried the lot:

define( 'WP_DEBUG', false );
define( 'WP_DEBUG_DISPLAY', false );
ini_set('display_errors','Off');
ini_set('error_reporting', 0 );

Still showing Deprecated errors.

How strange as I don’t have WP_DEBUG on, hmmm

// Enable WP_DEBUG mode
define( 'WP_DEBUG', false );

Is set in my wp-config.php

Edit, I just found define( 'WP_DEBUG_DISPLAY', false ); So I will try that, not sure why this would display if the debug is false.

• This reply was modified 2 years, 9 months ago by Tom.
• This reply was modified 2 years, 9 months ago by Tom.

I have no idea what actually fixed it, but I tried again and it randomly worked.

View post on imgur.com

@sterndata Right, more digging and I found the issue but have no idea how to fix it.

I do not seem to have any logs created for cat: /var/log/mariadb/mariadb.log: No such file or directory.

I repaired and optimised the database as you said, then out of curiosity I looked at SHOW VARIABLES LIKE 'max_connections'; and then show status where variable_name = 'threads_connected'; Turns out that this process is filling up all the max_connections, so I increased it from 151 to 512, ran it again, and it never completes, it constantly keeps creating more and more and more and more threads until it finally reaches 512.
Nearly all of them are Waiting for table level lock | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'

But just before that there is this that seems to be stuck in perminant processing.

| 53764 | wordpress_db | localhost       | dbusername | Query   | 3220 | Sending data                 | DELETE a, b FROM wp_options a, wp_options b
				WHERE a.option_name LIKE '\\_site\\_transient\\_%'
	 |    0.000 |

heres the full output:
https://gist.github.com/TomLewis/af884179358406d2ea4d7c7d65a5523a

• This reply was modified 2 years, 10 months ago by Tom.

are you using the most recent versions of both Wordfence and the GeoIP Detection plugin?

What is extreamly strange, is that I disabled Wordfence and the code started working on my frontend pages, then enabled it again and it continued to work?
Now im scared to touch anything.
And the errors are still shwoing in GeoIP.
I have no idea how to get Wordfence to update their maxmind library.
Would it be possible for you to force the update to update their library? its the same format between versions so there wont be any breaking code will there?

Its the plugin “WordFence” that if conficting and breaking it.
How I get Geolocation IP Detection to not listen to Wordfence.
This is the error in the settings, I do not want it to use this version.

View post on imgur.com

View post on imgur.com

None of these do until you click them:
https://piratemc.com/videos/

Oh, I assumed it would be put underneath the same as “Add links below the embedded videos?” so that it works with SEO/Loads before the video and can be CTRL+F to find a video.

Nope! Same as on my videos page.

https://piratemc.com/wpyoutubelyte/

• This reply was modified 3 years, 2 months ago by Tom.

Tried that! the only way I can get anything to display under is by checking “Add links below the embedded videos?” which displays “Watch this video on YouTube.” but not the video name.

These are my settings

View post on imgur.com

I think I figured it out, I enabled the “YouTube oEmbed API” which required its own Key, I loaded that API url with that key and it worked, even tho its the v3 api request, but in Lyte it gave an API error, it no longer said it was limited.
Then I tried my old API again and it worked!

Something about needing to activate that YouTube oEmbed API and populate the url once did it? No idea, its googles end.

I still dont get names under videos tho ??

• This reply was modified 3 years, 2 months ago by Tom.

I tried with an entirely separate google account and fresh APIs, the same API response.
You may want to check you have the correct API url.

• This reply was modified 3 years, 2 months ago by Tom.

Didn’t work, I tried both the system path and full url.

This is all the apache configs SG generates in htaccess:

# SGS XMLRPC Disable Service
<Files xmlrpc.php>
	order deny,allow
	deny from all
</Files>
# SGS XMLRPC Disable Service END
# SGS XSS Header Service
<IfModule mod_headers.c>
    # SGS XSS
     Header always set X-Content-Type-Options "nosniff"
     Header set X-XSS-Protection "1; mode=block"
    # SGS XSS END
</IfModule>
# SGS XSS Header Service END

Edit, I resolved this myself, the issue wasn’t with this plugin, but is the fault of “SiteGround Security” plugin setting “Lock and Protect System Folders” where there is no URL whitelist!