PDA

View Full Version : Mysql help please !!


Inuro
16/04/2017, 02:41 PM
Hey, Im on Mac OS X, I can compile, play on GTA SA etc but I can't start de server because I have this error :

[16:30:01] [debug] Run time error 19: "File or function is not found"
[16:30:01] [debug] mysql_close
[16:30:01] [debug] mysql_query
[16:30:01] [debug] mysql_store_result
[16:30:01] [debug] mysql_num_rows
[16:30:01] [debug] mysql_retrieve_row
[16:30:01] [debug] mysql_fetch_field_row
[16:30:01] [debug] mysql_free_result
[16:30:01] [debug] mysql_fetch_row_format
[16:30:01] [debug] mysql_real_escape_string
[16:30:01] [debug] mysql_connect
[16:30:01] [debug] mysql_debug
[16:30:01] [debug] mysql_ping
[16:30:01] [debug] Run time error 19: "File or function is not found"
[16:30:01] [debug] mysql_close
[16:30:01] [debug] mysql_query
[16:30:01] [debug] mysql_store_result
[16:30:01] [debug] mysql_num_rows
[16:30:01] [debug] mysql_retrieve_row
[16:30:01] [debug] mysql_fetch_field_row
[16:30:01] [debug] mysql_free_result
[16:30:01] [debug] mysql_fetch_row_format
[16:30:01] [debug] mysql_real_escape_string
[16:30:01] [debug] mysql_connect
[16:30:01] [debug] mysql_debug
[16:30:01] [debug] mysql_ping

My MySQL plugin just failed

[16:30:00] Loading plugin: mysql.dll
[16:30:00] Failed.

I have 0 warning/errors when I compile de game mode

please help :/

GangstaSunny.
16/04/2017, 02:51 PM
.DLL are windows files. I'm not sure whether you can use this on Mac too.

Inuro
16/04/2017, 02:55 PM
Why streamer, native checker and sscanf work then ?

coool
16/04/2017, 03:22 PM
I think you are not using incorrect MySQL plugin version

Melktert
16/04/2017, 03:24 PM
.dll files don't work on linux, try using "mysql.so" in server.cfg

and as coool said, you're probably using a different mysql version too.

Inuro
16/04/2017, 03:34 PM
I have the same errors with the .so

I will try another versions :/

Inuro
16/04/2017, 03:40 PM
Hey ! My plugin finally work but here is my new problem :

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[17:28:53] filterscripts = "" (string)
[17:28:53]
[17:28:53] Server Plugins
[17:28:53] --------------
[17:28:53] Loading plugin: crashdetect.dll
[17:28:53] CrashDetect v4.12 is OK.
[17:28:53] Loaded.
[17:28:53] Loading plugin: streamer.dll
[17:28:53]

*** Streamer Plugin v2.9.0 by Incognito loaded ***

[17:28:53] Loaded.
[17:28:53] Loading plugin: mysql.dll
[17:28:53]

> MySQL plugin R5 successfully loaded.

[17:28:53] Loaded.
[17:28:53] Loading plugin: sscanf.dll
[17:28:53]

[17:28:53] ===============================

[17:28:53] sscanf plugin loaded.

[17:28:53] Version: 2.8.1

[17:28:53] (c) 2012 Alex "******" Cole

[17:28:53] ===============================

[17:28:53] Loaded.
[17:28:53] Loaded 4 plugins.

[17:28:53]
[17:28:53] Filterscripts
[17:28:53] ---------------
[17:28:53] Loaded 0 filterscripts.

[17:28:53]
[17:28:53] --------------------------------------
[17:28:53] Anticheat Nex-AC charge!
[17:28:53] Version anti-triche: 1.9.20
[17:28:53] Auteur: Nexius
[17:28:53] --------------------------------------

