[Release] vSql - MySQL Async Library

FiveM Releases
,
41

Would be cool if you add feature from Mysql Async:

vSql.Async.execute

You pass Insert statement and it returns ID of inserted elemenet

42

Please read API section.

43

VsQL

This happens the first time after i put vSql on our server. I havent changed or altered any scripts before putting it . So i thought it might be vSql.

44

Currently when server is started, i get this error:



SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

SCRIPT ERROR in tick: System.NullReferenceException: Object reference not set to an instance of an object.

When I restart it, sometimes I get those errors and sometime I dont.

Getting this error quite often too:

SCRIPT ERROR in reference call: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index
45 
MySQL 3.2.0
.transaction...51 ms
.execute...49 ms
.fetchScalar...50 ms
.fetchAll...52 ms

vSql 1.3
.transaction...51 ms
.execute...52 ms
.fetchScalar...51 ms
.fetchAll...53 ms
2 Likes
46

Few quick questions;

  1. Will this at all help with disappearing items from player inventories?
  2. Can this be integrated on a Linux server? [I don’t think it would be but had to ask]

And just to verify; if I replace all the Mysql.Ready and if a resource uses MySQL.Sync.* method will I need to edit them to work with vSql.Async ?

47

Hi,

  1. No, it’s resource issue.
  2. Yes, it’s fully compatible with Linux.
  3. Yes, but you won’t be able to adapt it without decent programming skills, as sync and async modes are very different.
    You should avoid using resources with MySQL.Sync.* calls.
48

Are you able to expand on #1?

49

This resource is using to work with database.
It has nothing to do with inventory, player etc.
If you don’t understand the difference - you don’t need it.

51

VsQL
VsQL1172×1004 59.2 KB

52

Could you find the exact line of code which produces this error, please?

54

Fixed it, I tried to convert mysql.sync hehe

2 Likes
56

vSql 1.4

  • More server-friendly performance
  • Updated MySqlConnector to 0.61.0
  • Updated resource manifest format

Binaries: https://github.com/warxander/vSql/releases/tag/v1.4

57

Is vSql compact. with onesync?

58

Yes (5 ch)

60

So just leave MySQL.Sync methods alone ? I’m just converting ESX to use vSQL

61

No, this resource doesn’t support MySQL.Sync methods.
You need to remove them completely, as they greatly affects your server performance.

62

So with new version of vSync i need to replace all of my triggers on server side and resource lua?

63

Should i replace MySql.Sync = vSql.Async or only Mysql.Async = vSql.Async?

64

You can’t replace synchronous methods with async ones, because they have different behavior.