1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Plugin Development

Threaded Mode
[Plugin] [REL] MySQL Plugin (Now on github!)
Cypress
Gangsta
*****
Posts: 937
Threads: 69
Joined: Dec 2009
Reputation: 0
#2,501

03.09.2017, 13:02
What could I possible do to avoid getting this frustrating error: error 075: input line too long (after substitutions)

Code:
mysql_format(
                    			mysql,
                    			query,
                    			sizeof( query ),
                    			"SELECT characters.id, `password`, `salt`, `ip`, `cash`, `gang_id`, `gang_level`, `rank`, `reputation_points`, \
                    			`overall_expenses`, `overall_earnings`, `kills`, `total_deaths`, `shots_fired`, `shots_hit`, `vip_level`, \
                    			`play_time`, `mute_time`, DATE(`date_created`) as `date_created`, \
                    			interactions.sign_in, UNIX_TIMESTAMP(`last_online`) as `last_online` \
                    			FROM `characters` INNER JOIN `interactions` ON characters.id = interactions.id WHERE `username` = '%e' LIMIT 1",
                    			player_data[ playerid ][ e_PLAYER_NAME ]
                			);
Yes, I need to load even more shit later, gets very big.
Find
Reply
Vince
Spam Machine
*****
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0
#2,502

09.09.2017, 09:32
You have two options. You can use either or both. First is to use Zeex' fixed compiler that allows longer lines, second is to create view. A view is basically the output of a query that is presented as a virtual table and which can be read (but not written to) like any other table, e.g.

PHP Code:
CREATE VIEW CharacterInteraction AS SELECT characters.id, ... 
And then when you do

PHP Code:
SELECT * FROM CharacterInteraction 
You'll get the output of the query that's behind it in real time.
Find
Reply
maddinat0r
Banned
Posts: 845
Threads: 3
Joined: Jun 2010
#2,503

10.09.2017, 19:15
R41-4 has been released.
Changelog:
- bug-fix: multi-line queries are not parsed correctly from files
- Windows 'libmariadb.dll' was faulty; this resulted in a connection error for some users

Download as always here.
Find
Reply
wallee
Huge Clucker
****
Posts: 266
Threads: 22
Joined: Jan 2017
Reputation: 0
#2,504

12.09.2017, 06:00
if i'm already using your log-core plugin i can ignore the log-core.dll or should i overwrite?
Find
Reply
maddinat0r
Banned
Posts: 845
Threads: 3
Joined: Jun 2010
#2,505

12.09.2017, 19:16
I'm always trying to use the latest available log-core version. So if you use the latest version of both plugins, the log-core should be the same. If you're not sure however, you can always download the log-core runtime here: https://github.com/maddinat0r/samp-log-core/releases
Find
Reply
Aliassassin123456
Banned
Posts: 232
Threads: 4
Joined: Apr 2013
#2,506

