Error Message While Trying to Import Backup Files

  • themamalist

    (@themamalist)


    16 years, 9 months ago

    My site was hacked and shut down and I’m now trying to import my backup files onto my new server but I keep getting this error message:

    Error
    SQL query:
    — — Dumping data for table wp_comments — INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id, comment_subscribe) VALUES (3, 8, ‘Abbie’, ‘abbie@gmail.com’, ”, ‘70.137.149.33’, ‘2009-02-12 10:44:11’, ‘2009-02-12 18:44:11’, ‘This is really a great list. I wish I had something like this when our DS was born last year. Thanks!’, 0, ‘1’, ‘Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.0.6) Gecko/2009011913 Firefox/3.0.6’, ”, 0, 0, ‘N’), (4, 8, ‘Rema’, ‘remachazbek@yahoo.com’, ”, ‘75.2.138.123’, ‘2009-02-18 22:16:34’, ‘2009-02-19 06:16:34’, ‘Great list! I went to my registry and added a few new items. Thanks!’, 0, ‘1’, ‘Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; (R1 1.5); .NET CLR 1.1.4322; .NET CLR 2.0.50727)’, ”, 0[…]

    MySQL said: #1054 – Unknown column ‘comment_subscribe’ in ‘field list’

    I was told that it may be because I hadn’t downloaded the comments plugin on my new wordpress account so i added the Akismet plugin and I’m still getting the same error message.

    Any ideas?

    Thank you!

Viewing 13 replies - 1 through 13 (of 13 total)
  • esmi

    (@esmi)

    16 years, 9 months ago

    Have you installed and activated the comment subscribe plugin that you seem to have been using previously?

    jon

    (@adiant)

    16 years, 9 months ago

    I’m not trying to be picky, but you said you downloaded the plug-in. Did you activate it?

    Plug-ins add their database table columns/fields as part of the activation/installation process.

    Sorry for the duplicate. I started writing mine before the one above was posted.

    Thread Starter themamalist

    (@themamalist)

    16 years, 9 months ago

    I actually had a few different comment plugins that were on my old blog like comment luv (which apparently is no longer available), and one that had something to do with replying to a thread that I can’t remember the name of, and I think there was another one that let you edit your comments.

    Yes, I did activate the Akismet plugin I installed by entering my API key.

    jon

    (@adiant)

    16 years, 9 months ago

    I just did some Googling and discovered that the comment_subscribe column/field is added by the Subscribe to Comments plug-in.

    Thread Starter themamalist

    (@themamalist)

    16 years, 9 months ago

    I was able to find commentluv along with most of the other comment plugins I had on my old site. I downloaded and activated them and I’m still getting the error message.

    When I download a plugin is it automatically reflected on the server? Because I’m looking at phpMyAdmin and it looks exactly the same with the same number of files as before I added these 5 or so plugins.

    Is there anything else I should try?

    Thank you!

    jon

    (@adiant)

    16 years, 9 months ago

    Plug-ins have to be activated, not just downloaded, before they will change the database.

    A little more reading says the Subscribe to Comments plug-in has not been tested on any version of WordPress after 2.3.1, and there are reports of people not being able to get it working, so I wouldn’t plan to use it longer than necessary to get your database restored.

    The original problem won’t go away until you can see, with phpMyAdmin, column/field “comment_subscribe” in table “wp_comments”.

    Brian Harris

    (@zgani)

    16 years, 9 months ago

    If you were using the edit comment by Andrew Sutherland the its available through your admin>>plugins>>add new in the search box type edit comment and its the first one in the list.

    As for the reply to comment I dont know if its the same, I use the WP comment remix available at http://wordpress.org/extend/plugins/wp-comment-remix/

    When you activate a plug in the setup creats a table or field in the database.

    Thread Starter themamalist

    (@themamalist)

    16 years, 9 months ago

    All of my plugins have been downloading AND activated.

    I just downloaded and activated Subscribe to Comments even though it says it hasn’t been tested with my version of WP.

    I checked out “wp_comments” in phpMyAdmin and i do see “comment_subscribe” on the last line.

    I’m now getting a new error message as follows:

    Error

    SQL query:

    — — Dumping data for table wp_comments — INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id, comment_subscribe) VALUES (3, 8, ‘Abbie’, ‘abbie@gmail.com’, ”, ‘70.137.149.33’, ‘2009-02-12 10:44:11’, ‘2009-02-12 18:44:11’, ‘This is really a great list. I wish I had something like this when our DS was born last year. Thanks!’, 0, ‘1’, ‘Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.0.6) Gecko/2009011913 Firefox/3.0.6’, ”, 0, 0, ‘N’), (4, 8, ‘Rema’, ‘remachazbek@yahoo.com’, ”, ‘75.2.138.123’, ‘2009-02-18 22:16:34’, ‘2009-02-19 06:16:34’, ‘Great list! I went to my registry and added a few new items. Thanks!’, 0, ‘1’, ‘Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; (R1 1.5); .NET CLR 1.1.4322; .NET CLR 2.0.50727)’, ”, 0[…]

    MySQL said: Documentation
    #1062 – Duplicate entry ‘3’ for key 1

    Thoughts?

    esmi

    (@esmi)

    16 years, 9 months ago

    Have you got 2 comments with identical ids?

    Thread Starter themamalist

    (@themamalist)

    16 years, 9 months ago

    How would I find this out?

    Thread Starter themamalist

    (@themamalist)

    16 years, 9 months ago

    I know there have been people that have made more than one comment – is that what you mean by identical ids?

    jon

    (@adiant)

    16 years, 9 months ago

    No, comment_ID is just a unique number assigned to the post, and has nothing to do with the author.

    This sounds to me like the table has already been at least partially loaded, and you are trying to re-load it.

    Before you do the Restore of the database, make sure (with phpMyAdmin) that the table wp_comments is empty: has no rows in it. If necessary, use phpMyAdmin to delete the existing rows.

    For the record, any database backups I’ve done on the two web hosts that I’ve used, automatically empty the table before loading it. In fact, they re-define the table, completely avoiding the “missing fields/columns” problem that you experienced at the outset.

    Thread Starter themamalist

    (@themamalist)

    16 years, 9 months ago

    Thanks everyone for your help. I was able to import a backed up file from WordPress but when I went to my domain it still said “Reported Attack Site.” So i think i just have to accept that i cannot use any of my backed up files and i have to start over.

    thanks again for taking the time to help me.

Viewing 13 replies - 1 through 13 (of 13 total)

The topic ‘Error Message While Trying to Import Backup Files’ is closed to new replies.