Database issue?

  • Resolved zmmccrocklin

    (@zmmccrocklin)


    3 years, 5 months ago

    Hello Friends,
    I recently migrated from CentOS8 to RockyLinux, and am having issues with this site. Before this, a while back, somehow I got hit with a mysql injection attack or something of that nature and my site had a hidden redirect that I couldn’t find. I ended up scrapping everything on it. Now, I’m trying to build it again with a fresh database & wordpress install. The only issue is that for some reason I’m getting a 500 error due to an issue on finding the wp-options table. I was expecting to get the install pages to set all this up. Someone please advise what my issue could be.

    # uname -r
    4.18.0-305.19.1.el8_4.x86_64

    # php -v
    PHP 8.1.0RC3 (cli) (built: Sep 28 2021 21:40:07) (NTS gcc x86_64)
    Copyright (c) The PHP Group
    Zend Engine v4.1.0RC3, Copyright (c) Zend Technologies
    with Zend OPcache v8.1.0RC3, Copyright (c), by Zend Technologies

    # httpd -v
    Server version: Apache/2.4.37 (rocky)
    Server built: Jun 11 2021 15:35:05

    MySQL version: 8.0.26

    • This topic was modified 3 years, 5 months ago by zmmccrocklin.
    • This topic was modified 3 years, 5 months ago by zmmccrocklin. Reason: corrected CentOS version

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hi, check that the wp_options table exists in the database. The db table probably isn’t there.

    Thread Starter zmmccrocklin

    (@zmmccrocklin)

    Well, that’s the thing. It SHOULDN’T be there. This is a fresh install with no previous content & an empty databse (doesn’t even have any tables). I did all the normal installation steps & set everything up in the wp-config.php file. Idk why it’s looking for a table instead of giving me the new install page.

    Dion

    (@diondesigns)

    Before you do anything else, please install a production version of PHP to insure compatibility with WordPress. I suggest the latest version in the 7.4 branch, which right now is 7.4.24.

    There is a file in the root of the site wp-config.php ?
    With a clean installation, it should not be there.

    • This reply was modified 3 years, 5 months ago by Serge.
    Thread Starter zmmccrocklin

    (@zmmccrocklin)

    I’ll get around to working on the php install later today, but yes. I created it from the wp-config-sample.php & added the DB info since that was what I had done on previous installs.

    Thread Starter zmmccrocklin

    (@zmmccrocklin)

    Welp downgrade in PHP fixed it. Although I wonder if the full restart of apache is what fixed it as I had to actually stop & then start it back up since downgrading the PHP put all my sites in a 503 error. Ah well. I’ll stick with 7.4 until 8.1 is supported.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Database issue?’ is closed to new replies.