Mysql. - Printable Version

Mysql. - 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. (/showthread.php?tid=613541)

Mysql. - [HM]Nicky - 28.07.2016

Hey, Can somebody help me with this?

[20:33:10] [WARNING] cache_get_data - no active cache
[20:33:14] [ERROR] CMySQLQuery::Execute - (error #1146) Table 'database.playerdata' doesn't exist

Halp??

Re: Mysql. - Flake. - 28.07.2016

You haven't got an active cache to pick results from.

And your table is player not playerdata

Re: Mysql. - [HM]Nicky - 28.07.2016

I got it fixed, now the problem is Column count doesn't match value count at row 1.. It means?

Re: Mysql. - Konstantinos - 28.07.2016

pawn Код:

"INSERT INTO table (column1, column2) VALUES ('value1', 'value2', 'value3')"

As you can see in the example above, there are 2 columns and 3 values - like the error describes: "Column count doesn't match value count ..."

Re: Mysql. - [HM]Nicky - 28.07.2016

How to enable the cache?