oldwebgeek

No. Still seeing the errors. Doesn’t seem to prevent the plugin from working.

It’s weird, we’re using Percona XtraDB cluster (Galera).

• This reply was modified 3 years, 7 months ago by oldwebgeek.

Looks like this is still an issue. At first, I thought is was a string interpolation issue, but somehow $wpdb->pantheon_sessions is empty.

2021-04-09T17:49:42.000Z - - [09-Apr-2021 13:49:42 America/New_York] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id='b9npncnar5sk687c1oa62jbbt0'' at line 1 for query SELECT * FROM WHERE session_id='b9npncnar5sk687c1oa62jbbt0' made by Pantheon_Sessions\Session_Handler->write, Pantheon_Sessions\Session::create_for_sid, Pantheon_Sessions\Session::get_by_sid

Thanks Daniel. That may not have actually fixed the issue because I noticed more of the same log events after I patched my local copy of the plugin the day I posted the initial report. However, I’ve run the plugin update from the WP dashboard and will let you know if I see more of those errors.

One other item, I also noticed were these errors in our logs, issues are probably related:

2021-04-09T15:15:21.000Z – – [09-Apr-2021 11:15:21 America/New_York] WordPress database error Incorrect table name ” for query SHOW FULL COLUMNS FROM made by Pantheon_Sessions\Session_Handler->write, Pantheon_Sessions\Session::create_for_sid

PhoenixBird’s solution does work for me too, but there was a mistake in the .hraccess code. The “zend.ze1_compatibility_mode” directive is a PHP Flag. Therefore, you need to specify the “php_flag” instruction before it.

The proper .htaccess directives should look like:

php_flag zend.ze1_compatibility_mode Off
php_value memory_limit 32M

I know very few people who can run v2.3. I can’t upgrade ANY of my blogs past v2.2.2 becuase of this 500 Server error. And that’s on different server configs.

bewood:

That solved the problem perfectly, thank you very much!

Download the theme for debugging.

Nevermind the “<br>” tags, they were added when I posted to this forum.

<?php<br>
/*<br>
Template Name: Web Page<br>
*/<br>
?>
<?php get_header(); ?>
<div id="content">
<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
<div id="page-<?php the_ID(); ?>"><br>
<br>
<h1><?php the_title(); ?></h1><br>
<?php the_content(‘Read the rest of this page &raquo;’); ?><br>
<br>
<?php link_pages(‘Pages: ‘, ”, ‘number’); ?><br>
<br>
<?php endwhile; endif; ?><br>
<br>
<?php edit_post_link(‘Edit this entry.’, ”, ”); ?><br>
<br>
</div>
</div>
<?php get_footer(); ?>

No I haven’t turned off all the plugins because only the default ones are running.

If I switch to either the classic or default themes, the Page content shows up on a Page just fine.

However, using my theme (including page.php) a Page will load showing the most recent Post, not the Page content that I typed into the editor.

I’ll try the pastebin site and see if I can’t paste the template here.

The page content shows up properly using the WP default and classic themes.

I compared the Page template code from my themes page to that of the other themes and they are identical. Every major template tag is present in my Page theme including the Loop.

Can someone please help, I really need to get this problem solved!

UPDATE II: Even when trying to access the Page with permalinks turned off (using the ?page_id= parameter), the content that displays on the Page is still the most recent Post, not the Page’s content.

UPDATE: I double-checked the .htaccess file and it never gets updated by WP whenever a new page is created. I verified that it is write-able so I’m really not sure how to solve this problem.

Any assistance would be greatly appreciated.

When I edit the page, I can see the Page’s content in the text editor just fine. The post slug is automatically created by WP when the Page is first created.

It’s when I attempt to view the Page, using the URL created by WP, that I see the Page load with the most recent post instead of the Page content.

My aplogies:

URL to blog home page:
https://wtamm.no200.nononsensehosting.net/

URL of the test page that shows the blog post instead of page content:
https://wtamm.no200.nononsensehosting.net/first-test-page/