search

codermanchris / redemrp_gameplay

A few custom jobs that I'm writing for the redem framework.
MIT License
10 stars 9 forks source link

Posse error MYSQL #1

Open SirFreddie opened 4 years ago

SirFreddie commented 4 years ago

Hi, im getting this error, and idk how to solve it

image

misnaged commented 4 years ago

As far as i know it needs to rebuild any db's scripts.

for example Helpers.GetCharacter(playerId, function(character) local realId = character.getSessionVar('realcharid') local query = 'insert into `posses` (Name, OwnerId) values (@Name, @OwnerId);' local params = { ['@Name'] = name, ['@OwnerId'] = realId }

should look like this Helpers.GetCharacter(playerId, function(character) MySQL.Async.execute('INSERT INTO posses (`Name`, `OwnerId`) VALUES (@Name, @OwnerId);', { Name = Name, OwnerId = realId, }, function(rowsChanged) end)