Mysql eror
#1

I make some basic script with user login and register system, but i have eror in log

PHP код:
[00:57:11]  ** MySQL Debugging enabled (10/26/15)
[
00:57:11]  
[
00:57:39] >> mysql_formatConnection handle)
[
00:57:39CMySQLHandler::EscapeString(bigboy81); - Escaped 13 characters to bigboy81.
[
00:57:39] >> mysql_query_callbackConnection handle)
[
00:57:39Passing query SELECT FROM `usersWHERE `Username` = `bigboy81` | d
[00:57:39CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[
00:57:39OnQueryError() - Called
Reply
#2

Hello!

Put this in your script (at the end) and restart the server.
PHP код:
public OnQueryError(erroriderror[], resultidextraidcallback[], query[], connectionHandle)
{
    
printf("ErrorID: %d | Error: %s | Query: %s",errorid,error,query);
    return 
1;

Do you get some more information about this error in your log?
Reply
#3

No i don't have more information about this eror.
I have also made some kind of print for my Query..

PHP код:
public OnQueryFinish(gQuery[])
{
    
printf("Query %s is finished"Query);
    return 
1;

but that query working when players disconnect form the srerver.
Reply
#4

Do you take my code?

Maybe you don't have an error I think it's a note.
But I'm not sure.
Reply
#5

Quote:
Originally Posted by Mencent
Посмотреть сообщение
Do you take my code?

Maybe you don't have an error I think it's a note.
But I'm not sure.
Yes i also tested with your code but not work.
Reply
#6

Use the proper quotes. ' and ` look alike but serve different purposes and are are not interchangeable. Backtick (`) for identifiers (columns, tables, databases) only, regular quote (') for strings only. Your query says: select everything from the users table where column username is equal to column bigboy81.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)