Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
mySQL error: Unknown column 'tourney_use' in 'field list' Details »»
mySQL error: Unknown column 'tourney_use' in 'field list'
Version: , by jessej jessej is offline
Developer Last Online: Aug 2008 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 11-23-2006 Last Update: Never Installs: 0
 
No support by the author.

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..


Code:
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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 11-27-2006, 03:03 AM
jessej jessej is offline
 
Join Date: Jun 2006
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think I got missed. LOL Anyone know what this problem is? Please..
Reply With Quote
  #3  
Old 11-28-2006, 09:21 AM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

it was a fresh v2.5.7+ installation ?
Reply With Quote
  #4  
Old 11-29-2006, 05:56 AM
jessej jessej is offline
 
Join Date: Jun 2006
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:24 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04069 seconds
  • Memory Usage 2,227KB
  • Queries Executed 19 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (3)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete