MySQL Table
#1

I follow the tutorial on SA-MP wiki how to set up mysql i follow everything..
Except the scripting part, The only thing i follow in the tutorial is how to set up table.

I create a table name "user", after that i follow Killer's MySQL tutorial the script works
the register dialog show up, The problem is.. player account is not getting created in the table..

How to make it work?

pawn Code:
#define mysql_host "localhost"
#define mysql_user "root"
#define mysql_password ""
#define mysql_database "user"
Reply
#2

There are many places where you could have gone wrong.

Here are a couple possible issues:
- Your MySQL credentials could be wrong (host/user/password)
- Your database might not exist
- MySQL user does not have permissions to access/modify the data
- There is an error with your query

If I was you I would start by checking MySQL debug file for possible connection/query errors.

If you cannot see mysql_log.txt, make sure MySQL debugging is enabled (probably mysql_debug(true)
Reply
#3

Find the error here it is

pawn Code:
[00:57:34] CMySQLHandler::Connect() - Unknown database 'user' (Error ID: 1049)
But i've created a table, i go to localhost/phpMyAdmin, then click mysql then click "Create Table"
What i've done?, Did i create table wrong?
Reply
#4

Quote:
Originally Posted by Romel
View Post
Find the error here it is

pawn Code:
[00:57:34] CMySQLHandler::Connect() - Unknown database 'user' (Error ID: 1049)
But i've created a table, i go to localhost/phpMyAdmin, then click mysql then click "Create Table"
What i've done?, Did i create table wrong?
Then the database is "mysql" and not "user"
Reply
#5

Let me try..
Reply
#6

Never mind found it!
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)