Results 1 to 2 of 2

Error with mysql replication - one specific vbseo table

This is a discussion on Error with mysql replication - one specific vbseo table within the Troubleshooting forums, part of the vBSEO SEO Plugin category; Hi Guys, We are running mySQL slave replication on our servers and our slave breaks connection due to an error ...

  1. #1
    Member
    Join Date
    Oct 2005
    Posts
    49
    Liked
    1 times

    Error with mysql replication - one specific vbseo table

    Hi Guys,

    We are running mySQL slave replication on our servers and our slave breaks connection due to an error to one specific table.

    The query is

    Error 'Duplicate entry '24954' for key 1' on query. Default database: 'sitename_vb'. Query: 'INSERT INTO vb3_vbseo_linkback
    (t_time, t_src_url, t_dest_url, t_type, t_postid, t_postcount, t_threadid, t_page,
    t_title, t_text, t_approve, t_incoming, t_wait)

    It consistently breaks every minute. We then have to ignore the query and then start the replication again. Is there a way around this? This is urgent since we now have had to shut down the slave .. any leads will be appreciated.

    Thanks


  2. #2
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,744
    Liked
    169 times
    Please check if you have more than one record in master db with primary key (t_id) equal to 24945 for some reason. If that's the case, you should keep only one of them.

Similar Threads

  1. Linkback Table Error from MySQL
    By GlitterKill in forum Bug Reporting
    Replies: 2
    Last Post: 07-01-2008, 06:02 PM
  2. MySQL error
    By debug in forum Troubleshooting
    Replies: 1
    Last Post: 05-21-2008, 10:18 PM
  3. mysql error
    By Slingblade61 in forum Troubleshooting
    Replies: 13
    Last Post: 03-09-2008, 05:22 AM
  4. Blog table error
    By Banana Man in forum Troubleshooting
    Replies: 3
    Last Post: 02-19-2008, 08:20 AM
  5. MySQL error: mailqueue
    By rj2 in forum Troubleshooting
    Replies: 1
    Last Post: 03-04-2006, 05:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •