1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

trouble installing BANS

Discussion in 'Commission Junction' started by richkid, Nov 28, 2007.

  1. #1
    hey,

    i am trying to install BANS on my host gator hosting, and i am doing everything the manual tells me to and it keeps coming up with the following error.


    Could not connect to the MySQL database 'tsweight_bans', please check your database name!
    (MySQL error: Access denied for user 'tsweight_ban'@'localhost' to database 'tsweight_bans'​


    Website: www.gain-weight.info



    which is what I have been putting in, but it keeps telling me they cannot connect.

    Is anyone able to tell me what is going wrong, or even give it a try to fix?

    thanks
    Tom
     
    richkid, Nov 28, 2007 IP
  2. smithy

    smithy Guest

    Messages:
    134
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I have no experience of BANS and limited experience of mysql but I think your username and password is ok, it's the database name that is wrong.

    The second line of the error message is from mysql and from my experience mysql wouldn't mention the database unless you had provided a valid username/password. If either of those were wrong you'd just get

    MySQL error: Access denied for user 'tsweight_ban'@'localhost'
     
    smithy, Nov 28, 2007 IP
  3. bondjpf

    bondjpf Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    bondjpf, Nov 28, 2007 IP
  4. crystak

    crystak Well-Known Member

    Messages:
    1,121
    Likes Received:
    36
    Best Answers:
    0
    Trophy Points:
    115
    #4
    Noooo take the password off IMMEDIATELY!

    Any experienced hacker can do harm to your account.

    I can also suggest posting in the members' forum on the BANS website, they're usually a helpful bunch.
     
    crystak, Nov 28, 2007 IP
  5. richkid

    richkid Well-Known Member

    Messages:
    1,684
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    140
    #5
    thanks,
    i didnt even think of that! fixed
     
    richkid, Nov 28, 2007 IP
  6. Mmecca

    Mmecca Guest

    Messages:
    225
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I would also remove the install.php file until to sort this out.

    It looks like the server name is wrong, you should be able to find the correct one in your CP or by contacting the hostgator support.


    Good luck.
     
    Mmecca, Nov 28, 2007 IP
  7. van_theman

    van_theman Banned

    Messages:
    470
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #7
    i think you copy and pastes database name fill form
    you can try type manual
     
    van_theman, Nov 29, 2007 IP
  8. richkid

    richkid Well-Known Member

    Messages:
    1,684
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    140
    #8
    I have tried this also
     
    richkid, Nov 29, 2007 IP
  9. login

    login Notable Member

    Messages:
    8,849
    Likes Received:
    349
    Best Answers:
    0
    Trophy Points:
    280
    #9
    Hi richkid. I tought that you used bans already? If you want me to take a look at the install for you can PM me.
     
    login, Nov 29, 2007 IP
  10. richkid

    richkid Well-Known Member

    Messages:
    1,684
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    140
    #10
    Hi, I have, and I have installed if for myself once, and all the other times someone else has...

    PM coming..thanks!
     
    richkid, Nov 29, 2007 IP
  11. hanji

    hanji Peon

    Messages:
    612
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Could this be a simple typo??

    Could not connect to the MySQL database 'tsweight_bans', please check your database name!
    (MySQL error: Access denied for user 'tsweight_ban'@'localhost' to database 'tsweight_bans'
    Code (markup):
    database = tsweight_bans
    user = tsweight_ban (notice no 's' in the username)

    hanji
     
    hanji, Nov 29, 2007 IP
  12. richkid

    richkid Well-Known Member

    Messages:
    1,684
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    140
    #12
    thanks for the idea, but no, I specifically made it bans and ban
     
    richkid, Nov 29, 2007 IP
  13. hanji

    hanji Peon

    Messages:
    612
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #13
    Access denied for user 'tsweight_ban'@'localhost', can only mean you're using the wrong password, or you're connecting to the wrong database host. Did you triple check your mysql password and verify that it's working (ala phpmyadmin, etc?). If that works, view what host it's connecting to (localhost or some other host).

    hanji
     
    hanji, Nov 29, 2007 IP
  14. login

    login Notable Member

    Messages:
    8,849
    Likes Received:
    349
    Best Answers:
    0
    Trophy Points:
    280
    #14
    Problem solved, you didnt connect the user to the db.
     
    login, Nov 29, 2007 IP
  15. richkid

    richkid Well-Known Member

    Messages:
    1,684
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    140
    #15
    :S oh... now i feel stupid..


    thankyou so much for your help!
     
    richkid, Nov 29, 2007 IP
  16. login

    login Notable Member

    Messages:
    8,849
    Likes Received:
    349
    Best Answers:
    0
    Trophy Points:
    280
    #16
    Forget it, give me a green for it :D
     
    login, Nov 30, 2007 IP
    richkid likes this.
  17. Killermule

    Killermule Well-Known Member

    Messages:
    1,060
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    165
    #17
    I cant be bothered reading the whole thread but I had your same problem.

    Search the error in the BANS members only forum and there is an alternate install file that fixes this problem.

    I will not link the file directly as I know you might have obtained the software illegally so you can go to the members only forum and get it yourself.


    Hope this can help :D (well not really cos then there would be competition... but anywho)
     
    Killermule, Dec 1, 2007 IP
  18. mcjp6

    mcjp6 Well-Known Member

    Messages:
    1,140
    Likes Received:
    49
    Best Answers:
    0
    Trophy Points:
    140
    #18
    if you cannot be bothered reading the thread then why comment at all? If you had read the thread you would realise that your suggestion is rubbish!
     
    mcjp6, Dec 1, 2007 IP
  19. crystak

    crystak Well-Known Member

    Messages:
    1,121
    Likes Received:
    36
    Best Answers:
    0
    Trophy Points:
    115
    #19
    For post count of course :p.
     
    crystak, Dec 1, 2007 IP