Solved PHP MySQL 0.3.6pl1 (QUERY() EROR!

[lord azteck]

Hello guys,
okay, my problem is that, when i invite a player to the guild like this:

!invite Player Name

In-Game I've got this:

[13/03/2010 22:06:10] mysql_real_query(): SELECT `id` FROM `guild_invites` WHERE `player_id` = 95 AND `guild_id`= 13 LIMIT 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[13/03/2010 22:06:17] mysql_real_query(): SELECT `id` FROM `guild_invites` WHERE `player_id` = 91 AND `guild_id`= 13 LIMIT 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[13/03/2010 22:06:31] mysql_real_query(): SELECT `id` FROM `guild_invites` WHERE `player_id` = 126 AND `guild_id`= 13 LIMIT 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[13/03/2010 22:06:44] mysql_real_query(): SELECT `id` FROM `guild_invites` WHERE `player_id` = 86 AND `guild_id`= 13 LIMIT 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[13/03/2010 22:06:49] mysql_real_query(): SELECT `id` FROM `guild_invites` WHERE `player_id` = 44 AND `guild_id`= 13 LIMIT 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)

How can i repair it?
maybe executing a query?

Thanks!:wub::thumbup:

 

[lord azteck]

bump

 

[Migxxx]

<?php
      echo(base64_decode('V1RGIGRvZXMgdGhpcyBoYXZlIHRvIGRvIHdpdGggUEhQPyByZXRhcmQu'));
?>

 

[lord azteck]

<?php
      echo(base64_decode('V1RGIGRvZXMgdGhpcyBoYXZlIHRvIGRvIHdpdGggUEhQPyByZXRhcmQu'));
?>

soo, what does i need to do with that?

 

[Paxton]

Don't select `id` because there is no such column.

 

[lord azteck]

Don't select `id` because there is no such column.

but, where does i need to put it?

 

[Xampy]

LoL! Just go to phpMyAdmin (or your mysql editor) and insert this SQL code:

ALTER TABLE `guild_invites`
ADD `id` INT NOT NULL DEFAULT 0;

Btw, I think 0.3.6 doesn't use `id` column anymore .

 

[lord azteck]

LoL! Just go to phpMyAdmin (or your mysql editor) and insert this SQL code:

ALTER TABLE `guild_invites`
ADD `id` INT NOT NULL DEFAULT 0;

Btw, I think 0.3.6 doesn't use `id` column anymore .

thanks, solved.

 

[Paxton]

LoL! Just go to phpMyAdmin (or your mysql editor) and insert this SQL code:

ALTER TABLE `guild_invites`
ADD `id` INT NOT NULL DEFAULT 0;

@up
You have done it the really wrong way.

For what? Also ID should be primary key and inrecement.

Just don't select ID select `guild_id` or `player_id` or just * but it's not neccesary.

 

[Diazapam]

You'll need to edit the script, new TFS only have player_id and Guild_id, normal "id" doesn't exist anymore.

Post the script and someone will take a look.
The way its fixed now is wrong!