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 have been incredibly busy leading a school. This means that my blog as been completely corrupted for about a year.
My wordpress is un-accessable up because of an add on:
I tried installing MaxBulk Mailer Demo version to see if I liked it (I can’t send more than 20 emails to friends without getting tagged as a spammer.)
The only installation help they offer is here.
http://www.maxprog.com/blog/?p=106
It didn’t install correctly so I FTP’d everything and directly edited the necessary files. as per their instructions.
1.- Open the lm/lm_settings.php file with a text editor.
2.- Edit the script settings and save (each setting is explained in the file). [1]
3.- Upload the ‘lm’ folder to your FTP server (in your public folder). [2]
4.- Use your FTP software to CHMOD the ‘lm’ folder to 777 (or 775 or 755). [3]
5.- Enter the ‘lm.php’ full URL and your user ID and password to MaxBulk preferences.
6.- If you have selected to use mySQL run the script with the ‘Init’ command:
Then 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.
Whatever I try I can either get one of the following errors
1.
Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost. This could mean your host’s database server is down.
• Are you sure you have the correct username and password? -YES
• Are you sure that you have typed the correct hostname? -YES
• Are you sure that the database server is running? -Yes (even after I run a repair it still doesn’t work.)
If you’re unsure what these terms mean you should probably contact your host.
2.
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please 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.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache 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
————
I’ve tried rebuilding the SQL DATABASE: it said it was successful
I tried deleting .htaccess and wp-config.php and starting over. Nothing.
I tried installing a parallel version of WordPress: It works but of course my data isn’t there. (yet).
I checked and all of my data is still completely intact in the SQL database.
so-I might make a copy and replace the data on my parallel version.
———-
Determining the cause to ‘Error establishing a database connection’ or similar error
This error suggests WordPress cannot connect to your database. Check the below settings in your wp-config.php and verify they are correct:
• Database name – correct
• username- correct
• password- correct
• host-I use gator hosting and their website says that they use localhost.
•
The 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 “wordpress [your webhosts name] host” will return an FAQ or forum article detailing where to find that information for your particular host.
——
There 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.
-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.
-when run this error came up
Could not connect: Access denied for user ‘user’@’localhost’ (using password: YES)
I changed to a new user and got this message
Connected successfully
DB selected successfully
—-
then tried to re-access my blog: Error 500: Internal Server Error
did another repair database
MySQL Databases
Repairing Database
sanborns_wordpress is now being repaired.
sanborns_wordpress.wp_commentmeta OK
sanborns_wordpress.wp_comments OK
sanborns_wordpress.wp_contact_form_7 OK
sanborns_wordpress.wp_links OK
sanborns_wordpress.wp_options OK
sanborns_wordpress.wp_postmeta OK
sanborns_wordpress.wp_posts OK
sanborns_wordpress.wp_term_relationships OK
sanborns_wordpress.wp_term_taxonomy OK
sanborns_wordpress.wp_terms OK
sanborns_wordpress.wp_usermeta OK
sanborns_wordpress.wp_users OK
—-
– Same errors as before.
So – what now. The data is all there. I suppose I have to
1. backup the database.
2. Move it to my computer
3. FTP it back to the new/empty wordpress
4. change all the links on my website.
—-
But- 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.
– ANY IDEAS?