Mediawiki and phpbb

[creamers]

ok heres my problem.

 

<?php

# This file was automatically generated by the MediaWiki installer.
# If you make manual changes, please keep track in case you need to
# recreate them later.
#
# See includes/DefaultSettings.php for all configurable settings
# and their default values, but don't forget to make changes in _this_
# file, not there.

# If you customize your file layout, set $IP to the directory that contains
# the other MediaWiki files. It will be used as a base to locate files.
if( defined( 'MW_INSTALL_PATH' ) ) {
$IP = MW_INSTALL_PATH;
} else {
$IP = dirname( __FILE__ );
}

$path = array( $IP, "$IP/includes", "$IP/languages" );
set_include_path( implode( PATH_SEPARATOR, $path ) . PATH_SEPARATOR . get_include_path() );

require_once( "$IP/includes/DefaultSettings.php" );

# If PHP's memory limit is very low, some operations may fail.
# ini_set( 'memory_limit', '20M' );

if ( $wgCommandLineMode ) {
if ( isset( $_SERVER ) && array_key_exists( 'REQUEST_METHOD', $_SERVER ) ) {
	die( "This script must be run from the command line\n" );
}
}
## Uncomment this to disable output compression
# $wgDisableOutputCompression = true;

$wgSitename         = "The Mac Site - Guides";

## The URL base path to the directory containing the wiki;
## defaults for all runtime URL paths are based off of this.
$wgScriptPath       = "/guides";
$wgScriptExtension  = ".php";

## For more information on customizing the URLs please see:
## [url=http://"http://www.mediawiki.org/wiki/Manual:Short_URL"]http://www.mediawiki.org/wiki/Manual:Short_URL[/url]

$wgEnableEmail      = true;
$wgEnableUserEmail  = true;

$wgEmergencyContact = "closed";
$wgPasswordSender = "closed";

## For a detailed description of the following switches see
## [url=http://"http://www.mediawiki.org/wiki/Extension:Email_notification"]http://www.mediawiki.org/wiki/Extension:Email_notification[/url] 
## and [url=http://"http://www.mediawiki.org/wiki/Extension:Email_notification"]http://www.mediawiki.org/wiki/Extension:Email_notification[/url]
## There are many more options for fine tuning available see
## /includes/DefaultSettings.php
## UPO means: this is also a user preference option
$wgEnotifUserTalk = false; # UPO
$wgEnotifWatchlist = false; # UPO
$wgEmailAuthentication = true;

$wgDBtype           = "mysql";
$wgDBserver         = "closed";
$wgDBname           = "closed";
$wgDBuser           = "closed";
$wgDBpassword       = "closed";

# MySQL specific settings
$wgDBprefix         = "guides_";

# MySQL table options to use during installation or update
$wgDBTableOptions   = "TYPE=InnoDB";

# Experimental charset support for MySQL 4.1/5.0.
$wgDBmysql5 = false;

# Postgres specific settings
$wgDBport           = "5432";
$wgDBmwschema       = "mediawiki";
$wgDBts2schema      = "public";

## Shared memory settings
$wgMainCacheType = CACHE_NONE;
$wgMemCachedServers = array();

## To enable image uploads, make sure the 'images' directory
## is writable, then set this to true:
$wgEnableUploads       = true;
# $wgUseImageMagick = true;
# $wgImageMagickConvertCommand = "/usr/bin/convert";

## If you want to use image uploads under safe mode,
## create the directories images/archive, images/thumb and
## images/temp, and make them all writable. Then uncomment
## this, if it's not already uncommented:
# $wgHashedUploadDirectory = false;

## If you have the appropriate support software installed
## you can enable inline LaTeX equations:
$wgUseTeX           = false;

$wgLocalInterwiki   = $wgSitename;

$wgLanguageCode = "en";

$wgProxyKey = "closed";

## Default skin: you can change the default skin. Use the internal symbolic
## names, ie 'standard', 'nostalgia', 'cologneblue', 'monobook':
$wgDefaultSkin = 'monobook';

## For attaching licensing metadata to pages, and displaying an
## appropriate copyright notice / icon. GNU Free Documentation
## License and Creative Commons licenses are supported so far.
$wgEnableCreativeCommonsRdf = true;
$wgRightsPage = ""; # Set to the title of a wiki page that describes your license/copyright
$wgRightsUrl = "http://creativecommons.org/licenses/by-sa/3.0/";
$wgRightsText = "Attribution-Share Alike 3.0 ";
$wgRightsIcon = "http://i.creativecommons.org/l/by-sa/3.0/88x31.png";
# $wgRightsCode = "by-sa"; # Not yet used

$wgDiff3 = "";

# When you make changes to this configuration file, this will make
# sure that cached pages are cleared.
$configdate = gmdate( 'YmdHis', @filemtime( __FILE__ ) );
$wgCacheEpoch = max( $wgCacheEpoch, $configdate );

// This requires a user be logged into the wiki to make changes.

$wgGroupPermissions['*']['edit'] = true; 



// Specify who may create new accounts.

$wgGroupPermissions['*']['createaccount'] = false; 



// PHPBB User Database Plugin. (Requires MySQL Database)

require_once './extensions/Auth_phpbb.php';



$wgPHPBB_WikiGroupName  = array("Support", "Administrators", "Global moderators", "Registered users");              // Name of your PHPBB group
                                                // users need to be a member

                                                // of to use the wiki. (i.e. wiki)



$wgPHPBB_UseWikiGroup   = true;                 // This tells the Plugin to require

                                                // a user to be a member of the above

                                                // phpBB group. (ie. wiki) Setting

                                                // this to false will let any phpBB

                                                // user edit the wiki.



$wgPHPBB_UseExtDatabase = false;                // This tells the plugin that the phpBB tables

                                                // are in a different database then the wiki.

                                                // The default settings is false.



/*-[NOTE: You only need the next four settings if you set $wgPHPBB_UseExtDatabase to true.]-*/

//$wgPHPBB_MySQL_Host     = 'host';               // phpBB MySQL Host Name.

//$wgPHPBB_MySQL_Username = 'username';           // phpBB MySQL Username.

//$wgPHPBB_MySQL_Password = 'password';           // phpBB MySQL Password.

//$wgPHPBB_MySQL_Database = 'database_name';      // phpBB MySQL Database Name.



$wgPHPBB_UserTB         = 'phpbb_users';        // Name of your PHPBB user table. (i.e. phpbb_users)

$wgPHPBB_GroupsTB       = 'phpbb_groups';       // Name of your PHPBB groups table. (i.e. phpbb_groups)

$wgPHPBB_User_GroupTB   = 'phpbb_user_group';   // Name of your PHPBB user_group table. (i.e. phpbb_user_group)

$wgAuth                 = new Auth_PHPBB();     // Auth_PHPBB Plugin.

 

i need help fast

[fenway]

You won't get any help fast... that's ugly, hard to read, and even hard for a moderator to reformat with all those crazy non-printing characters.  Besides, you don't even mention the problem.

[creamers]

can anyone tell me what to do now i keep getting this error.

Unable to view external table

MySQL Error Number: 1267

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

[fenway]

Why are they being mixed? Check you charset definitions for your columns, tables and databases