• Ok, I am trying to set up wp on a
    FreeBSD 4.9
    with PHP 4.3.3 (With Zend Optimizer 2.1.0) and Apache and MySQL 4.1.1
    The installation went ok until it had to reach step 3. It took ages to load the page, when once it started to load it only loaded the first lines:
    ****************************************
    <h1 id=”logo”><span>WordPress</span></h1>
    <h1>Step 3</h1>
    *******************************************
    Then nothing. Of course then I did not have my password so I had no way to enter as Admin. In any case, just to see I went to http://www.mysite.com/blog where the blog is supposed to reside. What I got was an error:
    **************************************
    Database error: [Table ‘ourpieee_psblog.wp_post2cat’ doesn’t exist]
    SELECT DISTINCT ID, category_id, cat_name, category_nicename, category_description, category_parent FROM wp_categories, wp_post2cat, wp_posts WHERE category_id = cat_ID AND post_id = ID AND post_id IN (1)
    Warning: Invalid argument supplied for foreach() in /home/ourpieee/public_html/blog/wp-blog-header.php on line 478
    *********************************
    Under that the entry hello world but before the content it said:
    ***********************************
    Filed under:
    Database error: [Table ‘ourpieee_psblog.wp_post2cat’ doesn’t exist]
    SELECT category_id, cat_name, category_nicename, category_description, category_parent FROM wp_categories, wp_post2cat WHERE wp_post2cat.category_id = cat_ID AND wp_post2cat.post_id = 1
    Warning: Invalid argument supplied for foreach() in /home/ourpieee/public_html/blog/wp-includes/template-functions-category.php on line 65
    � site admin @ 6:01 pm
    **************************************
    to explain, ourpieee is my name according to by host, and public_html is where all the files are.
    Under the categories also there were errors, just after the title and before the ‘no category’ text:
    ******************************************
    Database error: [Table ‘ourpieee_psblog.wp_post2cat’ doesn’t exist]
    SELECT cat_ID, COUNT(wp_post2cat.post_id) AS cat_count FROM wp_categories INNER JOIN wp_post2cat ON (cat_ID = category_id) INNER JOIN wp_posts ON (ID = post_id) WHERE post_status = ‘publish’ GROUP BY category_id
    Warning: Invalid argument supplied for foreach() in /home/ourpieee/public_html/blog/wp-includes/template-functions-category.php on line 304
    ***************************************
    I went to the install.php to see if I could unbandle the mess, but I just reached the conclusion that the error was somwhere there. Anybody can give me a help?
    Many thanks,
    Pietro

Viewing 7 replies - 1 through 7 (of 7 total)
  • For blank install, linux installation, php and mysql option on install problems, the following threads may be useful:
    http://wordpress.org/support/2/4213
    http://wordpress.org/support/2/9550
    http://wordpress.org/support/2/11556
    might help.
    Please search, using google, and different search strings. It is not always easy to find the answer, but we are working on it.

    Thread Starter pietros

    (@pietros)

    Somehow I managed to get it nearly running. When he asked me his address, instead of giving him the default (which also was, as far as I was concerned the right one) I told him he was on http://www.mysite.com/~ourpieee/blog which with other programs for the same host what was it needed. Go figure why. In any case he then entered full strength in step 3 and gave me a whole page of errors (better than silence!) ending with
    setup succesful!! (then why those errors?)
    Your password is…
    When I entered then I discovered that the setup HAD NOT BEEN SUCESSFUL.
    Database error: [Table ‘ourpieee_psblog.wp_post2cat’ doesn’t exist]
    SELECT category_id, cat_name, category_nicename, category_description, category_parent FROM wp_categories, wp_post2cat WHERE wp_post2cat.category_id = cat_ID AND wp_post2cat.post_id = 2
    This message appeared pretty much every time something had to work with posts and categories. So… is it a bug in the released version (and why did this happen only to me), or is my system buggy? Other errors that appear:
    Warning: Invalid argument supplied for foreach() in /home/ourpieee/public_html/blog/wp-includes/template-functions-category.php on line 65
    � site admin @ 4:46 pm
    and the following appears at the beginning of the whole page.
    Database error: [Table ‘ourpieee_psblog.wp_post2cat’ doesn’t exist]
    SELECT DISTINCT ID, category_id, cat_name, category_nicename, category_description, category_parent FROM wp_categories, wp_post2cat, wp_posts WHERE category_id = cat_ID AND post_id = ID AND post_id IN (1,4,3,2)
    Warning: Invalid argument supplied for foreach() in /home/ourpieee/public_html/blog/wp-blog-header.php on line 478
    hmmmmmmmmmmmmmmmmm
    Pietro
    P.S. I looked at those threads, but they seem to have different kind of errors.

    I had the same problem.
    Did you configure something in your wp-config.php ?
    Check all…
    DB password and so on, and look also the language parameters.
    You must have empty cotes (”) in it for a proper install.
    I had put in (fr) and my install never works…
    I leave the fr and… youpiiiii !
    With WP, i think the best to do is to install first, and customize AFTER.

    Thread Starter pietros

    (@pietros)

    Thanks Daniel, the config is fine. The info about the database are fine or else it would not be able to connect and create the tables, which for the most it does. The language is actually empty:
    define (‘WPLANG’, ”);
    and the table prefix is the default:
    $table_prefix = ‘wp_’;
    Honestly I think is a bug in the install that does not define any wp_post2cat table. Infact in the install version there is not a single occcurrance of post2cat. And the only create table with post2cat I could find was in the upgrade_function file. In short they forgot to permit to new user to have a post2cat. Either I find a past version and then upgrade or I’ll have to learn php really quick!
    Thanks for your help in any case.
    Pietro
    Quite a trivial bug I suppose, and I also suppose that you can upgrade ok from a previous version to this version.

    i have this exact same problem. freebsd 5.3 php5 mysql4.1 apache2…

    I don’t get an admin password either.
    So instead I created a user and copied the password from the user to admin in wp_users.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Unable to complete Step 3’ is closed to new replies.