SQL INSERT DOES NOT WORK #11

New Issue

2021-05-25T14:32:46Z

NiniMine commented

2021-05-25 14:32:46 +00:00

(Migrated from github.com)

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

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)

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)

What exactly should I convert? the variables?

GovindasOM commented

2021-05-25 15:03:17 +00:00

(Migrated from github.com)

yes

GovindasOM commented

2021-05-25 15:03:36 +00:00

(Migrated from github.com)

yes

NiniMine commented

2021-05-25 15:09:03 +00:00

(Migrated from github.com)

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)

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)

okay thanks

Sign in to join this conversation.