Little error MySQL - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (
https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Little error MySQL (
/showthread.php?tid=184353)
Little error MySQL -
Brian_Furious - 19.10.2010
I've got this error when i try to register/login on my server.
Код:
[14:54:42] >> mysql_connect( )
[14:54:42] CMySQLHandler::CMySQLHandler() - constructor called.
[14:54:42] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "damonds_test" | Username: "damonds_test" ...
[14:54:42] CMySQLHandler::Connect() - Connection was successful.
[14:54:42] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[14:54:42] >> mysql_query( Connection handle: 1 )
[14:54:42] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: -1)
[14:54:42] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[14:55:25] >> mysql_ping( Connection handle: 1 )
[14:55:25] CMySQLHandler::Ping() - Connection is still alive.
[14:55:26] >> mysql_ping( Connection handle: 1 )
[14:55:26] CMySQLHandler::Ping() - Connection is still alive.
[14:55:26] >> mysql_real_escape_string( Connection handle: 1 )
[14:55:26] CMySQLHandler::EscapeString(Brian_Furious); - Escaped 13 characters to Brian_Furious.
[14:55:26] >> mysql_query( Connection handle: 1 )
[14:55:26] CMySQLHandler::Query(SELECT * FROM Accounts WHERE Username = 'Brian_Furious') - An error has occured. (Error ID: 1146, Table 'damonds_test.Accounts' doesn't exist)
This happen on my host
Re: Little error MySQL -
armyoftwo - 19.10.2010
it clearly says that Accounts table doesnt exist.
Re: Little error MySQL -
Brian_Furious - 19.10.2010
Quote:
Originally Posted by armyoftwo
it clearly says that Accounts table doesnt exist.
|
Yes i know, but i dont know how to create it
Re: Little error MySQL -
armyoftwo - 19.10.2010
go into your mysql database and create it, you'll need to know all field names
Re: Little error MySQL -
Brian_Furious - 19.10.2010
Quote:
Originally Posted by armyoftwo
go into your mysql database and create it, you'll need to know all field names
|
Can you give me an exemple?
Re: Little error MySQL -
Calgon - 19.10.2010
http://lmgtfy.com/?q=How+to+create+a+MySQL+table
http://lmgtfy.com/?q=How+to+create+a+MySQL+table
http://lmgtfy.com/?q=How+to+create+a+MySQL+table
http://lmgtfy.com/?q=How+to+create+a+MySQL+table
http://lmgtfy.com/?q=How+to+create+a+MySQL+table
http://lmgtfy.com/?q=How+to+create+a+MySQL+table
http://lmgtfy.com/?q=How+to+create+a+MySQL+table
http://lmgtfy.com/?q=How+to+create+a+MySQL+table
Would it kill you to use your brain and to use ******? 8,500,000 results returned.