Mysql error
#1

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

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[13:33:47] filterscripts = "" (string)
[13:33:47]
[13:33:47] Server Plugins
[13:33:47] --------------
[13:33:47] Loading plugin: mysql
[13:33:47] Failed.
[13:33:47] Loading plugin: crashdetect
[13:33:47] Failed.
[13:33:47] Loading plugin: streamer
[13:33:47]

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

[13:33:47] Loaded.
[13:33:47] Loading plugin: sscanf
[13:33:47]

[13:33:47] ===============================

[13:33:47] sscanf plugin loaded.

[13:33:47] Version: 2.8.2

[13:33:47] © 2012 Alex "******" Cole

[13:33:47] ===============================

[13:33:47] Loaded.
[13:33:47] Loading plugin: whirlpool
[13:33:47]
[13:33:47] ==================
[13:33:47]
[13:33:47] Whirlpool loaded
[13:33:47]
[13:33:47] ==================
[13:33:47]
[13:33:47] Loaded.
[13:33:47] Loading plugin: irc
[13:33:47]

*** IRC Plugin v1.4.8 by Incognito loaded ***

[13:33:47] Loaded.
[13:33:47] Loading plugin: nativechecker
[13:33:47] Loaded.
[13:33:47] Loaded 5 plugins.

[13:33:47]
[13:33:47] Filterscripts
[13:33:47] ---------------
[13:33:47] Loaded 0 filterscripts.

[13:33:47] Error: Function not registered: 'mysql_format'
[13:33:47] Error: Function not registered: 'mysql_tquery'
[13:33:47] Error: Function not registered: 'mysql_query'
[13:33:47] Error: Function not registered: 'cache_is_valid'
[13:33:47] Error: Function not registered: 'cache_get_field_content_int'
[13:33:47] Error: Function not registered: 'cache_get_field_content'
[13:33:47] Error: Function not registered: 'cache_insert_id'
[13:33:47] Error: Function not registered: 'cache_delete'
[13:33:47] Error: Function not registered: 'cache_get_row_count'
[13:33:47] Error: Function not registered: 'cache_get_field_content_float'
[13:33:47] Error: Function not registered: 'cache_set_active'
[13:33:47] Error: Function not registered: 'mysql_connect'
[13:33:47] Error: Function not registered: 'mysql_log'
[13:33:47] Error: Function not registered: 'mysql_stat'
[13:33:47] Error: Function not registered: 'mysql_close'
[13:33:47] Script[gamemodes/test.amx]: Run time error 19: "File or function is not found"
[13:33:47] Number of vehicle models: 0

Anyone knows what's the problem?
Reply
#2

Do you get any message about missing files when starting the server? libmysql.dll must be at the main directory (where samp-server.exe is located) and not in the plugins folder.

Looking at the version of the streamer means you have Microsoft Visual C++ 2015 Redistributable Package.

I'm not sure why crashdetect failed. What version are you trying to load?
Reply
#3

Added crashdetect.dll & mysql.dll, now I get this



Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[14:34:46] filterscripts = ""  (string)
[14:34:46] 
[14:34:46] Server Plugins
[14:34:46] --------------
[14:34:46]  Loading plugin: mysql
[14:34:46] 

  > MySQL plugin R7 successfully loaded.

[14:34:46]   Loaded.
[14:34:46]  Loading plugin: crashdetect
[14:34:46]   CrashDetect v4.16 is OK.
[14:34:46]   Loaded.
[14:34:46]  Loading plugin: streamer
[14:34:46] 

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

[14:34:46]   Loaded.
[14:34:46]  Loading plugin: sscanf
[14:34:46] 

[14:34:46]  ===============================

[14:34:46]       sscanf plugin loaded.     

[14:34:46]          Version:  2.8.2        

[14:34:46]    © 2012 Alex "******" Cole  

[14:34:46]  ===============================

[14:34:46]   Loaded.
[14:34:46]  Loading plugin: whirlpool
[14:34:46]  
[14:34:46]  ==================
[14:34:46]  
[14:34:46]   Whirlpool loaded
[14:34:46]  
[14:34:46]  ==================
[14:34:46]  
[14:34:46]   Loaded.
[14:34:46]  Loading plugin: irc
[14:34:46] 

*** IRC Plugin v1.4.8 by Incognito loaded ***

[14:34:46]   Loaded.
[14:34:46]  Loading plugin: nativechecker
[14:34:46]   Loaded.
[14:34:46]  Loaded 7 plugins.

[14:34:46] 
[14:34:46] Filterscripts
[14:34:46] ---------------
[14:34:46]   Loaded 0 filterscripts.

