can install – wp-install prob..
-
hi guys im having probs wiht the WP gold.. im very sure i configed my b2config properly but it just wont install.. here’s the prob..
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 '', " . " 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 ('', 'https://www.remarpro.com', 'WordPress', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '');"); $links = mysql_query("INSERT INTO $tablelinks VALUES ('', 'https://cafelog.com', 'b2', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '');"); $links = mysql_query("INSERT INTO $tablelinks VALUES ('', 'https://photomatt.net', 'Matt', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '');"); $links = mysql_query("INSERT INTO $tablelinks VALUES ('', 'https://zed1.com/b2/', 'Mike', '', '', 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, 'General')"; $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'); $query = "INSERT INTO $tablecomments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_content) VALUES ('1', 'Mr WordPress', '[email protected]', 'https://www.remarpro.com', '127.0.0.1', '$now', '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); $query = "INSERT INTO $tablesettings ( ID, posts_per_page, what_to_show, archive_mode, time_difference, AutoBR, time_format, date_format) VALUES ( '1', '20', 'posts', 'monthly', '0', '1', 'g:i a', 'n/j/Y')"; $q = $wpdb->query($query); ?>
Settings are okay.
query($query); $random_password = substr(md5(uniqid(microtime())),0,6); $query = "INSERT INTO $tableusers (ID, user_login, user_pass, user_firstname, user_lastname, user_nickname, user_icq, user_email, user_url, user_ip, user_domain, user_browser, dateYMDhour, user_level, user_aim, user_msn, user_yim, user_idmode) VALUES ( '1', 'admin', '$random_password', '', '', 'admin', '0', '$admin_email', '', '127.0.0.1', '127.0.0.1', '', '00-00-0000 00:00:01', '10', '', '', '', 'nickname')"; $q = $wpdb->query($query); ?>
User setup successful!
Now you can log in with the login "admin" and password "".
Note that password carefully! It is a random password that was generated just for you. If you lose it, you will have to delete the tables from the database yourself, and re-install WordPress.
Were you expecting more steps? Sorry to disappoint. All done!
- The topic ‘can install – wp-install prob..’ is closed to new replies.