vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)
-   -   Getting a strange error at ARCADE (https://vborg.vbsupport.ru/showthread.php?t=185535)

veenuisthebest 07-16-2008 09:01 PM
Getting a strange error at ARCADE
 
hiii.. I'm getting an error on opening the arcade right after a full database restore. It was working perfect before that.

After restoration, I had to rebuild forum cache as my forum was unable to find any vb tables. I simply did this with tools.php and everything worked fine after that.

But now I notice that its unable to find just arcade tables, i think I need to rebuild some sort of arcade's cache as well. Is there an option to do so. However, I can view my games list from the admincp.

This is the error I get on visiting arcade:-

Code:
mySQL query error: SELECT p.mid, p.tid, t.nbtries, p.timesplayed, p.rungscore, p.rung, p.faceoff, p.notified, t.creat FROM tournament_players AS p LEFT JOIN tournaments AS t ON (p.tid=t.tid) LEFT JOIN tournament_players_statut AS s ON (p.tid=s.tid AND p.mid=s.mid) WHERE p.timesplayed<t.nbtries AND t.demare=1 AND s.statut=0 AND p.timeplayed<1215638945

mySQL error: Table 'mydb.tournament_players' doesn't exist
mySQL error code:
Date: Wednesday 16th 2008f July 2008 09:29:05 PM
I notice the table tournament_players is not in my db. On importing the product again, it is not getting created !!

Any help plz.

MrZeropage 07-20-2008 06:58 PM
all other ibProArcade-tables are existing ?

you did not change any tableprefix ?


Code:
CREATE TABLE IF NOT EXISTS tournament_players (mid int(11) NOT NULL default '0', tid int(11) NOT NULL default '0', rung int(11) NOT NULL default '0', rungscore int(11) NOT NULL default '0', faceoff int(11) NOT NULL default '0', timeplayed int(10) NOT NULL default '0', timesplayed int(11) NOT NULL default '0')


All times are GMT. The time now is 08:59 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01012 seconds
  • Memory Usage 1,709KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete