Another Ipb Problem.....

Discussion in 'Gaming' started by stpl91, Apr 23, 2006.

  1. stpl91

    stpl91 Well-Known Member

    Age:
    34
    Posts:
    371
    Likes Received:
    0
    Joined:
    Feb 13, 2006
    Location:
    Coram, NY
    mySQL query error: ALTER TABLE ibf_members ADD refer_id INT(11) DEFAUlT '0' NOT NULL,
    ADD refer_ban TINYINT(1) DEFAULT '0' NOT NULL,
    ADD refer_hits INT(11) DEFAUlT '0' NOT NULL,
    ADD refer_vals INT(11) DEFAUlT '0' NOT NULL,
    ADD refer_regs INT(11) DEFAUlT '0' NOT NULL

    mySQL error: Duplicate column name 'refer_id'
    mySQL error code:
    Date: Sunday 23rd of April 2006 02:17:19 PM



    whats this meen? im trying to run the installer for the refferal mod.. i uploaded all the files right but i keep getting that error when trying to install it.. anyone know?
     
  2. HydrogeN

    HydrogeN Well-Known Member

    Posts:
    2,532
    Likes Received:
    0
    Joined:
    Sep 7, 2004
    I would say one of your edits are wrong. Double check them using Wordpad and not notepad and see if you missed something. I bet it is a minor mistake.
     
  3. stpl91

    stpl91 Well-Known Member

    Age:
    34
    Posts:
    371
    Likes Received:
    0
    Joined:
    Feb 13, 2006
    Location:
    Coram, NY
    thats the thing... i did the eidts and uploaded them, but i kept backups so i reuploaded the backups and it still wont install lol..
     
  4. HydrogeN

    HydrogeN Well-Known Member

    Posts:
    2,532
    Likes Received:
    0
    Joined:
    Sep 7, 2004
    If you upload the back-ups of the original files, it shouldn't install, the mod cant find what it is looking for. Double check your edits or host the files you modded and the mod itself and PM me the link, I will look at them and see if I can find an error in the edits.
     
  5. stpl91

    stpl91 Well-Known Member

    Age:
    34
    Posts:
    371
    Likes Received:
    0
    Joined:
    Feb 13, 2006
    Location:
    Coram, NY
    well its an error in the SQL files, so ill reupload them and see if it works, if not ill pm you the link to download the files to edit. thanks man
     
  6. HydrogeN

    HydrogeN Well-Known Member

    Posts:
    2,532
    Likes Received:
    0
    Joined:
    Sep 7, 2004
    NO problem. I am getting back into my IPB modding after some time off, so the practice will be good for me.

    I have added the rep and store mods to my test board, I am always looking for new ones to try and add for fun.
     
  7. stpl91

    stpl91 Well-Known Member

    Age:
    34
    Posts:
    371
    Likes Received:
    0
    Joined:
    Feb 13, 2006
    Location:
    Coram, NY
    kk pm sent :)
     
  8. DiabloDj1

    DiabloDj1 Well-Known Member

    Age:
    35
    Posts:
    5,610
    Likes Received:
    0
    Joined:
    Jan 27, 2005
    Location:
    USA/RI
    Start a shop then...you'll get paid to do it :P
    I did that but it became overwhelming becuase I didnt organize it correctly. Make sure you do if you make a shop!
     
  9. stpl91

    stpl91 Well-Known Member

    Age:
    34
    Posts:
    371
    Likes Received:
    0
    Joined:
    Feb 13, 2006
    Location:
    Coram, NY
    lol i had my own shop too until like 40 people wanted hosting & they all wanted to copy gamerenders with the rep/store mods... so i would be on msn & aim 24 hours a day doing mods so i just left the store lol
     
  10. HydrogeN

    HydrogeN Well-Known Member

    Posts:
    2,532
    Likes Received:
    0
    Joined:
    Sep 7, 2004
    I dont need a shop, I dont care to get paid to do it, it is mainly for my knowledge and to help the members of the community, I mean isnt that what we are supposed to do, help each other?

    Glad you got it sorted stpl91, I also editted your sig, cant have referals here.
     
  11. stpl91

    stpl91 Well-Known Member

    Age:
    34
    Posts:
    371
    Likes Received:
    0
    Joined:
    Feb 13, 2006
    Location:
    Coram, NY
    oh we cant lol? its rlly not refering its advertising in my sig. lol thanks though, i prolly would of gotten in more trouble if somebody else found out first.
     
  12. -Calypso-

    -Calypso- Well-Known Member

    Posts:
    57
    Likes Received:
    0
    Joined:
    Apr 23, 2006
    this one is simple...

    Code:
    mySQL error: Duplicate column name 'refer_id'
    
    is your error, you are trying to create a table that is already there, move on with ur edits, its fine. Im pretty decent with IPB myself.
     
  13. stpl91

    stpl91 Well-Known Member

    Age:
    34
    Posts:
    371
    Likes Received:
    0
    Joined:
    Feb 13, 2006
    Location:
    Coram, NY
    lol thanks man, thats kinda what i thought but i couldnt find out whre lol. all that matter is that it works now :P
     
  14. -Calypso-

    -Calypso- Well-Known Member

    Posts:
    57
    Likes Received:
    0
    Joined:
    Apr 23, 2006
    correct, and this goes with any future mods you install, during the sql query, if you get an error that tells u the table already exist, then its not gonna cause u any problems unless that table is being used my another modification. What version board are u running? I have v2.1.5
     
  15. stpl91

    stpl91 Well-Known Member

    Age:
    34
    Posts:
    371
    Likes Received:
    0
    Joined:
    Feb 13, 2006
    Location:
    Coram, NY
    2.0.4 , i like it the best because its the newest 2.0.X and it has so many more mods than the 2.1.X series.

    i also have the files for 2.1.5 i instaled it once to test it and its just like the other 2.1.X lol
     

Share This Page