MySQL - Query not storing data
#4

Quote:
Originally Posted by JaTochNietDan
Посмотреть сообщение
You specified too many values:

pawn Код:
"INSERT INTO `VehicleKeys` (ID,VehicleID,Linked) VALUES('%d','%d','%s','%d')"
You're only specifying 3 columns to insert a value into, yet you specify 4 values?

It should be more along the lines of this:

pawn Код:
"INSERT INTO `VehicleKeys` (ID,VehicleID,Linked) VALUES(%d,%d,%d)"
Yea I fixed that soon after I posted and it is still not storing data.

Quote:
Originally Posted by Strawhats
Посмотреть сообщение
Use mysql_debug(1); at OnGameModeInit and check if you are connected and whether the query was succesfull. A new file should be created.
Yea, I already have that and nothing out of the ordinary is showing up in my mysql_log

Код:
[Mon Jun 25 23:48:24 2012] -------------------------
[Mon Jun 25 23:48:24 2012]      Logging Started
[Mon Jun 25 23:48:24 2012] -------------------------
[Tue Jun 26 00:01:59 2012] -------------------------
[Tue Jun 26 00:01:59 2012]       Logging Ended
[Tue Jun 26 00:01:59 2012] -------------------------
[00:32:13] Unloading Plugin
[00:32:25] Unloading Plugin
[Tue Jun 26 00:42:30 2012] -------------------------
[Tue Jun 26 00:42:30 2012]      Logging Started
[Tue Jun 26 00:42:30 2012] -------------------------
[Tue Jun 26 00:43:21 2012] -------------------------
[Tue Jun 26 00:43:21 2012]      Logging Started
[Tue Jun 26 00:43:21 2012] -------------------------
[Tue Jun 26 00:44:26 2012] -------------------------
[Tue Jun 26 00:44:26 2012]       Logging Ended
[Tue Jun 26 00:44:26 2012] -------------------------
[Tue Jun 26 00:44:28 2012] -------------------------
[Tue Jun 26 00:44:28 2012]      Logging Started
[Tue Jun 26 00:44:28 2012] -------------------------
[Tue Jun 26 16:20:19 2012] -------------------------
[Tue Jun 26 16:20:19 2012]      Logging Started
[Tue Jun 26 16:20:19 2012] -------------------------
[Tue Jun 26 16:21:25 2012] -------------------------
[Tue Jun 26 16:21:25 2012]      Logging Started
[Tue Jun 26 16:21:25 2012] -------------------------
[Tue Jun 26 16:21:51 2012] -------------------------
[Tue Jun 26 16:21:51 2012]       Logging Ended
[Tue Jun 26 16:21:51 2012] -------------------------
[Tue Jun 26 16:21:55 2012] -------------------------
[Tue Jun 26 16:21:55 2012]      Logging Started
[Tue Jun 26 16:21:55 2012] -------------------------
[Tue Jun 26 16:22:42 2012] -------------------------
[Tue Jun 26 16:22:42 2012]      Logging Started
[Tue Jun 26 16:22:42 2012] -------------------------
[Tue Jun 26 16:37:05 2012] -------------------------
[Tue Jun 26 16:37:05 2012]       Logging Ended
[Tue Jun 26 16:37:05 2012] -------------------------
[Tue Jun 26 16:37:07 2012] -------------------------
[Tue Jun 26 16:37:07 2012]       Logging Ended
[Tue Jun 26 16:37:07 2012] -------------------------
[Tue Jun 26 16:40:00 2012] -------------------------
[Tue Jun 26 16:40:00 2012]      Logging Started
[Tue Jun 26 16:40:00 2012] -------------------------
[Tue Jun 26 16:43:02 2012] -------------------------
[Tue Jun 26 16:43:02 2012]       Logging Ended
[Tue Jun 26 16:43:02 2012] -------------------------
[16:51:30] Unloading Plugin
[19:10:34] Unloading Plugin
Reply


Messages In This Thread
MySQL - Query not storing data - by Deal-or-die - 28.06.2012, 07:58
Re: MySQL - Query not storing data - by JaTochNietDan - 28.06.2012, 08:09
Re: MySQL - Query not storing data - by Baboon - 28.06.2012, 08:09
Re: MySQL - Query not storing data - by Deal-or-die - 28.06.2012, 12:20
Re: MySQL - Query not storing data - by phillip875 - 28.06.2012, 13:32
Re: MySQL - Query not storing data - by Deal-or-die - 28.06.2012, 13:38
Re: MySQL - Query not storing data - by iGetty - 28.06.2012, 13:39

Forum Jump:


Users browsing this thread: 2 Guest(s)