WordPress on IIS on Server 2019

  • bfckc

    (@bfckc)


    1 year, 8 months ago

    I’m trying to install WordPress on IIS on a server running Windows Server 2019 Datacenter.

    The Web Platform Installer stopped working a few years back, so I guess this has to be done manually.

    I installed PHP (and then tested it by pointing my browser at a php file in the web root, which displayed a bunch of php info. Then I installed MySQL 8.0, including MySQL Workbench 8.0 CE.

    I tried creating the database (schema) in the Workbench and when I attempt to fire up the WordPress Install, it pops up a box that says “The database server could be connected to (which means your username and password is okay) but the worpress database could not be selected.

    Then if I try making changes, which I think should fix the issue, I get this output in the browser screen when I try to go to the WordPress Install file:

    WordPress database error Table 'wordpress.wp_options' doesn't exist for query INSERT INTOwp_options(option_name,option_value,autoload) VALUES ('nonce_key', ':x=as$~R?gPiVQGV,IhBaOTC_BB4XK&^r<SXh>.(%P6%{[z1o$h3|1Paf8ypa;|’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by wp_can_install_language_pack, WP_Upgrader->fs_connect, Automatic_Upgrader_Skin->request_filesystem_credentials, WP_Upgrader_Skin->request_filesystem_credentials, request_filesystem_credentials, wp_nonce_field, wp_create_nonce, wp_hash, wp_salt, update_site_option, update_network_option, add_network_option, add_option

    Is there a compatibility issue with IIS and WordPress or MySQL? ANy recommendations on how to fix any of this?

Viewing 8 replies - 1 through 8 (of 8 total)
  • corrinarusso

    (@corrinarusso)

    1 year, 8 months ago

    Your message is right here–>
    WordPress database error Table ‘wordpress.wp_options’ doesn’t exist

    Check the TABLE_PREFIX value in your wp-config file and make sure it says wordpress_

    See here:
    https://www.technical-recipes.com/2020/how-to-change-the-wordpress-database-table-prefix/

    • This reply was modified 1 year, 8 months ago by corrinarusso.
    Thread Starter bfckc

    (@bfckc)

    1 year, 8 months ago

    I changed it from wp_ to wordpress_ and am getting this, below. Also, most of the articles I’ve seen related to installing WordPress assume access to CPanel. I’m not using CPanel or any interface for that matter. I’m trying to do this manually with Windows Server 2019 with IIS installed.

    WordPress database error Table ‘wordpress.wordpress_options’ doesn’t exist for query INSERT INTO wordpress_options (option_name, option_value, autoload) VALUES (‘nonce_key’, ‘QMFdf=JZf:fPJt)KVt{%FUBM.C{D}x<]FA;Ar ?a:uC~k1?4.xwvjpFpN0=M}C6b’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by wp_can_install_language_pack, WP_Upgrader->fs_connect, Automatic_Upgrader_Skin->request_filesystem_credentials, WP_Upgrader_Skin->request_filesystem_credentials, request_filesystem_credentials, wp_nonce_field, wp_create_nonce, wp_hash, wp_salt, update_site_option, update_network_option, add_network_option, add_option
    WordPress database error Table ‘wordpress.wordpress_options’ doesn’t exist for query INSERT INTO wordpress_options (option_name, option_value, autoload) VALUES (‘nonce_salt’, ‘!l&Ks~F9-i]ND>.]]xg>Cl=FIO+=%0<$OMO86o)]4cGI/|#cw$g%Z52Jzh;F_KR}’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by wp_can_install_language_pack, WP_Upgrader->fs_connect, Automatic_Upgrader_Skin->request_filesystem_credentials, WP_Upgrader_Skin->request_filesystem_credentials, request_filesystem_credentials, wp_nonce_field, wp_create_nonce, wp_hash, wp_salt, update_site_option, update_network_option, add_network_option, add_option

    corrinarusso

    (@corrinarusso)

    1 year, 8 months ago

    Doesn’t matter if it is IIS or not.
    You need to be able to hit the db and validate the name of your database, and the prefix of your tables.

    Leave WordPress alone for now, and just make sure you can hit the database like this:
    https://docs.microsoft.com/en-us/iis/extensions/database-manager/use-the-database-manager
    then grab the connection strings from your wp-config file and see if you can log the db using those credentials.

    You have SQL Server on your server? or MySQL?

    Thread Starter bfckc

    (@bfckc)

    1 year, 8 months ago

    Currently using MySQL 8.0.

    Thread Starter bfckc

    (@bfckc)

    1 year, 8 months ago

    WHile I could follow the directions and create the connection string, I was unable to test it because the IIS Database Manager is no longer supported and Microsoft has removed the download from their site.

    corrinarusso

    (@corrinarusso)

    1 year, 8 months ago

    IIS is so painful.
    I’ve not used it in 20 years, but I see they suck just as much as ever.

    I guess you’ll need to wait for an IIS person to help you test the connection.

    Jorge Luiz

    (@jluizsouzadev)

    1 year, 7 months ago

    Do you have any backups for rolling back to the previous installation state when it worked?

    Thread Starter bfckc

    (@bfckc)

    1 year, 7 months ago

    Unfortunately, this is a fresh install of Server 2019 Datacenter w/ IIS. Then fresh installs of MySQL 8, PHP, and WordPress. All of this was done on Microsoft Azure.

    I tried using their support and they told me that WordPress on IIS wouldn’t work on Server 2019 Datacenter running on Azure, so I guess I’m going to have to figure something else out.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘WordPress on IIS on Server 2019’ is closed to new replies.

Tags