Limework/skript-db
2
2
Fork 3
Code Issues 4 Pull Requests 1 Projects Releases 14 Wiki Activity

SQL INSERT DOES NOT WORK #11

New Issue
Closed
opened 2021-05-25 14:32:46 +00:00 by NiniMine · 7 comments
NiniMine commented 2021-05-25 14:32:46 +00:00 (Migrated from github.com)
Copy Link
Copy Source

What does it mean? (last sql error)
Invalid argument value: java.io.NotSerializableException

my code:
execute "INSERT INTO disky (id, title, description, pattern, type, addon_name, addon_link, addon_version, last_updated, event_values, event_cancellable, type_usage, depends, tags) VALUES (%{_id}%, %{_title}%, %{_description}%, %{_pattern}%, %{_type}%, %{_addon_name}%, %{addon_link}%, %{_addon_version}%, %{_last_updated}%, %{_event_values}%, %{_event_cacellable}%, %{_type_usage}%, %{_depends}%, %{_filtered_tags}%)" in {sql}

If I don't use variables, then it works. But I don't know if it's one variable or all variables.
The SQL Structure
image

What does it mean? (`last sql error`) `Invalid argument value: java.io.NotSerializableException` my code: `execute "INSERT INTO disky (id, title, description, pattern, type, addon_name, addon_link, addon_version, last_updated, event_values, event_cancellable, type_usage, depends, tags) VALUES (%{_id}%, %{_title}%, %{_description}%, %{_pattern}%, %{_type}%, %{_addon_name}%, %{addon_link}%, %{_addon_version}%, %{_last_updated}%, %{_event_values}%, %{_event_cacellable}%, %{_type_usage}%, %{_depends}%, %{_filtered_tags}%)" in {sql}` If I don't use variables, then it works. But I don't know if it's one variable or all variables. The SQL Structure ![image](https://user-images.githubusercontent.com/66845615/119516002-a65f8300-bd76-11eb-9b18-76db985de900.png)
GovindasOM commented 2021-05-25 14:46:10 +00:00 (Migrated from github.com)
Copy Link
Copy Source

this happens due to trying to insert unserializable data type, try to convert it to text

this happens due to trying to insert unserializable data type, try to convert it to text
NiniMine commented 2021-05-25 14:56:19 +00:00 (Migrated from github.com)
Copy Link
Copy Source

What exactly should I convert? the variables?

What exactly should I convert? the variables?
GovindasOM commented 2021-05-25 15:03:17 +00:00 (Migrated from github.com)
Copy Link
Copy Source

yes

yes
GovindasOM commented 2021-05-25 15:03:36 +00:00 (Migrated from github.com)
Copy Link
Copy Source

yes

yes
NiniMine commented 2021-05-25 15:09:03 +00:00 (Migrated from github.com)
Copy Link
Copy Source

Thank you, that works. Another question: What does this warning mean? [Skript] Cannot write variables to the database 'default' at sufficient speed; server performance may suffer and many variables will be lost if the server crashes. (this warning will be repeated at most once every 10 seconds)

Thank you, that works. Another question: What does this warning mean? `[Skript] Cannot write variables to the database 'default' at sufficient speed; server performance may suffer and many variables will be lost if the server crashes. (this warning will be repeated at most once every 10 seconds)`
GovindasOM commented 2021-05-25 15:23:46 +00:00 (Migrated from github.com)
Copy Link
Copy Source

you are modifying disk variables too often, not related to this addon

you are modifying disk variables too often, not related to this addon
NiniMine commented 2021-05-25 15:27:34 +00:00 (Migrated from github.com)
Copy Link
Copy Source

okay thanks

okay thanks
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
Something isn't working
 documentation
Improvements or additions to documentation
 duplicate
This issue or pull request already exists
 enhancement
New feature or request
 good first issue
Good for newcomers
 help wanted
Extra attention is needed
 invalid
This doesn't seem right
 question
Further information is requested
 wontfix
This will not be worked on
No Label question
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
Govindas ham1255 rigbot
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Limework/skript-db#11
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?