Error Object Cannot Be Cast from DBNull to Other Types

Return to plugin
RustyBear

RustyBear

Customer
I reload on carbon and get:

c.reload CurrencySyncUnloaded plugin Currency Sync v1.0.0 by VisEntitiesLoaded plugin Currency Sync v1.0.0 by VisEntities [55ms][Currency Sync] Initialised and connected to MySQL - waiting for first balance list…MySql command callback raised an exception (Object reference not set to an instance of an object) at void Oxide.Plugins.CurrencySync.RefreshCurrencyCache(bool isFirstPull)+(List<Dictionary<string, object>> rows) => { } in /home/container/carbon/plugins/CurrencySync.cs:line 298 at bool Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle()+() => { } in /__w/Carbon/Carbon/Carbon.Core/Carbon.Components/Carbon.Common/src/Oxide/MySql/MySql.cs:line 273

I also got this on oxide:

MySql handle raised an exception in 'CurrencySync v1.0.0' plugin (InvalidCastException: Object cannot be cast from DBNull to other types.) at System.DBNull.System.IConvertible.ToInt32 (System.IFormatProvider provider) [0x00000] in <f98723dd4586469db5213ec59da723ca>:0 at System.Convert.ToInt32 (System.Object value, System.IFormatProvider provider) [0x00003] in <f98723dd4586469db5213ec59da723ca>:0 at MySql.Data.MySqlClient.Driver.LoadCharacterSets (MySql.Data.MySqlClient.MySqlConnection connection) [0x00079] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at MySql.Data.MySqlClient.Driver.Configure (MySql.Data.MySqlClient.MySqlConnection connection) [0x00060] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at MySql.Data.MySqlClient.MySqlConnection.Open () [0x00198] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x00059] in <021a1dba6a754e42a6cc7771fdfee190>:0 MySql handle raised an exception in 'CurrencySync v1.0.0' plugin (KeyNotFoundException: The given key '63' was not present in the dictionary.) at MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader (System.IAsyncResult result) [0x00022] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader(System.IAsyncResult) at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x0010e] in <021a1dba6a754e42a6cc7771fdfee190>:0 MySql command callback raised an exception (NullReferenceException: Object reference not set to an instance of an object) at Oxide.Plugins.CurrencySync+<>c__DisplayClass25_0.<RefreshCurrencyCache>b__0 (System.Collections.Generic.List1[T] rows) [0x00006] in &lt;b28e0d67499d49c391e7db15e199b8c9&gt;:0 at Oxide.Core.MySql.Libraries.MySql+MySqlQuery+<>c__DisplayClass24_0.<Handle>b__0 () [0x0005d] in <021a1dba6a754e42a6cc7771fdfee190>:0
 
You must log in or register to reply here.
Back
Top
Chat commands start with a /, while console commands can be entered directly in the F1 console or server console. Use find <keyword> in console to search for available commands related to the plugin. Parameters in < > are required, while [ ] are optional.
This plugin uses Oxide's permission system. Grant or revoke permissions using oxide.grant and oxide.revoke. You can assign them to individual players or groups using their Steam id or group name.
Settings are stored in the config file found under the config/ directory. You can edit this file manually, then reload the plugin to apply your changes.
Persistent data is saved in the data/ directory. This includes things like saved settings, usage stats, or player progress depending on the plugin. Deleting a data file will reset stored progress or customizations.
Language files are located in the lang/ folder. To translate messages, copy the en.json file into your target language folder (e.g. fr, de) and edit the values. Reload the plugin after changes to apply new messages.
This section lists public methods exposed by the plugin for use in other plugins. You can call these via the CallHook method. Ensure the plugin is loaded before calling its API to avoid null reference errors.
These are custom hooks that other plugins can listen for. Simply define a method with the same name and expected parameters in your plugin to handle the event. Hooks are triggered at key moments and are useful for extending or reacting to plugin behavior.
These hooks are injected into the game's code using Harmony. They let the plugin run code at key points in the game's internal logic. You can return values to block or modify behavior. Use with caution — these are powerful and can affect core mechanics.
Cart

Cart

Total -