vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   mysql error: Duplicate entry (https://vborg.vbsupport.ru/showthread.php?t=92247)

JamesX4334 07-15-2005 11:16 AM
mysql error: Duplicate entry
 
When trying to log out or log in i get this message
Database error in vBulletin 3.0.7:

PHP Code:
Invalid SQL:
               INSERT INTO session
                       (sessionhash, userid, host, idhash, lastactivity, styleid, useragent)
               VALUES
                       ('e3b621592a4b6a651798d8233c955350', 0, '81.152.165.200', '73f217f5e10d566906167b7557618da7', 1121425831, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)')

mysql error: Duplicate entry 'e3b621592a4b6a651798d8233c955350' for key 1

mysql error number: 1062

Date: Friday 15th of July 2005 06:10:31 AM
Script: http://aaaaaa.com/login.php?do=logout&u=5
Referer: http://aaaaaa.com/index.php?
Username: Unregistered
IP Address: 81.152.165.200 
Ive tried to fix but i could not

Can someone help

sabret00the 07-15-2005 11:42 AM
what hacks did you install before this happened?

JamesX4334 07-15-2005 12:36 PM
arcade,cash,medals and some other stuff but they did not effect SQL

sabret00the 07-15-2005 12:49 PM
as far as i know all of them do actually modify the database, i have a feeling that something modified your session tables or where the sessions are handled in the files badly.

JamesX4334 07-15-2005 12:55 PM
yes i was wondering that,
Ill take out some of the tables like the arcade and re-install and see what happens.
I cannot re-install da forums thougth ive made/installed way to many mods for it so this need to be fixed

--------------
I think its the arcade causing the trouble but how do i recover the session table ?

Marco van Herwaarden 07-15-2005 06:44 PM
You could easily delete all rows from the session table.

Funny the sessionhash should not get duplicates, but Floris had the same problem posted at vb.com using vB3.5.

Not sure if he ever found out what was causing it. Try searching vb.com for a thread started by floris.


All times are GMT. The time now is 01:13 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.00963 seconds
  • Memory Usage 1,721KB
  • 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_php_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