Posted 2 years ago #
Hi All,
I've installed WP Multisite successfully and added new sites. Now if I go to their dashboards it is my original site's dashboard showing up and I only can visit that, but not the sub sites - their name doesn't show up neither. If I type in the new sub sites' address, this message shows up:
"Error establishing a database connection".
Can you help me?
Teréz
Posted 2 years ago #
And below the "Network Admin" name in Dashboard - My Sites, only the original website's title shows up, no name for the new ones.
Posted 2 years ago #
And when I do database repair I have the following:
wp_9_posts: Table 'usr_web373_1.wp_9_posts' doesn't exist
wp_9_comments: Table 'usr_web373_1.wp_9_comments' doesn't exist
wp_9_links: Table 'usr_web373_1.wp_9_links' doesn't exist
wp_9_options: Table 'usr_web373_1.wp_9_options' doesn't exist
wp_9_postmeta: Table 'usr_web373_1.wp_9_postmeta' doesn't exist
wp_9_terms: Table 'usr_web373_1.wp_9_terms' doesn't exist
wp_9_term_taxonomy: Table 'usr_web373_1.wp_9_term_taxonomy' doesn't exist
wp_9_term_relationships: Table 'usr_web373_1.wp_9_term_relationships' doesn't exist
wp_9_commentmeta: Table 'usr_web373_1.wp_9_commentmeta' doesn't exist
What do I have to do?
Posted 2 years ago #
Then the sites did not actually get their tables created.Check the database to make sure the user has *ALL* permissions and is allowed to execute commands.
Posted 2 years ago #
Here are some mysql commands to run
//replace user with username to see what grants you have
SHOW GRANTS FOR 'user'@'localhost';
//Grant all privs to user (replace user with username) on all tables
GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost';
//Dont forget to flush after granting
FLUSH PRIVILEGES;
Posted 2 years ago #
Hello,
thank you! It sais
#1045 - Access denied for user 'xxx'@'localhost' (using password: YES)
What does it mean?
Posted 2 years ago #
Well, ok, now I got every permissions from my host, recreated the multisite thing, but nothing has changed, and the error message is also the same when I try to repair the databases, only the numbers inside the names are increasing.
wp_10_posts: Table 'usr_web373_1.wp_10_posts' doesn't exist
wp_10_comments: Table 'usr_web373_1.wp_10_comments' doesn't exist
wp_10_links: Table 'usr_web373_1.wp_10_links' doesn't exist
wp_10_options: Table 'usr_web373_1.wp_10_options' doesn't exist
wp_10_postmeta: Table 'usr_web373_1.wp_10_postmeta' doesn't exist
wp_10_terms: Table 'usr_web373_1.wp_10_terms' doesn't exist
wp_10_term_taxonomy: Table 'usr_web373_1.wp_10_term_taxonomy' doesn't exist
wp_10_term_relationships: Table 'usr_web373_1.wp_10_term_relationships' doesn't exist
wp_10_commentmeta: Table 'usr_web373_1.wp_10_commentmeta' doesn't exist
any other ideas?
Posted 2 years ago #
Talk to your webhost again. Tell them you are using multisite and the db user cannot create new tables.
Posted 2 years ago #
Now we reinstalled the whole thing in a new database and it seem to work. (However if I go to http://www.lichtung.tv/uk/wp-admin, it still offers to repair the database).
Posted 2 years ago #
Sorry, it doesn't. Everything's fine by now.
This topic has been closed to new replies.
