Posts: 102
Threads: 20
Joined: Nov 2016
Reputation:
0
hy all i make server using my sql.and i upload sql file which contain 2 coloum playerbans and playerstats when i play game i login from my account and give myself money admin and more but when i relog my stats reset and when i see in database its just account register and nothing in it how to fix these so player data save on sql file
help
Posts: 872
Threads: 25
Joined: Sep 2014
Reputation:
0
Maybe there's an error in save player stats query. Is there any errors in your mysql log?
Posts: 102
Threads: 20
Joined: Nov 2016
Reputation:
0
Wed Dec 14 08:29:51 2016] Logging Started
[Wed Dec 14 08:29:51 2016] -------------------------
[Wed Dec 14 08:29:51 2016] Connected (0) to port_2509 @ 127.0.0.1 via TCP/IP.
[Wed Dec 14 08:29:51 2016] MySQL Server Version 5.5.50-0+deb8u1.
[Wed Dec 14 08:29:51 2016] Error (0): Could not execute query. Table 'port_2509.gang' doesn't exist.
[Wed Dec 14 08:29:51 2016] MySQL closed. Logging ended.
[Wed Dec 14 08:32:26 2016] -------------------------
[Wed Dec 14 08:32:26 2016] Logging Started
[Wed Dec 14 08:32:26 2016] -------------------------
[Wed Dec 14 08:32:27 2016] Connected (0) to port_2509 @ 127.0.0.1 via TCP/IP.
[Wed Dec 14 08:32:27 2016] MySQL Server Version 5.5.50-0+deb8u1.
[Wed Dec 14 08:32:27 2016] Error (0): Could not execute query. Table 'port_2509.gang' doesn't exist.
[Wed Dec 14 08:34:29 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:34:29 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:34:29 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:35:05 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:37:17 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:37:17 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:37:17 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:39:35 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:39:42 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:41:04 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:49:37 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:54:06 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:54:49 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:56:29 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 08:59:37 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:02:16 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:06:38 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:15:51 2016] -------------------------
[Wed Dec 14 09:15:51 2016] Logging Started
[Wed Dec 14 09:15:51 2016] -------------------------
[Wed Dec 14 09:15:52 2016] Connected (0) to port_2509 @ 127.0.0.1 via TCP/IP.
[Wed Dec 14 09:15:52 2016] MySQL Server Version 5.5.50-0+deb8u1.
[Wed Dec 14 09:15:52 2016] Error (0): Could not execute query. Table 'port_2509.gang' doesn't exist.
[Wed Dec 14 09:16:43 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:18:55 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:22:28 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:22:42 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:26:20 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:26:23 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:27:04 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:27:13 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:28:28 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:28:45 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:29:43 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:30:39 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:37:40 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:37:51 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:37:52 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:37:53 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:37:54 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:37:54 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:38:05 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:38:09 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:38:15 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:38:16 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:38:19 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 09:43:11 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:44:08 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:44:08 2016] Error (0): Could not execute query. Table 'port_2509.playerbans' doesn't exist.
[Wed Dec 14 09:45:44 2016] Error (0): Could not execute query. Table 'port_2509.playerbans' doesn't exist.
[Wed Dec 14 09:46:19 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:46:41 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:46:51 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:47:05 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:47:11 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:47:37 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:47:48 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:48:48 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:48:48 2016] Error (0): Could not execute query. Table 'port_2509.playerbans' doesn't exist.
[Wed Dec 14 09:53:42 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:53:42 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:54:23 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 09:59:08 2016] Error (0): Could not execute query. Table 'port_2509.playerdata' doesn't exist.
[Wed Dec 14 10:09:34 2016] -------------------------
[Wed Dec 14 10:09:34 2016] Logging Started
[Wed Dec 14 10:09:34 2016] -------------------------
[Wed Dec 14 10:09:35 2016] Connected (0) to port_2509 @ 127.0.0.1 via TCP/IP.
[Wed Dec 14 10:09:35 2016] MySQL Server Version 5.5.50-0+deb8u1.
[Wed Dec 14 10:09:35 2016] Error (0): Could not execute query. Table 'port_2509.gang' doesn't exist.
[Wed Dec 14 10:10:17 2016] -------------------------
[Wed Dec 14 10:10:17 2016] Logging Started
[Wed Dec 14 10:10:17 2016] -------------------------
[Wed Dec 14 10:10:18 2016] Connected (0) to port_2509 @ 127.0.0.1 via TCP/IP.
[Wed Dec 14 10:10:18 2016] MySQL Server Version 5.5.50-0+deb8u1.
[Wed Dec 14 10:10:18 2016] Error (0): Could not execute query. Table 'port_2509.gang' doesn't exist.
[Wed Dec 14 10:12:16 2016] -------------------------
[Wed Dec 14 10:12:16 2016] Logging Started
[Wed Dec 14 10:12:16 2016] -------------------------
[Wed Dec 14 10:12:18 2016] Connected (0) to port_2509 @ 127.0.0.1 via TCP/IP.
[Wed Dec 14 10:12:18 2016] MySQL Server Version 5.5.50-0+deb8u1.
[Wed Dec 14 10:12:18 2016] Error (0): Could not execute query. Table 'port_2509.gang' doesn't exist.
[Wed Dec 14 10:14:08 2016] -------------------------
[Wed Dec 14 10:14:08 2016] Logging Started
[Wed Dec 14 10:14:08 2016] -------------------------
[Wed Dec 14 10:14:10 2016] Connected (0) to port_2509 @ 127.0.0.1 via TCP/IP.
[Wed Dec 14 10:14:10 2016] MySQL Server Version 5.5.50-0+deb8u1.
[Wed Dec 14 10:14:10 2016] Error (0): Could not execute query. Table 'port_2509.gang' doesn't exist.
[Wed Dec 14 10:15:49 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 10:19:23 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 10:19:42 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 10:20:24 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 10:21:32 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 10:24:37 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 10:24:37 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
[Wed Dec 14 10:26:48 2016] Error (0): Could not execute query. Unknown column 'gang' in 'field list'.
i didnt make gane column but how to fix player data?