1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
[Help] PHPMyAdmin Help
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#1

06.02.2013, 21:07
Hello, I'm having a problem with PHPMyAdmin saving account stats via MySQL. If I try to test it, instead of register, it will have the login dialog box appear, even though I don't have an account registered yet. If you attempt to log in, it will just kick you. Nothing happens when you compile it, that's not the problem. I'm not sure how to fix this, so I'll show you some images that should help in fixing this.


This only shows the defines for the MySQL system.



This is where the problem starts, instead of registering, it assumes you have an account and the login dialog box appears.



Here is all the stats saving variables, if this helps.



Here's my PHPMyAdmin page, showing the "users" table.



This is what comes up when you select this table.


Also, with the image above, I tried setting the "SELECT * FROM `users` LIMIT 0 , 30" to "SELECT * FROM `users` WHERE `name` = '%s' LIMIT 1" but it won't save, so idk what to do here

If anyone can help, please do so, I need this fixed ASAP.
Find
Reply
Kirollos
Gangsta
****
Posts: 566
Threads: 14
Joined: Jun 2010
Reputation: 0
#2

06.02.2013, 22:05
check mysql_logs.txt? PS: also add mysql_debug(true); on GameModeInit
Find
Reply
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#3

07.02.2013, 01:02
[20:23:59]

[20:23:59] ---------------------------

[20:23:59] MySQL Debugging activated (02/06/13)

[20:23:59] ---------------------------

[20:23:59]

[20:24:32] >> mysql_query( Connection handle: 1 )

[20:24:32] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[20:24:32] >> mysql_store_result( Connection handle: 1 )

[20:24:32] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[20:24:32] >> mysql_num_rows( Connection handle: 1 )

[20:24:32] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[20:24:32] >> mysql_free_result( Connection handle: 1 )

[20:24:32] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[20:24:36] >> mysql_query( Connection handle: 1 )

[20:24:36] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[20:24:36] >> mysql_store_result( Connection handle: 1 )

[20:24:36] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[20:24:36] >> mysql_num_rows( Connection handle: 1 )

[20:24:36] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[20:24:36] >> mysql_query( Connection handle: 1 )

[20:24:36] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[20:24:36] >> mysql_store_result( Connection handle: 1 )

[20:24:36] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[20:24:36] >> mysql_fetch_row_format( Connection handle: 1 )

[20:24:36] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[20:24:36] >> mysql_free_result( Connection handle: 1 )

[20:24:36] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[20:24:36] >> mysql_free_result( Connection handle: 1 )

[20:24:36] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


It only gave me that when I ran the server once.
Find
Reply
3ventic
Huge Clucker
****
Posts: 318
Threads: 2
Joined: Jun 2009
Reputation: 0
#4

07.02.2013, 06:34
Do you ever make the connection itself? (Just to make sure)

Do you have access to the MySQL log & config itself?
Find
Reply
Cameltoe
High-roller
*****
Posts: 1,741
Threads: 44
Joined: Apr 2010
Reputation: 0
#5

07.02.2013, 06:38
If the database is inactive for some time (very low at free hosts) the database connection will die. To keep the connection alive you could send ping requests to the server frequently using the mysql_ping function.
Find
Reply
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#6

07.02.2013, 20:35
( Last edited by Stephano; 07/02/2013 at 09:41 PM. )
Well, I'm using wamp server so I turn it on when I need to. And I don't know where the mysql_logs.txt are at.

EDIT: I'm not sure if I found it, but I found this:

130205 20:39:21 [Note] Plugin 'FEDERATED' is disabled.
130205 20:39:22 InnoDB: The InnoDB memory heap is disabled
130205 20:39:22 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130205 20:39:22 InnoDB: Compressed tables use zlib 1.2.3
130205 20:39:22 InnoDB: Initializing buffer pool, size = 128.0M
130205 20:39:22 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
130205 20:39:22 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130205 20:39:22 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130205 20:39:23 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130205 20:39:23 InnoDB: Waiting for the background threads to start
130205 20:39:24 InnoDB: 1.1.8 started; log sequence number 0
130205 20:39:24 [Note] Server hostname (bind-address): '(null)'; port: 3306
130205 20:39:24 [Note] - '(null)' resolves to '::';
130205 20:39:24 [Note] - '(null)' resolves to '0.0.0.0';
130205 20:39:24 [Note] Server socket created on IP: '0.0.0.0'.
130205 20:39:25 [Note] Event Scheduler: Loaded 0 events
130205 20:39:25 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
130206 0:01:04 [Note] wampmysqld: Normal shutdown