[14:34:46]    Error: Function not registered: 'mysql_tquery'
[14:34:46]    Error: Function not registered: 'mysql_query'
[14:34:46]    Error: Function not registered: 'cache_is_valid'
[14:34:46]    Error: Function not registered: 'cache_get_field_content_int'
[14:34:46]    Error: Function not registered: 'cache_insert_id'
[14:34:46]    Error: Function not registered: 'cache_delete'
[14:34:46]    Error: Function not registered: 'cache_get_row_count'
[14:34:46]    Error: Function not registered: 'cache_get_field_content_float'
[14:34:46]    Error: Function not registered: 'cache_set_active'
[14:34:46]    Error: Function not registered: 'mysql_log'
[14:34:46] [debug] Run time error 19: "File or function is not found"
[14:34:46] [debug]  mysql_tquery
[14:34:46] [debug]  mysql_query
[14:34:46] [debug]  cache_is_valid
[14:34:46] [debug]  cache_get_field_content_int
[14:34:46] [debug]  cache_insert_id
[14:34:46] [debug]  cache_delete
[14:34:46] [debug]  cache_get_row_count
[14:34:46] [debug]  cache_get_field_content_float
[14:34:46] [debug]  cache_set_active
[14:34:46] [debug]  mysql_log
[14:34:46] [debug] Run time error 19: "File or function is not found"
[14:34:46] [debug]  mysql_tquery
[14:34:46] [debug]  mysql_query
[14:34:46] [debug]  cache_is_valid
[14:34:46] [debug]  cache_get_field_content_int
[14:34:46] [debug]  cache_insert_id
[14:34:46] [debug]  cache_delete
[14:34:46] [debug]  cache_get_row_count
[14:34:46] [debug]  cache_get_field_content_float
[14:34:46] [debug]  cache_set_active
[14:34:46] [debug]  mysql_log
[14:34:46] Script[gamemodes/test.amx]: Run time error 19: "File or function is not found"
[14:34:46] Number of vehicle models: 0
I complied my game mode and I got this:
Код:
C:\Users\asd\Desktop\server\pawno\include\easy-mysql.inc(610) : error 017: undefined symbol "cache_is_valid"
C:\Users\asd\Desktop\server\pawno\include\easy-mysql.inc(912) : error 017: undefined symbol "cache_is_valid"
C:\Users\asd\Desktop\server\pawno\include\GM/atm.inc(113) : warning 202: number of arguments does not match definition
C:\Users\asd\Desktop\server\pawno\include\GM/atm.inc(113) : warning 202: number of arguments does not match definition
C:\Users\asd\Desktop\server\pawno\include\GM/atm.inc(307) : warning 202: number of arguments does not match definition
C:\Users\asd\Desktop\server\pawno\include\GM/atm.inc(307) : warning 202: number of arguments does not match definition
C:\Users\asd\Desktop\server\pawno\include\GM/atm.inc(353) : warning 202: number of arguments does not match definition
C:\Users\asd\Desktop\server\pawno\include\GM/atm.inc(353) : warning 202: number of arguments does not match definition
C:\Users\asd\Desktop\server\gamemodes\test.pwn(348) : warning 202: number of arguments does not match definition
C:\Users\asd\Desktop\server\gamemodes\test.pwn(348) : warning 202: number of arguments does not match definition
C:\Users\asd\Desktop\server\gamemodes\test.pwn(349) : warning 202: number of arguments does not match definition
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


2 Errors.
Reply
#4

The last version of cache_get_field_content_int was in R39-6. It was renamed to cache_get_value_name_int for R40 and above. If you use easy-mysql include by eco1999, he has updated the include for R40+ in case you are interested.
Reply
#5

Yea I am using easy-mysql, could you link me the newest?
Reply
#6

MySQL plugin R41: https://github.com/pBlueG/SA-MP-MySQL/releases
Updated version of the include for R40+: https://github.com/MaxAndolini/easy-mysql/releases
Reply
#7

Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
+Rep

Got this when I compiled:

Код:
C:\Users\asd\Desktop\server\pawno\include\GM/stock.inc(88) : warning 213: tag mismatch
C:\Users\asd\Desktop\server\pawno\include\GM/stock.inc(89) : warning 213: tag mismatch
C:\Users\asd\Desktop\server\pawno\include\GM/stock.inc(91) : error 017: undefined symbol "cache_get_field_content"
C:\Users\asd\Desktop\server\pawno\include\GM/fuelstation.inc(12) : warning 213: tag mismatch
C:\Users\asd\Desktop\server\pawno\include\GM/fuelstation.inc(13) : warning 213: tag mismatch
C:\Users\asd\Desktop\server\pawno\include\GM/fuelstation.inc(22) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/fuelstation.inc(23) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/fuelstation.inc(24) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/fuelstation.inc(41) : warning 213: tag mismatch
C:\Users\asd\Desktop\server\pawno\include\GM/fuelstation.inc(42) : warning 213: tag mismatch
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(42) : warning 213: tag mismatch
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(43) : warning 213: tag mismatch
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(50) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(51) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(52) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(53) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(54) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(55) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(56) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(57) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(58) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(59) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(61) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(62) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(63) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(64) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(65) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(85) : error 017: undefined symbol "cache_get_field_content"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(91) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/stores.inc(92) : error 017: undefined symbol "cache_get_field_content_float"
C:\Users\asd\Desktop\server\pawno\include\GM/garage.inc(20) : warning 213: tag mismatch
C:\Users\asd\Desktop\server\pawno\include\GM/garage.inc(28) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\asd\Desktop\server\pawno\include\GM/garage.inc(29) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\asd\Desktop\server\pawno\include\GM/garage.inc(30) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\asd\Desktop\server\pawno\include\GM/garage.inc(31) : error 017: undefined symbol "cache_get_field_content_float"

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


26 Errors.
Reply
#8

You've got two options:
- downgrade easy-mysql and load R39-6 version.
- update the code from these 3 includes to R40+ (recommended).

For the second option: https://sampforum.blast.hk/showthread.php?tid=616103
Reply
#9

C:\Users\--9\Desktop\server\pawno\include\a_mysql.inc(13) : fatal error 111: user error: You have to include the MySQL plugin include before this one!

when I try to compile^

whats the problem?
Reply
#10

As far as I know, none of the versions in BlueG's had this custom error. Can you post the contents of the include?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)