Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [vRP/C#] query exception vRP/create_married_column : System.AggregateException: One or more errors occurred. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS Married varchar(255) DEFAULT 0' at line 1
- at MySql.Data.Serialization.PayloadData.ThrowIfError () [0x0001d] in <c9032194188746cfa5d8bb7625c7912b>:0
- at MySql.Data.Serialization.MySqlSession.TryAsyncContinuation (System.Threading.Tasks.Task`1[TResult] task) [0x00023] in <c9032194188746cfa5d8bb7625c7912b>:0
- at (wrapper delegate-invoke) System.Func`2[System.Threading.Tasks.Task`1[System.ArraySegment`1[System.Byte]],MySql.Data.Serialization.PayloadData].invoke_TResult_T(System.Threading.Tasks.Task`1<System.ArraySegment`1<byte>>)
- at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Threading.Tasks.Task.Execute () [0x00000] in <4fffd39960df419684f9b9cb5ce46688>:0
- --- End of stack trace from previous location where exception was thrown ---
- at MySql.Data.MySqlClient.MySqlDataReader.ActivateResultSet (MySql.Data.MySqlClient.Results.ResultSet resultSet) [0x0000e] in <c9032194188746cfa5d8bb7625c7912b>:0
- at MySql.Data.MySqlClient.MySqlDataReader.ReadFirstResultSetAsync (MySql.Data.Protocol.Serialization.IOBehavior ioBehavior) [0x000b0] in <c9032194188746cfa5d8bb7625c7912b>:0
- at MySql.Data.MySqlClient.MySqlDataReader.CreateAsync (MySql.Data.MySqlClient.MySqlCommand command, System.Data.CommandBehavior behavior, MySql.Data.Protocol.Serialization.IOBehavior ioBehavior) [0x0016e] in <c9032194188746cfa5d8bb7625c7912b>:0
- at MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor.ExecuteReaderAsync (System.String commandText, MySql.Data.MySqlClient.MySqlParameterCollection parameterCollection, System.Data.CommandBehavior behavior, MySql.Data.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x001ea] in <c9032194188746cfa5d8bb7625c7912b>:0
- at vRP.MySQL+<>c__DisplayClass11_2.<e_query>b__0 () [0x003e9] in <8dfc0861f4df44189d833de5e878b97b>:0
- --- End of inner exception stack trace ---
- ---> (Inner Exception #0) MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS Married varchar(255) DEFAULT 0' at line 1
- at MySql.Data.Serialization.PayloadData.ThrowIfError () [0x0001d] in <c9032194188746cfa5d8bb7625c7912b>:0
- at MySql.Data.Serialization.MySqlSession.TryAsyncContinuation (System.Threading.Tasks.Task`1[TResult] task) [0x00023] in <c9032194188746cfa5d8bb7625c7912b>:0
- at (wrapper delegate-invoke) System.Func`2[System.Threading.Tasks.Task`1[System.ArraySegment`1[System.Byte]],MySql.Data.Serialization.PayloadData].invoke_TResult_T(System.Threading.Tasks.Task`1<System.ArraySegment`1<byte>>)
- at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Threading.Tasks.Task.Execute () [0x00000] in <4fffd39960df419684f9b9cb5ce46688>:0
- --- End of stack trace from previous location where exception was thrown ---
- at MySql.Data.MySqlClient.MySqlDataReader.ActivateResultSet (MySql.Data.MySqlClient.Results.ResultSet resultSet) [0x0000e] in <c9032194188746cfa5d8bb7625c7912b>:0
- at MySql.Data.MySqlClient.MySqlDataReader.ReadFirstResultSetAsync (MySql.Data.Protocol.Serialization.IOBehavior ioBehavior) [0x000b0] in <c9032194188746cfa5d8bb7625c7912b>:0
- at MySql.Data.MySqlClient.MySqlDataReader.CreateAsync (MySql.Data.MySqlClient.MySqlCommand command, System.Data.CommandBehavior behavior, MySql.Data.Protocol.Serialization.IOBehavior ioBehavior) [0x0016e] in <c9032194188746cfa5d8bb7625c7912b>:0
- at MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor.ExecuteReaderAsync (System.String commandText, MySql.Data.MySqlClient.MySqlParameterCollection parameterCollection, System.Data.CommandBehavior behavior, MySql.Data.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x001ea] in <c9032194188746cfa5d8bb7625c7912b>:0
- at vRP.MySQL+<>c__DisplayClass11_2.<e_query>b__0 () [0x003e9] in <8dfc0861f4df44189d833de5e878b97b>:0 <---
- Stacktrace:
- at <unknown> <0xffffffff>
- at (wrapper managed-to-native) CitizenFX.Core.GameInterface.WalkStackBoundary (string,byte[],byte[],byte[]&) [0x0000a] in <94e53bb248f84d8ba0d08db39dc381e9>:0
- at CitizenFX.Core.InternalManager.WalkStack (byte[],byte[]) [0x00000] in /src/code/client/clrcore/InternalManager.cs:253
- at (wrapper remoting-invoke-with-check) CitizenFX.Core.InternalManager.WalkStack (byte[],byte[]) [0x00034] in <94e53bb248f84d8ba0d08db39dc381e9>:0
- at (wrapper xdomain-dispatch) CitizenFX.Core.InternalManager.WalkStack (object,byte[]&,byte[]&,byte[],byte[]) [0x00054] in <94e53bb248f84d8ba0d08db39dc381e9>:0
- at (wrapper xdomain-invoke) CitizenFX.Core.InternalManager.WalkStack (byte[],byte[]) <0x00151>
- at (wrapper remoting-invoke-with-check) CitizenFX.Core.InternalManager.WalkStack (byte[],byte[]) [0x00028] in <94e53bb248f84d8ba0d08db39dc381e9>:0
- at CitizenFX.Core.MonoScriptRuntime.WalkStack (byte[],int,byte[],int,CitizenFX.Core.IScriptStackWalkVisitor) <0x0005b>
- at (wrapper cominterop) CitizenFX.Core.IScriptStackWalkingRuntime.WalkStack (intptr,byte[],int,byte[],int,CitizenFX.Core.IScriptStackWalkVisitor) <0x0005a>
- at (wrapper native-to-managed) CitizenFX.Core.IScriptStackWalkingRuntime.WalkStack (intptr,intptr,int,intptr,int,intptr) <0x00343>
- at <unknown> <0xffffffff>
- at (wrapper xdomain-dispatch) CitizenFX.Core.MonoScriptRuntime/WrapScriptHost.InvokeNative (object,byte[]&,byte[]&) <0x0025f>
- at (wrapper xdomain-invoke) CitizenFX.Core.MonoScriptRuntime/WrapScriptHost.InvokeNative (intptr) [0x0006b] in <94e53bb248f84d8ba0d08db39dc381e9>:0
- at CitizenFX.Core.ScriptContext.InvokeInternal (CitizenFX.Core.fxScriptContext*,ulong,CitizenFX.Core.IScriptHost) [0x00007] in /src/code/client/clrcore/ScriptContext.cs:343
- at CitizenFX.Core.ScriptContext.InvokeInternal (ulong,CitizenFX.Core.IScriptHost) [0x00014] in /src/code/client/clrcore/ScriptContext.cs:330
- at CitizenFX.Core.ScriptContext.Invoke (ulong,CitizenFX.Core.IScriptHost) [0x00000] in /src/code/client/clrcore/ScriptContext.cs:321
- at CitizenFX.Core.Native.Function.InvokeInternal (CitizenFX.Core.Native.Hash,System.Type,CitizenFX.Core.Native.InputArgument[]) [0x00022] in /src/code/client/clrcore/Native.cs:28
- at CitizenFX.Core.Native.Function.Call (CitizenFX.Core.Native.Hash,CitizenFX.Core.Native.InputArgument[]) [0x00000] in /src/code/client/clrcore/Native.cs:16
- at CitizenFX.Core.BaseScript.TriggerEventInternal (string,byte[],bool) [0x00029] in /src/code/client/clrcore/BaseScript.cs:262
- at CitizenFX.Core.BaseScript.TriggerEvent (string,object[]) [0x00007] in /src/code/client/clrcore/BaseScript.cs:156
- at vRP.MySQL.e_tick () [0x001f3] in <8dfc0861f4df44189d833de5e878b97b>:0
- at (wrapper runtime-invoke) object.runtime_invoke_void__this__ (object,intptr,intptr,intptr) [0x0004f] in <4fffd39960df419684f9b9cb5ce46688>:0
- at <unknown> <0xffffffff>
- at (wrapper managed-to-native) System.Reflection.MonoMethod.InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&) [0x00016] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Reflection.MonoMethod.Invoke (object,System.Reflection.BindingFlags,System.Reflection.Binder,object[],System.Globalization.CultureInfo) [0x00041] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Reflection.MethodBase.Invoke (object,object[]) [0x00006] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Delegate.DynamicInvokeImpl (object[]) [0x000e9] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.MulticastDelegate.DynamicInvokeImpl (object[]) [0x0000a] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Delegate.DynamicInvoke (object[]) [0x00002] in <4fffd39960df419684f9b9cb5ce46688>:0
- at CitizenFX.Core.EventHandlerEntry/<Invoke>d__5.MoveNext () [0x00064] in /src/code/client/clrcore/EventHandlerDictionary.cs:89
- at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start<CitizenFX.Core.EventHandlerEntry/<Invoke>d__5> (CitizenFX.Core.EventHandlerEntry/<Invoke>d__5&) [0x00033] in <4fffd39960df419684f9b9cb5ce46688>:0
- at CitizenFX.Core.EventHandlerEntry.Invoke (string,object[]) [0x00037] in <94e53bb248f84d8ba0d08db39dc381e9>:0
- at CitizenFX.Core.EventHandlerDictionary/<Invoke>d__4.MoveNext () [0x00028] in /src/code/client/clrcore/EventHandlerDictionary.cs:51
- at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start<CitizenFX.Core.EventHandlerDictionary/<Invoke>d__4> (CitizenFX.Core.EventHandlerDictionary/<Invoke>d__4&) [0x00033] in <4fffd39960df419684f9b9cb5ce46688>:0
- at CitizenFX.Core.EventHandlerDictionary.Invoke (string,string,object[]) [0x0003f] in <94e53bb248f84d8ba0d08db39dc381e9>:0
- at CitizenFX.Core.InternalManager/<>c__DisplayClass33_2.<TriggerEvent>b__0 () [0x0002f] in /src/code/client/clrcore/InternalManager.cs:368
- at System.Threading.Tasks.Task`1<TResult_REF>.InnerInvoke () [0x00011] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Threading.Tasks.Task.Execute () [0x00001] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Threading.Tasks.Task.ExecutionContextCallback (object) [0x00006] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Threading.ExecutionContext.RunInternal (System.Threading.ExecutionContext,System.Threading.ContextCallback,object,bool) [0x00073] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Threading.ExecutionContext.Run (System.Threading.ExecutionContext,System.Threading.ContextCallback,object,bool) [0x00004] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Threading.Tasks.Task.ExecuteWithThreadLocal (System.Threading.Tasks.Task&) [0x00038] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Threading.Tasks.Task.ExecuteEntry (bool) [0x00050] in <4fffd39960df419684f9b9cb5ce46688>:0
- at System.Threading.Tasks.TaskScheduler.TryExecuteTask (System.Threading.Tasks.Task) [0x00016] in <4fffd39960df419684f9b9cb5ce46688>:0
- at CitizenFX.Core.CitizenTaskScheduler.InvokeTryExecuteTask (System.Threading.Tasks.Task) [0x00000] in /src/code/client/clrcore/CitizenTaskScheduler.cs:168
- at CitizenFX.Core.CitizenTaskScheduler.Tick () [0x00097] in /src/code/client/clrcore/CitizenTaskScheduler.cs:133
- at CitizenFX.Core.InternalManager.TriggerEvent (string,byte[],string) [0x0015f] in /src/code/client/clrcore/InternalManager.cs:384
- at (wrapper remoting-invoke-with-check) CitizenFX.Core.InternalManager.TriggerEvent (string,byte[],string) [0x00035] in <94e53bb248f84d8ba0d08db39dc381e9>:0
- at (wrapper xdomain-dispatch) CitizenFX.Core.InternalManager.TriggerEvent (object,byte[]&,byte[]&,string,byte[],string) [0x00061] in <94e53bb248f84d8ba0d08db39dc381e9>:0
- at (wrapper xdomain-invoke) CitizenFX.Core.InternalManager.TriggerEvent (string,byte[],string) <0x0015e>
- at (wrapper remoting-invoke-with-check) CitizenFX.Core.InternalManager.TriggerEvent (string,byte[],string) [0x00029] in <94e53bb248f84d8ba0d08db39dc381e9>:0
- at CitizenFX.Core.MonoScriptRuntime.TriggerEvent (string,byte[],int,string) <0x0005b>
- at (wrapper cominterop) CitizenFX.Core.IScriptEventRuntime.TriggerEvent (intptr,string,byte[],int,string) <0x00052>
- at (wrapper native-to-managed) CitizenFX.Core.IScriptEventRuntime.TriggerEvent (intptr,intptr,intptr,int,intptr) <0x0014b>
- /proc/self/maps:
- 40252000-404aa000 rwxp 00000000 00:00 0
- 40542000-40552000 rwxp 00000000 00:00 0
- 40b35000-40c15000 rwxp 00000000 00:00 0
- 40d93000-40e83000 rwxp 00000000 00:00 0
- 419c4000-41b69000 rwxp 00000000 00:00 0
- 6c327f00000-6c327f80000 rw-p 00000000 00:00 0
- 1065c4900000-1065c4903000 rw-p 00000000 00:00 0
- 1065c4903000-1065c4980000 r--p 00000000 00:00 0
- 115f18c00000-115f18c2f000 rw-p 00000000 00:00 0
- 15044fb80000-15044fb83000 rw-p 00000000 00:00 0
- 194db56d6000-194db5700000 ---p 00000000 00:00 0
- 194db5700000-194db5703000 rw-p 00000000 00:00 0
- 194db5703000-194db5704000 ---p 00000000 00:00 0
- 194db5704000-194db577f000 r-xp 00000000 00:00 0
- 194db577f000-194dbd6d6000 ---p 00000000 00:00 0
- 2875a1764000-2875a176c000 rw-p 00000000 00:00 0
- 2c8d77a00000-2c8d77a80000 rw-p 00000000 00:00 0
- 36fe50900000-36fe50980000 rw-p 00000000 00:00 0
- 7f826b824000-7f826bc9b000 rw-p 00000000 00:00 0
- 7f826be9f000-7f826c0ed000 rw-p 00000000 00:00 0
- 7f826c8e0000-7f826c8e2000 ---p 00000000 00:00 0
- 7f826c8e2000-7f826c8e3000 rw-p 00000000 00:00 0
- 7f826c8e3000-7f826c8eb000 ---p 00000000 00:00 0
- 7f826c8eb000-7f826cb24000 rw-p 00000000 00:00 0 [stack:8600]
- 7f826cb24000-7f826cb26000 ---p 00000000 00:00 0
- SCRIPT ERROR: [string "vrp_mysql/MySQL.lua"]:48: attempt to index a nil value (global 'r')
- > fn (@vrp_mysql/init.lua:3)
Advertisement
Add Comment
Please, Sign In to add comment