No, because the default GCC compiler is on version 4.1.x. R39-2 requires at least GCC 4.4.x (and R40 will require GCC 4.7/4..
|
C:\Users\ZOFTer\Desktop\Ravens MYSQL\gamemodes\ZZZ.pwn(26472) : error 017: undefined symbol "inline"
C:\Users\ZOFTer\Desktop\Ravens MYSQL\gamemodes\ZZZ.pwn(26472) : error 017: undefined symbol "Grabber"
C:\Users\ZOFTer\Desktop\Ravens MYSQL\gamemodes\ZZZ.pwn(26473) : error 017: undefined symbol "cache_insert_id"
C:\Users\ZOFTer\Desktop\Ravens MYSQL\gamemodes\ZZZ.pwn(26477) : error 017: undefined symbol "mysql_tquery_inline"
C:\Users\ZOFTer\Desktop\Ravens MYSQL\gamemodes\ZZZ.pwn(26477) : error 017: undefined symbol "inline"
C:\Users\ZOFTer\Desktop\Ravens MYSQL\gamemodes\ZZZ.pwn(26477) : warning 215: expression has no effect
C:\Users\ZOFTer\Desktop\Ravens MYSQL\gamemodes\ZZZ.pwn(26477) : warning 215: expression has no effect
C:\Users\ZOFTer\Desktop\Ravens MYSQL\gamemodes\ZZZ.pwn(26477) : error 001: expected token: ";", but found ")"
C:\Users\ZOFTer\Desktop\Ravens MYSQL\gamemodes\ZZZ.pwn(26477) : fatal error 107: too many error messages on one line
Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase
7 Errors.
inline Grabber() { // 26472
HouseInfo[houseid][hdbID] = cache_insert_id(dbhandle); // 26473
printf("[SCRIPT]: Created house %d (%d)", houseid, HouseInfo[houseid][hdbID]);
OnPropUpdate(1,houseid);
}
mysql_tquery_inline(dbhandle, "INSERT INTO properties() VALUES()", using inline "Grabber", ""); // 26477
[03:49:12] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [03:49:12] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [03:49:12] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [03:49:12] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) |
Trying to update from R37 to R39-2 and I am having a problem
Now here is the problem on R37 it works fine and I don't need for it too connect to mysqld.sock where on R39-2 I have too and the problem is I am on CentOS with cPanel and mysqld.stock isn't included only mysql.stock and there's no way to install the mySQL server with yum or anything I've tried everything. |
Use the static version from the general Linux download.
Create a shared link from 'mysqld.sock' to 'mysql.sock' or use the normal CentOS build (pretty sure that this should fix that error too). |
You don't have to resend the queries if the connection dropped. Just enable the auto-reconnect function through mysql_connect (which is enabled by default).
|
Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory) |
cmd:vhouse(pid,params[]) { #pragma unused params new d[32],a[32],p[32],r[32]; new rows; mysql_query(handle,"SELECT * FROM `adminlog`"); rows = cache_num_rows(); for(new i=0;i<rows;i++) { cache_get_field_content(0,"Date",d[i]); cache_get_field_content(0,"Admin",a[i]); cache_get_field_content(0,"Player",p[i]); cache_get_field_content(0,"Reason",r[i]); sfm(pid,-1,"Date: %s,Admin: %s,Player: %s,Reason: %s",d[i],a[i],p[i],r[i]); } return 1; }
[12:34:03] [DEBUG] cache_get_row_count - connection: 1 [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Date", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Date", data: "11/พฤศจิกายน/2014 - 15:15" [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Admin", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Admin", data: "izcream" [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Player", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Player", data: "ไม่มี" [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Reason", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Reason", data: "สร้าง Pickup" [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Date", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Date", data: "11/พฤศจิกายน/2014 - 15:15" [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Admin", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Admin", data: "izcream" [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Player", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Player", data: "ไม่มี" [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Reason", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Reason", data: "สร้าง Pickup" [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Date", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Date", data: "11/พฤศจิกายน/2014 - 15:15" [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Admin", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Admin", data: "izcream" [12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Player", connection: 1, max_len: 1 [12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Player", data: "ไม่มี"
cmd:vhouse(pid,params[])
{
#pragma unused params
mysql_tquery(handle, "SELECT * FROM adminlog", "OnLoadAdminLog", "i", playerid);
return true;
}
forward OnLoadAdminLog(playerid);
public OnLoadAdminLog(playerid)
{
new d[32], a[32], p[32], r[32];
for(new i = 0; i != cache_get_row_count(); i++)
{
cache_get_field_content(i, "Date", d);
cache_get_field_content(i, "Admin", a);
cache_get_field_content(i, "Player", p);
cache_get_field_content(i, "Reason", r);
printf("Date: %s, Admin: %s, Player: %s, Reason: %s", d, a, p, r);
//sfm(playerid,-1,"Date: %s, Admin: %s, Player: %s, Reason: %s", d, a, p, r);
}
return true;
}