1. Welcome to skUnity!

    Welcome to skUnity! This is a forum where members of the Skript community can communicate and interact. Skript Resource Creators can post their Resources for all to see and use.

    If you haven't done so already, feel free to join our official Discord server to expand your level of interaction with the comminuty!

    Now, what are you waiting for? Join the community now!

  2. LOOKING FOR A VERSION OF SKRIPT?

    You can always check out our Wiki for downloads and any other information about Skript!

Welcome Skript Download
Dismiss Notice
This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL error/help

Discussion in 'Skript' started by McAcrylic, May 1, 2019.

Thread Status:
Not open for further replies.
  1. McAcrylic

    McAcrylic Active Member

    Joined:
    Oct 21, 2017
    Messages:
    59
    Likes Received:
    0
    I am not too sure if I am using SkQuery's or skript-db's MySQL system, but either ways, I have no idea why it breaks the skript after a reload.
    [​IMG]
    Even so, it didn't work initially.

    Here is my code:
    For this, I created a database named BlockProperties using the XAMPP control panel.
    Code (Text):
    1. script options:
    2.     $ db url jdbc:http://localhost/phpmyadmin/db_structure.php?db=blockproperties
    3.     $ db username root
    4.     $ db password MyPW_12345 (This is not my actual pw)
     
    #1 McAcrylic, May 1, 2019
  2. TPGamesNL

    TPGamesNL
    Moderator Supporter Addon Developer Dev Programme

    Joined:
    Jan 20, 2018
    Messages:
    1,501
    Likes Received:
    108
    Medals:
    That URL is for phpMyAdmin, not the database
     
    #2 TPGamesNL, May 1, 2019
  3. McAcrylic

    McAcrylic Active Member

    Joined:
    Oct 21, 2017
    Messages:
    59
    Likes Received:
    0
    What am I suppose to look out for or what would/should the url be then?
     
    #3 McAcrylic, May 1, 2019
  4. TPGamesNL

    TPGamesNL
    Moderator Supporter Addon Developer Dev Programme

    Joined:
    Jan 20, 2018
    Messages:
    1,501
    Likes Received:
    108
    Medals:
    Do you see something like this on the phpMyAdmin page?
    upload_2019-5-1_13-54-30.png
    If so, send a screenshot of that
     
    #4 TPGamesNL, May 1, 2019
  5. McAcrylic

    McAcrylic Active Member

    Joined:
    Oct 21, 2017
    Messages:
    59
    Likes Received:
    0
    [​IMG]
    This? Not exactly what you had, but ye

    [​IMG]
     
    #5 McAcrylic, May 1, 2019
  6. TPGamesNL

    TPGamesNL
    Moderator Supporter Addon Developer Dev Programme

    Joined:
    Jan 20, 2018
    Messages:
    1,501
    Likes Received:
    108
    Medals:
    Have you changed the default MySQL port in XAMPP?
     
    #6 TPGamesNL, May 2, 2019
  7. McAcrylic

    McAcrylic Active Member

    Joined:
    Oct 21, 2017
    Messages:
    59
    Likes Received:
    0
    No but if need be, how would I go about doing it?
     
    #7 McAcrylic, May 2, 2019
  8. TPGamesNL

    TPGamesNL
    Moderator Supporter Addon Developer Dev Programme

    Joined:
    Jan 20, 2018
    Messages:
    1,501
    Likes Received:
    108
    Medals:
    No, try
    Code (Text):
    1. $ db url jdbc:mysql://localhost:3306/blockproperties
     
    #8 TPGamesNL, May 2, 2019
  9. McAcrylic

    McAcrylic Active Member

    Joined:
    Oct 21, 2017
    Messages:
    59
    Likes Received:
    0
    Tried:

    Code (Text):
    1. script options:
    2.     $ db url jdbc:mysql://localhost:3306/blockproperties
    3.     $ db username root
    4.     $ db password **********
    5.    
    Still does not work, it just breaks the script.
     
    #9 McAcrylic, May 2, 2019
  10. TPGamesNL

    TPGamesNL
    Moderator Supporter Addon Developer Dev Programme

    Joined:
    Jan 20, 2018
    Messages:
    1,501
    Likes Received:
    108
    Medals:
    Can you send the error for that one?
     
    #10 TPGamesNL, May 2, 2019
  11. McAcrylic

    McAcrylic Active Member

    Joined:
    Oct 21, 2017
    Messages:
    59
    Likes Received:
    0
    Its the same/similar[​IMG] as I was having before but here....
     
    #11 McAcrylic, May 2, 2019
  12. TPGamesNL

    TPGamesNL
    Moderator Supporter Addon Developer Dev Programme

    Joined:
    Jan 20, 2018
    Messages:
    1,501
    Likes Received:
    108
    Medals:
    What SkQuery and server (spigot/bukkit/paper/craftbukkit) version are you using?
     
    #12 TPGamesNL, May 3, 2019
  13. McAcrylic

    McAcrylic Active Member

    Joined:
    Oct 21, 2017
    Messages:
    59
    Likes Received:
    0
    1.11.2 Spigot
    [​IMG]
    [​IMG]
     
    #13 McAcrylic, May 3, 2019
  14. TPGamesNL

    TPGamesNL
    Moderator Supporter Addon Developer Dev Programme

    Joined:
    Jan 20, 2018
    Messages:
    1,501
    Likes Received:
    108
    Medals:
    #14 TPGamesNL, May 3, 2019
  15. McAcrylic

    McAcrylic Active Member

    Joined:
    Oct 21, 2017
    Messages:
    59
    Likes Received:
    0
    #15 McAcrylic, May 3, 2019
  16. TPGamesNL

    TPGamesNL
    Moderator Supporter Addon Developer Dev Programme

    Joined:
    Jan 20, 2018
    Messages:
    1,501
    Likes Received:
    108
    Medals:
    Try again on a fresh server with spigot 1.13.2 and skript 2.3.6 and skquery 3.6.5. If it still occurs then, there isn't much you can do, as it's already reported. You could post your error on there too saying you have the same issue.
     
    #16 TPGamesNL, May 3, 2019
(You must log in or sign up to post here.)
Thread Status:
Not open for further replies.

Share This Page

Loading...