Support » Installing WordPress » “wp_usermeta: Table ‘duanerf.wp_usermeta’ doesn’t exist” Why?

  • Resolved renaudfra

    (@renaudfra)


    Hi everyone,

    I downloaded WP2.9.2 to create a new blog but there is a problem when I install it.
    When it tries to repair the database, I get the tag below:

    wp_usermeta: Table ‘duanerf.wp_usermeta’ doesn’t exist

    URL : duanerf.free.fr
    Hosting : Free.fr
    WP version : 2.9.1

    Anyone has an idea how to fix it?

    Thanks

    Francois

Viewing 15 replies - 1 through 15 (of 18 total)
  • Does the install create the other WordPress tables?

    My first reaction is that the database user doesn’t have all privileges so review Installing WordPress.

    Thread Starter renaudfra

    (@renaudfra)

    Hi, thanks for your reply!

    all other tables are created (10 in total) and diagnostic is OK.

    So it looks specific to wp_usermeta .

    Below is a copy of the page I get after database repair:

    The wp_users table is okay.

    The wp_usermeta table is not okay. It is reporting the following error: Table ‘duanerf.wp_usermeta’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_usermeta table. Error: Table ‘duanerf.wp_usermeta’ doesn’t exist

    The wp_posts table is okay.

    The wp_comments table is okay.

    The wp_links table is okay.

    The wp_options table is okay.

    The wp_postmeta table is okay.

    The wp_terms table is okay.

    The wp_term_taxonomy table is okay.

    The wp_term_relationships table is okay.

    The wp_commentmeta table is okay.

    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

    wp_usermeta: Table ‘duanerf.wp_usermeta’ doesn’t exist

    Thanks
    Francois

    This is the code the install routine uses to create that table. Might try using that in phpMyAdmin to see if it works. Replace the $wpdb-> with your table prefix (e.g. wp_)

    CREATE TABLE $wpdb->postmeta (
      meta_id bigint(20) unsigned NOT NULL auto_increment,
      post_id bigint(20) unsigned NOT NULL default '0',
      meta_key varchar(255) default NULL,
      meta_value longtext,
      PRIMARY KEY  (meta_id),
      KEY post_id (post_id),
      KEY meta_key (meta_key)
    );
    Thread Starter renaudfra

    (@renaudfra)

    It seemed to work (with usermeta instead of postmeta)

    Is it exactly the same code for usermeta? (variables, values)

    Thank

    Sorry:

    CREATE TABLE $wpdb->usermeta (
      umeta_id bigint(20) unsigned NOT NULL auto_increment,
      user_id bigint(20) unsigned NOT NULL default '0',
      meta_key varchar(255) default NULL,
      meta_value longtext,
      PRIMARY KEY  (umeta_id),
      KEY user_id (user_id),
      KEY meta_key (meta_key)
    );

    from wp-admin/includes/schema.php

    Wondering if this is a PHP version problem–try adding to your .htaccess this:

    AddType x-mapp-php5 .php

    Also, can you try installing the english version of WordPress available in the Download tab at the top of this page.

    Salut François,

    Je m’appelle clément, j’ai le même problème que toi, suis une bite en anglais, et accessoirement, en informatique aussi.

    Si tu as un peu de temps, pourrais tu me dire si tu as réussi à résoudre ce problème grâce aux quelques informations ci dessus, et si oui, me résumer en français les manipulations à exécuter?

    Merci beaucoup.

    Hello everyone,

    I installed the last wordpress version on a new free account and got the exact same problem described here.
    Now I followed instructions gave by MichaelH, and it worked about the database but it seems I’m stuck in sort of a loop: when i come back to install.php, wordpress tells me the data base need to be repaired and if I click so, it tells me the db is all fine… So nothing to repair but it won’t launch installation either. Is there a special manipulation whom needs to be done after the database repair?
    Thanks in advance : )

    @jeannedeau: Please post a new topic.

    didierjacquier

    (@didierjacquier)

    @clem 75
    salut ,suis dans le meme cas
    .”wp_usermeta’ doesnt exist…”
    suis vraiment une truffe en informatique …si tu as des infos suis vraiment interessé!
    merci!

    alanp_france

    (@alanp_france)

    I have the same problem. “Free” is my internet provider too.

    I have put AddType x-mapp-php5 .php into .htaccess using Notepad++, but still the same error message…

    Seems to be specific to this internet provider.

    Is this the only line that should be in .htaccess?

    All thoughts gratefully received. Thanks!

    MichaelH

    (@michaelh)

    DROPping the database tables and trying the install again has been the ‘solution’ I’ve seen to the problem.

    wernerb

    (@wernerb)

    For installions at “FREE”, I resolved the problem with the following .htaccess content :

    php 1
    # BEGIN WordPress
    ErrorDocument 404 /index.php
    # END WordPress

    MichaelH

    (@michaelh)

    Great. I’ll mark this resolved and refer to this when others report the problem. Thanks.

Viewing 15 replies - 1 through 15 (of 18 total)
  • The topic ‘“wp_usermeta: Table ‘duanerf.wp_usermeta’ doesn’t exist” Why?’ is closed to new replies.