20.09.2017, 10:38
( Последний раз редактировалось Aliassassin123456; 21.09.2017 в 11:46. )
I'm trying to compile latest version of the plugin using Ubuntu 14.04.5 and it fails with this error:
Код:
[100%] Building CXX object src/CMakeFiles/mysql.dir/main.cpp.o
Linking CXX shared module mysql.so
/usr/bin/ld: cannot find -lmysqlclient_r
collect2: error: ld returned 1 exit status
make[2]: *** [src/mysql.so] Error 1
make[1]: *** [src/CMakeFiles/mysql.dir/all] Error 2
make: *** [all] Error 2
CMake output:
Код:
-- The C compiler identification is GNU 4.8.4
-- The CXX compiler identification is GNU 4.8.4
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- Found MySQLCAPI: /usr/include/mysql
-- CMake version: 3.1.3
-- Version: 4.0.0
-- Build type:
-- Performing Test HAVE_STD_CPP11_FLAG
-- Performing Test HAVE_STD_CPP11_FLAG - Success
-- Performing Test FMT_CPP11_CMATH
-- Performing Test FMT_CPP11_CMATH - Success
-- Performing Test FMT_CPP11_UNISTD_H
-- Performing Test FMT_CPP11_UNISTD_H - Success
-- Performing Test FMT_CPP11_SNPRINTF
-- Performing Test FMT_CPP11_SNPRINTF - Success
-- Performing Test SUPPORTS_VARIADIC_TEMPLATES
-- Performing Test SUPPORTS_VARIADIC_TEMPLATES - Success
-- Performing Test SUPPORTS_INITIALIZER_LIST
-- Performing Test SUPPORTS_INITIALIZER_LIST - Failed
-- Performing Test SUPPORTS_ENUM_BASE
-- Performing Test SUPPORTS_ENUM_BASE - Success
-- Performing Test SUPPORTS_TYPE_TRAITS
-- Performing Test SUPPORTS_TYPE_TRAITS - Failed
-- Performing Test SUPPORTS_USER_DEFINED_LITERALS
-- Performing Test SUPPORTS_USER_DEFINED_LITERALS - Success
-- Looking for open
-- Looking for open - found
-- Looking for alloca.h
-- Looking for alloca.h - found
-- Looking for inttypes.h
-- Looking for inttypes.h - found
-- Looking for malloc.h
-- Looking for malloc.h - found
-- Looking for stdint.h
-- Looking for stdint.h - found
-- Found SAMPSDK: /root/SA-MP-MySQL/libs/sdk
-- Configuring done
-- Generating done
-- Build files have been written to: /root/SA-MP-MySQL/build
MySQL libraries are in /usr/lib/x86_64-linux-gnu/, I tried to link them manually but failed.
No errors on compiling tho.
Find
Reply
Jeroen52
Gangsta
*****
Posts: 882
Threads: 34
Joined: Oct 2008
Reputation: 0
#2,507

20.09.2017, 10:57
Quote:
Originally Posted by Aliassassin123456
Посмотреть сообщение
I'm trying to compile latest version of Ubuntu 14.04.5 and it fails with this error:
Код:
[100%] Building CXX object src/CMakeFiles/mysql.dir/main.cpp.o
Linking CXX shared module mysql.so
/usr/bin/ld: cannot find -lmysqlclient_r
collect2: error: ld returned 1 exit status
make[2]: *** [src/mysql.so] Error 1
make[1]: *** [src/CMakeFiles/mysql.dir/all] Error 2
make: *** [all] Error 2
CMake output:
Код:
-- The C compiler identification is GNU 4.8.4
-- The CXX compiler identification is GNU 4.8.4
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- Found MySQLCAPI: /usr/include/mysql
-- CMake version: 3.1.3
-- Version: 4.0.0
-- Build type:
-- Performing Test HAVE_STD_CPP11_FLAG
-- Performing Test HAVE_STD_CPP11_FLAG - Success
-- Performing Test FMT_CPP11_CMATH
-- Performing Test FMT_CPP11_CMATH - Success
-- Performing Test FMT_CPP11_UNISTD_H
-- Performing Test FMT_CPP11_UNISTD_H - Success
-- Performing Test FMT_CPP11_SNPRINTF
-- Performing Test FMT_CPP11_SNPRINTF - Success
-- Performing Test SUPPORTS_VARIADIC_TEMPLATES
-- Performing Test SUPPORTS_VARIADIC_TEMPLATES - Success
-- Performing Test SUPPORTS_INITIALIZER_LIST
-- Performing Test SUPPORTS_INITIALIZER_LIST - Failed
-- Performing Test SUPPORTS_ENUM_BASE
-- Performing Test SUPPORTS_ENUM_BASE - Success
-- Performing Test SUPPORTS_TYPE_TRAITS
-- Performing Test SUPPORTS_TYPE_TRAITS - Failed
-- Performing Test SUPPORTS_USER_DEFINED_LITERALS
-- Performing Test SUPPORTS_USER_DEFINED_LITERALS - Success
-- Looking for open
-- Looking for open - found
-- Looking for alloca.h
-- Looking for alloca.h - found
-- Looking for inttypes.h
-- Looking for inttypes.h - found
-- Looking for malloc.h
-- Looking for malloc.h - found
-- Looking for stdint.h
-- Looking for stdint.h - found
-- Found SAMPSDK: /root/SA-MP-MySQL/libs/sdk
-- Configuring done
-- Generating done
-- Build files have been written to: /root/SA-MP-MySQL/build
MySQL libraries are in /usr/lib/x86_64-linux-gnu/, I tried to link them manually but failed.
No errors on compiling tho.
Try this then recompile.
PHP код:
sudo apt-get install mysql-client:i386
sudo apt-get install libmysqlclient-dev:i386 
Find
Reply
Aliassassin123456
Banned
Posts: 232
Threads: 4
Joined: Apr 2013
#2,508

20.09.2017, 11:11
I got so many errors trying to install those, I think I should install i386 version of the OS but is that really necessary? isn't there another way?
Find
Reply
Jeroen52
Gangsta
*****
Posts: 882
Threads: 34
Joined: Oct 2008
Reputation: 0
#2,509

20.09.2017, 11:17
Quote:
Originally Posted by Aliassassin123456
Посмотреть сообщение
I got so many errors trying to install those, I think I should install i386 version of the OS but is that really necessary? isn't there another way?
What errors did you get?
Find
Reply
BrianHarrisHun
Little Clucker
**
Posts: 17
Threads: 9
Joined: Oct 2014
Reputation: 0
#2,510

09.11.2017, 17:13
Hi!
what's the difference between cache and orm?
Find
Reply
Xeon™
Banned
Posts: 457
Threads: 7
Joined: Jul 2017
#2,511

09.11.2017, 18:10
Quote:
Originally Posted by BrianHarrisHun
Посмотреть сообщение
Hi!
what's the difference between cache and orm?
ORM is a thing, and mysql is a thing

read this https://www.quora.com/What-is-the-di...ORMs-and-MySQL
Find
Reply
wallee
Huge Clucker
****
Posts: 266
Threads: 22
Joined: Jan 2017
Reputation: 0
#2,512

11.11.2017, 09:32
can this plugin still be called mysql if it now uses mariadb?
Find
Reply
maddinat0r
Banned
Posts: 845
Threads: 3
Joined: Jun 2010
#2,513

12.11.2017, 07:45
Quote:
Originally Posted by wallee
Посмотреть сообщение
can this plugin still be called mysql if it now uses mariadb?
A good question actually!
The MariaDB client library is compatible to MySQL and MariaDB servers. If this changes in the future, I'll make separate builds which use the MariaDB and the MySQL client library.
So basically you could say the MySQL plugin now additionally has support for MariaDB servers.
Find
Reply
Luca12
Banned
Posts: 1,018
Threads: 320
Joined: Jul 2010
#2,514

13.11.2017, 00:11
Hello maddinat0r when I try switch from R39-6 to R-40 and I compile gamemode with new a_mysql I get errors
pawn Код:
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3169) : error 017: undefined symbol "LOG_ALL"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3170) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3178) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3201) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3202) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3203) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3204) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3205) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3206) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3207) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3208) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3209) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3210) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3211) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3212) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3213) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3214) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3215) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3216) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3217) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3219) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3220) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3221) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3222) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3223) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3224) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3225) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3226) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3227) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3228) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3229) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(10563) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(10564) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(10940) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(10941) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11201) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11203) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11205) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11207) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11209) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11211) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11213) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11215) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11217) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11218) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11220) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11222) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11224) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11226) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11228) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11230) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11232) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11234) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11236) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11238) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12145) : error 017: undefined symbol "cache_get_data"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12148) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12149) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12150) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12151) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12152) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12153) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12154) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12155) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12156) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12157) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12158) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12159) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12160) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12144) : warning 203: symbol is never used: "fields"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12168) : error 017: undefined symbol "cache_get_data"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12171) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12172) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12173) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12174) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12175) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12176) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12177) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12178) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12179) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12180) : error 017: undefined symbol "cache_get_field_content"

