Jump to content

Recommended Posts

Posted
15 minutes ago, Gummibaum said:

Hey Xabi, exist a discord Group for this script?

Nope, there's no discord group.

Posted
2 hours ago, Jeromson said:

Hello,

I have not error on my server but the phone not found, how i configure it please ?
 

Thanks you

Jeromson.

I don't know if it's ready, didn't test it at all.

Posted (edited)

Hey awesome work ! ❤️ 

Unluckily i have problems to save the characterinformation to the "users" table in db

Someone here had it too .

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 'rank = 0, duty = 0, phone = 0, carKeys = '0,0,0,0,0', documentation = 0, license' 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)

 

Edited by kappi
Posted
1 minute ago, kappi said:

Hey awesome work ! ❤️ 

Unluckily i have problems to save the characterinformation to the "users" table in db

Someone here had i too 


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 'rank = 0, duty = 0, phone = 0, carKeys = '0,0,0,0,0', documentation = 0, license' 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)

 

You're using MySQL 8.0, right? If so, try with 5.6 or so, still have to test that with 8.0 to know where the bug could be. Maybe it's a new reserved word or something like that.

  • Like 1
Posted (edited)

Yes right. Cars get saved maybe something with the characterinformation. Thanks for your help. Really great what you did !

Edited by kappi
Posted
1 hour ago, kappi said:

Yes right. Cars get saved maybe something with the characterinformation. Thanks for your help. Really great what you did !

I updated the query, to make it work on MySQL 8.0 also.

  • Like 1
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...