[N0FeaR]

Hello have problem MySQL i get this. but the work fine on my home-host but when i use volt-host i get this erros thanks in advance


http://pastebin.com/TRRrQyfF

[Christopher]

Have you read the errors? It's telling you that it cannot authenticate the username and password combination you supplied.

"[00:08:36] MySQL Error (0): Failed to connect. Access denied for user '3802_Hellman'@'localhost' to database 'samp'."


Verify that your connection variables in your script are correct and match your details on Volt's.

[Silentfood]

Problems & Solutions:

1. Your login information is incorrect
2. The user you're using is already logged in under a different process (doing something else)
3. Your database isn't selected, or hasn't been created
4. Maybe try not to use localhost, and try using an IP specified with volt-host

[N0FeaR]

Now i have type right username and datebase name and pw i get this

Код:

[00:35:54] MySQL: Connected (0) to 3802_Hellman @ 176.31.192.96 via TCP/IP. MySQL version 5.0.84.
[00:35:54] MySQL Error (0): Could not execute query. Table '3802_Hellman.Accounts' doesn't exist.
[00:35:54] MySQL Error (0): Could not execute query. Table '3802_Hellman.Accounts' doesn't exist.
[00:35:54] MySQL Error (0): Could not execute query. Table '3802_Hellman.Accounts' doesn't exist.
[00:35:54] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
[00:35:54] Job Positions have been loaded
[00:35:54] MySQL Error (0): Could not execute query. Table '3802_Hellman.Houses' doesn't exist.
[00:35:54] MySQL Error (0): Function: 'mysql_store_result' called when no prior query executed.. Table '3802_Hellman.Houses' doesn't exist.
[00:35:54] MySQL Error (0): Function: 'mysql_fetch_row' called when no result stored. Table '3802_Hellman.Houses' doesn't exist.
[00:35:54] MySQL Error (0): Could not execute query. Table '3802_Hellman.Houses' doesn't exist.
[00:35:54] MySQL Error (0): Function: 'mysql_store_result' called when no prior query executed.. Table '3802_Hellman.Houses' doesn't exist.

[N0FeaR]

Can anyone help me ? :P

[Christopher]

Are you being serious? It cannot be hard to read the errors can it? It's telling you that the table 'Accounts' and 'Houses' doesn't exist.

[N0FeaR]

Quote:

Originally Posted by Bitrate Are you being serious? It cannot be hard to read the errors can it? It's telling you that the table 'Accounts' and 'Houses' doesn't exist.

What that means then. and how to fix that and I appreciate if you can help me

and i have in my datebase houses.

cus working perfect on home host so i dont understand whats the problem are

[Christopher]

Do you have the full structure of the database created? Also if you supply a dump of the database I could assist you more; if you do though ensure to remove all your data for security reasons I only need the table structure.

[N0FeaR]

Quote:

Originally Posted by Bitrate Do you have the full structure of the database created? Also if you supply a dump of the database I could assist you more; if you do though ensure to remove all your data for security reasons I only need the table structure.

u mean i show you my whole datebase ?

[Christopher]

No not the whole database just the table structure. Just a screen shot of the field names would be suffice.