130206 0:01:04 [Note] Event Scheduler: Purging the queue. 0 events
130206 0:01:04 InnoDB: Starting shutdown...
130206 0:01:04 InnoDB: Shutdown completed; log sequence number 1676744
130206 0:01:04 [Note] wampmysqld: Shutdown complete

130206 15:59:08 [Note] Plugin 'FEDERATED' is disabled.
130206 15:59:08 InnoDB: The InnoDB memory heap is disabled
130206 15:59:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130206 15:59:08 InnoDB: Compressed tables use zlib 1.2.3
130206 15:59:09 InnoDB: Initializing buffer pool, size = 128.0M
130206 15:59:09 InnoDB: Completed initialization of buffer pool
130206 15:59:09 InnoDB: highest supported file format is Barracuda.
130206 15:59:10 InnoDB: Waiting for the background threads to start
130206 15:59:11 InnoDB: 1.1.8 started; log sequence number 1676744
130206 15:59:11 [Note] Server hostname (bind-address): '(null)'; port: 3306
130206 15:59:11 [Note] - '(null)' resolves to '::';
130206 15:59:11 [Note] - '(null)' resolves to '0.0.0.0';
130206 15:59:11 [Note] Server socket created on IP: '0.0.0.0'.
130206 15:59:12 [Note] Event Scheduler: Loaded 0 events
130206 15:59:12 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
130206 16:30:41 [Note] wampmysqld: Normal shutdown

130206 16:30:41 [Note] Event Scheduler: Purging the queue. 0 events
130206 16:30:41 InnoDB: Starting shutdown...
130206 16:30:42 InnoDB: Shutdown completed; log sequence number 1676754
130206 16:30:42 [Note] wampmysqld: Shutdown complete

130207 17:02:56 [Note] Plugin 'FEDERATED' is disabled.
130207 17:02:57 InnoDB: The InnoDB memory heap is disabled
130207 17:02:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130207 17:02:57 InnoDB: Compressed tables use zlib 1.2.3
130207 17:02:57 InnoDB: Initializing buffer pool, size = 128.0M
130207 17:02:57 InnoDB: Completed initialization of buffer pool
130207 17:02:58 InnoDB: highest supported file format is Barracuda.
130207 17:02:59 InnoDB: Waiting for the background threads to start
130207 17:03:00 InnoDB: 1.1.8 started; log sequence number 1676754
130207 17:03:00 [Note] Server hostname (bind-address): '(null)'; port: 3306
130207 17:03:00 [Note] - '(null)' resolves to '::';
130207 17:03:00 [Note] - '(null)' resolves to '0.0.0.0';
130207 17:03:00 [Note] Server socket created on IP: '0.0.0.0'.
130207 17:03:01 [Note] Event Scheduler: Loaded 0 events
130207 17:03:01 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
Find
Reply
3ventic
Huge Clucker
****
Posts: 318
Threads: 2
Joined: Jun 2009
Reputation: 0
#7

08.02.2013, 06:05
Find your MySQL config file (it's my.cnf on my system, I don't know about wamp) and enable general log (the file it saves to is set below that, you need to restart MySQL after that)

Then try running the server and connecting. Check the log after that.
Find
Reply
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#8

08.02.2013, 22:01
130205 20:39:21 [Note] Plugin 'FEDERATED' is disabled.
130205 20:39:22 InnoDB: The InnoDB memory heap is disabled
130205 20:39:22 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130205 20:39:22 InnoDB: Compressed tables use zlib 1.2.3
130205 20:39:22 InnoDB: Initializing buffer pool, size = 128.0M
130205 20:39:22 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
130205 20:39:22 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130205 20:39:22 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130205 20:39:23 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130205 20:39:23 InnoDB: Waiting for the background threads to start
130205 20:39:24 InnoDB: 1.1.8 started; log sequence number 0
130205 20:39:24 [Note] Server hostname (bind-address): '(null)'; port: 3306
130205 20:39:24 [Note] - '(null)' resolves to '::';
130205 20:39:24 [Note] - '(null)' resolves to '0.0.0.0';
130205 20:39:24 [Note] Server socket created on IP: '0.0.0.0'.
130205 20:39:25 [Note] Event Scheduler: Loaded 0 events
130205 20:39:25 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
130206 0:01:04 [Note] wampmysqld: Normal shutdown

130206 0:01:04 [Note] Event Scheduler: Purging the queue. 0 events
130206 0:01:04 InnoDB: Starting shutdown...
130206 0:01:04 InnoDB: Shutdown completed; log sequence number 1676744
130206 0:01:04 [Note] wampmysqld: Shutdown complete

