SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 13/05/2020, 06:14 AM   #1
PrednizoN
Big Clucker
 
Join Date: Sep 2014
Posts: 90
Reputation: 1
Default MYSQL [ERROR] cache_get_row_int - invalid data type

Hi everyone, This warning is constantly logged in the mysql_log file. Whenever a new player enters, this error is rewritten.

In my mysql_log File;
Code:
[18:11:07] [ERROR] cache_get_row_int - invalid data type
[09:51:44] [ERROR] cache_get_row_int - invalid data type
[13:23:07] [ERROR] cache_get_row_int - invalid data type
[13:27:51] [ERROR] cache_get_row_int - invalid data type
[13:33:13] [ERROR] cache_get_row_int - invalid data type
[13:35:14] [ERROR] cache_get_row_int - invalid data type
[13:55:48] [ERROR] cache_get_row_int - invalid data type
[13:56:55] [ERROR] cache_get_row_int - invalid data type
[13:58:01] [ERROR] cache_get_row_int - invalid data type
[14:03:16] [ERROR] cache_get_row_int - invalid data type
[14:09:00] [ERROR] cache_get_row_int - invalid data type
[19:51:01] [ERROR] cache_get_row_int - invalid data type
[19:55:40] [ERROR] cache_get_row_int - invalid data type
[20:01:00] [ERROR] cache_get_row_int - invalid data type
[20:12:10] [ERROR] cache_get_row_int - invalid data type
[20:16:44] [ERROR] cache_get_row_int - invalid data type
[20:34:01] [ERROR] cache_get_row_int - invalid data type
[20:36:13] [ERROR] cache_get_row_int - invalid data type

In my gamemode lines;
https://imgur.com/cgCeSyL

And my mysql database;
https://imgur.com/5MbcIzn
PrednizoN is offline   Reply With Quote
Old 13/05/2020, 08:54 AM   #2
Calisthenics
High-roller
 
Join Date: May 2018
Posts: 1,229
Reputation: 205
Default Re: MYSQL [ERROR] cache_get_row_int - invalid data type

`email` is not an integer.

pawn Code:
//native cache_get_row(row, field_idx, destination[], connectionHandle = 1, max_len = sizeof(destination));
cache_get_row(0, 15, PlayerInfo[playerid][Email], dbHandle, 128);

Use the same way for `LastIP` and `RegIP`.
__________________
Calisthenics is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[ERROR] cache_get_row_int - invalid data type PrednizoN Scripting Help 12 10/05/2020 10:44 AM
House System Problem [ERROR] cache_get_row_int - invalid datatype ShahinJBR Scripting Help 9 17/07/2019 08:08 AM
cache_get_row_int - Invalid datatype Romero837 Scripting Help 8 22/07/2017 09:18 PM
MySQL fetching data error invalid data type - NULL Hargrave Scripting Help 1 16/07/2016 04:23 PM


All times are GMT. The time now is 05:36 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.