MySQL Query not completing - Printable Version

MySQL Query not completing - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL Query not completing (/showthread.php?tid=228421)

MySQL Query not completing - jameskmonger - 19.02.2011

I couldn't put the whole query in to one line as I got an error, I do this and it only inserts the data up to "Rank4Name".

pawn Код:

new string[256];
    format(string, sizeof(string), "INSERT INTO groups (ID,Name,Rank1Name,Rank2Name,Rank3Name,Rank4Name) VALUES ('%d','%s','%s','%s','%s','%s')", rows += 1, GroupCreating[playerid][Name], GroupCreating[playerid][Rank1Name], GroupCreating[playerid][Rank2Name], GroupCreating[playerid][Rank3Name], GroupCreating[playerid][Rank4Name]);
    mysql_query(string);

    format(string, sizeof(string), "INSERT INTO groups (Rank5Name,Rank6Name,Rank7Name,Rank8Name,JoinRank) VALUES ('%s','%s','%s','%s','%d') WHERE Name='%d'", GroupCreating[playerid][Name], GroupCreating[playerid][Rank5Name], GroupCreating[playerid][Rank6Name], GroupCreating[playerid][Rank7Name], GroupCreating[playerid][Rank8Name], GroupCreating[playerid][JoinRank]);
    mysql_query(string);

Re: MySQL Query not completing - Scenario - 19.02.2011

Check your MySQL error log file.

Re: MySQL Query not completing - jameskmonger - 19.02.2011

Mind telling me where to find that? I'll have a look but this is the first time I've ever touched SQL.

Re: MySQL Query not completing - dice7 - 19.02.2011

WHERE Name='%d'"

Your name is an integer ?

Re: MySQL Query not completing - jameskmonger - 19.02.2011

Dice, that hasn't fixed it.

Re: MySQL Query not completing - dice7 - 19.02.2011

Could you show the (formated) queries and any errors in your error log ?

Re: MySQL Query not completing - Scenario - 19.02.2011

Which MySQL plugin are you using?

Re: MySQL Query not completing - jameskmonger - 19.02.2011

I am using G-Stylezzz' plugin. I have edited my queries to these:

pawn Код:

format(string, sizeof(string), "INSERT INTO groups (ID,Name,Rank1Name,Rank2Name,Rank3Name,Rank4Name) VALUES (%d,'%s','%s','%s','%s','%s')", groupID, GroupCreating[playerid][Name], GroupCreating[playerid][Rank1Name], GroupCreating[playerid][Rank2Name], GroupCreating[playerid][Rank3Name], GroupCreating[playerid][Rank4Name]);
    mysql_query(string);

    format(string, sizeof(string), "INSERT INTO groups (Rank5Name,Rank6Name,Rank7Name,Rank8Name,JoinRank) VALUES ('%s','%s','%s','%s',%d)", GroupCreating[playerid][Rank5Name], GroupCreating[playerid][Rank6Name], GroupCreating[playerid][Rank7Name], GroupCreating[playerid][Rank8Name], GroupCreating[playerid][JoinRank]);
    mysql_query(string);

And now it splits like so:

Re: MySQL Query not completing - Calgon - 19.02.2011

What types for your fields did you set?

Re: MySQL Query not completing - Hiddos - 19.02.2011

What if you use the 'UPDATE' syntax for the second query?