130206 15:59:08 [Note] Plugin 'FEDERATED' is disabled.
130206 15:59:08 InnoDB: The InnoDB memory heap is disabled
130206 15:59:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130206 15:59:08 InnoDB: Compressed tables use zlib 1.2.3
130206 15:59:09 InnoDB: Initializing buffer pool, size = 128.0M
130206 15:59:09 InnoDB: Completed initialization of buffer pool
130206 15:59:09 InnoDB: highest supported file format is Barracuda.
130206 15:59:10 InnoDB: Waiting for the background threads to start
130206 15:59:11 InnoDB: 1.1.8 started; log sequence number 1676744
130206 15:59:11 [Note] Server hostname (bind-address): '(null)'; port: 3306
130206 15:59:11 [Note] - '(null)' resolves to '::';
130206 15:59:11 [Note] - '(null)' resolves to '0.0.0.0';
130206 15:59:11 [Note] Server socket created on IP: '0.0.0.0'.
130206 15:59:12 [Note] Event Scheduler: Loaded 0 events
130206 15:59:12 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
130206 16:30:41 [Note] wampmysqld: Normal shutdown

130206 16:30:41 [Note] Event Scheduler: Purging the queue. 0 events
130206 16:30:41 InnoDB: Starting shutdown...
130206 16:30:42 InnoDB: Shutdown completed; log sequence number 1676754
130206 16:30:42 [Note] wampmysqld: Shutdown complete

130207 17:02:56 [Note] Plugin 'FEDERATED' is disabled.
130207 17:02:57 InnoDB: The InnoDB memory heap is disabled
130207 17:02:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130207 17:02:57 InnoDB: Compressed tables use zlib 1.2.3
130207 17:02:57 InnoDB: Initializing buffer pool, size = 128.0M
130207 17:02:57 InnoDB: Completed initialization of buffer pool
130207 17:02:58 InnoDB: highest supported file format is Barracuda.
130207 17:02:59 InnoDB: Waiting for the background threads to start
130207 17:03:00 InnoDB: 1.1.8 started; log sequence number 1676754
130207 17:03:00 [Note] Server hostname (bind-address): '(null)'; port: 3306
130207 17:03:00 [Note] - '(null)' resolves to '::';
130207 17:03:00 [Note] - '(null)' resolves to '0.0.0.0';
130207 17:03:00 [Note] Server socket created on IP: '0.0.0.0'.
130207 17:03:01 [Note] Event Scheduler: Loaded 0 events
130207 17:03:01 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
130207 17:06:01 [Note] wampmysqld: Normal shutdown

130207 17:06:01 [Note] Event Scheduler: Purging the queue. 0 events
130207 17:06:01 InnoDB: Starting shutdown...
130207 17:06:01 InnoDB: Shutdown completed; log sequence number 1676764
130207 17:06:01 [Note] wampmysqld: Shutdown complete

130207 17:39:50 [Note] Plugin 'FEDERATED' is disabled.
130207 17:39:51 InnoDB: The InnoDB memory heap is disabled
130207 17:39:51 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130207 17:39:51 InnoDB: Compressed tables use zlib 1.2.3
130207 17:39:51 InnoDB: Initializing buffer pool, size = 128.0M
130207 17:39:51 InnoDB: Completed initialization of buffer pool
130207 17:39:52 InnoDB: highest supported file format is Barracuda.
130207 17:39:53 InnoDB: Waiting for the background threads to start
130207 17:39:54 InnoDB: 1.1.8 started; log sequence number 1676764
130207 17:39:54 [Note] Server hostname (bind-address): '(null)'; port: 3306
130207 17:39:54 [Note] - '(null)' resolves to '::';
130207 17:39:54 [Note] - '(null)' resolves to '0.0.0.0';
130207 17:39:54 [Note] Server socket created on IP: '0.0.0.0'.
130207 17:39:54 [Note] Event Scheduler: Loaded 0 events
130207 17:39:54 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
130207 17:45:35 [Note] wampmysqld: Normal shutdown

130207 17:45:35 [Note] Event Scheduler: Purging the queue. 0 events
130207 17:45:35 InnoDB: Starting shutdown...
130207 17:45:36 InnoDB: Shutdown completed; log sequence number 1676774
130207 17:45:36 [Note] wampmysqld: Shutdown complete

130207 23:13:16 [Note] Plugin 'FEDERATED' is disabled.
130207 23:13:16 InnoDB: The InnoDB memory heap is disabled
130207 23:13:16 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130207 23:13:16 InnoDB: Compressed tables use zlib 1.2.3
130207 23:13:16 InnoDB: Initializing buffer pool, size = 128.0M
130207 23:13:16 InnoDB: Completed initialization of buffer pool
130207 23:13:16 InnoDB: highest supported file format is Barracuda.
130207 23:13:16 InnoDB: Waiting for the background threads to start
130207 23:13:17 InnoDB: 1.1.8 started; log sequence number 1676774
130207 23:13:17 [Note] Server hostname (bind-address): '(null)'; port: 3306
130207 23:13:17 [Note] - '(null)' resolves to '::';
130207 23:13:17 [Note] - '(null)' resolves to '0.0.0.0';
130207 23:13:17 [Note] Server socket created on IP: '0.0.0.0'.
130207 23:13:17 [Note] Event Scheduler: Loaded 0 events
130207 23:13:17 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
130207 23:43:53 [Note] wampmysqld: Normal shutdown

