[Jumberi]

can you give us sql which is filled with the missing columns?

I tried by myself , and when i checked char in db there was nothing changed Age="Invalid" Gender="Invalid" uhm and also this sql errors popped up

Code:

[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("SetupInfo") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Gender") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("RentAt") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype

[N0FeaR]

Good job keep it up!

[0x88]

Quote:

Originally Posted by Jumberi can you give us sql which is filled with the missing columns? I tried by myself , and when i checked char in db there was nothing changed Age="Invalid" Gender="Invalid" uhm and also this sql errors popped up Code: [13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype [13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("SetupInfo") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'") [13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype [13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Gender") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'") [13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype [13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("RentAt") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'") [13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype

SetupInfo, Gender, RentAt are missing, add them in the 'characters' table it should be fixed

[Klayton]

Can you give me the syntax of this value for the database ?

http://prntscr.com/huyk19

[0x88]

Quote:

Originally Posted by Klayton Can you give me the syntax of this value for the database ? http://prntscr.com/huyk19

They are smallint type and should be 6 length

[KietXoi]

I'm having a problem with your code, it can not be read when I use that statement

mysql_format(this, query, sizeof(query), "INSERT INTO businesses (BusinessType, BusinessName) VALUES(%i, '%s')", type_id, ReturnBusinessName(type_id));
mysql_tquery(this, query, "Query_InsertBusiness", "iii", playerid, idx, type_id, ReturnBusinessName(type_id));

[Gangstakilla]

Good work. I repped.

[Jumberi]

Quote:

Originally Posted by KietXoi I'm having a problem with your code, it can not be read when I use that statement mysql_format(this, query, sizeof(query), "INSERT INTO businesses (BusinessType, BusinessName) VALUES(%i, '%s')", type_id, ReturnBusinessName(type_id)); mysql_tquery(this, query, "Query_InsertBusiness", "iii", playerid, idx, type_id, ReturnBusinessName(type_id));

can you give me a database? if you updated characters table?

[DavidGravelli]

where is the UCP?

[REmixs1]

I have black window when i respawned at the LSI someone know how to delete it?

[Gong]

Any solution for the registering thing or do I need to do something in PHPMyAdmin or MySQL because when I enter my password it just stays at some kind of beach or something like that.

[lostmode]

Anyone can fix the sql problem and share the fixed sql ?

[homelessdrop]

Hello @0x88 .
I have two ask for you. I did everything, everything works, but. If I make a new one character, sql create the line in "characters" but not in "masters" too, but everything is loaded good (admin level,skin,pos etc.). And the next is, if a make the business, set entrance/interior, and walk to "entrance" pickup, in the moment gta crashed.. Maybe idea?
(sry for a bad english)

[NLDBrian]

For some reasons players keep spawning at the airport, instead of their last known position? I checked the on player connect, login and spawn, but no clue whats wrong...

[penaut]

Fixed the registration errors in the databasehttp://www70.zippyshare.com/v/GXZMNbb5/file.html

[P00kie]

looks good first i see this script

[NailOrduna]

Explication in English:
Help me, I have a problem with the database, the localhost receives it well, I have no problems in importing anything, the problem is that it does not connect me to the database, here I bring my .logs of the console and of MySQL

Explicaciуn en Espaсol:
Ayudenme, tengo un problema con la base de datos, el localhost me la recibe bien, no tengo problemas en importarla nada, el problema estб en que no me conecta a la base de datos, aquн les traigo mis .logs de la consola y de MySQL.

Log de consola / Console log:

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

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

[00:12:34] filterscripts = "" (string)
[00:12:34]
[00:12:34] Server Plugins
[00:12:34] --------------
[00:12:34] Loading plugin: mysql.dll
[00:12:35] >> plugin.mysql: R39-6 successfully loaded.
[00:12:35] Loaded.
[00:12:35] Loading plugin: pawncmd.dll
[00:12:35] Pawn.CMD plugin v3.1.4 by urShadow loaded
[00:12:35] Loaded.
[00:12:35] Loading plugin: sscanf.dll
[00:12:35]

[00:12:35] ===============================

[00:12:35] sscanf plugin loaded.

[00:12:35] Version: 2.8.2

[00:12:35] © 2012 Alex "Y_Less" Cole

[00:12:35] ===============================

[00:12:35] Loaded.
[00:12:35] Loading plugin: streamer.dll
[00:12:35]

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

[00:12:35] Loaded.
[00:12:35] Loaded 4 plugins.

[00:12:35]
[00:12:35] Filterscripts
[00:12:35] ---------------
[00:12:35] Loaded 0 filterscripts.

[00:12:35] [ADM] Info: Load 3DTryg v4.5.2 for SA:MP 0.3.7 by Abyss Morgan
[00:12:35] [DATABASE]: Connection failed to 'ls-rp'...
[00:12:35] Number of vehicle models: 1
[00:12:36]
[00:12:36] [ADM] Info: Please update your 3DTryg include to v4.6.1 from here:
[00:12:36] http://8.ct8.pl/d/3DTryg.inc
[00:12:36]


Log de MySQL / Log MySQL.

[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)

[penaut]

You need to edit the mysql connection in the mod, read some about mysql r39 first of all

[bigtigerbeee]

Oh, nice. I'm trying to develop script like LS-RP too.

Vehicle System:


Phone System:


Car Moding Shop:


And more...

I waiting for your drug system, I can't access it on LS-RP

Turf
http://ls-rp.in.th/turfmap/

[Astralis]

Quote:

Originally Posted by NailOrduna Explication in English: Help me, I have a problem with the database, the localhost receives it well, I have no problems in importing anything, the problem is that it does not connect me to the database, here I bring my .logs of the console and of MySQL Explicaciуn en Espaсol: Ayudenme, tengo un problema con la base de datos, el localhost me la recibe bien, no tengo problemas en importarla nada, el problema estб en que no me conecta a la base de datos, aquн les traigo mis .logs de la consola y de MySQL. Log de consola / Console log: ---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [00:12:34] filterscripts = "" (string) [00:12:34] [00:12:34] Server Plugins [00:12:34] -------------- [00:12:34] Loading plugin: mysql.dll [00:12:35] >> plugin.mysql: R39-6 successfully loaded. [00:12:35] Loaded. [00:12:35] Loading plugin: pawncmd.dll [00:12:35] Pawn.CMD plugin v3.1.4 by urShadow loaded [00:12:35] Loaded. [00:12:35] Loading plugin: sscanf.dll [00:12:35] [00:12:35] =============================== [00:12:35] sscanf plugin loaded. [00:12:35] Version: 2.8.2 [00:12:35] © 2012 Alex "Y_Less" Cole [00:12:35] =============================== [00:12:35] Loaded. [00:12:35] Loading plugin: streamer.dll [00:12:35] *** Streamer Plugin v2.9.1 by Incognito loaded *** [00:12:35] Loaded. [00:12:35] Loaded 4 plugins. [00:12:35] [00:12:35] Filterscripts [00:12:35] --------------- [00:12:35] Loaded 0 filterscripts. [00:12:35] [ADM] Info: Load 3DTryg v4.5.2 for SA:MP 0.3.7 by Abyss Morgan [00:12:35] [DATABASE]: Connection failed to 'ls-rp'... [00:12:35] Number of vehicle models: 1 [00:12:36] [00:12:36] [ADM] Info: Please update your 3DTryg include to v4.6.1 from here: [00:12:36] http://8.ct8.pl/d/3DTryg.inc [00:12:36] Log de MySQL / Log MySQL. [00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES) [00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES) [00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES) [00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)

Make sure the database details are correct, you must have one.