SA-MP Forums Archive
MySQL problem - 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 problem (/showthread.php?tid=207662)



MySQL problem - GaB1TzZzu - 06.01.2011

I`m using ModernTopia GameMod and i have a mysql problem. If i make an player GM/Tester, i can find in DataBase at GMLevel 1, but after restart, i will find 0. So, after restart, GM level doesn't save, just Admin Level.


Re: MySQL problem - Kaylux - 06.01.2011

Check your MySQL Log for errors or just post it here and as far as I know that script uses an outdated plugin too.


Re: MySQL problem - Toreno - 06.01.2011

Give us your SAVE function...


Re: MySQL problem - GaB1TzZzu - 06.01.2011

Код:
101227 19:26:25 [Note] Plugin 'FEDERATED' is disabled.
101227 19:26:26  InnoDB: Started; log sequence number 0 46409
101227 19:26:26 [Note] Event Scheduler: Loaded 0 events
101227 19:26:26 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
101228 13:07:22 [Note] wampmysqld: Normal shutdown

101228 13:07:22 [Note] Event Scheduler: Purging the queue. 0 events
101228 13:07:22  InnoDB: Starting shutdown...
101228 13:07:24  InnoDB: Shutdown completed; log sequence number 0 46409
101228 13:07:24 [Warning] Forcing shutdown of 1 plugins
101228 13:07:24 [Note] wampmysqld: Shutdown complete

101228 16:20:26 [Note] Plugin 'FEDERATED' is disabled.
101228 16:20:26  InnoDB: Started; log sequence number 0 46409
101228 16:20:26 [Note] Event Scheduler: Loaded 0 events
101228 16:20:26 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
                                                                                                                                                                                                                                                                                                                                                                     101228 20:43:12 [Note] Plugin 'FEDERATED' is disabled.
101228 20:43:12  InnoDB: Started; log sequence number 0 46409
101228 20:43:12 [Note] Event Scheduler: Loaded 0 events
101228 20:43:12 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
101230 18:32:03 [Note] wampmysqld: Normal shutdown

101230 18:32:03 [Note] Event Scheduler: Purging the queue. 0 events
101230 18:32:03  InnoDB: Starting shutdown...
101230 18:32:04  InnoDB: Shutdown completed; log sequence number 0 46409
101230 18:32:04 [Warning] Forcing shutdown of 1 plugins
101230 18:32:04 [Note] wampmysqld: Shutdown complete

101230 20:02:14 [Note] Plugin 'FEDERATED' is disabled.
101230 20:02:14  InnoDB: Started; log sequence number 0 46409
101230 20:02:14 [Note] Event Scheduler: Loaded 0 events
101230 20:02:15 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110102 11:36:21 [Note] Plugin 'FEDERATED' is disabled.
110102 11:36:21  InnoDB: Started; log sequence number 0 46409
110102 11:36:21 [Note] Recovering after a crash using mysql-bin
110102 11:36:32 [Note] Starting crash recovery...
110102 11:36:32 [Note] Crash recovery finished.
110102 11:36:32 [Note] Event Scheduler: Loaded 0 events
110102 11:36:32 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110102 14:46:18 [Note] wampmysqld: Normal shutdown

110102 14:46:18 [Note] Event Scheduler: Purging the queue. 0 events
110102 14:46:18  InnoDB: Starting shutdown...
110102 14:46:19  InnoDB: Shutdown completed; log sequence number 0 46409
110102 14:46:19 [Warning] Forcing shutdown of 1 plugins
110102 14:46:19 [Note] wampmysqld: Shutdown complete

110103 12:09:56 [Note] Plugin 'FEDERATED' is disabled.
110103 12:09:56  InnoDB: Started; log sequence number 0 46409
110103 12:09:56 [Note] Event Scheduler: Loaded 0 events
110103 12:09:56 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110103 13:05:37 [Note] wampmysqld: Normal shutdown

110103 13:05:37 [Note] Event Scheduler: Purging the queue. 0 events
110103 13:05:39  InnoDB: Starting shutdown...
110103 13:05:40  InnoDB: Shutdown completed; log sequence number 0 46409
110103 13:05:40 [Warning] Forcing shutdown of 1 plugins
110103 13:05:40 [Note] wampmysqld: Shutdown complete

110103 13:06:21 [Note] Plugin 'FEDERATED' is disabled.
110103 13:06:21  InnoDB: Started; log sequence number 0 46409
110103 13:06:21 [Note] Event Scheduler: Loaded 0 events
110103 13:06:21 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110103 20:24:51 [Note] wampmysqld: Normal shutdown

110103 20:24:51 [Note] Event Scheduler: Purging the queue. 0 events
110103 20:24:51  InnoDB: Starting shutdown...
110103 20:24:52  InnoDB: Shutdown completed; log sequence number 0 46409
110103 20:24:52 [Warning] Forcing shutdown of 1 plugins
110103 20:24:52 [Note] wampmysqld: Shutdown complete

110103 22:50:59 [Note] Plugin 'FEDERATED' is disabled.
110103 22:51:00  InnoDB: Started; log sequence number 0 46409
110103 22:51:00 [Note] Event Scheduler: Loaded 0 events
110103 22:51:00 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110104 19:34:21 [Note] wampmysqld: Normal shutdown

110104 19:34:21 [Note] Event Scheduler: Purging the queue. 0 events
110104 19:34:21  InnoDB: Starting shutdown...
110104 19:34:22  InnoDB: Shutdown completed; log sequence number 0 46409
110104 19:34:22 [Warning] Forcing shutdown of 1 plugins
110104 19:34:22 [Note] wampmysqld: Shutdown complete

110104 19:56:53 [Note] Plugin 'FEDERATED' is disabled.
110104 19:56:53  InnoDB: Started; log sequence number 0 46409
110104 19:56:54 [Note] Event Scheduler: Loaded 0 events
110104 19:56:54 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110105 16:26:05 [Note] wampmysqld: Normal shutdown

110105 16:26:05 [Note] Event Scheduler: Purging the queue. 0 events
110105 16:26:05  InnoDB: Starting shutdown...
110105 16:26:05  InnoDB: Shutdown completed; log sequence number 0 46409
110105 16:26:05 [Warning] Forcing shutdown of 1 plugins
110105 16:26:05 [Note] wampmysqld: Shutdown complete

110105 19:32:00 [Note] Plugin 'FEDERATED' is disabled.
110105 19:32:00  InnoDB: Started; log sequence number 0 46409
110105 19:32:00 [Note] Event Scheduler: Loaded 0 events
110105 19:32:00 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
And the save function:
[pwn]
PlayerInfo[para1][pGM] = level;
MySQLUpdatePlayerIntSingle(para1, "GMLevel", level);
[/pwn]


Re: MySQL problem - GaB1TzZzu - 07.01.2011

Help me.


Re: MySQL problem - GaB1TzZzu - 08.01.2011

So... ?


Re: MySQL problem - GaB1TzZzu - 08.01.2011

I resolved this thing.. I need help here: https://sampforum.blast.hk/showthread.php?tid=207996 ..

Need closed!