{"id":23256,"date":"2003-08-22T12:52:09","date_gmt":"2003-08-22T12:52:09","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/wp-installphp-problem\/"},"modified":"2016-08-18T18:15:00","modified_gmt":"2016-08-18T18:15:00","slug":"wp-installphp-problem","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/wp-installphp-problem\/","title":{"rendered":"wp-install.php problem"},"content":{"rendered":"<p>Sorry, about the big post but this is the message I got when I click on the wp-install.php from the readme.html.  What don&#8217;t I have config correctly?<br \/>\nStep 1<br \/>\nOkay first we\u2019re going to set up the links database. This will allow you to host your own blogroll, complete with Weblogs.com updates.<br \/>\nInstalling WP-Links.<br \/>\nChecking for tables&#8230;<br \/>\n &#8221; . mysql_error());     if (&#036;result != false) {         echo &#8220;<br \/>\nTable &#8216;&#036;tablelinkcategories&#8217; created OK<br \/>\n&#092;n&#8221;;         &#036;got_cats = true;     } } else {     echo &#8220;<br \/>\nFound table &#8216;&#036;tablelinkcategories&#8217;, don&#8217;t need to create it&#8230;<br \/>\n&#092;n&#8221;;         &#036;got_cats = true; } if (!&#036;got_links) {     echo &#8220;<br \/>\nCan&#8217;t find &#8216;&#036;tablelinks&#8217;, gonna create it&#8230;<br \/>\n&#092;n&#8221;;     &#036;sql = &#8220;CREATE TABLE &#036;tablelinks (              link_id int(11) NOT NULL auto_increment,             link_url varchar(255) NOT NULL default &#8221;,             link_name varchar(255) NOT NULL default &#8221;,             link_image varchar(255) NOT NULL default &#8221;,             link_target varchar(25) NOT NULL default &#8221;,             link_category int(11) NOT NULL default 0,             link_description varchar(255) NOT NULL default &#8221;,             link_visible enum (&#8216;Y&#8217;,&#8217;N&#8217;) NOT NULL default &#8216;Y&#8217;,             link_owner int NOT NULL DEFAULT &#8216;1&#8217;,             link_rating int NOT NULL DEFAULT &#8216;0&#8217;,             link_updated DATETIME NOT NULL DEFAULT &#8216;0000-00-00 00:00:00&#8217;,             link_rel varchar(255) NOT NULL default &#8221;,             PRIMARY KEY (link_id)            ) &#8220;;     &#036;result = mysql_query(&#036;sql) or print (&#8220;Can&#8217;t create the table &#8216;&#036;tablelinks&#8217; in the database.<br \/>\n&#8221; . &#036;sql . &#8220;<br \/>\n&#8221; . mysql_error());         &#036;links = mysql_query(&#8220;INSERT INTO &#036;tablelinks VALUES (&#8221;, &#8216;http:\/\/wordpress.org&#8217;, &#8216;WordPress&#8217;, &#8221;, &#8221;, 1, &#8221;, &#8216;Y&#8217;, 1, 0, &#8216;0000-00-00 00:00:00&#8217;, &#8221;);&#8221;);         &#036;links = mysql_query(&#8220;INSERT INTO &#036;tablelinks VALUES (&#8221;, &#8216;http:\/\/cafelog.com&#8217;, &#8216;b2&#8217;, &#8221;, &#8221;, 1, &#8221;, &#8216;Y&#8217;, 1, 0, &#8216;0000-00-00 00:00:00&#8217;, &#8221;);&#8221;);         &#036;links = mysql_query(&#8220;INSERT INTO &#036;tablelinks VALUES (&#8221;, &#8216;http:\/\/photomatt.net&#8217;, &#8216;Matt&#8217;, &#8221;, &#8221;, 1, &#8221;, &#8216;Y&#8217;, 1, 0, &#8216;0000-00-00 00:00:00&#8217;, &#8221;);&#8221;);         &#036;links = mysql_query(&#8220;INSERT INTO &#036;tablelinks VALUES (&#8221;, &#8216;http:\/\/zed1.com\/b2\/&#8217;, &#8216;Mike&#8217;, &#8221;, &#8221;, 1, &#8221;, &#8216;Y&#8217;, 1, 0, &#8216;0000-00-00 00:00:00&#8217;, &#8221;);&#8221;);        if (&#036;result != false) {         echo &#8220;<br \/>\nTable &#8216;&#036;tablelinks&#8217; created OK<br \/>\n&#092;n&#8221;;         &#036;got_links = true;     } } else {     echo &#8220;<br \/>\nFound table &#8216;&#036;tablelinks&#8217;, don&#8217;t need to create it&#8230;<br \/>\n&#092;n&#8221;;         &#036;got_links = true; }  if (&#036;got_links &#038;&amp; &#036;got_cats) {     echo &#8220;<br \/>\nLooking for category 1&#8230;<br \/>\n&#092;n&#8221;;     &#036;sql = &#8220;SELECT * FROM &#036;tablelinkcategories WHERE cat_id=1 &#8220;;     &#036;result = mysql_query(&#036;sql) or print (&#8220;Can&#8217;t query &#8216;&#036;tablelinkcategories&#8217;.<br \/>\n&#8221; . &#036;sql . &#8220;<br \/>\n&#8221; . mysql_error());     if (&#036;result != false) {         if (&#036;row = mysql_fetch_object(&#036;result)) {             echo &#8220;<br \/>\nYou have at least 1 category. Good!<br \/>\n&#092;n&#8221;;             &#036;got_row = true;         } else {             echo &#8220;<br \/>\nGonna insert category 1&#8230;<br \/>\n&#092;n&#8221;;             &#036;sql = &#8220;INSERT INTO &#036;tablelinkcategories (cat_id, cat_name) VALUES (1, &#8216;General&#8217;)&#8221;;             &#036;result = mysql_query(&#036;sql) or print (&#8220;Can&#8217;t query insert category.<br \/>\n&#8221; . &#036;sql . &#8220;<br \/>\n&#8221; . mysql_error());             if (&#036;result != false) {                 echo &#8220;<br \/>\nInserted category Ok<br \/>\n&#092;n&#8221;;                 &#036;got_row = true;             }         }     } }  if (&#036;got_row) {     echo &#8220;<br \/>\nAll done!<br \/>\n&#092;n&#8221;; } ?&gt;<br \/>\nDid you defeat the boss monster at the end? Great! You\u2019re ready for Step    2.<\/p>\n","protected":false},"template":"","class_list":["post-23256","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/23256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/23256\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=23256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}