130207 23:43:53 [Note] Event Scheduler: Purging the queue. 0 events
130207 23:43:53 InnoDB: Starting shutdown...
130207 23:43:56 InnoDB: Shutdown completed; log sequence number 1678658
130207 23:43:56 [Note] wampmysqld: Shutdown complete

130208 17:24:29 [Note] Plugin 'FEDERATED' is disabled.
130208 17:24:29 InnoDB: The InnoDB memory heap is disabled
130208 17:24:29 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130208 17:24:29 InnoDB: Compressed tables use zlib 1.2.3
130208 17:24:30 InnoDB: Initializing buffer pool, size = 128.0M
130208 17:24:30 InnoDB: Completed initialization of buffer pool
130208 17:24:30 InnoDB: highest supported file format is Barracuda.
130208 17:24:32 InnoDB: Waiting for the background threads to start
130208 17:24:33 InnoDB: 1.1.8 started; log sequence number 1678658
130208 17:24:33 [Note] Server hostname (bind-address): '(null)'; port: 3306
130208 17:24:33 [Note] - '(null)' resolves to '::';
130208 17:24:33 [Note] - '(null)' resolves to '0.0.0.0';
130208 17:24:33 [Note] Server socket created on IP: '0.0.0.0'.

This should be it.
Find
Reply
Memoryz
Gangsta
****
Posts: 724
Threads: 62
Joined: Dec 2008
Reputation: 0
#9

08.02.2013, 22:03
I doubt it's an issue with PHPMyAdmin itself.
Find
Reply
[MG]Dimi
High-roller
*****
Posts: 1,239
Threads: 16
Joined: Mar 2011
Reputation: 0
#10

08.02.2013, 22:17
Omg Guys...
pawn Code:
#define DATA "users"
Param 4 for mysql_connect is Database, not table. You instead of that you have to put
pawn Code:
#define DATA "[...]"
where [...] is name of Database that includes Table users. Understood?
Find
Reply
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#11

08.02.2013, 22:25


I believe I set "users" to be the database name here.
Find
Reply
[MG]Dimi
High-roller
*****
Posts: 1,239
Threads: 16
Joined: Mar 2011
Reputation: 0
#12

08.02.2013, 22:30
Try renaming Database $ #define DATA in script and then connect.
Find
Reply
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#13

08.02.2013, 23:04
didn't work, same problem :/
Find
Reply
Stream
Big Clucker
***
Posts: 159
Threads: 13
Joined: Oct 2012
Reputation: 0
#14

18.02.2013, 07:53
well , i have the same problem , if anyone can help us , plz do.



regards.
Find
Reply
3ventic
Huge Clucker
****
Posts: 318
Threads: 2
Joined: Jun 2009
Reputation: 0
#15

19.02.2013, 09:08
You need to enable the slow-query log for MySQL so I can see what could be wrong there.. You could also try running the query in phpMyAdmin under the SQL tab and see what it outputs.

Here's how to enable the slow-query in wamp:
Quote:
Originally Posted by Jesus-Blog
Although in hindsight this is DEAD easy, I’ve just had a bit of a hard time finding out how to do it, so I thought I’d make a quick post which will hopefully get indexed by ****** and save some other folk the hard time I had. Thoughtful, eh.

So, to enable the slow query log in WAMP is as simple as adding

log-slow-queries=PATH to your config file.

The config file is located in your wamp installation directory, under bin/mysql/mysql.version/my.ini

In there you will find an entry for standard logs, which will look something like log-error=c:/wamp/logs/mysql.log

Add the slow query flag, and change the log file name to something like log-slow-queries=c:/wamp/logs/mysqlslow.log

Restart wamp, and you’re done.
Find
Reply
Stephano
Banned
Posts: 47
Threads: 12
Joined: Oct 2011
#16

20.02.2013, 21:31
Quote:
Originally Posted by 3ventic
View Post
You need to enable the slow-query log for MySQL so I can see what could be wrong there.. You could also try running the query in phpMyAdmin under the SQL tab and see what it outputs.

Here's how to enable the slow-query in wamp:
wampmysqld, Version: 5.5.24-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: /tmp/mysql.sock
Time Id Command Argument


This is all that came up.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help