Posted 2 years ago #
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
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.
Posted 2 years ago #
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)
);
Posted 2 years ago #
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 .phpAlso, can you try installing the english version of WordPress available in the Download tab at the top of this page.
Posted 2 years ago #
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.
Posted 2 years ago #
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.
Posted 2 years ago #
@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!
Posted 2 years ago #
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!
DROPping the database tables and trying the install again has been the 'solution' I've seen to the problem.
Posted 2 years ago #
For installions at "FREE", I resolved the problem with the following .htaccess content :
php 1
# BEGIN WordPress
ErrorDocument 404 /index.php
# END WordPress
Great. I'll mark this resolved and refer to this when others report the problem. Thanks.
Posted 2 years ago #
I cannot use htaccess on free.
ere is te solution I found on the french wordpress support:
http://www.wordpress-fr.net/support/viewtopic.php?id=34941
and this can help too.
http://wpchannel.com/installer-wordpress-sur-un-serveur-local-avec-easyphp/
Posted 1 year ago #
And the .htaccess solution works for wp 3.0 adn free. fr hosting
Thanks MichaelH
Posted 1 year ago #
I canot succed : to much compliqué. So I pass by the 2.8 version with no problems with db. I'll try "mise à niveau" later to the 3.0.1, and saw...
This topic has been closed to new replies.
