{"id":2864,"date":"2019-07-19T23:27:57","date_gmt":"2019-07-19T23:27:57","guid":{"rendered":"http:\/\/cocoalopez.com\/blog\/?p=2864"},"modified":"2019-07-19T23:28:11","modified_gmt":"2019-07-19T23:28:11","slug":"wp-how-to-fix-database-connection-error","status":"publish","type":"post","link":"https:\/\/cocoalopez.com\/blog\/?p=2864","title":{"rendered":"WP How to fix “Error establishing a database connection”"},"content":{"rendered":"\n

If you get the following error “Error establishing a database connection”<\/p>\n\n\n\n

  1. Modify your wp-config.php and add the following line:
    define(‘WP_ALLOW_REPAIR’, true);<\/li>
  2. Reload your website, usually under “wp-admin\/maint\/repair.php?”<\/li>
  3. If the repairs didn’t go through and still get this message
    ” Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums<\/a> to get additional assistance. “<\/li>
  4. Go to phpMyAdmin
    (1) Log in to your phpMyAdmin or connect to it via your web hosting (cPanel?) backend.
    (2) Select the database with the crashed table.
    (3) Put a checkmark next to each crashed table.
    (4) Select \u201cRepair table\u201d from the \u201cWith selected:\u201d drop down at the bottom of the list. <\/li>
  5. Reload website (it should work now)

    More info on:     https:\/\/wordpress.org\/support\/topic\/wp_options-table-is-marked-as-crashed-and-last-repair-failed-10\/<\/a><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"

    If you get the following error “Error establishing a database connection” Modify your wp-config.php and add the following line:define(‘WP_ALLOW_REPAIR’, true); Reload your website, usually under “wp-admin\/maint\/repair.php?” If the repairs didn’t go through and still get this message ” Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress […]<\/p>\n","protected":false},"author":1,"featured_media":2867,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[31],"tags":[],"class_list":["post-2864","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips-y-tutoriales"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2019\/07\/wp-how-to-fix-error-establishing-a-database-connection.png?fit=829%2C474&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9XJix-Kc","jetpack-related-posts":[{"id":2680,"url":"https:\/\/cocoalopez.com\/blog\/?p=2680","url_meta":{"origin":2864,"position":0},"title":"No connection to NextCloud. Operation Canceled windows client","author":"cgmodeler","date":"May 7, 2018","format":false,"excerpt":"Cuando el nextlcoud no se conecta y arroja el siguiente error: \"No connection to NextCloud. Operation Canceled windows client Una de las causas probables es el cambio de contrase\u00f1as en el cliente de windows, al tratar de hacer login y recibir el password erroneo un cierto n\u00famero de veces, el\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/05\/no-connection-to-nextcloud-operation-canceled-windows-client.png?fit=420%2C420&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2654,"url":"https:\/\/cocoalopez.com\/blog\/?p=2654","url_meta":{"origin":2864,"position":1},"title":"Nextcloud file locked cannot sync","author":"cgmodeler","date":"April 14, 2018","format":false,"excerpt":"Cuando los archivos se bloquean al sincronizarse. Entrar al Phpmyadmin Seleccionar la tabla \"oc_file_locks\" Hacer click en el tab SQL Poner el siguiente comando. SELECT * FROM `oc_file_locks` WHERE 1; DELETE FROM oc_file_locks WHERE 1; Darle click en GO Esperar a que se borren los archivos en el cliente.","rel":"","context":"In "Tips y Tutoriales"","block_context":{"text":"Tips y Tutoriales","link":"https:\/\/cocoalopez.com\/blog\/?cat=31"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/04\/nextcloud-file-locked-cannot-sync.png?fit=709%2C586&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/04\/nextcloud-file-locked-cannot-sync.png?fit=709%2C586&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/04\/nextcloud-file-locked-cannot-sync.png?fit=709%2C586&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2018\/04\/nextcloud-file-locked-cannot-sync.png?fit=709%2C586&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":3034,"url":"https:\/\/cocoalopez.com\/blog\/?p=3034","url_meta":{"origin":2864,"position":2},"title":"Arduino MKR1000 – Iot Update Firmware First time setup","author":"cgmodeler","date":"March 19, 2021","format":false,"excerpt":"So you bought an Arduino MKR1000 and would like to quick start making some experiments, unfortunatedly it's no so quick since it seems that the firmware that the boards use is so outdated that even Iot Arduino Cloud service cannot detect them and throws the following error after trying the\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2021\/03\/image-6.png?fit=624%2C708&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2021\/03\/image-6.png?fit=624%2C708&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2021\/03\/image-6.png?fit=624%2C708&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":4178,"url":"https:\/\/cocoalopez.com\/blog\/?p=4178","url_meta":{"origin":2864,"position":3},"title":"Maya and Pyserial fix on Windows","author":"cgmodeler","date":"July 19, 2023","format":false,"excerpt":"Well, I was having issues getting pyserial and Maya to run for serial communications using python. I was getting the error \"Error: No module named serial\" The solution: Make sure that pyserial is installed, if not type the following on any command (CMD) window python -m pip install pyserial After\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2017\/02\/Honeyview_2017-02-26_20-10-11.png?fit=1200%2C591&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2017\/02\/Honeyview_2017-02-26_20-10-11.png?fit=1200%2C591&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2017\/02\/Honeyview_2017-02-26_20-10-11.png?fit=1200%2C591&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2017\/02\/Honeyview_2017-02-26_20-10-11.png?fit=1200%2C591&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2017\/02\/Honeyview_2017-02-26_20-10-11.png?fit=1200%2C591&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":3859,"url":"https:\/\/cocoalopez.com\/blog\/?p=3859","url_meta":{"origin":2864,"position":4},"title":"Ways to fix your ping","author":"cgmodeler","date":"December 30, 2022","format":false,"excerpt":"Best Ways to Fix Ping Spikes on Windows 10\/11 Taken from auslogics Contents How to Fix Ping Spikes in Wi-FiHow to Get Rid of Ping Spikes in Windows 11 and 10Ping Spikes: Fix the Problem With the Best SolutionsBest Solution 1: Run TroubleshooterBest Solution 2: Registry ModificationBest Solution 3: Adopt\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/ways-to-fix-your-ping.jpg?fit=1200%2C754&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/ways-to-fix-your-ping.jpg?fit=1200%2C754&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/ways-to-fix-your-ping.jpg?fit=1200%2C754&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/ways-to-fix-your-ping.jpg?fit=1200%2C754&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2022\/12\/ways-to-fix-your-ping.jpg?fit=1200%2C754&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":3158,"url":"https:\/\/cocoalopez.com\/blog\/?p=3158","url_meta":{"origin":2864,"position":5},"title":"Dual Boot & Windows 10 \/7 on HP Z800","author":"cgmodeler","date":"May 7, 2021","format":false,"excerpt":"And I still refuse to update from Windows 7 to Windows 10 however certain applications are just running now on Windows 10, even some Wifi PCi cards do the same so for the time being I want to have a dual boot Windows 7 + Windows 10 machine. So lets\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/cocoalopez.com\/blog\/?cat=1002"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cocoalopez.com\/blog\/wp-content\/uploads\/2021\/05\/image-1.png?fit=504%2C549&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2864"}],"version-history":[{"count":2,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2864\/revisions"}],"predecessor-version":[{"id":2866,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2864\/revisions\/2866"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/2867"}],"wp:attachment":[{"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cocoalopez.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}