Compilation aborted.Pawn compiler 3.2.3664          Copyright (c) 1997-2006, ITB CompuPhase


26 Errors.
for tag mismatch here is code
pawn Код:
mysql_tquery(mysql,"SELECT * FROM swatmembers","LoadSWAT","");
Find
Reply
Unrea1
Gangsta
*****
Posts: 824
Threads: 80
Joined: Oct 2013
Reputation: 0
#2,515

13.11.2017, 00:55
Quote:
Originally Posted by Luca12
Посмотреть сообщение
Hello maddinat0r when I try switch from R39-6 to R-40 and I compile gamemode with new a_mysql I get errors
pawn Код:
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3169) : error 017: undefined symbol "LOG_ALL"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3170) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3178) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3201) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3202) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3203) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3204) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3205) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3206) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3207) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3208) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3209) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3210) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3211) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3212) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3213) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3214) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3215) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3216) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3217) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3219) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3220) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3221) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3222) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3223) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3224) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3225) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3226) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3227) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3228) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(3229) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(10563) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(10564) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(10940) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(10941) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11201) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11203) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11205) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11207) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11209) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11211) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11213) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11215) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11217) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11218) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11220) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11222) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11224) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11226) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11228) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11230) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11232) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11234) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11236) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(11238) : warning 213: tag mismatch
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12145) : error 017: undefined symbol "cache_get_data"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12148) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12149) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12150) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12151) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12152) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12153) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12154) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12155) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12156) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12157) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12158) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12159) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12160) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12144) : warning 203: symbol is never used: "fields"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12168) : error 017: undefined symbol "cache_get_data"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12171) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12172) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12173) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12174) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12175) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12176) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12177) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12178) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12179) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Ivica\Documents\GURP MYSQL v4.0.0\gamemodes\guRP_4.0.0_mysql.pwn(12180) : error 017: undefined symbol "cache_get_field_content"

Compilation aborted.Pawn compiler 3.2.3664          Copyright (c) 1997-2006, ITB CompuPhase


26 Errors.
for tag mismatch here is code
pawn Код:
mysql_tquery(mysql,"SELECT * FROM swatmembers","LoadSWAT","");
https://sampforum.blast.hk/showthread.php?tid=616103
Find
Reply
wallee
Huge Clucker
****
Posts: 266
Threads: 22
Joined: Jan 2017
Reputation: 0
#2,516

14.11.2017, 09:24
can i run select queries on the terminal while the server is active or i shouldn't do that since it might f**k things up? desync something etc?
Find
Reply
admantis
High-roller
*****
Posts: 2,524
Threads: 109
Joined: Sep 2009
Reputation: 0
#2,517

17.12.2017, 23:52
( Последний раз редактировалось admantis; 18.12.2017 в 13:46. )
I'm using XAMPP in Debian 8.9 with version R40 of this plugin and it loads properly but as soon as I attempt to do any SQL queries I get this error:
Quote:

MySQL: ERROR 2002 (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)).
That directory/file however doesn't exist in the system, the socket is actually in /opt/lampp/var/mysql/mysql.sock as installed per XAMPP. Does anybody have any ideas of what could be causing this? Thank you.

EDIT: If anybody else is running into this problem, try creating a symlink between the two paths. It worked for me
Find
Reply
Locky_
High-roller
*****
Posts: 1,605
Threads: 61
Joined: Jul 2012
Reputation: 0
#2,518

01.01.2018, 11:20
What does this "core" file mean that has been modified after 1 second of my mysql error log?
Find
Reply
Meller
Banned
Posts: 578
Threads: 40
Joined: Dec 2016
#2,519

11.01.2018, 12:35
Where can I find the documentary of R39-6?
Find
Reply
maddinat0r
Banned
Posts: 845
Threads: 3
Joined: Jun 2010
#2,520

11.01.2018, 16:32
Quote:
Originally Posted by Meller
Посмотреть сообщение
Where can I find the documentary of R39-6?
https://sampwiki.blast.hk/wiki/MySQL/R33
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 4 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Plugin Development