SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 26/03/2018, 11:28 PM   #11
oSAINTo
Huge Clucker
 
oSAINTo's Avatar
 
Join Date: Aug 2015
Posts: 204
Reputation: 35
Default Re: MySQL Variable/Enum is using cached data instead of updating

Quote:
Originally Posted by Grim_ View Post
Can you post the SQL log of the queries? That should tell us something.
Heh, mind telling me where I can locate that? I've never checked the SQL logs before. (Yeah, yeah, noob. I know.) Just never had to. q.q
oSAINTo is offline   Reply With Quote
Old 26/03/2018, 11:34 PM   #12
Grim_
High-roller
 
Grim_'s Avatar
 
Join Date: Sep 2008
Location: United States
Posts: 2,862
Reputation: 118
Default Re: MySQL Variable/Enum is using cached data instead of updating

Should be in the server directory. MySQL_log.txt or something like that.
Grim_ is offline   Reply With Quote
Old 26/03/2018, 11:38 PM   #13
oSAINTo
Huge Clucker
 
oSAINTo's Avatar
 
Join Date: Aug 2015
Posts: 204
Reputation: 35
Default Re: MySQL Variable/Enum is using cached data instead of updating

Quote:
Originally Posted by Grim_ View Post
Should be in the server directory. MySQL_log.txt or something like that.
I just checked the mysql_log.txt file and it hasn't logged anything.
oSAINTo is offline   Reply With Quote
Old 27/03/2018, 12:10 AM   #14
oSAINTo
Huge Clucker
 
oSAINTo's Avatar
 
Join Date: Aug 2015
Posts: 204
Reputation: 35
Default Re: MySQL Variable/Enum is using cached data instead of updating

Here's the video showcasing my problem, just incase anyone wants a visual(just click the thumbnail):
oSAINTo is offline   Reply With Quote
Old 27/03/2018, 12:39 AM   #15
Grim_
High-roller
 
Grim_'s Avatar
 
Join Date: Sep 2008
Location: United States
Posts: 2,862
Reputation: 118
Default Re: MySQL Variable/Enum is using cached data instead of updating

Are you using BlueG's plugin? If so enable logging
pawn Code:
native mysql_log(E_LOGLEVEL:loglevel = ERROR | WARNING);
// use
mysql_log(E_LOGLEVEL:loglevel = ALL);
Then the log should populate and we can see exactly what queries are called.
Grim_ is offline   Reply With Quote
Old 27/03/2018, 01:11 AM   #16
oSAINTo
Huge Clucker
 
oSAINTo's Avatar
 
Join Date: Aug 2015
Posts: 204
Reputation: 35
Default Re: MySQL Variable/Enum is using cached data instead of updating

Quote:
Originally Posted by Grim_ View Post
Are you using BlueG's plugin? If so enable logging
pawn Code:
native mysql_log(E_LOGLEVEL:loglevel = ERROR | WARNING);
// use
mysql_log(E_LOGLEVEL:loglevel = ALL);
Then the log should populate and we can see exactly what queries are called.
All it did was give me this:
Code:
[20:05:18 03/26/18] [WARNING] CMySQLHandle::Create - connection already exists
oSAINTo is offline   Reply With Quote
Old 27/03/2018, 01:36 AM   #17
oSAINTo
Huge Clucker
 
oSAINTo's Avatar
 
Join Date: Aug 2015
Posts: 204
Reputation: 35
Default Re: MySQL Variable/Enum is using cached data instead of updating

I do appreciate all of your assistance so far @Grim_. It's kind of a relief that I'm not the only one who's lost with this bug. Haha.
oSAINTo is offline   Reply With Quote
Old 27/03/2018, 09:27 AM   #18
Florin48
Huge Clucker
 
Join Date: Nov 2015
Location: Romania
Posts: 265
Reputation: 5
Default Re: MySQL Variable/Enum is using cached data instead of updating

Solved?
Florin48 is offline   Reply With Quote
Old 27/03/2018, 12:08 PM   #19
oSAINTo
Huge Clucker
 
oSAINTo's Avatar
 
Join Date: Aug 2015
Posts: 204
Reputation: 35
Default Re: MySQL Variable/Enum is using cached data instead of updating

Quote:
Originally Posted by Florin48 View Post
Solved?
Not yet.
oSAINTo is offline   Reply With Quote
Old 27/03/2018, 12:14 PM   #20
Florin48
Huge Clucker
 
Join Date: Nov 2015
Location: Romania
Posts: 265
Reputation: 5
Default Re: MySQL Variable/Enum is using cached data instead of updating

Quote:
Originally Posted by oSAINTo View Post
Not yet.
in at /park

Car_Spawn(carid);
Car_Save(carid);
DestroyVehicle(CarData[carid][carVehicle]);
currentCarID[playerid] = 0;

try
Car_Save(carid);
Car_Spawn(carid);
DestroyVehicle(CarData[carid][carVehicle]);
currentCarID[playerid] = 0;
Florin48 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
[Include] Modshop car color selection menu (SA original) Drebin Includes 9 29/07/2018 09:05 AM
Function data as enum Jimmy0wns Scripting Help 5 23/03/2015 12:33 PM
Mysql data not properly getting processed into enum oliverrud Scripting Help 8 25/08/2013 06:44 PM
Loading MySQL data in Enum Wesley221 Scripting Help 4 06/01/2012 05:47 PM


All times are GMT. The time now is 10:38 AM.


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