vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Error 1062 (23000) duplicate entry (https://vborg.vbsupport.ru/showthread.php?t=241435)

CrashfAB 04-28-2010 05:08 PM
Error 1062 (23000) duplicate entry
 
I am in the process of setting up a duplicate forum for reasons of testing.

I had my host pull me a database backup thru SSH.

I took the backup and went to restore it into a new database on another host I have. I ran the proper code mysql -u databaseuser -p databasename < backup.sql and all went good.

I then get a ERROR 1062(23000) at line 5458 : Duplicate entry 'jagermeister' for key 2

I have done as much reading as I can interpret with my slim knowledge of databases. from what I can tell this has to do with information being placed into the wrong tables due to hacks/plugins on my site? Am I wrong on this?

Any help would appreciated.

Speysider 04-28-2010 05:26 PM
Duplicate entry key means that this key already exists and is trying to be made again.

CrashfAB 04-28-2010 05:36 PM
I understand that (and I should have stated so) but how do I go about correcting it?

Speysider 04-28-2010 06:34 PM
You would have to delete that table and recreate it being empty.
There was a better way of creating an entirely duplicate test forum, which was to use ImpEx.

CrashfAB 04-28-2010 07:47 PM
Quote:
Originally Posted by Speysider (Post 2028682)
You would have to delete that table and recreate it being empty.
There was a better way of creating an entirely duplicate test forum, which was to use ImpEx.
How can I tell what table it is?

I understand I can use ImpEx but I prefer to do things so I know how to. If I was to move my forum to another server I would be doing the same thing so might as well learn how to now.

Paul M 04-28-2010 10:34 PM
View the database to see which table was created last.


All times are GMT. The time now is 02:47 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01157 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete