Fehler beim Aufbau einer Datenbankverbindung

ensylol · 26. September 2014

Hallo,

von heute auf Morgen bekomme ich nun die Meldung: [h=1]Fehler beim Aufbau einer Datenbankverbindung[/h]Ich wüsste nicht was jetzt das Problem ist. Ich habe nichts verändert oder sonstiges.
Der Befehlt für automatisches Repair funktioniert nicht.

Kann mir jemand helfen? Könnte Datenbank Login durchgeben.
Steckt ziemlich viel zeit in Seite.

Vielen Dank im voraus.

Putzlowitsch · 26. September 2014

Vielleicht gibt es beim Webhoster z.Z. Probleme mit dem Datenbank-Server. Sowas soll auch vorkommen.

Gruß
Ingo

ensylol · 26. September 2014

Ne hab ich gefragt, bei Aufrufen der Repair.php

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]SELECT option_value FROM wp_options WHERE option_name = 'siteurl' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'home' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'active_plugins' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'hack_file' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'blog_charset' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'permalink_structure' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'wp_user_roles' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'template' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'stylesheet' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'category_base' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'tag_base' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'link_manager_enabled' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'sidebars_widgets' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_pages' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_calendar' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_archives' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_links' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_meta' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_search' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_text' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_categories' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_recent-posts' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_recent_entries' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_recent-comments' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_recent_comments' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_rss' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_tag_cloud' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'widget_nav_menu' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'use_smilies' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'cron' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1411723555;a:1:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1411723555;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1411723555;a:1:{s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'timezone_string' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
SELECT option_value FROM wp_options WHERE option_name = 'gmt_offset' LIMIT 1

WordPress database error: [Table 'db195680x2111506.wp_options' doesn't exist]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1411759740;a:1:{s:20:\"wp_maybe_auto_update\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload`

Klicke in dieses Feld, um es in vollständiger Größe anzuzeigen.

ensylol · 26. September 2014

nach versuchen die Repair aufzuführen, hilft er leider nicht.
Folgendes spuckt er dann aus:

wp_users: Table 'db195680x2111506.wp_users' doesn't exist
wp_usermeta: Table 'db195680x2111506.wp_usermeta' doesn't exist
wp_posts: Table 'db195680x2111506.wp_posts' doesn't exist
wp_links: Table 'db195680x2111506.wp_links' doesn't exist
wp_options: Table 'db195680x2111506.wp_options' doesn't exist
wp_postmeta: Table 'db195680x2111506.wp_postmeta' doesn't exist
wp_terms: Table 'db195680x2111506.wp_terms' doesn't exist
wp_term_taxonomy: Table 'db195680x2111506.wp_term_taxonomy' doesn't exist
wp_term_relationships: Table 'db195680x2111506.wp_term_relationships' doesn't exist

Ich verstehe das ganze nicht. Warum das auf einmal kommt.

Fsb311 · 27. September 2014

Hast Du root Zugriff auf den Server ? Wenn ja, dann logge Dich per FTP ein und gehe zu /var/Lib/MySQL/ dort findest Du eine Datei MySQL.sok diese hat 0 Bytes. Die löschenund das Problem hat sich erledigt. Auf meinem Server klappt das. Mein OS auf dem Server ist ein CentOS 6.

Fsb311 · 27. September 2014

Manchmal hilft es auch den Server bzw. den Dienst httpd neu zu Starten.

ensylol · 28. September 2014

Hi,

danke erst einmal für die Lösung, hab leider kein root Zugriff auf dem Server.

Hille · 28. September 2014

Die Fehlermeldung ist aber eindeutig, es fehlen einige Tabellen, warum auch immer. Am besten ein datenbank Backup einspielen.

ensylol · 29. September 2014

Habe kein Datenbank Backup
Bekommt man das irgendiwe trotzdem hin?

maxe · 29. September 2014

stimmen denn die Daten in der wp-config.php zur Datenbank?

WPDE.org

Fehler beim Aufbau einer Datenbankverbindung

ensylol Member

Putzlowitsch Well-Known Member

ensylol Member

ensylol Member

Fsb311 Well-Known Member

Fsb311 Well-Known Member

ensylol Member

Hille Well-Known Member

ensylol Member

maxe Well-Known Member
Ehrenmitglied

Nützliche Suchen

Fehler beim Aufbau einer Datenbankverbindung

ensylol Member

Putzlowitsch Well-Known Member

ensylol Member

ensylol Member

Fsb311 Well-Known Member

Fsb311 Well-Known Member

ensylol Member

Hille Well-Known Member

ensylol Member

maxe Well-Known Member Ehrenmitglied

maxe Well-Known Member
Ehrenmitglied