[Plugin] [REL] MySQL Plugin (Now on github!)

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.
Reply

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.
Reply

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.
Reply

if i'm already using your log-core plugin i can ignore the log-core.dll or should i overwrite?
Reply

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
Reply

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.
Reply

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 
Reply

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?
Reply

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?
Reply

Hi!
what's the difference between cache and orm?
Reply

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
Reply

can this plugin still be called mysql if it now uses mariadb?
Reply

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.
Reply

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","");
Reply

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
Reply

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?
Reply

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
Reply

What does this "core" file mean that has been modified after 1 second of my mysql error log?
Reply

Where can I find the documentary of R39-6?
Reply

Quote:
Originally Posted by Meller
Посмотреть сообщение
Where can I find the documentary of R39-6?
https://sampwiki.blast.hk/wiki/MySQL/R33
Reply


Forum Jump:


Users browsing this thread: 4 Guest(s)