Databases were updated for July 2020: https://github.com/George480/geolite/releases/tag/v21.0 Province database will be uploaded tomorrow because it takes too long. EDIT: I was unable to get the pro...

Databases were updated for June 2020: https://github.com/George480/geolite/releases/tag/v20.0 Update geolite.inc: https://raw.githubusercontent.com/Ge...er/geolite.inc Added new database maxmind_prov...

Was database opened correctly? You can enable: pawn Code: db_logging 1 option in server.cfg

logs\plugins for R40+ or mysql_log.txt/mysql_log.html for R33+ Note `mysql_log` should not be set to none.

Quote: Originally Posted by TomasByoka link dont' work https://pastebin.com/raw/83dYkMp0

Check mysql logs. If host is Linux, table names must be exact same because it is case-sensitive.

Quote: Originally Posted by JR_Junior All files is on the correct place and I've tried getting info like this way too... but nothing, no errors, but no data too. Database files in corre...

`maxmind_country.db` and `maxmind_city.db` must be located in scriptfiles folder otherwise the functions will return 0. pawn Code: GetPlayerCountry(playerid, PlayerInfo[playerid][GeoCountry], MAX_CO...

Code: cache_get_field_content_int(0, registered, mysql); pawn Code: native cache_get_field_content_int(row, const field_name[], connectionHandle = 1); It expects a column name to search for but `reg...

`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], dbH...

Wrong plugin version, load the latest: https://github.com/pBlueG/SA-MP-MySQL/releases

Depends how you include the files, it can complain about files with same name (includes core.pwn only once and ignores other files with same name). pawn Code: #include "core\player/player.pwn" Quot...

Do you sort `top_kills` array? Can you post the code?

For YSI 5: pawn Code: #include <YSI_Coding\y_hooks> I use \ for path name and / for file name pawn Code: #include "modules\server/database.pwn"#include "modules\server/log.pwn"#include "modul...

Trying to fetch data that is not integer.

If it is not shown at all, the formatting should not be the problem. You can try set textdraw string and re-show it.

Comment the last parts you changed if you remember until it responds (will compile or show errors/warnings). Then start un-commenting parts of code until you find the source of the problem.

Quote: Originally Posted by Vy The problem is that if I connect and then someone connects, that someone doesn't show up but I do. Even if the other one is id 0 and I'm 1. What do you me...

When you execute another query (non-threaded) inside the callback, the cache is reset. You will have to re-apply it. pawn Code: new rows = cache_num_rows();if(rows){    new Cache: cache_id = cache_...

Might be an issue with how you display the data? Post full mysql logs and code.