[MySQL] Help - Printable Version

[MySQL] Help - 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] Help (/showthread.php?tid=260233)

[MySQL] Help - Luis- - 07.06.2011

Hello, I seem to have some problems with my MySQL:

Код:

[00:05:36] errorid: 1054 | error: Unknown column '481100' in 'field list' | resultid: -1 | extraid: -1 | callback: NULL | query: INSERT INTO houses (houseOwner, houseLocked, housePrice) VALUES('Nobody', '1', `481100`)

That is what I am getting and I have no idea why I am using Calgon's Vortex Roleplay 2 script and have never encountered this before.

Re: [MySQL] Help - StilThere - 07.06.2011

Does your VPS or home PC (depending on where you run your server) have that database? If no, create it?

Re: [MySQL] Help - Luis- - 07.06.2011

It does have it, I use the same database for my main server where the script it hosted.

Re: [MySQL] Help - Scenario - 07.06.2011

You are doing this:

pawn Код:

`481100`

When it should be:

pawn Код:

'481100'

See the difference?