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

  • mstralka

    (@mstralka)


    14 years, 1 month 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

Viewing 4 replies - 1 through 4 (of 4 total)
  • rune00

    (@rune00)

    14 years, 1 month 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.

    Thread Starter mstralka

    (@mstralka)

    14 years, 1 month 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?

    Thread Starter mstralka

    (@mstralka)

    14 years, 1 month 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.

    rune00

    (@rune00)

    14 years, 1 month 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 🙂

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress Database Error on step 2 of installation with APC (Advanced PHP Cache)’ is closed to new replies.