Just Updated from PHP5 to PHP7, having issues

  • bluedrag

    (@bluedrag)


    6 years, 11 months ago

    I’ve just gone through the big update from PHP5 to PHP7 and at first it seemed like my site was working fine, but I’m noticing two pretty big problems now.

    Firstly, I cannot create new posts, I just get an error message saying “You are currently editing the page that shows your latest posts” instead of the text box for editing content.

    I also noticed I cannot upload images to my media library. When I try to do this I get an error saying “Could not Insert post into the database.”

    I just discovered my server is running MySQL 5.1.73, is it possible the old version of MySQL not playing nice with the new version of PHP is the issue? I see that WordPress recommends MySQL 5.6.

    Any help or direction wouldbe greatly appreciated!

    Links to screenshots: https://imgur.com/a/SBnmVLf

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter bluedrag

    (@bluedrag)

    6 years, 11 months ago

    Do you know which version of MySQL you are running on your server?

    Dion

    (@diondesigns)

    6 years, 11 months ago

    Do you know which version of MySQL you are running on your server?

    Spammers usually don’t respond to questions. 😉

    You’re using MySQL 5.1.73, which has the same basic feature level as the 5.5 branch. (Note: MySQL jumped from the 5.1 branch directly to 5.5.) It is fully supported by PHP 7.x as long as the PHP mysqlnd module is installed. Check the phpinfo() page, and if the mysqlnd module is displayed, you’re fine. If the mysqlnd module is not displayed, then you’ll need to install the mysqlnd module or update MySQL.

    If you do update MySQL, I strongly suggest going to the 5.5 branch, which is stable, secure, and fully supported by WordPress. In addition, updating multiple branches of MySQL at once is quite dangerous, so you may as well try out the 5.5 branch since you’ll need to install it anyway.

    Thread Starter bluedrag

    (@bluedrag)

    6 years, 11 months ago

    Thanks for the info. Looks like MySQL is installed. I am seeing this on the phpinfo() page:

    Client API library version mysqlnd 5.0.12-dev

    I guess I am running an older version than I thought?

    Thread Starter bluedrag

    (@bluedrag)

    6 years, 11 months ago

    An update: I am able to update posts and pages that have been previously created. The issue is only with creating new posts and uploading new media to the media library.

    Thread Starter bluedrag

    (@bluedrag)

    6 years, 11 months ago

    Another update: I have tried increasing my memory_limit to 256M and post_max_size 64M, this did not fix the issue

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

The topic ‘Just Updated from PHP5 to PHP7, having issues’ is closed to new replies.