SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 09/05/2020, 02:28 PM   #1
PrednizoN
Big Clucker
 
Join Date: Sep 2014
Posts: 90
Reputation: 1
Default [ERROR] cache_get_row_int - invalid data type

what exactly is the problem?


Code:
[16:49:28] [ERROR] cache_get_row_int - invalid data type
[16:50:18] [ERROR] cache_get_row_int - invalid data type
[16:51:11] [ERROR] cache_get_row_int - invalid data type
[16:53:10] [ERROR] cache_get_row_int - invalid data type
[16:56:42] [ERROR] cache_get_row_int - invalid data type
[16:57:23] [ERROR] cache_get_row_int - invalid data type
[16:58:04] [ERROR] cache_get_row_int - invalid data type
[16:59:23] [ERROR] cache_get_row_int - invalid data type
[17:00:51] [ERROR] cache_get_row_int - invalid data type
[17:00:59] [ERROR] cache_get_row_int - invalid data type
[17:01:36] [ERROR] cache_get_row_int - invalid data type
[17:01:44] [ERROR] cache_get_row_int - invalid data type
[17:02:14] [ERROR] cache_get_row_int - invalid data type
[17:03:42] [ERROR] cache_get_row_int - invalid data type
[17:06:13] [ERROR] cache_get_row_int - invalid data type
[17:09:26] [ERROR] cache_get_row_int - invalid data type
[17:10:33] [ERROR] cache_get_row_int - invalid data type
[17:11:26] [ERROR] cache_get_row_int - invalid data type
[17:11:30] [ERROR] cache_get_row_int - invalid data type
[17:12:31] [ERROR] cache_get_row_int - invalid data type
[17:13:46] [ERROR] cache_get_row_int - invalid data type
[17:15:23] [ERROR] cache_get_row_int - invalid data type
[17:15:26] [ERROR] cache_get_row_int - invalid data type
[17:16:22] [ERROR] cache_get_row_int - invalid data type
[17:18:39] [ERROR] cache_get_row_int - invalid data type
[17:19:49] [ERROR] cache_get_row_int - invalid data type
[17:20:14] [ERROR] cache_get_row_int - invalid data type
[17:22:33] [ERROR] cache_get_row_int - invalid data type
[17:23:35] [ERROR] cache_get_row_int - invalid data type
PrednizoN is offline   Reply With Quote
Old 09/05/2020, 02:49 PM   #2
Calisthenics
High-roller
 
Join Date: May 2018
Posts: 1,228
Reputation: 205
Default Re: [ERROR] cache_get_row_int - invalid data type

Trying to fetch data that is not integer.
__________________
Calisthenics is offline   Reply With Quote
Old 09/05/2020, 04:15 PM   #3
PrednizoN
Big Clucker
 
Join Date: Sep 2014
Posts: 90
Reputation: 1
Default Re: [ERROR] cache_get_row_int - invalid data type

Quote:
Originally Posted by Calisthenics View Post
Trying to fetch data that is not integer.
What should I do to solve this problem?
PrednizoN is offline   Reply With Quote
Old 09/05/2020, 04:21 PM   #4
Adamoneoone
Huge Clucker
 
Join Date: Sep 2014
Posts: 496
Reputation: 37
Default Re: [ERROR] cache_get_row_int - invalid data type

He told you the issue, you are trying to fetch data using the wrong function. If you're trying to get floats, use
Quote:
cache_get_row_float
if you're trying to get a string
Quote:
cache_get_row
__________________
If you want to have your own custom script, or even want to have one of our already released scripts, join our SCRIPTING SERVICES DISCORD, or send me a private message!
Adamoneoone is offline   Reply With Quote
Old 10/05/2020, 08:45 AM   #5
PrednizoN
Big Clucker
 
Join Date: Sep 2014
Posts: 90
Reputation: 1
Default Re: [ERROR] cache_get_row_int - invalid data type

Quote:
Originally Posted by Adamoneoone View Post
He told you the issue, you are trying to fetch data using the wrong function. If you're trying to get floats, use if you're trying to get a string
I tried to change them, but I get errors everywhere. I have little experience with mysql. I need detailed help: /
PrednizoN is offline   Reply With Quote
Old 10/05/2020, 10:01 AM   #6
BaFFyJunior
Big Clucker
 
Join Date: May 2018
Posts: 76
Reputation: 0
Default Re: [ERROR] cache_get_row_int - invalid data type

Why don't you use cache_get_field_content?
https://wiki.sa-mp.com/wiki/MySQL/R3...ld_content_int
https://wiki.sa-mp.com/wiki/MySQL/R33#cache_get_row_int
Show use the lines where you get those errors.
__________________
BaFFyJunior is offline   Reply With Quote
Old 10/05/2020, 10:09 AM   #7
Proxus
Huge Clucker
 
Proxus's Avatar
 
Join Date: May 2018
Location: United Kingdom
Posts: 440
Reputation: 20
Default Re: [ERROR] cache_get_row_int - invalid data type

Quote:
Originally Posted by BaFFyJunior View Post
Why don't you use cache_get_field_content?
https://wiki.sa-mp.com/wiki/MySQL/R3...ld_content_int
https://wiki.sa-mp.com/wiki/MySQL/R33#cache_get_row_int
Show use the lines where you get those errors.
Why are you telling him to use an outdated version of MySQL? R33 is outdated, use R40 instead.
__________________
Developer @ Trucknation
"Never tell people how to do things. Tell them what to do and they will surprise you with their ingenuity"


IMPORTANT LINKS
An upcoming mix of trucking & light roleplay
Proxus is offline   Reply With Quote
Old 10/05/2020, 10:36 AM   #8
BaFFyJunior
Big Clucker
 
Join Date: May 2018
Posts: 76
Reputation: 0
Default Re: [ERROR] cache_get_row_int - invalid data type

Quote:
Originally Posted by Proxus View Post
Why are you telling him to use an outdated version of MySQL? R33 is outdated, use R40 instead.
He could be using mysql r39-6.
__________________
BaFFyJunior is offline   Reply With Quote
Old 10/05/2020, 10:38 AM   #9
jasperschellekens
High-roller
 
jasperschellekens's Avatar
 
Join Date: Dec 2016
Location: Holland
Posts: 1,070
Reputation: 106
Default Re: [ERROR] cache_get_row_int - invalid data type

Quote:
Originally Posted by Proxus View Post
Why are you telling him to use an outdated version of MySQL? R33 is outdated, use R40 instead.
Because this person has no Idea and is posting bullshit everywhere
__________________
If you want to have your own custom script, or even want to have one of our already released scripts, join our SCRIPTING SERVICES DISCORD, or send me a private message!


Undead Wasteland Roleplay - The year is 1996. San Andreas is a wasteland ruled by the undead. the once so glorius landscape of San Andreas, is now a shattered decayed place that is only a vague memory of the world as we used to know it.
Discord - Website
jasperschellekens is offline   Reply With Quote
Old 10/05/2020, 10:40 AM   #10
BaFFyJunior
Big Clucker
 
Join Date: May 2018
Posts: 76
Reputation: 0
Default Re: [ERROR] cache_get_row_int - invalid data type

Quote:
Originally Posted by jasperschellekens View Post
Because this person has no Idea and is posting bullshit everywhere
=)) Yeah, of course ) If he has that version of mysql I should suggest him to update an entire system for 1 problem? ))
__________________
BaFFyJunior 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
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
cache_get_row_int error Japanda Scripting Help 2 15/12/2015 04:36 PM


All times are GMT. The time now is 04:55 AM.


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