[17:28:53]
[17:28:53]
[17:28:53]
[17:28:53] =======================================
[17:28:53] | |
[17:28:53] | YSI version 3.09.0684 |
[17:28:53] | By Alex "******" Cole |
[17:28:53] | |
[17:28:53] =======================================
[17:28:53]
[17:28:53] MySQL connection is alive!
[17:28:53] -mSelection- WARNING: Failed to load list: "skins.txt"
[17:28:53] [CHARGEMENT] Chargement des objets en cours ...
[17:28:53] [CHARGEMENT] 0 objet(s) chargÈ(s).
[17:28:53] [CHARGEMENT] Chargement des radars en cours ...
[17:28:53] [CHARGEMENT] -1 radars(s) chargÈ(s).
[17:28:53] [CHARGEMENT] Chargement des ATM en cours ...
[17:28:53] [CHARGEMENT] -1 atm(s) chargÈ(s).
[17:28:53] [CHARGEMENT] Chargement des meubles en cours ...
[17:28:53] [CHARGEMENT] 0 meuble(s) chargÈ(s).
[17:28:53] [CHARGEMENT] Chargement des items en cours ...
[17:28:53] [CHARGEMENT] 0 items(s) chargÈ(s).
[17:28:53] [CHARGEMENT] Chargement des forfaits tÈlÈphoniques ...
[17:28:53] [CHARGEMENT] 0 forfait(s) tÈlÈphonique(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des tÈlÈphones ...
[17:28:54] [CHARGEMENT] 0 tÈlÈphone(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des items au sol en cours ...
[17:28:54] [CHARGEMENT] 0 items(s) au sol chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des concess en cours ...
[17:28:54] [CHARGEMENT] 0 veh concess chargÈ.
[17:28:54] [CHARGEMENT] 0 faction(s) chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des money-gov en cours ...
[17:28:54] [CHARGEMENT] 0 money-gov chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des lois en cours ...
[17:28:54] [CHARGEMENT] 0 loi(s) chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des maisons en cours ...
[17:28:54] [CHARGEMENT] 0 maison(s) chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des bizs en cours ...
[17:28:54] [CHARGEMENT] 0 biz(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des bizs en cours ...
[17:28:54] [CHARGEMENT] 0 entreprise(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des vÈhicules en cours ...
[17:28:54] [CHARGEMENT] 0 vÈhicules(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des tuning vÈhicules en cours ...
[17:28:54] [CHARGEMENT] Tuning vÈhicules chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des acteurs en cours ...
[17:28:54] [CHARGEMENT] 0 acteur(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des enter-exit en cours ...
[17:28:54] [CHARGEMENT] 0 enter-exit(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des positions GPS en cours ...
[17:28:54] [CHARGEMENT] 0 position(s) GPS chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des groupes de locaux en cours ...
[17:28:54] [CHARGEMENT] 0 groupe de locaux chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des locaux en cours ...
[17:28:54] [CHARGEMENT] 0 local(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des loots en cours ...
[17:28:54] [CHARGEMENT] 0 loot(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des objets loot en cours ...
[17:28:54] [CHARGEMENT] 0 objet(s) loot chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des positions de commandes en cours ...
[17:28:54] [CHARGEMENT] 0 positions de commandes chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des sacs ...
[17:28:54] [CHARGEMENT] 0 sac(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des pickups ...
[17:28:54] [CHARGEMENT] 0 pickups(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des boxes ...
[17:28:54] [CHARGEMENT] 0 boxe(s) chargÈ(s).
[17:28:54] [CHARGEMENT] Chargement des stations services ...
[17:28:54] [CHARGEMENT] 0 station(s) service chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des boomboxs en cours ...
[17:28:54] [CHARGEMENT] 0 boombox(s) chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des assurances en cours ...
[17:28:54] [CHARGEMENT] 0 assurance(s) chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des commandes de plaques en cours ...
[17:28:54] [CHARGEMENT] 0 commande(s) de plaque(s) chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des commandes de produits en cours ...
[17:28:54] [CHARGEMENT] 0 commande(s) de produit(s) chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des commandes d'armes en cours ...
[17:28:54] [CHARGEMENT] 0 commande(s) d'armes(s) chargÈe(s).
[17:28:54] [CHARGEMENT] Chargement des productions de drogues en cours ...
[17:28:54] [CHARGEMENT] 0 production(s) de drogues(s) chargÈe(s).
[17:28:54] [SERVEUR] Chargement des timers..
[17:28:54]
----------------------------------------------------
[17:28:54] Prosperity RP - Version 1.0
[17:28:54] ----------------------------------------------------

[17:28:54] Number of vehicle models: 0
[17:28:54] New version of CrashDetect is available for download (4.13)
[17:28:54] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:28:55] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:28:55] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:28:56] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:28:57] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:28:58] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:28:58] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:28:59] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:28:59] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:29:00] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:29:00] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:29:01] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:29:01] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:29:02] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:29:02] [debug] Run time error 20: "Invalid index parameter (bad entry point)"
[17:29:03] [debug] Run time error 20: "Invalid index parameter (bad entry point)"

SQL LOG :

[17:28:53]

[17:28:53] ---------------------------

[17:28:53] MySQL Debugging activated (04/16/17)

[17:28:53] ---------------------------

[17:28:53]

[17:28:53] >> mysql_ping( Connection handle: 1 )

[17:28:53] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[17:28:53] >> mysql_ping( Connection handle: 1 )

[17:28:53] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[17:28:53] >> mysql_query( Connection handle: 1 )

[17:28:53] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_store_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:53] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:53] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_free_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:53] >> mysql_query( Connection handle: 1 )

[17:28:53] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_store_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:53] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:53] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_free_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:53] >> mysql_query( Connection handle: 1 )

[17:28:53] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_store_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:53] >> mysql_num_rows( Connection handle: 1 )

[17:28:53] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[17:28:53] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:53] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_free_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:53] >> mysql_query( Connection handle: 1 )

[17:28:53] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_store_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:53] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:53] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_free_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:53] >> mysql_query( Connection handle: 1 )

[17:28:53] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_store_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:53] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:53] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_free_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:53] >> mysql_query( Connection handle: 1 )

[17:28:53] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_store_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:53] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:53] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_free_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:53] >> mysql_query( Connection handle: 1 )

[17:28:53] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_store_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:53] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:53] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_free_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:53] >> mysql_query( Connection handle: 1 )

[17:28:53] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_store_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:53] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:53] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:53] >> mysql_free_result( Connection handle: 1 )

[17:28:53] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:53] >> mysql_query( Connection handle: 1 )

[17:28:53] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:28:54] >> mysql_query( Connection handle: 1 )

[17:28:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_store_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[17:28:54] >> mysql_fetch_row_format( Connection handle: 1 )

[17:28:54] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[17:28:54] >> mysql_free_result( Connection handle: 1 )

[17:28:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


My database information (local):

#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASSWORD "root"//XeWG3OK1A1
#define SQL_DATABASE "prosperity"

I am using MAMP on Mac

Inuro
17/04/2017, 07:51 AM
bump please

Zav1337
17/04/2017, 08:21 AM
If you are using BlueG's plugin, make sure you have "log-core.dll/log-core.so" in your server folder.

Inuro
17/04/2017, 08:24 AM
My samp-server just won't connect to my XAMPP database, all my configuration is right, I don't know what's wrong

Zav1337
17/04/2017, 08:28 AM
Are you using BlueG's plugin? Did you change user password in XAMPP? If you didn't change it, use #define SQL_PASSWORD "" instead of #define SQL_PASSWORD "root".

Inuro
17/04/2017, 08:33 AM
The connection work now ! Thanks man but now, on Samp I didn't see my server using IP dress 127.0.0.1 or localhost

Zav1337
17/04/2017, 08:40 AM
So under what IP do you see it? You should be able to (still) see it under localhost/127.0.0.1.

Inuro
17/04/2017, 08:45 AM
When I try to add my local server on SA-MP it's like

(Retrieving info...) 127.0.0.1:7777

I saw in my mysql_log and server_log the server take very long time to load my database :/

Zav1337
17/04/2017, 08:50 AM
Maybe you have bad queries. Or really big db.

Inuro
17/04/2017, 08:51 AM
On a VPS machine the server start very fast but not in local ^^

It work, the server just take a good time to load my database

Zav1337
17/04/2017, 08:54 AM
Try these options, just edit it, but keep the port 3306:

new MySQLOpt:options = mysql_init_options();
mysql_set_option(options, AUTO_RECONNECT, true);
mysql_set_option(options, SERVER_PORT, 3306);
connection = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DB, options);