vb.org Archive - 3.7.0. Beta 2 / ibProarcade

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)

- - 3.7.0. Beta 2 / ibProarcade (https://vborg.vbsupport.ru/showthread.php?t=165397)

kylek

12-17-2007 06:44 PM

3.7.0. Beta 2 / ibProarcade

Has anyone got ibProArcade and 3.7.0. Beta 2 running together yet? Curious as the arcade is the one thing that members complain the most when its not available.

Feckie (Roger)

12-17-2007 07:47 PM

Yes No Problems so far

Shazz

12-17-2007 08:18 PM

This is one of the head start threads. Theres going to be a ton of threads/posts "does this work on 3.7" etc.
It seems fine for the arcade

Scape-Server

12-18-2007 10:04 AM

I get an error whenever you view or post a thread. The thread will still post but (obviously) you cannot view it.

Code:

Database error in vBulletin 3.7.0 Beta 2:



Invalid SQL:



                        SELECT t.champion, u.userid FROM tournaments AS t

                        LEFT JOIN user AS u ON (t.champion = u.username)

                        WHERE champion<>'';



MySQL Error  : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='

Error Number : 1267

Date         : Tuesday, December 18th 2007 @ 04:01:03 AM

Script       : http://scape-server.org/showthread.php?p=542

Referrer     : http://scape-server.org/forums.php

IP Address   : 86.129.198.101

Username     : James

Classname    : vB_Database

??

EDIT:

I fixed this! In phpMyAdmin i changed the champion field's collation from latin1_swedish_ci to atin1_general_ci.

You might want to fix this :)

MrZeropage

12-18-2007 04:48 PM

how exactly do you change the collation ? Please describe it, as some more users have such problems (which is not related to vBulletin 3.7.x) - thanks

I think there should be no problems at all in vB 3.7.x - anyone tried a fresh install on it ?

Scape-Server

12-18-2007 05:08 PM

To change the collation execute this SQL query:

Code:

ALTER TABLE `tournaments` CHANGE `champion` `champion` TEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL

Execute it from within vBulletin to make sure it goes correctly :)

I have just noticed that no highscores save either!? It just says: Could not retrieve scores.

Any ideas on this?

EDIT: I just added the whole vba cmps thing (i had it installed) so i modded my file. Now it works but i still get the error. Note: I am playing snake. I have not tested other games YET.

syrus.xl

12-20-2007 02:32 PM

I've installed 3.7 beta 2 (upgrade from 3.6.8), updated a custom style (modified 9 templates) and then installed the arcade. There is no problems at all that I've come across. Scores are still saving, etc.

I only done all this on a test installation of vbulletin - just checking compatibility issues.

kylek

12-20-2007 05:07 PM

I have 3 sites running live with 3.7.0. Beta 2 and ibProarcade and everything is working fine. The only compatibility problem I have found is with vbcredits so if you are using it for points and tied into the arcade you cannot use the customize profile feature in 3.7.0 Beta 2. These sites already had ibProarcade installed, so no fresh installs though.

"Bitfield Collision: credits_cantearn = prefixrequired"

cheat-master30

12-25-2007 11:03 AM

Quote:

Originally Posted by kylek (Post 1405593)

Change either credits bitfield or the vBulletin default one to a different value to remove the collision. Or, you can disable the arcade intergration and the games can still be played fine.

Chance4Today

12-26-2007 03:58 AM

Quote:

Originally Posted by MrZeropage (Post 1403701)

I think there should be no problems at all in vB 3.7.x - anyone tried a fresh install on it ?

Yeah I have a fresh install of it for my kids Christmas Present but it isn't done yet and so far none or I should say that most of the hacks don't work but I will try and see if this one does I was planning on putting something in there for them anyways.

Magnumutz

01-28-2008 06:09 PM

OK, this just happened to me, using vB 3.7.0 Beta4... my problem was EXACTLY the same as scape-server's.
I ran that query and it's working just great.

All times are GMT. The time now is 03:44 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01080 seconds Memory Usage 1,738KB 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (11)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
Messages: