Forum Replies Created

Viewing 10 replies - 1 through 10 (of 10 total)
  • No, no-one seems to know the step by step green field process with sources outlined for a brand new clean out of the box Windows Server 2016. With screen shots preferred.

    My solution was to build my wordpress site on a clean install of Centos 7.2 from scratch. No issues.

    Carl

    Thank you for that response. I’ve installed and used WordPress since 2005, so I probably should have prefaced with that understanding. This installation is for a new server using windows 2016, MySQL version 5.7 and PHP version 7.1.26 and wordpress download 5.0.3

    Where this setup is having an issue is the original setup of the database for WordPress to use in the first place in the first place.

    http://127.0.0.1/wordpress/wp-admin/setup-config.php

    I’ve not encountered this problem in past installations and want to understand two things:

    1) What is this error:
    WordPress database error Unknown column ‘wp_’ in ‘field list’ for query SELECT wp_

    2) What is the resolution?

    My now question is what creates the correct blank initial vanilla wordpress schema for MySQL? No database comes with the download so some SQL statement is needed to create the initial blank schema correct? What am I missing?

    WordPress database error Unknown column ‘wp_’ in ‘field list’ for query SELECT wp_

    And just for completeness I “dropped” the schema in the MySQL workbench, (btw in MySQL parlance a database is a schema and a database is actually the database management instance), and received this error when trying to execute the wordpress configuration:

    Can’t select database
    We were able to connect to the database server (which means your username and password is okay) but not able to select the wordpress database.

    Are you sure it exists?
    Does the user wordpress have permission to use the wordpress database?
    On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?
    If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

    However, I’m still getting this error:

    WordPress database error Unknown column ‘wp_’ in ‘field list’ for query SELECT wp_

    Okay, now I see. I’ve checked the privileges using the MySQL workbench and now I have:

    mysql> USE mysql;
    Database changed
    mysql> SELECT * FROM user WHERE user = ‘wordpress’;
    +———–+———–+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+——————+—————-+———————+——————–+——————+————+————–+————————+———-+————+————-+————–+—————+————-+—————–+———————-+———————–+——————————————-+——————+———————–+——————-+—————-+
    | Host | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | password_expired | password_last_changed | password_lifetime | account_locked |
    +———–+———–+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+——————+—————-+———————+——————–+——————+————+————–+————————+———-+————+————-+————–+—————+————-+—————–+———————-+———————–+——————————————-+——————+———————–+——————-+—————-+
    | localhost | wordpress | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | mysql_native_password | *EE3A42CC2343344D831212BD9F58C05BD1B29269 | N | 2019-02-18 17:49:09 | NULL | N |
    +———–+———–+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+——————+—————-+———————+——————–+——————+————+————–+————————+———-+————+————-+————–+—————+————-+—————–+———————-+———————–+——————————————-+——————+———————–+——————-+—————-+
    1 row in set (0.00 sec)

    Yes for the contents of the page I pasted, the source of the contents was:

    http://127.0.0.1/wordpress/wp-admin/setup-config.php

    Then clicked “Let’s go”

    The follow-on screen I entered the database name, user, pwd, changed local host to 127.0.0.1 and left the last entry on the screen as wp_ for the table prefix and clicked submit. A nearly blank page immediately came back with the following at the top of the page:

    WordPress database error Unknown column ‘wp_’ in ‘field list’ for query SELECT wp_

    Thank you for helping.

    Are these privileges correct?

    mysql> USE mysql;
    No connection. Trying to reconnect…
    Connection id: 1789
    Current database: *** NONE ***

    Database changed
    mysql> SELECT * FROM user WHERE user = ‘wordpress’;
    +———–+———–+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+——————+—————-+———————+——————–+——————+————+————–+————————+———-+————+————-+————–+—————+————-+—————–+———————-+———————–+——————————————-+——————+———————–+——————-+—————-+
    | Host | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | password_expired | password_last_changed | password_lifetime | account_locked |
    +———–+———–+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+——————+—————-+———————+——————–+——————+————+————–+————————+———-+————+————-+————–+—————+————-+—————–+———————-+———————–+——————————————-+——————+———————–+——————-+—————-+
    | localhost | wordpress | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | *EE3A42CC2343344D831212BD9F58C05BD1B29269 | N | 2019-02-18 17:49:09 | NULL | N |
    +———–+———–+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+——————+—————-+———————+——————–+——————+————+————–+————————+———-+————+————-+————–+—————+————-+—————–+———————-+———————–+——————————————-+——————+———————–+——————-+—————-+
    1 row in set (0.03 sec)

    mysql>

    Yes there was but it seems the topic was set to “resolved” but without a step by step guide to implementing the solution.

    The version I downloaded has the file name: wordpress-5.0.3.zip

    I believe it’s the latest one.

    Thank you for your response.

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