Title: WordPress database error Table New Setup Last modified: August 19, 2016 --- # WordPress database error Table New Setup * [anil_allagh](https://wordpress.org/support/users/anil_allagh/) * (@anil_allagh) * [17 years, 7 months ago](https://wordpress.org/support/topic/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) 1 [2](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/page/2/?output_format=md) [→](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/page/2/?output_format=md) * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868448) * Take a look at [Trac ticket 7724](http://trac.wordpress.org/ticket/7724). * [beermkr](https://wordpress.org/support/users/beermkr/) * (@beermkr) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868506) * 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](https://wordpress.org/support/users/anil_allagh/) * (@anil_allagh) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868527) * 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 * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868530) * Move to a *nix server. * Thread Starter [anil_allagh](https://wordpress.org/support/users/anil_allagh/) * (@anil_allagh) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868554) * 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](https://wordpress.org/support/users/anil_allagh/) * (@anil_allagh) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868555) * Can someone please help:( * Thanks * [whooami](https://wordpress.org/support/users/whooami/) * (@whooami) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868556) * [http://www.thehatchergroup.com/blog/wp-config-sample.php](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](https://wordpress.org/support/users/anil_allagh/) * (@anil_allagh) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868560) * 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 * [whooami](https://wordpress.org/support/users/whooami/) * (@whooami) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868561) * 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](http://lists.automattic.com/mailman/listinfo/wp-pro) * here;s another good resource, as well: * [http://jobs.wordpress.net/postajob.php](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](https://wordpress.org/support/users/anil_allagh/) * (@anil_allagh) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868562) * Whooami — Thanks, I know it was a rights issue, I think I have it figured out. * Anil * [snowman53](https://wordpress.org/support/users/snowman53/) * (@snowman53) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868563) * 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](https://wordpress.org/support/users/anil_allagh/) * (@anil_allagh) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868566) * 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 >>> * 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](https://wordpress.org/support/users/package/) WordPress * [@since](https://wordpress.org/support/users/since/) 2.3 * @uses $wp_version Used to notidy the WordPress version. * * [@return](https://wordpress.org/support/users/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’); ?> * [winana](https://wordpress.org/support/users/winana/) * (@winana) * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868568) * **big thanks @ anil_allagh** the problem is solve! * [snowman53](https://wordpress.org/support/users/snowman53/) * (@snowman53) * [17 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868585) * 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. * [foncused](https://wordpress.org/support/users/foncused/) * (@foncused) * [17 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/#post-868588) * 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) 1 [2](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/page/2/?output_format=md) [→](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/page/2/?output_format=md) The topic ‘WordPress database error Table New Setup’ is closed to new replies. ## Tags * [wp_options](https://wordpress.org/support/topic-tag/wp_options/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 21 replies * 13 participants * Last reply from: [fertac](https://wordpress.org/support/users/fertac/) * Last activity: [16 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-new-setup/page/2/#post-868691) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics