Massive errors with MySQL!

Discussion in 'MySQL' started by Plutonic, Jul 5, 2008.

  1. #1
    I bought the YourOwnBux script.

    I tried to set it up, but when I do I get all kinds of errors, look:

    www.jakelynagh.com

    This is my config.php:

    Please help me fix this?
     
    Plutonic, Jul 5, 2008 IP
  2. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #2
    You did make a database correct? :)
     
    Boulder, Jul 5, 2008 IP
  3. Plutonic

    Plutonic Peon

    Messages:
    2,964
    Likes Received:
    85
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I put
    in one of the errors, and it came up with no database selected.

    If anyone can fix this I'll give you a free 500 clicks from the site.
     
    Plutonic, Jul 5, 2008 IP
  4. Plutonic

    Plutonic Peon

    Messages:
    2,964
    Likes Received:
    85
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Yes I did, the readme of the script said:

    2. Create an empty table and call it anything you like, we'll call ours "buxscript".
    3. Open up the empty table and Import the database.txt file.

    I tried to import it into a new table but that didn't work, so I just imported it into the database.
     
    Plutonic, Jul 5, 2008 IP
  5. Plutonic

    Plutonic Peon

    Messages:
    2,964
    Likes Received:
    85
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I think I may know the problem...

    Nope, didn't work.
     
    Plutonic, Jul 5, 2008 IP
  6. Plutonic

    Plutonic Peon

    Messages:
    2,964
    Likes Received:
    85
    Best Answers:
    0
    Trophy Points:
    0
    #6
    One of the errors is:

    This is sitename.php:

     
    Plutonic, Jul 5, 2008 IP
  7. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #7
    echo $row["sitename"];


    Probably needs to be the table name..

    Is sitename the name of table in your database?
     
    Boulder, Jul 5, 2008 IP
  8. Plutonic

    Plutonic Peon

    Messages:
    2,964
    Likes Received:
    85
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Lol, no there is no sitename table...
     
    Plutonic, Jul 5, 2008 IP
  9. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #9

    How many table rows are there?
     
    Boulder, Jul 5, 2008 IP
  10. Plutonic

    Plutonic Peon

    Messages:
    2,964
    Likes Received:
    85
    Best Answers:
    0
    Trophy Points:
    0
    #10
    There are 15 tables, I don't know what table rows are.

    I don't know much about MySQL.

    The database is www.jakelynagh.com/database.txt if that helps.
     
    Plutonic, Jul 5, 2008 IP
  11. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #11
    Okay so you created a database in phpmyadmin correct?

    Than you imported or ran an SQL query to populate that database with this file correct?

    And the name of that database is the same entry in this statement in the config file?

    $bd_base = "*****";

    Boulder
     
    Boulder, Jul 5, 2008 IP
  12. Plutonic

    Plutonic Peon

    Messages:
    2,964
    Likes Received:
    85
    Best Answers:
    0
    Trophy Points:
    0
    #12
    Yes, and the name is jakelyna_bux
     
    Plutonic, Jul 5, 2008 IP
  13. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #13
    And you did assign a user to that database and have the correct user and password entered in the config.php file?
     
    Boulder, Jul 5, 2008 IP
  14. Plutonic

    Plutonic Peon

    Messages:
    2,964
    Likes Received:
    85
    Best Answers:
    0
    Trophy Points:
    0
    #14
    Yes I did that.
     
    Plutonic, Jul 5, 2008 IP
  15. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #15
    Humm... I not sure.

    Might try reinstalling the files.. possible they got corrupt on upload somehow.

    Can you access the admin panel.. If so, is there an entry there for site name?


    Looks like your not the only one with this issue on this same script!

    I just found this one out of the wild (excelent bux [dot] com)

    What version of MySQL and php is on your server?


    Edit: Looks like your golden! Have it working now I see. Good deal. :)

    Boulder
     
    Boulder, Jul 5, 2008 IP