Fresh WordPress install, errors in wp_posts table

  • Just installed WordPress and did a quick SELECT * FROM wp_posts in phpmyadmin and immediately got an error pop-up: “Some errors have been detected on the server! Please look at the bottom of this window.”

    It looks like you guys done something with the pmahomme theme and didn’t clean up.

    Warning in ./libraries/DisplayResults.class.php#856
    A non-numeric value encountered

    Backtrace

    ./libraries/DisplayResults.class.php#4908: PMA_DisplayResults->_getTableNavigation(
integer 0,
integer 0,
boolean false,
)
./libraries/DisplayResults.class.php#4357: PMA_DisplayResults->_getPlacedTableNavigations(
integer 0,
integer 0,
string 'top_direction_dropdown',
boolean false,
)
./libraries/sql.lib.php#1623: PMA_DisplayResults->getTable(
object,
array,
array,
)
./libraries/sql.lib.php#1901: PMA_getHtmlForSqlQueryResultsTable(
object,
string './themes/pmahomme/img/',
NULL,
array,
boolean true,
integer 3,
integer 3,
NULL,
object,
array,
)
./libraries/sql.lib.php#2107: PMA_getQueryResponseForResultsReturned(
object,
array,
string './themes/pmahomme/img/',
integer 3,
integer 3,
./libraries/sql.lib.php#1984: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string './themes/pmahomme/img/',
./sql.php#216: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string './themes/pmahomme/img/',

Warning in ./libraries/DisplayResults.class.php#856
A non-numeric value encountered

Backtrace

./libraries/DisplayResults.class.php#4908: PMA_DisplayResults->_getTableNavigation(
integer 0,
integer 0,
boolean false,
)
./libraries/DisplayResults.class.php#4437: PMA_DisplayResults->_getPlacedTableNavigations(
integer 0,
integer 0,
string 'bottom_direction_dropdown',
boolean false,
)
./libraries/sql.lib.php#1623: PMA_DisplayResults->getTable(
object,
array,
array,
)
./libraries/sql.lib.php#1901: PMA_getHtmlForSqlQueryResultsTable(
object,
string './themes/pmahomme/img/',
NULL,
array,
boolean true,
integer 3,
integer 3,
NULL,
object,
array,
)
./libraries/sql.lib.php#2107: PMA_getQueryResponseForResultsReturned(
object,
array,
string './themes/pmahomme/img/',
integer 3,
integer 3,
./libraries/sql.lib.php#1984: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string './themes/pmahomme/img/', 
./sql.php#216: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string './themes/pmahomme/img/',
Viewing 10 replies - 1 through 10 (of 10 total)

  • It looks like you guys done something with the pmahomme theme and didn’t clean up.

    WordPress neither includes phpmyadmin nor does it do anything with pmahomme theme for phpmyadmin.

    Thread Starter jhbohlen

    (@jhbohlen)

    LOL… are you competent? Just saying that the table wp_posts contains errors after a FRESH install of WordPrewss. It doesn’t matter if I do a SELECT * FROM wp_posts from phpmyadmin, MySQL command line or whatever.

    All the errors you listed above seem to point to a phpmyadmin theme. Not WordPress.

    Where does it say there is an error with the WordPress tables in the code you posted?

    Thread Starter jhbohlen

    (@jhbohlen)

    I guess you don’t read too well.

    OK Lets start again. I’ll ignore the insults.

    You said you get the same error in mysql cli, so exactly what error?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Let’s everyone take a moment and not call people names. Assume good faith, please and thank you.

    It looks like you guys done something with the pmahomme theme and didn’t clean up.

    Warning in ./libraries/DisplayResults.class.php#856
    A non-numeric value encountered

    First, pmahomme theme is a theme for PHPMyAdmin, not WordPress.

    If that’s broken, you’re in the wrong place. We can’t help you with that.

    Second, you didn’t list anything WordPress…

    Just saying that the table wp_posts contains errors after a FRESH install of WordPrewss.

    Okay, what errors? If they’re ALL related to pmahomme, then logically the issue is that theme.

    Can you change PHPMyAdmin’s theme to confirm?

    Are you getting the exact same errors on command line?

    If not, what errors do you get on the command line?

    Thread Starter jhbohlen

    (@jhbohlen)

    OK, I cam here to report the issue to the WordPress development team but now I realized I’m in the wrong section. But let me break it down to you:

    1. SELECT * FROM wp_posts
    2. Pop-up: ““Some errors have been detected on the server! Please look at the bottom of this window.”
    3. Looking at the bottom of the window it displays the errors listed above:

    Warning in ./libraries/DisplayResults.class.php#856
    A non-numeric value encountered

    Backtrace

    ./libraries/DisplayResults.class.php#4908: PMA_DisplayResults->_getTableNavigation(
    integer 0,
    integer 0,
    boolean false,
    )

    etc, etc…

    Hello,

    I just made a clean install to double check this and everything seems fine with no errors at all. Proof screen: https://cloudup.com/c_nKwT-Kvxo

    Server config: Apache/2.4.27, PHP/7.1.12, mysqlnd 5.0.12, phpMyAdmin 4.7.7

    pmahomme is the default theme of phpMyAdmin and it has nothing to do with WordPress.

    Like the previous replies mention, it seems that your issues are with your phpMyAdmin solely. More info on the error you are getting: https://php.net/manual/en/migration71.other-changes.php .

    Maybe you’re running on an older phpMyAdmin version that doesn’t play along well with your current PHP version? If you have access you could try installing the latest phpMyAdmin and check again, else my best advice would be to contact your hosting provider to take a look for you.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    I’m sorry, but those errors aren’t WordPress related.

    “Some errors have been detected on the server”, in this case, means your server is having an issue. It happens to be WordPress that you’re testing with, but nothing you’ve told us so far gives any indication it’s WordPress that’s the problem.

    And you’ve never answered our questions:

    Can you change PHPMyAdmin’s theme to confirm?

    Are you getting the exact same errors on command line?

    If not, what errors do you get on the command line?

    We cannot help you if you cannot answer these. We would be happy to direct you to the right place, but thus far, this does not appear to be an issue with WordPress itself, and more that something’s borked on your server.

    Thread Starter jhbohlen

    (@jhbohlen)

    OK, I’ll look into it. I just find it strange that this happens only on that table. No other table or tables in other databases. Thanks!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Fresh WordPress install, errors in wp_posts table’ is closed to new replies.