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!