luismoyano

I forgot to let you know that I tried to fix the issues after the installation with Yoast Helper, and this is the result of every action I tried with it:

Yoast SEO feature Indexables tables & migrations could not be reset.
Yoast SEO feature Site information could not be reset.
Yoast SEO feature Tracking could not be reset.

Yoast SEO feature Configuration wizard has been reset.
Yoast SEO feature Notifications has been reset.
Yoast SEO feature Internal link counter has been reset.
Yoast SEO feature Prominent words calculation has been reset.

As you can see, although I reseted the internal links, Yoast did not offer to me teh ability to re create those links. Weird!!

Hi There,
I completely removed Yoast SEO, including cleaning all the transients, cron jobs, files, and tables in the database, because removing the plugin did not delete the tables in the database.

I can confirm you that my server has all the requirements for Yoast SEO, actually is a VPS created just for that website with cPanel in Centos 7, with 8 cores and 8 Gigas of RAM, PHP 7.4, Maria DB 10.3, of course TLS 1.2, and I do not know what else Yoast SEO needs to work properly, maybe nothing else….

My WordPress version is 5.5.1, all the plugins are updated and Yoast SEO is in 15 version, although to change to 15 did not make any change.

BTW, I’m using Zend Opcache, and before the installation I completely clean the OPcache, and just in case, before doing it, I removed by hand the wpseo folder inside the cache folder of the website.

As suggested I installed again Yoast SEO 15 from zero, and I can confirm you that the plugin was installed ok, actually I received no errors in the welcome page of the plugin, and everything seems to be correctly installed. But… It’s funny because any of the tables of Yoast SEO were added to the database, LOL

As this site is not the only site I manage, I visit a new site that I’m creating for a client, and took from there all the tables for Yoast SEO, I cleaned the auto increment numbers, cleaned the rows in the tables, and then I entered those tables in the site with problems.

At this moment, it seems that Yoast SEO is working, but only it seems becuase in the health check I’m still receiving a message saying that (translated from spanish) “The text link counter feature is not working as expected”. Actually, when I open Yoast SEO and I entered in the configuration, I did not receive the ability to recreate all the SEO links, nor to create the count of links as I received the first time I updated Yoast SEO from 12 to 14.9. Weird!

At least, now I’m not receiving php errors and errors and errors that make crash the site. I must say that this site is in production, and although is not a very big site, it receives something around 100.000 unique users per month with 180.000 page views. I tell you this, because I can not play with the site, which is not my site but the site of a client that can kill me (figuratively speaking) if I make something in the site that makes him lose money. I’m sure you understand me.

Any ideas about how to solve this problem? Although Again, it seems that apart from this error in the health system, the tables are starting to be full filed, and it seems that Yoast SEO is working properly.

Thanks in advance!

Hi @joyously, there was a lot of changes in my case apart from this update from WordPress 4.9 to WordPress 5.5. I changed to a new VPS with everything inside completely updated, php 7.4, Maria Db 10.5, last cPanel version, theme, plugins, everything updated.

In any case, my main problem was the not ability to debug the queries made by the system regarding these functions (get_next_post() or get_adjacent_post()) to be able to see where was the error. These queries does not appear on query_monitor plugin or mysql logs. So, I have not had the opportunity to debug them, and see what was happening.

By the way, I solved the issue in two different ways:

1) Asking for the full amount of posts in a query, and then creating an array in php, and look for the prev and next index in that array regarding the given post. This whole process takes: 0.053190946578979 (Not a lot of time).

2) Making two queries in mysql to get the first prev and first next post depending of the post_date and regarding the given post. This process takes 0.00084805488586426 (much less time).

So, as you pointed out, Mysql is much more efficient than PHP. So, I have chosen the second option.

Thank you so much for all your help with this bro!

Hello again @joyously,
as much as I have tried to use the functions included in WordPress to get the next post (that is, the newest post published before the post I am viewing) I have not succeeded.

I’ve been using: get_next_post), its parent get_adjacent_post () function, and also the_post_navigation () function you suggested to me, but with neither of them I have got the next_post object in many of published posts.

As far as I know and if I’m not mistaken, the default arguments of those functions do not fix any taxonomy, nor they use a common category to search for. FYI, if I use the category in the arguments, I do get the next_post object on quite a few more posts than usisng no arguments. But with the default option that is in_same_term = false, where the query to the database is supposed to search for results regardless of the category or taxonomy, it fails and does not generate any results.

I have activated SAVE_QUERIES to be able to debug the queries, but I can’t see the query that the WordPress core generates to get these links, so I can’t debug this query, and see what fails in PhpMyAdmin.

So in the end what I have done is generate a new query by myself inside my pagination.php where I obtain all the posts ordered by date, I save them in an array. Then I look for the index of the post that I am viewing, and then I only obtain the previous and next index for show, and then the links, title and image for each one of them.

I haven’t had time to look yet if doing this whole process with php is slower than doing it with SQl regarding the performance of each page load, but I have a question that I hope you can answer me.

I do not see in query monitor that the core of WordPress makes a query to obtain all the posts published on the web, and neither it does ordered by date. But the question is …

Is there some internal WordPress core array that has this information (all posts in an array or object) and that can be accessed from the single.php or the pagination script of my theme?

This would save me all these queries, and save loading time.

Thanks in advance!

Hi Again,
I have found a new clue to solve this problem…
My theme to get the next post use the function in this way:
$next_post = get_next_post();

I have used the mother function in this way:
$next_post = get_adjacent_post( true, ”, false );

Now I’m getting the next link in more post than before, and I have realized that maybe my problem is related to the category where are included those posts, which are not the same. ?Could it be this the problem? I mean…

