MySQL not storing - Printable Version

MySQL not storing - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL not storing (/showthread.php?tid=643754)

MySQL not storing - Jing_Chan - 26.10.2017

Код:

[20:49:08 10/26/17] [DEBUG] mysql_format - connection: 1, len: 550, format: "UPDATE faction_ranks SET factionrank%i = '%e' WHERE faction_id = %i"
[20:49:08 10/26/17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE faction_ranks SET factionrank1 = 'Chief of Police' WHERE ", callback: "(null)", format: "(null)"

Код:

[20:49:08 10/26/17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:49:08 10/26/17] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.197 milliseconds
[20:49:08 10/26/17] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

help?? literally doesn't store shit in it

Re: MySQL not storing - ISmokezU - 26.10.2017

Your Update query doesn't know where to update to. It's updating yes but doesn't know where to update it.

Maybe post some code or something

Код:

[20:49:08 10/26/17] [DEBUG] mysql_format - connection: 1, len: 550, format: "UPDATE faction_ranks SET factionrank%i = '%e' WHERE faction_id = %i"

[20:49:08 10/26/17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE faction_ranks SET factionrank1 = 'Chief of Police' WHERE Where what?", callback: "(null)", format: "(null)"

Re: MySQL not storing - Skream - 26.10.2017

raise up your string size

Re: MySQL not storing - Jing_Chan - 26.10.2017

Quote:

Originally Posted by ISmokezU

Your Update query doesn't know where to update to. It's updating yes but doesn't know where to update it.

Maybe post some code or something

Код:

[20:49:08 10/26/17] [DEBUG] mysql_format - connection: 1, len: 550, format: "UPDATE faction_ranks SET factionrank%i = '%e' WHERE faction_id = %i"

[20:49:08 10/26/17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE faction_ranks SET factionrank1 = 'Chief of Police' WHERE Where what?", callback: "(null)", format: "(null)"

pawn Код:

mysql_format(m_Handle, query, sizeof(query), "UPDATE faction_ranks SET factionrank%i = '%e' WHERE faction_id = %i", i, FactionRanks[factionid][i], FactionData[factionid][factionID]);
        mysql_tquery(m_Handle, query);

Re: MySQL not storing - Jing_Chan - 26.10.2017

solved, close