Smileey

[Source] Reallife/Roleplay Script

Recommended Posts

Char Id: 0
headOverlays Missing Key: bodyBlemishes
headOverlays Missing Key: addBodyBlemishes
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`rageleer`.`characters_customization`, CONSTRAINT `FK_characters_customization_characters` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
   at MySqlPacket MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at int MySql.Data.MySqlClient.NativeDriver.GetResult(ref int affectedRow, ref long insertedId)
   at ResultSet MySql.Data.MySqlClient.Driver.NextResult(int statementId, bool force)
   at bool MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySqlDataReader MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at int MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at void Roleplay.Login.Character.CreateCharacter(Client c, int hair, bool isMale, string headBlendJStr, byte eyeColor, byte hairColor, byte hightlightColor, string faceFeaturesStr, string headOverlaysJStr, string decorationJStr) in :line 384
   --- End of inner exception stack trace ---
   at object RuntimeMethodHandle.InvokeMethod(object target, object[] arguments, Signature sig, bool constructor)
   at object System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(object obj, object[] parameters, object[] arguments)
   at void GTANetworkInternals.RemoteEventParser.Parse(Client sender, ulong eventNameHash, object[] args) in C:\Users\Adam\Documents\Git\comp-layer2\BootstrapperNC\Handlers\ResourceInfo.cs:line 62
   at void GTANetworkInternals.RemoteEventHandler.Parse(Client sender, ulong eventNameHash, object[] arguments) in C:\Users\Adam\Documents\Git\comp-layer2\BootstrapperNC\Handlers\ResourceInfo.cs:line 67

beötige hilfe

Share this post


Link to post
Share on other sites
vor 5 Stunden schrieb Starblocks:

war bei mir genau anderst der Fall, bei kollegen auch

Hm, ok komisch. Vielleicht berichtet er uns ja was es nun war :D

 

  • Like 1

Share this post


Link to post
Share on other sites
Am 19.1.2020 um 10:52 schrieb ImmerAmSchlafen:

Char Id: 0
headOverlays Missing Key: bodyBlemishes
headOverlays Missing Key: addBodyBlemishes
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`rageleer`.`characters_customization`, CONSTRAINT `FK_characters_customization_characters` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
   at MySqlPacket MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at int MySql.Data.MySqlClient.NativeDriver.GetResult(ref int affectedRow, ref long insertedId)
   at ResultSet MySql.Data.MySqlClient.Driver.NextResult(int statementId, bool force)
   at bool MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySqlDataReader MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at int MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at void Roleplay.Login.Character.CreateCharacter(Client c, int hair, bool isMale, string headBlendJStr, byte eyeColor, byte hairColor, byte hightlightColor, string faceFeaturesStr, string headOverlaysJStr, string decorationJStr) in :line 384
   --- End of inner exception stack trace ---
   at object RuntimeMethodHandle.InvokeMethod(object target, object[] arguments, Signature sig, bool constructor)
   at object System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(object obj, object[] parameters, object[] arguments)
   at void GTANetworkInternals.RemoteEventParser.Parse(Client sender, ulong eventNameHash, object[] args) in C:\Users\Adam\Documents\Git\comp-layer2\BootstrapperNC\Handlers\ResourceInfo.cs:line 62
   at void GTANetworkInternals.RemoteEventHandler.Parse(Client sender, ulong eventNameHash, object[] arguments) in C:\Users\Adam\Documents\Git\comp-layer2\BootstrapperNC\Handlers\ResourceInfo.cs:line 67

beötige hilfe

sieht aus als hätte dein datenbank benutzer keine rechte was an der Datenbank zu ändern?

Oder hast du die Datenbank überhaupt hochgeladen

Share this post


Link to post
Share on other sites

Kann mir jemand helfen zu fixen das wenn man neu aufm Server ist das man keine admin Rechte hat und erst beim Rejoin normal ist ??

Share this post


Link to post
Share on other sites
Am 29.12.2019 um 15:34 schrieb XCRON:

Kleiner Fix für das Login Problem, womit alle Leute nach der Accounterstellung Adminrechte haben:

Serverside: Player\Commands.cs

        [RemoteEvent("firstlogin")]
        public void HandleFirstLogin(Client c)
        {
            c.Kick();
        }

Clientside: Character\Main.js

mp.events.add('FinishCharacter', () => {
    charBrowser.destroy();
	if (mp.gui.cursor.visible) {
	    mp.gui.cursor.show(false, false);	
	}
	mp.gui.chat.activate(true);
	mp.gui.chat.show(true);
	mp.events.callRemote("firstlogin", player);
});


So werden die Leute nachdem sie den Account bzw. Char erstellt haben einmal gekickt, im anschließenden Login haben diese keine Rechte mehr.

Hier

  • Like 2

Share this post


Link to post
Share on other sites

Danke für das Zitat. Fall es hierzu fragen gibt einfach melden.

Share this post


Link to post
Share on other sites

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> 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 ', creation FROM accounts WHERE name = 'test'' at line 1
   at MySqlPacket MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at int MySql.Data.MySqlClient.NativeDriver.GetResult(ref int affectedRow, ref long insertedId)
   at ResultSet MySql.Data.MySqlClient.Driver.NextResult(int statementId, bool force)
   at bool MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySqlDataReader MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at void Roleplay.Login.LoginHandler.LoginAccount(Client c, string user, string pass) in :line 150
   --- End of inner exception stack trace ---
   at object RuntimeMethodHandle.InvokeMethod(object target, object[] arguments, Signature sig, bool constructor)
   at object System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(object obj, object[] parameters, object[] arguments)
   at void GTANetworkInternals.RemoteEventParser.Parse(Client sender, ulong eventNameHash, object[] args) in C:\Users\Adam\Documents\Git\comp-layer2\BootstrapperNC\Handlers\ResourceInfo.cs:line 62
   at void GTANetworkInternals.RemoteEventHandler.Parse(Client sender, ulong eventNameHash, object[] arguments) in C:\Users\Adam\Documents\Git\comp-layer2\BootstrapperNC\Handlers\ResourceInfo.cs:line 67

Share this post


Link to post
Share on other sites
vor 6 Stunden schrieb ermakovsm:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> 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 ', creation FROM accounts WHERE name = 'test'' at line 1
   at MySqlPacket MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at int MySql.Data.MySqlClient.NativeDriver.GetResult(ref int affectedRow, ref long insertedId)
   at ResultSet MySql.Data.MySqlClient.Driver.NextResult(int statementId, bool force)
   at bool MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySqlDataReader MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at void Roleplay.Login.LoginHandler.LoginAccount(Client c, string user, string pass) in :line 150
   --- End of inner exception stack trace ---
   at object RuntimeMethodHandle.InvokeMethod(object target, object[] arguments, Signature sig, bool constructor)
   at object System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(object obj, object[] parameters, object[] arguments)
   at void GTANetworkInternals.RemoteEventParser.Parse(Client sender, ulong eventNameHash, object[] args) in C:\Users\Adam\Documents\Git\comp-layer2\BootstrapperNC\Handlers\ResourceInfo.cs:line 62
   at void GTANetworkInternals.RemoteEventHandler.Parse(Client sender, ulong eventNameHash, object[] arguments) in C:\Users\Adam\Documents\Git\comp-layer2\BootstrapperNC\Handlers\ResourceInfo.cs:line 67

Eine genauere Info wäre etwas von vorteil.

Hast du schon was am script geändert?

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.