3.7.0. Beta 2 / ibProarcade

[kylek]

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)]

Yes No Problems so far

[Shazz]

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]

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

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]

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]

To change the collation execute this SQL query:

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]

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]

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]

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"

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]

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]

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.