WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Database Error on step 2 of installation with APC (Advanced PHP Cache) (5 posts)

  1. mstralka
    Member
    Posted 4 years ago #

    WordPress 2.9.2 (it wasn't an option in the dropdown)
    Mac OS X 10.6
    PHP 5.3
    Mysql 5.088 - local, not using MAMP

    Database name: wordpress_site
    Database user: wordpress
    Database Permissions: all

    When I try to install WordPress on my Mac, I get the following error on step 2 of the installation process:

    WordPress database error: [ $db->get_row(string query, output type, int offset) -- Output type must be one of: OBJECT, ARRAY_A, ARRAY_N]
    SELECT * FROM wp_users WHERE ID = 1 LIMIT 1
    
    WordPress database error: [ $db->get_row(string query, output type, int offset) -- Output type must be one of: OBJECT, ARRAY_A, ARRAY_N]
    SELECT * FROM wp_users WHERE ID = 1 LIMIT 1
    
    WordPress database error: [ $db->get_row(string query, output type, int offset) -- Output type must be one of: OBJECT, ARRAY_A, ARRAY_N]
    SELECT * FROM wp_usermeta WHERE user_id = 0 AND meta_key = ''
    
    WordPress database error: [ $db->get_row(string query, output type, int offset) -- Output type must be one of: OBJECT, ARRAY_A, ARRAY_N]
    SELECT * FROM wp_users WHERE ID = 1 LIMIT 1

    Below that it says installation was successful and gives the password. When I try to login to the admin, the Apache error_log has similar errors and the page renders blank.

    The error message is being printed from method "get_row" in wp-db.php (line 888)

    Thanks

  2. rune00
    Member
    Posted 4 years ago #

    I got the same error im my Apache log. The error seems to cause issues with both backend and frontend - sometimes the page returns blank, sometimes mysql errors are returned.

  3. mstralka
    Member
    Posted 4 years ago #

    I'm seeing the same kind of errors. I even installed WP on a linux server and then imported the database to my Mac. Then I see the same problemsRune00 is experiencing. Rune00 are you on a Mac too?

  4. mstralka
    Member
    Posted 4 years ago #

    I was able to isolate the cause of the problem on my system, although I'm not sure why it's an issue. I have APC (Advanced PHP Cache) configured in my php.ini file. When I disable it, WordPress works fine again.

    Here were my APC settings in php.ini:

    ;Advanced PHP Cache (APC) - Kazaam
    extension = apc.so
    apc.enabled=1
    apc.shm_size=30

    I disabled apc by changing apc.enabled=0 and restarted Apache. I need to figure out why APC caused this problem because I need APC for other projects.

  5. rune00
    Member
    Posted 4 years ago #

    I did the exact same thing. Installed on Linux and exported db to set up on my Mac.

    I disabled APC on my server and it seems to be fixed.

    Pretty weird bug however.

    Thanks :)

Topic Closed

This topic has been closed to new replies.

About this Topic