Thread: Major Additions - Casino (w/ 10 player poker)
View Single Post
  #883  
Old 10-22-2007, 01:17 PM
Andrew Green's Avatar
Andrew Green Andrew Green is offline
 
Join Date: Nov 2005
Location: Winnipeg, MB
Posts: 996
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Rushty View Post
im getting an error when installing on MySQL v5 on Windows

Database error in vBulletin 3.6.8, casino versions .38 & .4

the error seems to be down to the use of a reserved word 'range' within thw SQL that creates casino_lotto_draw. SQL below.

Invalid SQL:
CREATE TABLE casino_lotto_draw (drawid integer NOT NULL PRIMARY KEY auto_increment,
drawtime integer, winners text, ticketnumbers text, jackpot integer, price integer, range integer, numbers integer, totalodds integer, odds text, winper text);
Range is not listed as a reserved word: http://dev.mysql.com/doc/refman/5.0/...ved-words.html

Is that the error it is giving you? I can escape it or rename it next time around which should get around that...



Quote:
Originally Posted by leeman View Post
I have Inferno Shoutbox ....

But I get confused when it conflicts with 3 outa six games ...

Well gonna try some stuff. Unless someone else have gotten the same and solved it.
Those 3 function in more or less the same way, and it does look like some sort of conflict with the Inferno stuff. When does the error show up? Does the start button flash up first? Do you get nothing but the error? Most of the page show up, but the error come in the place where the cards should be?

Quote:
Originally Posted by AdmiralGeek View Post
the 250, 500, 1000, chip in the admin control panel are not added automatically
maybe the admin.php needs to be re-done.
They have to be entered manually?
Yes they do. I know a lot of people have added higher chips, and I didn't want to overwrite existing settings, so the images are there, but they aren't added in.

Quote:
Originally Posted by samorite View Post
when i try to save the changes i get

any ideas ?
I'll patch that query out of there and post it here when I get a few minutes.

Quote:
Originally Posted by Mark.B View Post
Thanks Andrew.

Just for information, returning to the site at 0700 BST and the events have gone, so it looks like they are closing at server time rather than vbtime.
Ok, so the times all show up properly, but the events are staying open passed the time shown?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01156 seconds
  • Memory Usage 1,782KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete