Thread: voting stuck

Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18
  1. #11  
    Community Veteran


    arch337's Avatar
    Join Date
    Sep 2008
    Posts
    2,859
    Thanks given
    194
    Thanks received
    311
    Discord
    View profile
    Rep Power
    893
    Quote Originally Posted by kelaby View Post
    easy said than done I've actually took your advice and google that and its not as simple as that, because there are tons of sql and its not leading to the one that is needed for the mysql database table etc

    Not sure what you google'd, but I found this within seconds.


    "A fail act is something you do regular, but a dumb act is something you can learn from"
    Spoiler for Problem?:
    Reply With Quote  
     

  2. #12  
    ¦¦¦ RuneTimes ¦¦¦

    RainDropzZ's Avatar
    Join Date
    Oct 2010
    Posts
    373
    Thanks given
    31
    Thanks received
    103
    Discord
    View profile
    Rep Power
    556
    Quote Originally Posted by kelaby View Post
    easy said than done I've actually took your advice and google that and its not as simple as that, because there are tons of sql and its not leading to the one that is needed for the mysql database table etc
    It is as easy as he said, you just need to create your SQL table. You see all variables you need in the vote code. Example "username, site_id, ip_address, uid" just look through the code and note down what you need and then simply create a database via tutorial with these given variables.
    Reply With Quote  
     

  3. #13  
    RSPS & WEB Developer!

    Mr Pharaoh's Avatar
    Join Date
    May 2015
    Posts
    978
    Thanks given
    566
    Thanks received
    189
    Discord
    View profile
    Rep Power
    128
    Easy to fix, if you have sql files just need to import it to your phpmyadmin if you're having it already
    after created mysql, and make sure you added ur vps ip to remote mysql connect
    Reply With Quote  
     

  4. #14  
    Registered Member
    Join Date
    Sep 2011
    Posts
    22
    Thanks given
    9
    Thanks received
    0
    Rep Power
    11
    Quote Originally Posted by arch337 View Post
    Your mysql database need to have a table called 'fx_votes' with the row name's 'id', 'username', 'callback_date', 'started', 'ip_address', 'site_id', 'uid', 'claimed'...etc till you fullfilled all proposed values in this code.
    What each value should be, you'll have to look into the code. I am surprised this was not included in your sql if you followed a tutorial about it.
    thanks that helped

    Quote Originally Posted by arch337 View Post
    Your mysql database need to have a table called 'fx_votes' with the row name's 'id', 'username', 'callback_date', 'started', 'ip_address', 'site_id', 'uid', 'claimed'...etc till you fullfilled all proposed values in this code.
    What each value should be, you'll have to look into the code. I am surprised this was not included in your sql if you followed a tutorial about it.
    as you mentioned above that has now been created however and the error was gone now im getting this
    Code:
    Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'runeline_v.fx_sites' doesn't exist in /home/runeline/public_html/vote/classes/class.database.php:37 Stack trace: #0 /home/runeline/public_html/vote/classes/class.database.php(37): PDO->prepare('SELECT * FROM f...') #1 /home/runeline/public_html/vote/templates/site_list.php(43): Database->getAllSites() #2 /home/runeline/public_html/vote/admin.php(34): include('/home/runeline/...') #3 {main} thrown in /home/runeline/public_html/vote/classes/class.database.php on line 37
    Quote Originally Posted by Mr Pharaoh View Post
    Easy to fix, if you have sql files just need to import it to your phpmyadmin if you're having it already
    after created mysql, and make sure you added ur vps ip to remote mysql connect
    i tried all that can you add me on discord to help because I am not sure how to do the server sided as well
    Reply With Quote  
     

  5. #15  
    Registered Member
    Optimum's Avatar
    Join Date
    Apr 2012
    Posts
    3,538
    Thanks given
    847
    Thanks received
    1,713
    Discord
    View profile
    Rep Power
    5000
    Your website and vote doesn’t work

    Your website and vote doesn’t work

    Quote Originally Posted by DownGrade View Post
    Don't let these no life creeps get to you, its always the same on here. They'd rather spend hours upon hours in the rune-server spam section then getting laid! ha ha!Its honestly pathetic i haven't seen so many lowlifes in my life its actually insane i wish that this section would just vanish its probably the only way to get these people out of the community...
    PLEASE BE AWARE OF IMPOSTERS MY DISCORD ID: 362240000760348683
    Reply With Quote  
     

  6. Thankful user:


  7. #16  
    Everything is Corrupt
    Quantum's Avatar
    Join Date
    Oct 2020
    Posts
    97
    Thanks given
    15
    Thanks received
    30
    Discord
    View profile
    Rep Power
    63
    MySql is quite simple once you get into it, or maybe it just years of doing it myself. Go into your web domain, go to PHPMyAdmin, and go into your databases (if you havent created a database, go into your web domain, go to database, create a table labeled votes, and than create a user with a password, go into permissions and give it full permissions to the database), and once inside PHPMyAdmin, you will see your database. Go to create table , create the table (fx_votes) and start to add in the variables. check your file i think there only two strings, in which would be VARCHAR inside the MySql, set it to about 50, and everything else put as int. Go into your file in the server and use the connection information you just made with the database and user,
    In a Quantum World, nothing is real. We are one, and one is all. Live in the Quantum World.

    Reply With Quote  
     

  8. Thankful user:


  9. #17  
    Community Veteran


    arch337's Avatar
    Join Date
    Sep 2008
    Posts
    2,859
    Thanks given
    194
    Thanks received
    311
    Discord
    View profile
    Rep Power
    893
    Quote Originally Posted by kelaby View Post
    thanks that helped


    as you mentioned above that has now been created however and the error was gone now im getting this
    Code:
    Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'runeline_v.fx_sites' doesn't exist in /home/runeline/public_html/vote/classes/class.database.php:37 Stack trace: #0 /home/runeline/public_html/vote/classes/class.database.php(37): PDO->prepare('SELECT * FROM f...') #1 /home/runeline/public_html/vote/templates/site_list.php(43): Database->getAllSites() #2 /home/runeline/public_html/vote/admin.php(34): include('/home/runeline/...') #3 {main} thrown in /home/runeline/public_html/vote/classes/class.database.php on line 37


    i tried all that can you add me on discord to help because I am not sure how to do the server sided as well
    Clearly state the issue and what files is involved.
    Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'runeline_v.fx_sites' doesn't exist in /home/runeline/public_html/vote/classes/class.database.php:37 Stack trace: #0 /home/runeline/public_html/vote/classes/class.database.php(37): PDO->prepare('SELECT * FROM f...') #1 /home/runeline/public_html/vote/templates/site_list.php(43): Database->getAllSites() #2 /home/runeline/public_html/vote/admin.php(34): include('/home/runeline/...') #3 {main} thrown in /home/runeline/public_html/vote/classes/class.database.php on line 37


    "A fail act is something you do regular, but a dumb act is something you can learn from"
    Spoiler for Problem?:
    Reply With Quote  
     

  10. Thankful user:


  11. #18  
    Registered Member
    Join Date
    Sep 2011
    Posts
    22
    Thanks given
    9
    Thanks received
    0
    Rep Power
    11
    Thanks all now has been sovled
    Reply With Quote  
     

Page 2 of 2 FirstFirst 12

Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Stuck while setting up GTL Vote Script v1.1
    By Black Widow in forum Help
    Replies: 2
    Last Post: 07-25-2015, 06:58 PM
  2. Paint VS Photoshop, Vote Please!!!
    By Karlis in forum General
    Replies: 22
    Last Post: 11-04-2007, 07:40 PM
  3. Sotw 1 Voting
    By Stuie in forum General
    Replies: 28
    Last Post: 06-14-2007, 12:19 AM
  4. Vote your favorite....
    By Aces in forum Showcase
    Replies: 0
    Last Post: 04-02-2007, 03:00 AM
  5. Replies: 0
    Last Post: 12-26-2006, 06:36 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •