About a year ago I installed a program called MaxBulk Mailer to this website. It corrupted my database and therefore all of my posts. I emailed them what I wrote below and they said that any screw-up by their software affecting wordpress or anything else is not their concern or fault.<\/p>\n
Since that time I have been incredibly busy leading a school. This means that my blog as been completely corrupted for about a year.<\/p>\n
My wordpress is un-accessable up because of an add on:
\nI tried installing MaxBulk Mailer Demo version to see if I liked it (I can\u2019t send more than 20 emails to friends without getting tagged as a spammer.)
\nThe only installation help they offer is here.<\/p>\n
http:\/\/www.maxprog.com\/blog\/?p=106<\/p>\n
It didn\u2019t install correctly so I FTP\u2019d everything and directly edited the necessary files. as per their instructions.
\n1.- Open the lm\/lm_settings.php file with a text editor.\u20282.- Edit the script settings and save (each setting is explained in the file). [1]\u20283.- Upload the \u2018lm\u2019 folder to your FTP server (in your public folder). [2]\u20284.- Use your FTP software to CHMOD the \u2018lm\u2019 folder to 777 (or 775 or 755). [3]\u20285.- Enter the \u2018lm.php\u2019 full URL and your user ID and password to MaxBulk preferences.\u20286.- If you have selected to use mySQL run the script with the \u2018Init\u2019 command:
\nThen I had the program do a proper install. It seemed to work except that it did chmod everything on my entire site to 777. So I had to go back later and undo that problem.
\nWhatever I try I can either get one of the following errors
\n1.
\nError establishing a database connection
\nThis either means that the username and password information in your wp-config.php file is incorrect or we can\u2019t contact the database server at localhost. This could mean your host\u2019s database server is down.
\n\u2022\u00a0\u00a0 \u00a0Are you sure you have the correct username and password?\u00a0\u00a0 -YES
\n\u2022\u00a0\u00a0 \u00a0Are you sure that you have typed the correct hostname?\u00a0 -YES
\n\u2022\u00a0\u00a0 \u00a0Are you sure that the database server is running?\u00a0 -Yes (even after I run a repair it still doesn\u2019t work.)
\nIf you\u2019re unsure what these terms mean you should probably contact your host.
\n2.
\nInternal Server Error
\nThe server encountered an internal error or misconfiguration and was unable to complete your request.
\nPlease contact the server administrator, webmaster@sanborns.org and inform them of the time the error occurred, and anything you might have done that may have caused the error.
\nMore information about this error may be available in the server error log.
\nAdditionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
\nApache mod_fcgid\/2.3.5 mod_auth_passthrough\/2.1 mod_bwlimited\/1.4 FrontPage\/5.0.2.2635 Server at www.sanborns.org Port 80
\n\u2014\u2014\u2014\u2014
\nI\u2019ve tried rebuilding the SQL DATABASE: it said it was successful
\nI tried deleting\u00a0 .htaccess and wp-config.php and starting over. Nothing.
\nI tried installing a parallel version of WordPress: It works but of course my data isn\u2019t there. (yet).
\nI checked and all of my data is still completely intact in the SQL database.
\nso-I might make a copy and replace the data on my parallel version.
\n\u2014\u2014\u2014-
\nDetermining the cause to \u2018Error establishing a database connection\u2019 or similar error
\nThis error suggests WordPress cannot connect to your database. Check the below settings in your wp-config.php and verify they are correct:
\n\u2022\u00a0\u00a0 \u00a0Database name \u2013 correct
\n\u2022\u00a0\u00a0 \u00a0username- correct
\n\u2022\u00a0\u00a0 \u00a0password- correct
\n\u2022\u00a0\u00a0 \u00a0host-I use gator hosting and their website says that they use localhost.
\n\u2022
\nThe most common mistake is the wrong host. The host by default is set to localhost, but many hosting companies require a server name for this value. A typical search on any search engine like \u201cwordpress [your webhosts name] host\u201d will return an FAQ or forum article detailing where to find that information for your particular host.
\n\u2014\u2014
\nThere is also a MySQL connection and selection test script which can be retrieved from http:\/\/gist.github.com\/162913.txt. copy the contents of that link into a file called wp-mysql-test.php and place it in the same directory as wp-config.php. It can be called from a web browser or executed from the command line.
\n-note: do not copy this straight into a text editor or you will get errors. When I copied it straight into Dreamweaver it saved perfectly.
\n-when run this error came up
\nCould not connect: Access denied for user \u2018user\u2019@’localhost\u2019 (using password: YES)<\/p>\n
I changed to a new user and got this message
\nConnected successfully
\nDB selected successfully
\n\u2014-
\nthen tried to re-access my blog: Error 500: Internal Server Error
\ndid another repair database
\nMySQL Databases<\/p>\n
Repairing Database
\nsanborns_wordpress is now being repaired.
\nsanborns_wordpress.wp_commentmeta\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_comments\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_contact_form_7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_links\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_options\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_postmeta\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_posts\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_term_relationships\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_term_taxonomy\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_terms\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_usermeta\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nsanborns_wordpress.wp_users\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\n\u2014-
\n– Same errors as before.
\nSo \u2013 what now. The data is all there. I suppose I have to
\n1. backup the database.
\n2. Move it to my computer
\n3. FTP it back to the new\/empty wordpress
\n4. change all the links on my website.
\n\u2014-
\nBut- if there was any way to truly repair this database error that would make me much happier as the solution I just mentioned would be complex and not solve all my problems.
\n– ANY IDEAS?<\/p>\n","protected":false},"excerpt":{"rendered":"
About a year ago I installed a program called MaxBulk Mailer to this website. It corrupted my database and therefore all of my posts. I emailed them what I wrote below and they said that any screw-up by their software affecting wordpress or anything else is not their concern or fault. Since that time I […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[11],"tags":[],"class_list":["post-14","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/sanborns.org\/word_press\/wp-json\/wp\/v2\/posts\/14","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sanborns.org\/word_press\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sanborns.org\/word_press\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sanborns.org\/word_press\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sanborns.org\/word_press\/wp-json\/wp\/v2\/comments?post=14"}],"version-history":[{"count":3,"href":"https:\/\/sanborns.org\/word_press\/wp-json\/wp\/v2\/posts\/14\/revisions"}],"predecessor-version":[{"id":60,"href":"https:\/\/sanborns.org\/word_press\/wp-json\/wp\/v2\/posts\/14\/revisions\/60"}],"wp:attachment":[{"href":"https:\/\/sanborns.org\/word_press\/wp-json\/wp\/v2\/media?parent=14"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sanborns.org\/word_press\/wp-json\/wp\/v2\/categories?post=14"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sanborns.org\/word_press\/wp-json\/wp\/v2\/tags?post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}