vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Integration with vBulletin - Soccer Betting Game ("Fussball-Tippspiele") (https://vborg.vbsupport.ru/showthread.php?t=238043)

Gemma 06-07-2012 04:02 PM

Quote:

Originally Posted by vcoderzdotcom (Post 2337242)
does it work on vbulletin 3.8.7?

https://vborg.vbsupport.ru/showthread.php?t=237934

fortforum 06-08-2012 01:30 PM

Trying this but it just gives me this:

"The Maintenance Service doesn't respond or is not available yet. Please try it later again.
"

Is this service discontinued?

MattGarner 06-08-2012 03:31 PM

These errors have been starting on certain parts of the plugin:

Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT
b.`userid`, DATE_FORMAT(FROM_UNIXTIME(m.`dateline`), '%Y%m%d') AS `mdate`, `match_day`,
COUNT(*) AS `bets`,
SUM(`score_key`>0) AS 'evaluated',
SUM(`score_key`>0 AND `score_key` != `bet_score_key`) AS 'wr',
SUM(`score_key`>0 AND `bet_home`=`points_home` AND `bet_away`=`points_away`) AS 'rr',
SUM(`score_key`>0 AND CAST(`bet_home`-`bet_away` AS SIGNED)=(`points_home`-`points_away`) AND NOT (`bet_home`=`points_home` AND `bet_away`=`points_away`)) AS 'rd'
FROM `soccer_user_bet` b
INNER JOIN `soccer_match` m ON (m.`id`=b.`match_id`)
WHERE m.`league_id`=1 GROUP BY DATE_FORMAT(FROM_UNIXTIME(m.`dateline`), '%Y%m%d'), b.`userid`;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`habboxfo_forumhx`.`b`.`bet_home` - `habboxfo_forumhx`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Friday, June 8th 2012 @ 05:30:51 PM
Error Date : Friday, June 8th 2012 @ 05:30:51 PM
Script : http://www.habboxforum.com/vbsoccer....anking&l=1&m=2
Referrer : http://www.habboxforum.com/vbsoccer.php?do=tab&l=1&m=2
Classname : vB_Database
MySQL Version : 5.5.24-cll
Anyone have any idea?

MattGarner 06-08-2012 03:35 PM

Quote:

Originally Posted by ForceHSS (Post 2337782)
no support for vb version you are running as it has not been tested on that version yet

It was working fine before any matches started but ok :P

MattGarner 06-08-2012 05:20 PM

From what I have read in this thread, it's related if a user has entered too much of a high bid in one of the predictions. A user did have the number 45 in two of his predictions and I have removed them to see if it was the problem. The error still exists, anyone else had problems with vb 4.2 and MySQL 5.5? I know the plugin isn't fully supported but it was working before any of the matches started.

Gn_Snake 06-08-2012 08:15 PM

Hi for all,
in the ACP do not have the Euro 2012 championship, how?

ProFifaLeagues 06-08-2012 08:28 PM

Confirm its been working fine for us on 4.2 even after todays games have been updated and the scores confirmed....

MattGarner 06-08-2012 08:29 PM

Quote:

Originally Posted by ProFifaLeagues (Post 2337926)
Confirm its been working fine for us on 4.2 even after todays games have been updated and the scores confirmed....

Including the rankings?

ProFifaLeagues 06-08-2012 09:24 PM

Quote:

Originally Posted by MattGarner (Post 2337927)
Including the rankings?



Yes just doubled Checked them now and all A1.

We are only running the euros at present Not sure if it would matter any?

Are you using the Fixed Version which was posted?

MattGarner 06-08-2012 09:49 PM

Quote:

Originally Posted by ProFifaLeagues (Post 2337937)
Yes just doubled Checked them now and all A1.

We are only running the euros at present Not sure if it would matter any?

Are you using the Fixed Version which was posted?

The one from the signature? Yeah. Do you know if you use MySQL 5.5 or not? I think 5.5 may cause these issues somehow.


All times are GMT. The time now is 10:23 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.03491 seconds
  • Memory Usage 1,745KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete