mySQL error: Unknown column 'tourney_use' in 'field list'

Hi-

I am sorry if this is redundant. I looked back in this forum for any mention of it and didnt see it directly. I just may have missed it. But thanks for any help on this prob.

I am on v257 and I downloaded alot of TAR files with the game_ prefix on the file name, off of paldo site mentioned in another thread here. When I go into admincp>arcade>add game and click install, I get the error shown below. I was also getting this error on a few .zip files also, but these names did not start with game_ prefix, and I thought that was maybe the reason. I also seen another post saying how to fix this error, but the suggested fix was the reverse problem for me. The suggested fix said to change "tourney_user" to "tourney_use", but my php file already has "use" in it. I am not sure which way is up about now. THANKS..

mySQL query error: INSERT INTO vb_games_list (gname,gwords,gtitle,bgcolor,gwidth,gheight,active,object,gkeys,gcat,cost,jackpot,jackpot_type,added,tourney_use,gtime,game_type,filesize) VALUES ('100mRunning',' Run 100M as fast as you can, your best time will be submitted. ','100m Running','FFFFFF','600','450','1','4',' Run 100M as fast as you can. ','1','0','0','-1','1164279358','1','0','0','705337')

mySQL error: Unknown column 'tourney_use' in 'field list'
mySQL error code: 
Date: Thursday 23rd of November 2006 05:55:58 AM

[jessej]

I think I got missed. LOL Anyone know what this problem is? Please..

[MrZeropage]

it was a fresh v2.5.7+ installation ?

[jessej]

It was an upgrade from 256.

--------

I had found another post by someone with a similar problem, but the reverse issue. They needed tourney_use, and I needed tourney_user. The arcade.php file contained tourney_use
so I tried changing those entries to tourney_user, and the installs all worked ok.
----------------

Im not sure if this is related, but I have several games that were working, but now are not. When I loaded the 289 games last night, I had some duplicates of games previously loaded. So I went through them all in the admincp arcade games list and deleted out duplicates from the arcade. It looks like that delete process may have also killed the original good versions. The games are still listed, but the gifs for these games dont show up and when you click to play one of those games, the window opens, but it is blank.

Thanks for your help. People on my site love this arcade. Got a few that I think may go blind from so much playin. LOL