Support » Installing WordPress » WordPress database error Table New Setup

  • I am getting this error for a new setup for my client. Can someone plase help — Thanks

    Anil

    WordPress database error Table ‘hatchergroup.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1222571399;a:1:{s:17:\”wp_update_plugins\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}s:7:\”version\”;i:2;}’, ‘yes’) made by add_option WordPress database error Table ‘hatchergroup.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘random_seed’, ‘5fb08626f5d6cf732c434e5ed53aa13b’, ‘yes’) made by add_option WordPress database error Table ‘hatchergroup.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘auth_salt’, ‘GkrYjKewlRDd’, ‘yes’) made by add_option

Viewing 15 replies - 1 through 15 (of 21 total)
  • Take a look at Trac ticket 7724.

    I have the same issue. I looked at the Trac ticket and for the life of me can not figure out where I am suppossed to change that stuff. The file it references does not have that many lines in it.

    Any help?

    Mike

    Thread Starter anil_allagh

    (@anil_allagh)

    I have updated all the requied PHP files. Still having problem running the install.php. I am running IIS 6.0 on windows server 2003. Could it be the rights issue. Can u help. Thanks, Anil

    Move to a *nix server.

    Thread Starter anil_allagh

    (@anil_allagh)

    I am also getting this error page and looping back to creating the config file:

    line 145 PHP Warning: fwrite(): supplied argument is not a valid stream resource in D:\Web\thehatchergroup.com\www\blog\wp-admin\setup-config.php on line 145 PHP Warning: fwrite(): supplied argument is not a valid stream resource in D:\Web\thehatchergroup.com\www\blog\wp-admin\setup-config.php on line 145 PHP Warning: fwrite(): supplied argument is not a valid stream resource in D:\Web\thehatchergroup.com\www\blog\wp-admin\setup-config.php on line 145 PHP Warning: fwrite(): supplied argument is not a valid stream resource in D:\Web\thehatchergroup.com\www\blog\wp-admin\setup-config.php on line 145 PHP Warning: fwrite(): supplied argument is not a valid stream resource in D:\Web\thehatchergroup.com\www\blog\wp-admin\setup-config.php on line 145 PHP Warning: fclose(): supplied argument is not a valid stream resource in D:\Web\thehatchergroup.com\www\blog\wp-admin\setup-config.php on line 148 PHP Warning: chmod() [function.chmod]: No such file or directory in D:\Web\thehatchergroup.com\www\blog\wp-admin\setup-config.php on line 149 PHP Notice: Undefined variable: admin_dir in D:\Web\thehatchergroup.com\www\blog\wp-admin\setup-config.php on line 41

    Thread Starter anil_allagh

    (@anil_allagh)

    Can someone please help:(

    Thanks

    http://www.thehatchergroup.com/blog/wp-config-sample.php

    what does that say? Follow its advice.

    The answer to your problem lies in your ability to read wp-admin/setup-config.php

    its looking for a file to write to that doesnt exist.

    You would know that if you googled fwrite. You would know that if you opened the file and looked for that term.

    Are you being paid? If so, you might want to put on your thinking cap.

    “IT consultant”

    what kind of IT anything cant use the biggest search engine on the web to troubleshoot the simplest of PHP errors???

    Thread Starter anil_allagh

    (@anil_allagh)

    Thanks whooami — But you were no help at all, I know the problem is the ability to write not read the wp-admin/setup-config.php. I have created the file manually. The problem is the ability to write, and the access to the right folder. That is were I need help. So, if you know the answer, I will welcome your thoughts. If not please keep you opinions to your self. Your anger, is not my problem, it may be related to you not being breastfed. Learn to deal with it.

    Anil

    uh, I was breastfed, and am well past that, but thanks for your concern.

    again, put on your thinking cap — earn that money, and if you cant, here’s a link to ppl that actually know what theyre doing and enjoy assisting ppl that dont, but are getting paid all the same.

    http://lists.automattic.com/mailman/listinfo/wp-pro

    here;s another good resource, as well:

    http://jobs.wordpress.net/postajob.php

    Best of luck.

    Note that someone else may come along and help you — thats, of course, their deal. I merely offer these up as an alternative to your waiting for free support, if you have a time limit.

    Thread Starter anil_allagh

    (@anil_allagh)

    Whooami — Thanks, I know it was a rights issue, I think I have it figured out.

    Anil

    anil_allagh,

    I am seeing the same problem as your original post, i.e. table does not exist.

    Like you, I cannot figure out what to do with the ticket 7724 patch files. Initially I thought you added them into the update.php file at the indicated line numbers, but since there is no line 273, that does not make sense either. My update.php stops at line 173.

    Would you mind explaining how you solved this issue for the rest of us that are not as brilliant as Whooami and don’t have the option of using a *nix server? At least you would be contributing something useful.

    Thanks!

    Thread Starter anil_allagh

    (@anil_allagh)

    Hi Snowman53,

    The real solution was applying rights to the right folders. As the the php file, I opened it using wordpad and added the line that were recommended on Trac ticket 7724. Copy and paste the following to your wp-include\update.php >>>

    <?php
    /**
    * A simple set of functions to check our version 1.0 update service
    *
    * @package WordPress
    * @since 2.3
    */

    /**
    * wp_version_check() – Check WordPress version against the newest version.
    *
    * The WordPress version, PHP version, and Locale is sent. Checks against the WordPress server at
    * api.wordpress.org. Will only check if PHP has fsockopen enabled and WordPress isn’t installing.
    *
    * @package WordPress
    * @since 2.3
    * @uses $wp_version Used to check against the newest WordPress version.
    *
    * @return mixed Returns null if update is unsupported. Returns false if check is too soon.
    */
    function wp_version_check() {
    if ( !function_exists(‘fsockopen’) || defined(‘WP_INSTALLING’) )
    return;

    global $wp_version;
    $php_version = phpversion();

    $current = get_option( ‘update_core’ );
    $locale = get_locale();

    if (
    isset( $current->last_checked ) &&
    43200 > ( time() – $current->last_checked ) &&
    $current->version_checked == $wp_version
    )
    return false;

    $new_option = ”;
    $new_option->last_checked = time(); // this gets set whether we get a response or not, so if something is down or misconfigured it won’t delay the page load for more than 3 seconds, twice a day
    $new_option->version_checked = $wp_version;

    $http_request = “GET /core/version-check/1.1/?version=$wp_version&php=$php_version&locale=$locale HTTP/1.0\r\n”;
    $http_request .= “Host: api.wordpress.org\r\n”;
    $http_request .= ‘Content-Type: application/x-www-form-urlencoded; charset=’ . get_option(‘blog_charset’) . “\r\n”;
    $http_request .= ‘User-Agent: WordPress/’ . $wp_version . ‘; ‘ . get_bloginfo(‘url’) . “\r\n”;
    $http_request .= “\r\n”;

    $response = ”;
    if ( false !== ( $fs = @fsockopen( ‘api.wordpress.org’, 80, $errno, $errstr, 3 ) ) && is_resource($fs) ) {
    fwrite( $fs, $http_request );
    while ( !feof( $fs ) )
    $response .= fgets( $fs, 1160 ); // One TCP-IP packet
    fclose( $fs );

    $response = explode(“\r\n\r\n”, $response, 2);
    if ( !preg_match( ‘|HTTP/.*? 200|’, $response[0] ) )
    return false;

    $body = trim( $response[1] );
    $body = str_replace(array(“\r\n”, “\r”), “\n”, $body);

    $returns = explode(“\n”, $body);

    $new_option->response = attribute_escape( $returns[0] );
    if ( isset( $returns[1] ) )
    $new_option->url = clean_url( $returns[1] );
    if ( isset( $returns[2] ) )
    $new_option->current = attribute_escape( $returns[2] );
    }
    update_option( ‘update_core’, $new_option );
    }
    add_action( ‘init’, ‘wp_version_check’ );

    /**
    * wp_update_plugins() – Check plugin versions against the latest versions hosted on WordPress.org.
    *
    * The WordPress version, PHP version, and Locale is sent along with a list of all plugins installed.
    * Checks against the WordPress server at api.wordpress.org.
    * Will only check if PHP has fsockopen enabled and WordPress isn’t installing.
    *
    * @package WordPress
    * @since 2.3
    * @uses $wp_version Used to notidy the WordPress version.
    *
    * @return mixed Returns null if update is unsupported. Returns false if check is too soon.
    */
    function wp_update_plugins() {
    global $wp_version;

    if ( !function_exists(‘fsockopen’) || defined(‘WP_INSTALLING’) )
    return false;

    // If running blog-side, bail unless we’ve not checked in the last 12 hours
    if ( !function_exists( ‘get_plugins’ ) )
    require_once( ABSPATH . ‘wp-admin/includes/plugin.php’ );

    $plugins = get_plugins();
    $active = get_option( ‘active_plugins’ );
    $current = get_option( ‘update_plugins’ );

    $new_option = ”;
    $new_option->last_checked = time();
    $time_not_changed = isset( $current->last_checked ) && 43200 > ( time() – $current->last_checked );

    $plugin_changed = false;
    foreach ( $plugins as $file => $p ) {
    $new_option->checked[ $file ] = $p[‘Version’];

    if ( !isset( $current->checked[ $file ] ) ) {
    $plugin_changed = true;
    continue;
    }

    if ( strval($current->checked[ $file ]) !== strval($p[‘Version’]) )
    $plugin_changed = true;
    }

    foreach ( (array) $current->response as $plugin_file => $update_details ) {
    if ( ! isset($plugins[ $plugin_file ]) ) {
    $plugin_changed = true;
    }
    }

    // Bail if we’ve checked in the last 12 hours and if nothing has changed
    if ( $time_not_changed && !$plugin_changed )
    return false;

    $to_send->plugins = $plugins;
    $to_send->active = $active;
    $send = serialize( $to_send );

    $request = ‘plugins=’ . urlencode( $send );
    $http_request = “POST /plugins/update-check/1.0/ HTTP/1.0\r\n”;
    $http_request .= “Host: api.wordpress.org\r\n”;
    $http_request .= “Content-Type: application/x-www-form-urlencoded; charset=” . get_option(‘blog_charset’) . “\r\n”;
    $http_request .= “Content-Length: ” . strlen($request) . “\r\n”;
    $http_request .= ‘User-Agent: WordPress/’ . $wp_version . ‘; ‘ . get_bloginfo(‘url’) . “\r\n”;
    $http_request .= “\r\n”;
    $http_request .= $request;

    $response = ”;
    if( false != ( $fs = @fsockopen( ‘api.wordpress.org’, 80, $errno, $errstr, 3) ) && is_resource($fs) ) {
    fwrite($fs, $http_request);

    while ( !feof($fs) )
    $response .= fgets($fs, 1160); // One TCP-IP packet
    fclose($fs);
    $response = explode(“\r\n\r\n”, $response, 2);
    }

    $response = unserialize( $response[1] );

    if ( $response )
    $new_option->response = $response;

    update_option( ‘update_plugins’, $new_option );
    }

    function _maybe_update_plugins() {
    $current = get_option( ‘update_plugins’ );
    if ( isset( $current->last_checked ) && 43200 > ( time() – $current->last_checked ) )
    return;
    wp_update_plugins();
    }

    add_action( ‘load-plugins.php’, ‘wp_update_plugins’ );
    add_action( ‘admin_init’, ‘_maybe_update_plugins’ );
    add_action( ‘wp_update_plugins’, ‘wp_update_plugins’ );

    if ( !wp_next_scheduled(‘wp_update_plugins’) && !defined(‘WP_INSTALLING’) )
    wp_schedule_event(time(), ‘twicedaily’, ‘wp_update_plugins’);

    if ( !wp_next_scheduled(‘wp_update_themes’) && !defined(‘WP_INSTALLING’) )
    wp_schedule_event(time(), ‘twicedaily’, ‘wp_update_themes’);
    ?>

    big thanks @ anil_allagh
    the problem is solve!

    I had updated both PHP & MYSQL before installing WordPress. Everything looked like it worked & my other sites still worked. But no luck with WordPress.

    FInally discovered there is a problem with using an old verison of libmysql.dll with the lastest version of PHP.

    Once that was corrected and using anil_allagh’s post, I was able to get WordPress up and running.

    Do a search in the PHP forums for the libmysql problem if you think you have a similar problem.

    I have inserted this file… and overwritten the contents of the update.php file… but my error remains exaclty the same.

    WordPress database error Table ‘sa2ozblog.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1224482601;a:1:{s:17:\”wp_update_plugins\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}s:7:\”version\”;i:2;}’, ‘yes’) made by add_option
    WordPress database error Table ‘sa2ozblog.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘random_seed’, ‘af2f6fffa5079c5f54979e85b3d1a6fe’, ‘yes’) made by add_option
    WordPress database error Table ‘sa2ozblog.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘auth_salt’, ‘PeCBT$GipjGA’, ‘yes’) made by add_option

    Please can someone help me! I am getting desperate!

Viewing 15 replies - 1 through 15 (of 21 total)
  • The topic ‘WordPress database error Table New Setup’ is closed to new replies.