Title: Another Installation Problem Last modified: August 18, 2016 --- # Another Installation Problem * [wanbro](https://wordpress.org/support/users/wanbro/) * (@wanbro) * [21 years, 9 months ago](https://wordpress.org/support/topic/another-installation-problem/) * Hello – this is my first foray into WP and anything even remotely complicated techie/geeky-wise. Please bear with me… I’m being hosted by Act Now Domains hosting ([https://www.securepaynet.net/gdshop/hosting/landing.asp?isc=wwbb42&se=%2B&from%5Fapp=&prog%5Fid=actnowdomains&pl%5Fid=105](https://www.securepaynet.net/gdshop/hosting/landing.asp?isc=wwbb42&se=%2B&from%5Fapp=&prog%5Fid=actnowdomains&pl%5Fid=105)) and have confirmation that they are running PHP ver. 4.3.2 and MySQL ver. 4.0.14 on their hosting servers. So, no problem, right? Not quite so easy. I’ve downloaded WP no problems, and followed the instructions to change wp-config-sample to wp- config.php and uploaded that onto my FTP. Fine. * At this point, I might add that my username is the same as my database name (I only have one database on my account, so hopefully this should avoid confusion) – will this cause unneccessary problems? When I run the install program – wp-admin/install.php, I’m greeted with a familiar sight for other flailing newbies: wp-config.php file. I need this before we can get started. Need more help? We got it. You can create a wp- config.php file through a web interface, but this doesn’t work for all server setups. The safest way is to manually create the file.”); require_once(‘../wp- config.php’); require(‘upgrade-functions.php’); if (isset($_GET[‘step’])) $step = $_GET[‘step’]; else $step = 0; ?> WordPresshide_errors(); $installed = $wpdb- >get_results(“SELECT * FROM $tableusers”); if ($installed) die(__(‘ You appear to already have WordPress installed. If you would like to reinstall please clear your old database files first. ‘)); $wpdb->show_errors(); switch($step) { case 0: ?> Welcome to WordPress. We’re now going to go through a few steps to get you up and running with the latest in personal publishing platforms. Before we get started, remember that we require a PHP version of at least 4.1.0, you have. Look good? You also need to set up the database connection information in wp- config.php. Have you looked at the readme? If you’re all ready, let’s go! Step 1 Okay first we’re going to set up the links database. This will allow you to host your own blogroll, complete with Weblogs.com updates. Installing WP-Links. Checking for tables… ” . $sql . “ ” . mysql_error()); if ($result != false) { echo “ Table ‘$tablelinkcategories’ created OK \n”; $got_cats = true; } } else{ echo “ Found table ‘$tablelinkcategories’, don’t need to create it… \n”; $got_cats = true; } if (!$got_links) { echo “ Can’t find ‘$tablelinks’, gonna create it…\ n”; $sql = “CREATE TABLE $tablelinks ( ” . ” link_id int(11) NOT NULL auto_increment,”.” link_url varchar(255) NOT NULL default ”, ” . ” link_name varchar(255) NOT NULL default ”, ” . ” link_image varchar(255) NOT NULL default ”, ” . ” link_target varchar(25) NOT NULL default ”, ” . ” link_category int(11) NOT NULL default 0, ” . ” link_description varchar(255) NOT NULL default ”, ” . ” link_visible enum (‘Y’,’N’) NOT NULL default ‘Y’, ” . ” link_owner int NOT NULL DEFAULT ‘1’,”.” link_rating int NOT NULL DEFAULT ‘0’, ” . ” link_updated DATETIME NOT NULL DEFAULT‘ 0000-00-00 00:00:00’, ” . ” link_rel varchar(255) NOT NULL default ”, ” . ” link_notes MEDIUMTEXT NOT NULL default ”, ” . ” PRIMARY KEY (link_id) ” . “) “; $result = mysql_query($sql) or print (“Can’t create the table ‘$tablelinks’ in the database.”. $sql . “ ” . mysql_error()); $links = mysql_query(“INSERT INTO $tablelinks VALUES(”,‘ [http://wordpress.org/’](http://wordpress.org/’);, ‘WordPress’, ”, ”, 1, ”, ‘Y’, 1, 0, ‘0000-00-00 00:00:00’, ”, ”);”); $links = mysql_query(“INSERT INTO $tablelinks VALUES (”, ‘[http://photomatt.net/’](http://photomatt.net/’);,‘ Matt’, ”, ”, 1, ”, ‘Y’, 1, 0, ‘0000-00-00 00:00:00’, ”, ”);”); $links = mysql_query(“ INSERT INTO $tablelinks VALUES (”, ‘[http://zed1.com/journalized/’](http://zed1.com/journalized/’);,‘ Mike’, ”, ”, 1, ”, ‘Y’, 1, 0, ‘0000-00-00 00:00:00’, ”, ”);”); $links = mysql_query(“ INSERT INTO $tablelinks VALUES (”, ‘[http://www.alexking.org/’](http://www.alexking.org/’);,‘ Alex’, ”, ”, 1, ”, ‘Y’, 1, 0, ‘0000-00-00 00:00:00’, ”, ”);”); $links = mysql_query(“ INSERT INTO $tablelinks VALUES (”, ‘[http://dougal.gunters.org/’](http://dougal.gunters.org/’);,‘ Dougal’, ”, ”, 1, ”, ‘Y’, 1, 0, ‘0000-00-00 00:00:00’, ”, ”);”); if ($result ! = false) { echo “ Table ‘$tablelinks’ created OK \n”; $got_links = true; } } else { echo “ Found table ‘$tablelinks’, don’t need to create it… \n”; $got_links = true; } if ($got_links && $got_cats) { echo “ Looking for category 1… \n”; $sql = “SELECT * FROM $tablelinkcategories WHERE cat_id=1 “; $result = mysql_query( $sql) or print (“Can’t query ‘$tablelinkcategories’. ” . $sql . “ ” . mysql_error()); if ($result != false) { if ($row = mysql_fetch_object($result)) { echo “ You have at least 1 category. Good! \n”; $got_row = true; } else { echo “ Gonna insert category 1… \n”; $sql = “INSERT INTO $tablelinkcategories (cat_id, cat_name) VALUES (1, ‘Links’)”; $result = mysql_query($sql) or print (“Can’t query insert category. ” . $sql . “ ” . mysql_error()); if ($result != false) { echo “ Inserted category Ok \n”; $got_row = true; } } } } if ($got_row) { echo “ All done! \n”;}? > Did you defeat the boss monster at the end? Great! You’re ready for Step 2. Step 2 First we’re going to create the necessary blog tables in the database… query($query); ?> The first table has been created! … query($query); ?> The test post has been inserted correctly… query($query); $query = “INSERT INTO $tablecategories( cat_ID, cat_name) VALUES (‘0’, ‘General’)”; $q = $wpdb->query($query); $query = “UPDATE $tableposts SET post_category = 1”; $result = $wpdb->query($query);? > Categories are up and running… query($query); $now = date(‘Y-m-d H:i:s’); $ now_gmt = gmdate(‘Y-m-d H:i:s’); $query = “INSERT INTO $tablecomments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content) VALUES (‘1’, ‘Mr WordPress’,‘ mr@wordpress.org’, ‘[http://wordpress.org’](http://wordpress.org’);,‘ 127.0.0.1’, ‘$now’, ‘$now_gmt’, ‘Hi, this is a comment. To delete a comment, just log in, and view the posts\’ comments, there you will have the option to edit or delete them.’)”; $q = $wpdb->query($query); ?> Comments are groovy… query( $query); ?> Post metadata table ready to go… query($query); // $query = “DROP TABLE IF EXISTS $tableoptiontypes”; // $q = mysql_query($query) or mysql_doh(“ doh, can’t drop the table \”$tableoptiontypes\” in the database.”); $query = ” CREATE TABLE $tableoptiontypes ( optiontype_id int(11) NOT NULL auto_increment, optiontype_name varchar(64) NOT NULL, PRIMARY KEY (optiontype_id) ) “; $q = $ wpdb->query($query); // $query = “DROP TABLE IF EXISTS $tableoptiongroups”; // $q = mysql_query($query) or mysql_doh(“doh, can’t drop the table \”$tableoptiongroups\” in the database.”); $query = ” CREATE TABLE $tableoptiongroups ( group_id int( 11) NOT NULL auto_increment, group_name varchar(64) not null, group_desc varchar( 255), group_longdesc tinytext, PRIMARY KEY (group_id) ) “; $q = $wpdb->query( $query); // $query = “DROP TABLE IF EXISTS $tableoptiongroup_options”; // $q = mysql_query($query) or mysql_doh(“doh, can’t drop the table \”$tableoptiongroup_options\” in the database.”); $query = ” CREATE TABLE $tableoptiongroup_options ( group_id int(11) NOT NULL, option_id int(11) NOT NULL, seq int(11) NOT NULL, PRIMARY KEY( group_id, option_id) ) “; $q = $wpdb->query($query); // $query = “DROP TABLE IF EXISTS $tableoptionvalues”; // $q = mysql_query($query) or mysql_doh(“doh, can’t drop the table \”$tableoptionvalues\” in the database.”); $query = ” CREATE TABLE $tableoptionvalues ( option_id int(11) NOT NULL, optionvalue tinytext, optionvalue_desc varchar(255), optionvalue_max int(11), optionvalue_min int(11), optionvalue_seq int(11), UNIQUE (option_id, optionvalue(255)), INDEX (option_id, optionvalue_seq) ) “; $q = $wpdb->query($query); ?> Option Tables created okay. query($query); } ?> Option Data inserted okay. query($query); } ?> Links option data inserted okay. see here’, 8, 20)”, “INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(87,’default_geourl_lon’, 8, 0.0, ‘The default Longitude ICBM value’, 8, 20)”, “INSERT INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(9,’Geo Options’, ‘Settings which control the posting and display of Geo Options’)”, “INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(9,84,1)”, “INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(9,85,1)”, “INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(9,86,1)”, “INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(9,87,1)”, ); foreach ($geo_option_data as $query) { $q = $wpdb->query( $query); } ?> Geo option data inserted okay. OK. We’re nearly done now. We just need to ask you a couple of things: What is the web address of your WordPress installation? (We probably guessed it for you correctly.) On to Step 3 query( $query); } // $query = “DROP TABLE IF EXISTS $tableusers”; // $q = mysql Viewing 6 replies - 1 through 6 (of 6 total) * Thread Starter [wanbro](https://wordpress.org/support/users/wanbro/) * (@wanbro) * [21 years, 9 months ago](https://wordpress.org/support/topic/another-installation-problem/#post-77290) * It may be also worth noting a reply I had from my web server support: * > Thank you for contacting customer support. We are currently running PHP ver. > 4.3.2 and MySQL ver. 4.0.14 on our hosting servers. I would recommend that > you view the following link to see if you are trying to utilize a feature that > has been disabled for security reasons: > [http://ftphelp.secureserver.net/php-mysql-tutorial.html](http://ftphelp.secureserver.net/php-mysql-tutorial.html) > We also run our Hosting Servers in Safe Mode and will not be able too turn > off this feature. * Following that link tells me 1001 different things about PHP and MySQL that means absolutely nothing to me. Does it look as if it is going to work with this host, or is it likely I will have to change? Or is it not a problem with the host at all but something else? Any ideas, please, anything! * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [21 years, 9 months ago](https://wordpress.org/support/topic/another-installation-problem/#post-77291) * Safe Mode will not affect wp. Mod_rewrite is probably not installed, but that is not essential for your blog to work anyway. * Thread Starter [wanbro](https://wordpress.org/support/users/wanbro/) * (@wanbro) * [21 years, 9 months ago](https://wordpress.org/support/topic/another-installation-problem/#post-77302) * Thanks for that. Just about to give up on this – it’s been hours, not five minutes! When I go to [http://www.domain.com/wp-admin/install.php](http://www.domain.com/wp-admin/install.php) I get: * > Error establishing a database connection! This probably means that the connection > information in your wp-config.php file is incorrect. Double check it and try > again. > * Are you sure you have the correct user/password? * Are you sure that > you have typed the correct hostname? * Are you sure that the database server > is running? * Yes, I know I have the correct username and password. I only have one database hosted with my server, and know the correct name. Host server gives Host Name for database as mysql9.secureserver.net so I’ve tried this instead of ‘localhost’ but no luck. ‘localhost’ doesn’t work either. Any thoughts? * [Sushubh](https://wordpress.org/support/users/sushubh/) * (@sushubh) * [21 years, 9 months ago](https://wordpress.org/support/topic/another-installation-problem/#post-77305) * ur admin would be a better person to answer that. databases sometimes are prefixed by the username on the servers. can be various other reasons. for me, installing WP is a process that rarely takes more than 1 minute, if i exclude the time uploading the files on the connection i have here with me 🙂 * Thread Starter [wanbro](https://wordpress.org/support/users/wanbro/) * (@wanbro) * [21 years, 9 months ago](https://wordpress.org/support/topic/another-installation-problem/#post-77490) * Admin aren’t being particularly useful, unfortunately. However, they have confirmed the name for my database, and it’s the one I have been trying for the last couple of days. So I have the DB name, the username, password and host name they supply. I know they are running an up to date version of MySQL and PHP. But I still get the above error message saying my wp-config.php file isn’t correct and there’s an error establishing a database connection. Anyone, anything?? * Thread Starter [wanbro](https://wordpress.org/support/users/wanbro/) * (@wanbro) * [21 years, 9 months ago](https://wordpress.org/support/topic/another-installation-problem/#post-77498) * Ok, sorted it. Deleted all the files, and loaded them up in a new directory – [http://www.domain.com/blog.](http://www.domain.com/blog.) This seemed to do the trick, so now I’m ready to rock. Hope this might help any other strugglers… Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Another Installation Problem’ is closed to new replies. * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 6 replies * 3 participants * Last reply from: [wanbro](https://wordpress.org/support/users/wanbro/) * Last activity: [21 years, 9 months ago](https://wordpress.org/support/topic/another-installation-problem/#post-77498) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics