MySQL Help - Printable Version

MySQL Help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Help (/showthread.php?tid=607183)

MySQL Help - iDomo - 15.05.2016

I am having problems with MySQL, I'm currently using R6.

Код:

wcrp/admin.pwn(649) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1073) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1089) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1120) : error 017: undefined symbol "cache_get_data"
wcrp/admin.pwn(1126) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1128) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1133) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1135) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1136) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1119) : warning 203: symbol is never used: "fields"
wcrp/admin.pwn(1155) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1170) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1185) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1195) : error 017: undefined symbol "cache_get_data"
wcrp/admin.pwn(1200) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1201) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1203) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1194) : warning 203: symbol is never used: "fields"
wcrp/admin.pwn(1218) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(2404) : error 017: undefined symbol "cache_get_data"
wcrp/admin.pwn(2403) : warning 203: symbol is never used: "fields"
wcrp/admin.pwn(2426) : error 017: undefined symbol "cache_get_data"
wcrp/admin.pwn(2425) : warning 203: symbol is never used: "fields"
wcrp/admin.pwn(2592) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(3572) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(3579) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(3585) : error 017: undefined symbol "cache_get_data"
wcrp/admin.pwn(3587) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(3588) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(3589) : error 017: undefined symbol "cache_get_row"

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


26 Errors.

Right now I'm at a dead end, what should I do?

Re: MySQL Help - iKevin - 15.05.2016

Quote:

Originally Posted by iDomo

I am having problems with MySQL, I'm currently using R6.

Код:

wcrp/admin.pwn(649) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1073) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1089) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1120) : error 017: undefined symbol "cache_get_data"
wcrp/admin.pwn(1126) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1128) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1133) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1135) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1136) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1119) : warning 203: symbol is never used: "fields"
wcrp/admin.pwn(1155) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1170) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1185) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1195) : error 017: undefined symbol "cache_get_data"
wcrp/admin.pwn(1200) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1201) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(1203) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(1194) : warning 203: symbol is never used: "fields"
wcrp/admin.pwn(1218) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(2404) : error 017: undefined symbol "cache_get_data"
wcrp/admin.pwn(2403) : warning 203: symbol is never used: "fields"
wcrp/admin.pwn(2426) : error 017: undefined symbol "cache_get_data"
wcrp/admin.pwn(2425) : warning 203: symbol is never used: "fields"
wcrp/admin.pwn(2592) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(3572) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(3579) : error 017: undefined symbol "mysql_function_query"
wcrp/admin.pwn(3585) : error 017: undefined symbol "cache_get_data"
wcrp/admin.pwn(3587) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(3588) : error 017: undefined symbol "cache_get_row"
wcrp/admin.pwn(3589) : error 017: undefined symbol "cache_get_row"

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


26 Errors.

Right now I'm at a dead end, what should I do?

Show us the MySQL include.

Re: MySQL Help - iDomo - 15.05.2016

Quote:

Originally Posted by KevinExec

Show us the MySQL include.

What do you mean? Like the code that corresponds with the errors?

Re: MySQL Help - iKevin - 15.05.2016

Quote:

Originally Posted by iDomo

What do you mean? Like the code that corresponds with the errors?

No, go to your pawno/include folder and look for an .inc file called mysql.inc or a_mysql.inc, something like that and paste its content here. Use [code] bbcode tag.

Re: MySQL Help - iDomo - 15.05.2016

Oh okay.

Код:

/*
	SA-MP MySQL plugin R5
	Copyright © 2008-2010, G-sTyLeZzZ 
*/

#if defined mysql_included
	#endinput
#endif
#define mysql_included

//Common error codes (http://dev.mysql.com/doc/refman/5.0/en/error-messages-(client|server).html)

#define ER_DBACCESS_DENIED_ERROR 1044
#define ER_ACCESS_DENIED_ERROR 1045
#define ER_UNKNOWN_TABLE 1109
#define ER_SYNTAX_ERROR 1149
#define CR_SERVER_GONE_ERROR 2006
#define CR_SERVER_LOST 2013
#define CR_COMMAND_OUT_OF_SYNC 2014
#define CR_SERVER_LOST_EXTENDED 2055

//Native functions

#define mysql_fetch_row(%1) mysql_fetch_row_format(%1,"|")
#define mysql_next_row() mysql_retrieve_row()
#define mysql_get_field(%1,%2) mysql_fetch_field_row(%2,%1)

native mysql_affected_rows(connectionHandle = 1);
native mysql_close(connectionHandle = 1);
native mysql_connect(const host[],const user[],const database[],const password[]);
native mysql_debug(enable = 1);
native mysql_errno(connectionHandle = 1);
native mysql_fetch_int(connectionHandle = 1);
native mysql_fetch_field(number,dest[],connectionHandle = 1);
native mysql_fetch_field_row(string[],const fieldname[],connectionHandle = 1);
native mysql_fetch_float(&Float:result,connectionHandle = 1);
native mysql_fetch_row_format(string[],const delimiter[] = "|",connectionHandle = 1);
native mysql_field_count(connectionHandle = 1);
native mysql_free_result(connectionHandle = 1);
native mysql_get_charset(destination[],connectionHandle = 1);
native mysql_insert_id(connectionHandle = 1);
native mysql_num_rows(connectionHandle = 1);
native mysql_num_fields(connectionHandle = 1);
native mysql_ping(connectionHandle = 1);
native mysql_query(query[],resultid = (-1),extraid = (-1),connectionHandle = 1);
native mysql_query_callback(index,query[],callback[],extraid = (-1),connectionHandle = 1);
native mysql_real_escape_string(const source[],destination[],connectionHandle = 1);
native mysql_reconnect(connectionHandle = 1);
native mysql_reload(connectionHandle = 1);
native mysql_retrieve_row(connectionHandle = 1);
native mysql_set_charset(charset[],connectionHandle = 1);
native mysql_stat(const destination[],connectionHandle = 1);
native mysql_store_result(connectionHandle = 1);
native mysql_warning_count(connectionHandle = 1);

//forward declarations

forward OnQueryFinish(query[], resultid, extraid, connectionHandle);
forward OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle);

Re: MySQL Help - iKevin - 15.05.2016

Alright. You're using a downloaded script (most probably) and that script was supposed to be coded with another MySQL plugin which has different function names - by BlueG.

You can download that plugin here, switch the include and add the

Код:

#include <'the new mysql include name in your pawno/include folder'>

https://sampforum.blast.hk/showthread.php?tid=56564

Re-compile and reply here.

Re: MySQL Help - iDomo - 15.05.2016

Re-compiled after replacing the include/plugin.

Код:

wcrp/admin.pwn(1097) : error 017: undefined symbol "mysql_affected_rows"
wcrp/admin.pwn(1226) : error 017: undefined symbol "mysql_affected_rows"
wcrp/admin.pwn(3758) : warning 213: tag mismatch
wcrp/admin.pwn(3761) : warning 213: tag mismatch
wcrp/admin.pwn(3772) : warning 213: tag mismatch
wcrp/admin.pwn(3773) : warning 213: tag mismatch
wcrp/admin.pwn(3774) : warning 213: tag mismatch
wcrp/admin.pwn(3776) : warning 213: tag mismatch
wcrp/admin.pwn(5581) : warning 203: symbol is never used: "playerid"
wcrp/admin.pwn(5694) : error 017: undefined symbol "mysql_affected_rows"
wcrp/admin.pwn(5955) : error 017: undefined symbol "mysql_affected_rows"
wcrp/account.pwn(972) : warning 202: number of arguments does not match definition
wcrp/account.pwn(1087) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len")
wcrp/account.pwn(1558) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len")
wcrp/account.pwn(1978) : error 017: undefined symbol "mysql_affected_rows"
wcrp/vehicles.pwn(1112) : error 017: undefined symbol "CreateProgressBar"
wcrp/vehicles.pwn(1112) : warning 213: tag mismatch
wcrp/vehicles.pwn(1513) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len")
wcrp/vehicles.pwn(1684) : error 017: undefined symbol "DestroyProgressBar"
wcrp/vehicles.pwn(1742) : error 017: undefined symbol "INVALID_BAR_ID"
wcrp/vehicles.pwn(1743) : error 017: undefined symbol "HideProgressBarForPlayer"
wcrp/vehicles.pwn(1845) : error 017: undefined symbol "INVALID_BAR_ID"
wcrp/vehicles.pwn(1846) : error 017: undefined symbol "SetProgressBarValue"
wcrp/vehicles.pwn(1848) : error 017: undefined symbol "ShowProgressBarForPlayer"
wcrp/vehicles.pwn(2616) : error 017: undefined symbol "SetProgressBarValue"
wcrp/vehicles.pwn(2617) : error 017: undefined symbol "UpdateProgressBar"
wcrp/vehicles.pwn(2615) : warning 204: symbol is assigned a value that is never used: "fuelbar"
wcrp/vehicles.pwn(3975) : warning 204: symbol is assigned a value that is never used: "driver"
wcrp/business.pwn(2019) : warning 217: loose indentation
wcrp/business.pwn(2020) : warning 217: loose indentation
wcrp/business.pwn(2021) : warning 217: loose indentation
wcrp/business.pwn(2022) : warning 217: loose indentation
wcrp/business.pwn(2023) : warning 217: loose indentation
wcrp/business.pwn(2114) : warning 217: loose indentation
wcrp/interiors.pwn(278) : warning 209: function "interiorTryEnterExit" should return a value
wcrp/families.pwn(1087) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len")
wcrp/families.pwn(1098) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len")
wcrp/houses.pwn(752) : error 017: undefined symbol "mysql_affected_rows"
wcrp/jobs.pwn(2541) : error 017: undefined symbol "cache_get_field"
wcrp/safes.pwn(754) : error 017: undefined symbol "mysql_affected_rows"
wcrp/safes.pwn(789) : error 017: undefined symbol "mysql_affected_rows"
wcrp\factions\leo.pwn(493) : warning 204: symbol is assigned a value that is never used: "rank"
wcrp\factions\leo.pwn(492) : warning 204: symbol is assigned a value that is never used: "faction"
wcrp/forumsync.pwn(31) : warning 203: symbol is never used: "email"
wcrp/forumsync.pwn(31) : warning 203: symbol is never used: "pass"
wcrp/forumsync.pwn(31) : warning 203: symbol is never used: "username"
wcrp/forumsync.pwn(31) : warning 203: symbol is never used: "playerid"
wcrp/forumsync.pwn(38) : warning 203: symbol is never used: "pass"
wcrp/forumsync.pwn(38) : warning 203: symbol is never used: "playerid"
wcrp/forumsync.pwn(92) : warning 203: symbol is never used: "newusername"
wcrp/forumsync.pwn(92) : warning 203: symbol is never used: "oldusername"
wcrp/forumsync.pwn(92) : warning 203: symbol is never used: "playerid"
wcrp/walltags.pwn(512) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len")
wcrp/sqlqueries.pwn(385) : error 017: undefined symbol "mysql_affected_rows"
wcrp/sqlqueries.pwn(400) : error 017: undefined symbol "cache_get_field"
wcrp/cartoys.pwn(96) : warning 217: loose indentation
wcrp/cartoys.pwn(100) : warning 203: symbol is never used: "inputtext"
wcrp/cartoys.pwn(409) : warning 203: symbol is never used: "CRY"
wcrp/cartoys.pwn(409) : warning 203: symbol is never used: "CRX"
wcrp/cheats.pwn(18) : warning 203: symbol is never used: "reason"
wcrp/cheats.pwn(61) : warning 203: symbol is never used: "inputtext"
wcrp/cheats.pwn(76) : warning 203: symbol is never used: "oldkeys"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(350) : warning 205: redundant code: constant expression is zero
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(350) : warning 215: expression has no effect
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(352) : error 017: undefined symbol "enable_mutex"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(418) : error 017: undefined symbol "mysql_ping"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(1114) : warning 219: local variable "query" shadows a variable at a preceding level
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(1240) : warning 203: symbol is never used: "EventOnPlayerDeath"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(1240) : warning 203: symbol is never used: "IsEventAdmin"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(1240) : warning 203: symbol is never used: "IsFlyCar"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(1240) : warning 203: symbol is never used: "LookupPlayerIP"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(1240) : warning 203: symbol is never used: "NumPlayerRentCars"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(1240) : warning 203: symbol is never used: "RPTestLabels"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(1240) : warning 203: symbol is never used: "SendMsgToRadioSnoopers"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(1240) : warning 203: symbol is never used: "ShowAllNameTagsForPlayer"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(1240) : warning 203: symbol is never used: "SyncWarns"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212) : warning 204: symbol is assigned a value that is never used: "VoteStarter"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "_RenderBar"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "canUseDrugCommand"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "diseaseCheck"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "doBankSettlement"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "doDiseaseEffect"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "endRace"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "fpscamkeysOnPlayerKeyState"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "getBasketTeam"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "getCraftCooldownTime"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "getDrugCooldownTime"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "getPlayerNumAjails"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "getVehicleReclaimPrice"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "hasOOCTag"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "infectNearbyPlayers"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "isBankInNegative"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "isRaceActive"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "isSwitchingChars"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "playerGetsDisease"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(212 -- 1240) : warning 203: symbol is never used: "sendTourettesMessage"
C:\Users\Adam\Desktop\New folder (2)\gamemodes\WCRP.pwn(724) : warning 204: symbol is assigned a value that is never used: "servermaintenance"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


22 Errors.

Re: MySQL Help - iKevin - 15.05.2016

As I expected, because you now have to switch the functions to the ones in the current include. Like, before it was cache_get_field but here it is defined to be cache_get_field_content. Use ****** and the include (by BlueG) to check the functions, ****** to see what they should do.

It's a lot of work, but can fix the errors.