The website is a recipe website, that shows different recipes of different categories ordered by published date, until here everything is pretty normal. But… it seems that the next link buttons on every post depend on the categories where every post is included, Am I wrong?

Is there a way to generate the next and prev links just depending of its published date, and not depending of the category where they are included?

HI Joy,
I’m not using the block editor, I have disabled because I do not like at all, I use my own shortcodes instead. The theme is not completely updated, but is the very last version before the current one. There is no css problem, as I’m using my own customization for the buttons, and I’m showing them with my own php and css code.

The problem is not exactly the function. As you pointed out, the get_adjacent function() (get_next_post()) is working in the old posts. What I want to find out, is why is not returning any object in the case of the new posts.

I’m debbuging the queries, but it seems that query is done before getting the pagination page, so I can not get that query printed to see into it, and see what is failing.

Any idea about how to get that query printed in a log file, and see in PhpMyadmin what is failing on it?

Thanks in advance!

Thanks @joyously,
Maybe I did not explain well my problem. Of course, I expect to get a new post and it’s object through get_next_post() function, when I’m seeing not the last post published, but the previous post to that one, hahaha… Of course, the last published post does have no next post at all.

The thing is that I have published 4 new posts since I updated to 5.5, and when I start clicking in prev_post link in these posts, they always get the prev post link, but never get the next post link, until….. I arrive to the latest posts published in the website before making the update from 4.9 to 5.5. In all the following posts since that point WordPress gets both links (next and prev links) with no problem if I click in the prev button again and again to navigate through the posts of the website.

Do you understand me better now?

Any idea?

BTW, I can not see any javascript error, nor php or database error in the logs.

Hi Suwash,
Thank you for trying to help with my problem, but that’s not true!
Actually, I could send you several examples of other recipes blogs where Yoast Seo Graph shows several videos inside the markup, and then google get all of those videos in the Google Rich Results.

The only thing I wanted to find out it is… Whether those videos are added to the yoast schema by Yoast SEO or by the developers of the recipe plugin using the yoast schema.

But trust me, Google Rich Results is able to detect more than one video in the schema, and if it would be possible to attach images here, I could send you several screenshots to show it that I’m not lying to you, hehe…

So, question solved! If Yoast Seo is only able to detect one video, it’s clear that those extra videos added to the markup are added by the developers of the plugin, taking advantage os the Yoast SEO Graph Schema.

Thank you for confirm it!

Well, I understand the forum guidelines, but I do not think the answer break those guidelines. Let me change the question making it simpler and more direct.

Does the Yoast schema graph gets only one video because Yoast SEO in its free version only gets one video by post in the schema independently of the amount of videos inside the post?

Thanks in advance!

I solved, I have to change all the javascript because I understand there is no way to fix it with the code built in, right?

Thank you!!

No, I have not stilk moved to Premium. But yes, I’m doing the right thing in my blog in advance, in order to be able to move to premium and to profit every aspect of the premium package asap. In a couple of weeks I’ll be ready to think in the next step.

Thank you!

• This reply was modified 4 years, 5 months ago by luismoyano.

Wooow, such a support OMG!
Thank you so much for your fast answer and helpful tips.
I will read those two articles and of course, I will reload the sitemap again.
I was thinking exactly that all my problem could be something around your suggestion, which is that google should re crawl all my new structure of categories. I will let you know what happens!

Again, thank you so much for your amazing help!!

Luis

Hi again,
I should have seen that you were not answering comments since no less than 4 months ago.

Finally I have installed WP Rocket, and Oh My Good, now my website is extremely faster than before. I have paid $39 but I could disable no less than 5 plugins that I was using to do the same thing I can do now with Wp Rocket.

At any case, maybe I will be using your nice plugin in other sites that do not need so much optimization, because it works really well.

Thanks,

Luis

Hi Isabel,
thanks for your answer!

Unfortunately, I’m not able to update the PHP version in my hosting, because there more websites, I’m not alone. But, I’m using the changes in the code I posted here, and everything is working now.

BTW, Are you thinking of including the wheel chart draw in the upcoming version of the plugin?
It would be awesome and really appreciated!

Thanks for your awesome pluging!

Luis

Hi there again!

Reading the other issues posted in this support system, I found out that my errors were related with my outdated version of php. I’m in php 5.3.29, so there is no error in the functions zp_get_sidereal_methods() or zp_get_get_planets() or zp_get_house_systems(), the issue where related with the ability as of PHP 5.4 to array dereference the result of a function or method and call it directly.

I’m not an expert in PHP, but as I can not update the php version of my server, I looked for a solution to make it work. Maybe it can be used by other people like me that can not change the version of its servers. Here it is:

The solution obviously is to convert the function in an array, so the code:

$arrMethods = array();
$methods = zp_get_sidereal_methods();
  foreach ($methods as $key => $value) {
    $arrMethods[$key] = $value;
  }

Then the line:

$zodiac_type .= ' ' .
						sprintf( __( 'ayanamsa = %1$s <span class="zp-mobile-wrap">(%2$s)</span>', 'zodiacpress' ),
						$ayanamsa,
						zp_get_sidereal_methods()[ $this->chart->sidereal ]['label'] );

It can be changed by:

$zodiac_type .= ' ' .
						sprintf( __( 'ayanamsa = %1$s <span class="zp-mobile-wrap">(%2$s)</span>', 'zodiacpress' ),
						$ayanamsa,
						$arrMethods[ $this->chart->sidereal ]['label'] );

All the issues with files due to php 5.3 or below can be solved following the same method. Creating a new array and then call values with that new array instead of original function.

Note: Isabel, if you want to delete all my post, in order to make more clear this info, be free to do it, and put in order them , ok?

Thanks for your awesome pluging!

Luis