New Install Won’t Create Tables

  • I’m trying to do a new install in a new domain. I created the database using MySQL, and configured wp-config. When I try to do the install, I get a huge page of errors like this:

    WordPress database error: [Table ‘simberg_intraorbital1.wp_users’ doesn’t exist]
    CREATE TABLE wp_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default ”, user_pass varchar(255) NOT NULL default ”, user_nicename varchar(50) NOT NULL default ”, user_email varchar(100) NOT NULL default ”, user_url varchar(100) NOT NULL default ”, user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’, user_activation_key varchar(255) NOT NULL default ”, user_status int(11) NOT NULL default ‘0’, display_name varchar(250) NOT NULL default ”, PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename), KEY user_email (user_email) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

    It does this for every table. When I go in and look at the database in PHPMyAdmin, I see the schema, but no tables. In theory, I could build them manually, but life is too short.

    I’ve done many installations/upgrades, and never encountered this problem before. I’ve tried creating new databases, creating new users, and always get the same result. What am I doing wrong (if anything)?

Viewing 15 replies - 1 through 15 (of 16 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Blow away the database and user(s) and try again.

    If you have command line access:

    create database simberg_intraorbital1;
grant all on simbarg_intraorbital1.* to 'simbarg_wpuser'@'localhost' identified by 'simbarg_password';

    then exit mysql and put those values in the installation form.

    Thread Starter Rand Simberg

    (@rand-simberg)

    Thanks, but I don’t have permission to mysql from command line. I have to use DirectAdmin.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    You should be able to do that via PHPMYADMIN or some other tool that will give you a SQL command line.

    Thread Starter Rand Simberg

    (@rand-simberg)

    PhPMyAdmin doesn’t seem to have a command line that can do mysql commands, other than searches. It says “No Privileges” on the databases themselves. I really have limited ability to do much with databases, other than create them, using MySQL from DirectAdmin. I can try asking the server admin, but they weren’t very helpful yesterday, just told me that it was a problem with WordPress installation.

    Thread Starter Rand Simberg

    (@rand-simberg)

    I mean, I can edit tables in PHPMyAdmin, and even create them, but I don’t have any tables to edit, and I don’t want to manually create all those tables.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Delete and recreate a database and user in phpmyadmin.

    Thread Starter Rand Simberg

    (@rand-simberg)

    Been there, done that. Twice. I’m talking to sysadmin now, to see if I can get broader privileges. Frustrating to not be root on my own leased server.

    Thread Starter Rand Simberg

    (@rand-simberg)

    I’ve got a shiny new database with no schema or tables. I’ve put the information for it into wp-config, and also enabled debugging. I assume that in theory, if I try an install, it will populate it with the schema and tables for WordPress. I want to hear from you before I try, though.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Yes. When you run the install routine, it will create the tables.

    Thread Starter Rand Simberg

    (@rand-simberg)

    OK, except when I did that yesterday, it didn’t. Twice. Why will it this time?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    I don’t know. There’s something messed up with your server.

    Thread Starter Rand Simberg

    (@rand-simberg)

    The difference is that I have debugging turned on. Not sure what that means, though. Will it send error messages to the screen?

    Thread Starter Rand Simberg

    (@rand-simberg)

    Or to a log?

    Thread Starter Rand Simberg

    (@rand-simberg)

    OK, sysadmin at my server finally looked into issue, and is seeing some corruption in an table in another database causing the problem. Unfortunately, it’s comments at my blog…

    Thread Starter Rand Simberg

    (@rand-simberg)

    He’s backed up and rebuilding databases now, so that should clear the problem up. I’ll let you know if it does (or doesn’t).

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘New Install Won’t Create Tables’ is closed to new replies.