[MySQL] Error #1064

[steadyfi]

Hello

I've got a little annoying error in MySQL.

I am trying to import the database of Fairplay by Socialz (Git: https://github.com/Socialz/lua-mta-fairplay-roleplay) but when I try to create the contacts table it returns a error.

I'm using phpMyAdmin

MySQL Code:

CREATE TABLE `contacts` ( 
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, 
  `name` VARCHAR(100) NOT NULL, 
  `number` VARCHAR(10) UNSIGNED NOT NULL, 
  `ownerNumber` VARCHAR(10) UNSIGNED NOT NULL, 
  PRIMARY KEY (`id`) 
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; 

Error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unsigned NOT NULL, 
  `ownerNumber` varchar(10) unsigned NOT NULL, 
  PRIMARY KE' at line 4  

Thanks

[JR10]

You can't use UNSIGNED with a VARCHAR, you can use INTEGER instead.

[steadyfi]

You can't use UNSIGNED with a VARCHAR, you can use INTEGER instead.

Thank you JR10 !

Edited March 15, 2015 by Guest

[steadyfi]

Also, when I start the server it says:

ERROR: roleplay-accounts\s_accounts.lua:174: dbConnect failed; Access denied for user 'mta'@'localhost' (using password: YES)

local databaseConfig = { 
    ["type"] = "mysql", 
    ["hostname"] = "127.0.0.1", 
    ["database"] = "mtarp", 
    ["username"] = "mta", 
    ["password"] = "no-need-to-see-the-password" 
} 

I have created the user with privileges to all databases and the password is correct. What do I do ?

[JR10]

Are you sure that the host is correct? The host has to match the user's host on the server.

[steadyfi]

Are you sure that the host is correct? The host has to match the user's host on the server.

127.0.0.1 is basicaly localhost and my MySQL server is hosted on my PC along with the server so yeah

Summary:

MySQL: Hosted on my PC

MTA Server: Hosted on my PC