Help with MySQL - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Help with MySQL (/showthread.php?tid=310578)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Help with MySQL (/showthread.php?tid=310578)
Help with MySQL - N0FeaR - 12.01.2012
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
Re: Help with MySQL - Christopher - 12.01.2012
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.
Re: Help with MySQL - Silentfood - 12.01.2012
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
Re: Help with MySQL - N0FeaR - 12.01.2012
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.
Re: Help with MySQL - N0FeaR - 12.01.2012
Can anyone help me ? :P
Re: Help with MySQL - Christopher - 12.01.2012
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.
Re: Help with MySQL - N0FeaR - 12.01.2012
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.
|
and i have in my datebase houses.
cus working perfect on home host so i dont understand whats the problem are
Re: Help with MySQL - Christopher - 12.01.2012
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.
Re: Help with MySQL - N0FeaR - 12.01.2012
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.
|
Re: Help with MySQL - Christopher - 12.01.2012
No not the whole database just the table structure. Just a screen shot of the field names would be suffice.