Sql query

[Nightimarez]

I get this error when I try to invite someone to my guild.

[14/05/2010 01:20:40] mysql_real_query(): SELECT `id` FROM `guild_invites` WHERE `player_id` = 1985 AND `guild_id`= 122 LIMIT 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[14/05/2010 01:20:40] mysql_real_query(): INSERT INTO `guild_invites` (`player_id`, `guild_id`) VALUES ('1985', '122') - MYSQL ERROR: Duplicate entry '1985-122' for key 'player_id' (1062)

Anybody know how to fix this?

My mistake was turning on my old 8.4 server and it was running on the same database name. So it optimized back to 8.4, I optimized back to 8.54 but !invite command stopped working.

 

[Amiroslo]

try to uninstall xampp then install it again
Note:it will delete every thing in database such as players

 

[Korrex]

Not if he exports the database first.

 

[Nightimarez]

That didn't fix it.

Still getting this when I !invite name

[14/05/2010 03:23:49] mysql_real_query(): SELECT `id` FROM `guild_invites` WHERE `player_id` = 1895 AND `guild_id`= 122 LIMIT 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)

 

[Gloyz]

thennn its htdocs i have the same problem look.

[14/05/2010 10:53:37] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 7 ORDER BY `sid` DESC - MYSQL ERROR: Table 'war.player_depotitems' doesn't exist (1146)
[14/05/2010 10:53:38] GM hexiz has logged in.

it comes when some1 loggs in

 

[Nightimarez]

it's not in htdocs, it's our database tables that are messed up.

 

[Cykotitan]

TFS never had column id in guild_invites

 

[Nightimarez]

Any way to drop it? or do you think it's the forgotten server.exe u gave us?

 

[Cykotitan]

No, it's not the .exe

And what are you talking about? drop?

>Unknown column 'id'

 

[Nightimarez]

Whatever no problem, no big deal xD

 

[LucasFerraz]

Same to me, can some1 help?


mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`, `lastday`, `key`, `warnings` FROM `Accounts` WHERE `id` = 1 LIMIT = 1 - MYSQL ERROR: Unknow Column ´salt´ in ´field list´ (1054)
mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`, `lastday`, `key`, `warnings` FROM `Accounts` WHERE `id` = 6159667 LIMIT = 1 - MYSQL ERROR: Unknow Column ´salt´ in ´field list´ (1054)

 

[LucasFerraz]

Same to me, can some1 help?


mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`, `lastday`, `key`, `warnings` FROM `Accounts` WHERE `id` = 1 LIMIT = 1 - MYSQL ERROR: Unknow Column ´salt´ in ´field list´ (1054)
mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`, `lastday`, `key`, `warnings` FROM `Accounts` WHERE `id` = 6159667 LIMIT = 1 - MYSQL ERROR: Unknow Column ´salt´ in ´field list´ (1054)




sorry spam, my pc is lagged

 

[Cykotitan]

ALTER TABLE `accounts` ADD `salt` VARCHAR(40) NOT NULL DEFAULT '' AFTER `password`;

 

[LucasFerraz]

Thanks I love you cyko