Solved Problem with Account Maker

[remus934]

Hello ,it's me again!
I have problem with acc maker:

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\class\sql.php on line 214

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\class\sql.php on line 216

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\class\sql.php on line 214

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\class\sql.php on line 216

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. inC:\xampp\htdocs\class\sql.phpon line 214

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. inC:\xampp\htdocs\class\sql.phpon line 216

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. inC:\xampp\htdocs\class\sql.phpon line 214

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. inC:\xampp\htdocs\class\sql.phpon line 216


Fatal error: Uncaught exception 'DatabaseQueryException'
Message: Error #1054:Unknown column 'guilds.owner_id' in 'where clause'
SQL query: SELECT guilds.id, guilds.name FROM guilds, accounts, players WHERE players.id = guilds.owner_id AND players.account_id = accounts.id AND accounts.id = 2
File: sql.php on line: 94
Script was terminated because something unexpected happened. You can report this, if you think it's a bug.

Debug Backtrace:
Array
(
[0] => Array
(
[function] => ExceptionHandler
[class] => AAC
[type] => ::
[args] => Array
(
[0] => DatabaseQueryException Object
(
[query_stratabaseQueryExceptionrivate] => SELECT guilds.id, guilds.name FROM guilds, accounts, players WHERE players.id = guilds.owner_id AND players.account_id = accounts.id AND accounts.id = 2
[help_id:aacExceptionrivate] =>
[messagerotected] => Error #1054:Unknown column 'guilds.owner_id' in 'where clause'
[string:Exceptionrivate] =>
[coderotected] => 0
[filerotected] => C:\xampp\htdocs\class\sql.php
[linerotected] => 94
[trace:Exceptionrivate] => Array
(
[0] => Array
(
[file] => C:\xampp\htdocs\class\account.php
[line] => 36
[function] => myQuery
[class] => SQL
[type] => ->
[args] => Array
(
[0] => SELECT guilds.id, guilds.name FROM guilds, accounts, players WHERE players.id = guilds.owner_id AND players.account_id = accounts.id AND accounts.id = 2
)

)

[1] => Array
(
[file] => C:\xampp\htdocs\class\account.php
[line] => 133
[function] => load_guilds
[class] => Account
[type] => ->
[args] => Array
(
)

)

[2] => Array
(
[file] => C:\xampp\htdocs\account.php
[line] => 61
[function] => __get
[class] => Account
[type] => ->
[args] => Array
(
[0] => guilds
)

)

)

[previous:Exceptionrivate] =>
)

)

)

)

How to fix it?

 

[Pteryx]

Did your server run ok previously?

If not, what changed?


Your symptom is that your database table definition doesn't match the script. It's probably an install problem.

 

[remus934]

ok , I fixed it,
I changed name of table:
ownerid to owner_id and now it works.

But I have other problem:
In database of my server an created account exists.
When I am trying to login in my server ,account seems to does not exist.



#EDIT
FIXED!
password type: "sha1"