WordPress.org

Ready to get started?Download WordPress

Forums

MaxBulk Mailer corrupted my database-PLEASE HELP ME (1 post)

  1. sanborns_sean
    Member
    Posted 4 years ago #

    My wordpress is screwed 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.
    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? -I think so......
    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 http://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 'sanborns_sean'@'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. (I sent out HTML newsletter emails with links in them to my blog).
    - ANY IDEAS?
    -Sean

Topic Closed

This topic has been closed to new replies.

About this Topic