[Riddy]

Before R7, these queries worked.

Now, I get this:

Код:

[02:39:31] Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[02:39:31] ErrorID: 1064

I really don't get what changed on the latest plugin to stop these long queries from working.

Код:

UPDATE `properties` SET X = `%f`, Y = `%f`, Z = `%f`, eX = `%f`, eY = `%f`, eZ = `%f`, Owner = %s, Description = %s, \
		Cost = %d, Hel = %d, Arm = %d, Int = %d, Lock = %d, Owned = %d, Rooms = %d, Rent = %d, Rentabil = %d, \
		Takings = %d, Date = %d, Level = %d, World = %d, OutWorld = %d, OutInt = %d, OTaken = %d, Clothes = %d, \
		Clothes2 = %d, Clothes3 = %d, Safe = %d, Radio = %d, Station = %d, TV = %d WHERE ID = %d

That is currently what I have for my query..

[GWMPT]

Код:

UPDATE `properties` SET `X` = '%f', `Y` = '%f', `Z` = '%f', `eX` = '%f', `eY` = '%f', `eZ` = '%f', `Owner` = '%s', `Description` = '%s', \
		`Cost` = '%d', `Hel` = '%d', `Arm` = '%d', `Int` = '%d', `Lock` = '%d', `Owned` = '%d', `Rooms` = '%d', `Rent` = '%d', `Rentabil` = '%d', \
		`Takings` = '%d', `Date` = '%d', `Level` = '%d', `World` = '%d', `OutWorld` = '%d', `OutInt` = '%d', `OTaken` = '%d', `Clothes` = '%d', \
		`Clothes2` = '%d', `Clothes3` = '%d', `Safe` = '%d', `Radio` = '%d', `Station` = '%d' AND `TV` = '%d' WHERE `ID` = '%d'

Try that.

[Lorenc_]

Quote:

Originally Posted by Kikito Код: UPDATE `properties` SET `X` = '%f', `Y` = '%f', `Z` = '%f', `eX` = '%f', `eY` = '%f', `eZ` = '%f', `Owner` = '%s', `Description` = '%s', \ `Cost` = '%d', `Hel` = '%d', `Arm` = '%d', `Int` = '%d', `Lock` = '%d', `Owned` = '%d', `Rooms` = '%d', `Rent` = '%d', `Rentabil` = '%d', \ `Takings` = '%d', `Date` = '%d', `Level` = '%d', `World` = '%d', `OutWorld` = '%d', `OutInt` = '%d', `OTaken` = '%d', `Clothes` = '%d', \ `Clothes2` = '%d', `Clothes3` = '%d', `Safe` = '%d', `Radio` = '%d', `Station` = '%d' AND `TV` = '%d' WHERE `ID` = '%d' Try that.

You only use single quotes on strings!!!!

[Scenario]

You're using the graves incorrectly. Doing so can cause SQL errors.

pawn Код:

Y = `%f`

You're doing it the complete opposite way. It should be:

pawn Код:

`Y` = %f

However, you either have to surround each field (i.e. "Y") in graves, or just not use them at all. I like using them for clarity, but it's completely up to you as it's your code.

[Riddy]

I've tried without graving (which is my normal way), still no difference. Why is that long queries fail to work. My saving for player accounts has similar coding, but it works fine...

[Scenario]

Split the query up.

[Konstantinos]

It's because the lenght of the string is not large enough to store it and it cuts it, so it will give syntax error.

By the way

pawn Код:

// An example about '':
"UPDATE `something` SET integer = %d, float = %f, string = '%s' WHERE ID = 0"

[IstuntmanI]

Look into the mysql log and show us the final query.

Also, I recommend you to use MySQL R8 ****** Code.

[Scenario]

Quote:

Originally Posted by IstuntmanI Look into the mysql log and show us the final query. Also, I recommend you to use MySQL R8 ****** Code.

R20 is much faster, but R8 is an improvement of course.

[Riddy]

Quote:

Originally Posted by _Zeus It's because the lenght of the string is not large enough to store it and it cuts it, so it will give syntax error. By the way pawn Код: // An example about '': "UPDATE `something` SET integer = %d, float = %f, string = '%s' WHERE ID = 0"

Yep clumsy me.

I am using MySQL R7 REV 20

EDIT: Infact, that did not fix it. I'll ty RealCop's splitting input.