MySQL does not work with version 1.12. Can someone help me?

  • 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!

  • LOOKING FOR A VERSION OF SKRIPT?

    You can always check out skUnity Downloads for downloads and any other information about Skript!

Status
Not open for further replies.

TSBeatz

New Member
Apr 26, 2017
9
1
3
Skript Version: Skript 2.2 dev31c
Skript Author: Bensku
Minecraft Version: 1.12
MundoSK: 1.7.5-BETA.10.19
skDragon: 0.14.0
Skellett: 1.9.6b
SkQuery: 3.5.7-Lime
skRayFall: 1.9.10
SQLibrary: 7.1
Umbaska: 3.3

I am working on a stats system that should be connected to my forum.
And both codes do not work.
Can someone help me?




Script-Code 1
code_language.skript:
script options:
    $ db url jdbc:mysql://localhost:3306/<Your db name here>
    $ db username <username>
    $ db password <password>

Script-Code 1
code_language.skript:
[15:38:23 ERROR]: ':mysql://localhost:3306/' is not a valid item data (TSBeatz.sk, line 44: $ db url jdbc:mysql://localhost:3306/<Your db name here>')
[15:38:23 ERROR]: Can't understand this condition/effect: $ db username <username> (TSBeatz.sk, line 45: $ db username <username>')
[15:38:23 ERROR]: Can't understand this condition/effect: $ db password <password> (TSBeatz.sk, line 46: $ db password <password>')




Script-Code 2
code_language.skript:
on skript load:
    set mysql host to "127.0.0.1"
    set mysql port to 3306
    set mysql username to "root"
    set mysql password to "pass"
    set mysql database to "name"
    connect to mysql

Script-Code 2
code_language.skript:
[15:36:58 ERROR]: Can't understand this condition/effect: set mysql host to "127.0.0.1" (TSBeatz.sk, line 35: set mysql host to "127.0.0.1"')
[15:36:58 ERROR]: Can't understand this condition/effect: set mysql port to 3306 (TSBeatz.sk, line 36: set mysql port to 3306')
[15:36:58 ERROR]: Can't understand this condition/effect: set mysql username to "root" (TSBeatz.sk, line 37: set mysql username to "root"')
[15:36:58 ERROR]: Can't understand this condition/effect: set mysql password to "pass" (TSBeatz.sk, line 38: set mysql password to "pass"')
[15:36:58 ERROR]: Can't understand this condition/effect: set mysql database to "name" (TSBeatz.sk, line 39: set mysql database to "name"')
[15:36:58 ERROR]: Can't understand this condition/effect: connect to mysql (TSBeatz.sk, line 40: connect to mysql')
 
Skript Version: Skript 2.2 dev31c
Skript Author: Bensku
Minecraft Version: 1.12
MundoSK: 1.7.5-BETA.10.19
skDragon: 0.14.0
Skellett: 1.9.6b
SkQuery: 3.5.7-Lime
skRayFall: 1.9.10
SQLibrary: 7.1
Umbaska: 3.3

I am working on a stats system that should be connected to my forum.
And both codes do not work.
Can someone help me?




Script-Code 1
code_language.skript:
script options:
    $ db url jdbc:mysql://localhost:3306/<Your db name here>
    $ db username <username>
    $ db password <password>

Script-Code 1
code_language.skript:
[15:38:23 ERROR]: ':mysql://localhost:3306/' is not a valid item data (TSBeatz.sk, line 44: $ db url jdbc:mysql://localhost:3306/<Your db name here>')
[15:38:23 ERROR]: Can't understand this condition/effect: $ db username <username> (TSBeatz.sk, line 45: $ db username <username>')
[15:38:23 ERROR]: Can't understand this condition/effect: $ db password <password> (TSBeatz.sk, line 46: $ db password <password>')




Script-Code 2
code_language.skript:
on skript load:
    set mysql host to "127.0.0.1"
    set mysql port to 3306
    set mysql username to "root"
    set mysql password to "pass"
    set mysql database to "name"
    connect to mysql

Script-Code 2
code_language.skript:
[15:36:58 ERROR]: Can't understand this condition/effect: set mysql host to "127.0.0.1" (TSBeatz.sk, line 35: set mysql host to "127.0.0.1"')
[15:36:58 ERROR]: Can't understand this condition/effect: set mysql port to 3306 (TSBeatz.sk, line 36: set mysql port to 3306')
[15:36:58 ERROR]: Can't understand this condition/effect: set mysql username to "root" (TSBeatz.sk, line 37: set mysql username to "root"')
[15:36:58 ERROR]: Can't understand this condition/effect: set mysql password to "pass" (TSBeatz.sk, line 38: set mysql password to "pass"')
[15:36:58 ERROR]: Can't understand this condition/effect: set mysql database to "name" (TSBeatz.sk, line 39: set mysql database to "name"')
[15:36:58 ERROR]: Can't understand this condition/effect: connect to mysql (TSBeatz.sk, line 40: connect to mysql')
you shouldn't be using skellett or skquery for database shit. they are both insecure. the good sql addon is skript-db
 
Status
Not open for further replies.