Mysql Errors

Discussion in 'Troubleshooting' started by syan, Jun 28, 2003.

  1. syan

    syan aMember Pro Customer

    Joined:
    Apr 6, 2003
    Messages:
    39
    I am recieving the following error once I try to log in/sign up:

    MYSQL ERROR:
    Duplicate entry '6627' for key 1
    in query:
    INSERT INTO members (login, pass, email, name_f,
    name_l, street, city, state, zip, country, is_male,
    added, remote_addr, data, aff_id ) VALUES .....
    syan, Jun 28, 2003
    #1
  2. syan

    syan aMember Pro Customer

    Joined:
    Apr 6, 2003
    Messages:
    39
    I got similar erros like this a few days ago, i guess my mysql server was corrupted. Had a fresh restore (the whole OS ) and now that i've had a fresh install of amember all 6000 users signed up within within the period of 48 hrs. Hope that doesn't screw up the format of the tables. Within a few days im changing my site into a paysite and would really not work out if these problems come up. Anyone has any ideas as to why the mysql fail at times ? Is there a mysql fix for this?
    syan, Jun 28, 2003
    #2
  3. alex-adm

    alex-adm Guest

    It is MySQL troubles, possible it may be caused by hard disk/filesystem crash or it may be MySQL bug.

    If it happens again, please try to run the following MySQL queries:
    CHECK TABLE members;


    REPAIR TABLE members;
    alex-adm, Jun 30, 2003
    #3
  4. abgcompu

    abgcompu New Member

    Joined:
    Jan 1, 2008
    Messages:
    8
    My SQL Error. User cannot login or register.

    I have the folowong error. I everything was working find untli I add the wordpress integration plug in.


    MYSQL ERROR:
    Duplicate entry '139' for key 1
    in query:
    update tinypip_smf1.smf_members set ID_MEMBER = '139', memberName = '256robertm', dateRegistered = '1178914875', posts = '6', ID_GROUP = '21', lngfile = 'english', lastLogin = '1228337001', realName = '256robertm', instantMessages = '7', unreadMessages = '0', buddy_list = '', pm_ignore_list = '', messageLabels = '', passwd = '471857b100c25c3d6ee6e3cec7326ea2b124726e', emailAddress = 'cimpwimp@yahoo.com', personalText = '', gender = '0', birthdate = '0001-01-01', websiteTitle = '', websiteUrl = '', location = '', ICQ = '', AIM = '', YIM = '', MSN = '', hideEmail = '1', showOnline = '1', timeFormat = '', signature = '', timeOffset = '0', avatar = '', pm_email_notify = '1', karmaBad = '0', karmaGood = '0', usertitle = '', notifyAnnouncements = '1', notifyOnce = '1', notifySendBody = '0', notifyTypes = '2', memberIP = '24.214.231.57', memberIP2 = '24.214.231.57', secretQuestion = '', secretAnswer = '', ID_THEME = '1', is_activated = '1', validation_code = '', ID_MSG_LAST_VISIT = '4311', additionalGroups = '9', smileySet = '', ID_POST_GROUP = '4', totalTimeLoggedIn = '59765', passwordSalt = '7a2a' where memberName = '256robertm'
    abgcompu, Dec 18, 2008
    #4
  5. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    Did your wordpress database already have users in it?
    Can you delete these out- except for admin, and rebuild?

    David
    davidm1, Dec 18, 2008
    #5
  6. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Please contact support if this is not fixed yet.
    This seems to be a problem with SMF database.
    alexander, Dec 30, 2008
    #6

Share This Page