Creating Database without tables

  • vageez

    (@vageez)


    10 years ago

    http://authenticgreekdishes.com/wp-admin/install.php

    Tired installing WordPress on my Ubuntu machine.
    I am running :
    PHP 5.3.10-1ubuntu3.10
    Mysql

    The install is creating the database but no tables.
    I tried creating some tables inside the DB via the client and that works fine.

    Any help would be appreciated.

    follow the link to see the output of the issue.
    http://authenticgreekdishes.com/wp-admin/install.php

    From the version file:
    $wp_version = ‘3.8.1’;

    /**
    * Holds the WordPress DB revision, increments when changes are made to the WordPress DB schema.
    *
    * @global int $wp_db_version
    */
    $wp_db_version = 26691;

Viewing 9 replies - 1 through 9 (of 9 total)
  • Josh

    (@znuffn)

    10 years ago

    Did you set up wp-config.php correctly? You can find more information here: https://codex.wordpress.org/Installing_WordPress#Step_3:_Set_up_wp-config.php.

    Or did you leave it as wp-config-sample.php?

    Thread Starter vageez

    (@vageez)

    10 years ago

    I set up wp config correctly…
    I actually did some extensive testing with the settings to make sure they were correct.

    I tried several variations when trying to point to the dbhost…

    My guess at this point is that there may be some sort of permissions issue when wp tries to create the tables..

    Senff – a11n

    (@senff)

    10 years ago

    The install is creating the database but no tables.

    That’s strange, because the normal procedure is that you have to create the database (without any tables in it), and that WordPress will then create the tables in it.

    As far as I know, the standard WordPress install procedure can not create a database for you. Unless you use a 1-click install method that your webhost offers of course, is that the case here?

    Having said that, with errors like these it’s usually worth trying to remove all the tables from the database and start over from scratch. The database may have been corrupted during or after install.

    cdhishna

    (@cdhishna)

    10 years ago

    Are you sure the database name and one in the wp-config.php are same?
    Check for that

    Josh

    (@znuffn)

    10 years ago

    @vageez, check with your hosting provider then if you have all privileges. But since you could create a table yourself, I think it’s a little weird that it’s not working through WordPress. But I’m not sure.

    But I’d go with what Senff wrote and remove all the tables and start fresh. Or have you tried that already?

    Thread Starter vageez

    (@vageez)

    10 years ago

    @sneff I created the database
    1. names match in the config file
    2. user with full privileges created
    3. Once everything is set up i am attempting to run http://authenticgreekdishes.com/wp-admin/install.php

    4. No tables are being created.
    After chacking the error log i am seeing the following… which is essentially what being show in when accessing the URL…

    [Sun Apr 27 10:22:42 2014] [error] [client 64.229.165.94] WordPress database error Table 'agdsite.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'show_on_front' LIMIT 1 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, get_option
[Sun Apr 27 10:22:42 2014] [error] [client 64.229.165.94] WordPress database error Table 'agdsite.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'posts_per_page' LIMIT 1 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, get_option
[Sun Apr 27 10:22:42 2014] [error] [client 64.229.165.94] WordPress database error Table 'agdsite.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'comments_per_page' LIMIT 1 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, get_option
[Sun Apr 27 10:22:42 2014] [error] [client 64.229.165.94] WordPress database error Table 'agdsite.wp_posts' doesn't exist for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 1 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[Sun Apr 27 10:22:42 2014] [error] [client 64.229.165.94] WordPress database error Table 'agdsite.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'sticky_posts' LIMIT 1 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, get_option

    @znuffin Im on a VPS… my hosting provider also breifly looked into the issue a few weeks back… they were not able to find the issue and basically told me to add a CPANEL to my hosting plan…

    Im guessing ill try and install the most recent 3.9 version.

    Josh

    (@znuffn)

    10 years ago

    Did it work now with the latest version? Just interested if you figured it out. 🙂

    Thread Starter vageez

    (@vageez)

    10 years ago

    @znuffn

    A combination of things led to me successfully fixing the issue.

    1. Installed the latest version… 3.9
    2. Had to slightly alter my host file… with respects to removing rewrite directives…

    Thanks for all your help!

    Josh

    (@znuffn)

    10 years ago

    Okay, cool, thanks for the update! 😉 And glad you got it to work.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Creating Database without tables’ is closed to new replies.