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 ] );
CREATE VIEW CharacterInteraction AS SELECT characters.id, ...
SELECT * FROM CharacterInteraction
[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
-- 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
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 Код:
-- 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 No errors on compiling tho. |
sudo apt-get install mysql-client:i386
sudo apt-get install libmysqlclient-dev:i386
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?
|
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.
mysql_tquery(mysql,"SELECT * FROM swatmembers","LoadSWAT","");
Hello maddinat0r when I try switch from R39-6 to R-40 and I compile gamemode with new a_mysql I get errors
pawn Код:
pawn Код:
|
MySQL: ERROR 2002 (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)). |