| View previous topic :: View next topic |
mavis
Joined: 01 Jan 2010
Posts: 2
|
 Posted: Fri Jan 01, 2010 10:23 am Post subject: inegration fail |
 |
|
|
Hello,
I have a hostmonster phpBB3 site that has been running for some time. I recently installed mediawiki to the same server. In both cases, I used the "simple scripts" service to do the installations. I am untrained in programming, so I am liable to make obvious mistakes...
I downloaded the zipped files from your website, unzipped them, and copied them to the extensions folder of the wiki installation. I added the text (as described on the wediawiki site) to my localsettings.php file. I took the database name, username & password from the config.php file of the phpBB3 forum. I created a "wiki" user group via the admin panel of the phpBB3.
The wiki loads into the browser OK, but I get an error when I log in to make edits.
The error I get whe I log into the wiki is:
| Code: | Unexpected non-MediaWiki exception encountered, of type "Exception"
exception 'Exception' with message 'Unable to view external table<br />MySQL Error Number: 1146<br />MySQL Error Message: Table 'slaphead_mdw1.phpbb_users' doesn't exist<br /><br />' in /home2/slaphead/public_html/mofowiki/extensions/Auth_phpBB.php:699
Stack trace:
#0 /home2/slaphead/public_html/mofowiki/extensions/Auth_phpBB.php(505): Auth_phpBB->mySQLError('Unable to view ...')
#1 /home2/slaphead/public_html/mofowiki/includes/User.php(672): Auth_phpBB->getCanonicalName('Mavis')
#2 /home2/slaphead/public_html/mofowiki/includes/User.php(350): User::getCanonicalName('Mavis', 'valid')
#3 /home2/slaphead/public_html/mofowiki/includes/specials/SpecialUserlogin.php(415): User::newFromName('Mavis')
#4 /home2/slaphead/public_html/mofowiki/includes/specials/SpecialUserlogin.php(524): LoginForm->authenticateUserData()
#5 /home2/slaphead/public_html/mofowiki/includes/specials/SpecialUserlogin.php(107): LoginForm->processLogin()
#6 /home2/slaphead/public_html/mofowiki/includes/specials/SpecialUserlogin.php(17): LoginForm->execute()
#7 /home2/slaphead/public_html/mofowiki/includes/SpecialPage.php(771): wfSpecialUserlogin(NULL, Object(SpecialPage))
#8 /home2/slaphead/public_html/mofowiki/includes/SpecialPage.php(559): SpecialPage->execute('wfSpecialUserlo...', NULL, Object(SpecialPage))
#9 /home2/slaphead/public_html/mofowiki/includes/Wiki.php(229): SpecialPage::executePath(NULL)
#10 /home2/slaphead/public_html/mofowiki/includes/Wiki.php(59): MediaWiki->initializeSpecialCases(Object(Title))
#11 /home2/slaphead/public_html/mofowiki/index.php(116): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(WebRequest))
#12 {main} |
The database slaphead_mdw1 is the default database for the wiki. The database for the forum is slaphead_pbb01.
The edits I made to the local setting.php file are:
| Code: |
$wgAuth_Config['MySQL_Host'] = 'localhost'; // phpBB MySQL Host Name.
$wgAuth_Config['MySQL_Username'] = 'slaphead_pbb01'; // phpBB MySQL Username.
$wgAuth_Config['MySQL_Password'] = '**********'; // phpBB MySQL Password.
$wgAuth_Config['MySQL_Database'] = 'slaphead_pbb01'; // phpBB MySQL Database Name.
$wgAuth_Config['UserTB'] = 'phpbb_users'; // Name of your PHPBB user table. (i.e. phpbb_users)
$wgAuth_Config['GroupsTB'] = 'phpbb_groups'; // Name of your PHPBB groups table. (i.e. phpbb_groups)
$wgAuth_Config['User_GroupTB'] = 'phpbb_user_group'; // Name of your PHPBB user_group table. (i.e. phpbb_user_group)
$wgAuth_Config['PathToPHPBB'] = '../forum/'; // Path from this file to your phpBB install. Must end with '/'.
|
I have tried using 'phpbb_users' and 'phpbb3_users', but I get the same error. I have not been able to figure out which one (phpbb_user vs phpbb3_user) is correct.
The phpBB forum is located at ../forum/ and the wiki is installed under ../mofowiki/.
Both folders are directly under home2/slaphead/public_html/
Additionally, I have tried changing the user group "wiki" to "Registered users" in the localsettings.php file. no change to the error message.
Thanks for supporting us novice webmasters! |
|
| Back to top |
|
|
mavis
Joined: 01 Jan 2010
Posts: 2
|
| Posted: Fri Jan 01, 2010 12:24 pm Post subject: |
|
|
|
OK,
I figured out the problem.
I changed the following command from false to true
| Code: | $wgAuth_Config['UseExtDatabase'] = true; // This tells the plugin that the phpBB tables
// are in a different database then the wiki.
// The default settings is false. |
I also went into the phpmyadmin and nosed around the slaphead_pbb01 database. I realized that users, groups, and user _group were directly listed in the database - so my problem was that I wasn't giving the right path to the table....
I made the following changes to the local settings.php
| Code: | $wgAuth_Config['UserTB'] = 'users'; // Name of your PHPBB user table. (i.e. phpbb_users)
$wgAuth_Config['GroupsTB'] = 'groups'; // Name of your PHPBB groups table. (i.e. phpbb_groups)
$wgAuth_Config['User_GroupTB'] = 'user_group'; // Name of your PHPBB user_group table. (i.e. phpbb_user_group)
$wgAuth_Config['PathToPHPBB'] = '../forum/'; // Path from this file to your phpBB install. Must end with '/'. |
This cleaned up the problem nicely. I found that I still needed to use a special "Wiki" usr group, as registered users gave me an error message. I will just have to remember to add all new site members to the Wiki group as they join up.
Most of this I figured out from reading through the older posts. Seemed like most problems were based on getting the wiki software to look in the right place for the table info. Thanks again for the extension - if you're ever in New Hampshire, email me, and I'll buy you a beer for your hard work. |
|
| Back to top |
|
|
root
Site Admin
Joined: 24 Jun 2005
Posts: 432
|
| Posted: Sun Jan 03, 2010 10:57 am Post subject: |
|
|
|
| Thanks Mavis, have a happy new year. |
|
| Back to top |
|
|
AgentX
Joined: 11 Apr 2010
Posts: 3
|
| Posted: Sun Apr 11, 2010 3:18 pm Post subject: |
|
|
|
Hi,
I'm having a similar difficulty and think I've exhausted all the things that Mavis tried but am still stuck with this error:
| Quote: | Unexpected non-MediaWiki exception encountered, of type "Exception"
exception 'Exception' with message 'Unable to view external table<br />MySQL Error Number: 1146<br />MySQL Error Message: Table 'charmer_mwtest1.users' doesn't exist<br /><br />' in /home/charmer/public_html/mwtest1/extensions/Auth_phpBB.php:699
Stack trace:
#0 /home/charmer/public_html/mwtest1/extensions/Auth_phpBB.php(505): Auth_phpBB->mySQLError('Unable to view ...')
#1 /home/charmer/public_html/mwtest1/includes/User.php(672): Auth_phpBB->getCanonicalName('Test1admin')
#2 /home/charmer/public_html/mwtest1/includes/User.php(350): User::getCanonicalName('test1admin', 'valid')
#3 /home/charmer/public_html/mwtest1/includes/specials/SpecialUserlogin.php(415): User::newFromName('test1admin')
#4 /home/charmer/public_html/mwtest1/includes/specials/SpecialUserlogin.php(524): LoginForm->authenticateUserData()
#5 /home/charmer/public_html/mwtest1/includes/specials/SpecialUserlogin.php(107): LoginForm->processLogin()
#6 /home/charmer/public_html/mwtest1/includes/specials/SpecialUserlogin.php(17): LoginForm->execute()
#7 /home/charmer/public_html/mwtest1/includes/SpecialPage.php(771): wfSpecialUserlogin(NULL, Object(SpecialPage))
#8 /home/charmer/public_html/mwtest1/includes/SpecialPage.php(559): SpecialPage->execute('wfSpecialUserlo...', NULL, Object(SpecialPage))
#9 /home/charmer/public_html/mwtest1/includes/Wiki.php(229): SpecialPage::executePath(NULL)
#10 /home/charmer/public_html/mwtest1/includes/Wiki.php(59): MediaWiki->initializeSpecialCases(Object(Title))
#11 /home/charmer/public_html/mwtest1/index.php(116): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(WebRequest))
#12 {main} |
Running phpBB 3.0.6, Mediawiki 1.15.2, PHP 5.2.11, MySQL 5.0.81-community.
I would be most grateful for any clues as to what I should be trying next. The databases are on the same domain. |
|
| Back to top |
|
|
root
Site Admin
Joined: 24 Jun 2005
Posts: 432
|
| Posted: Sun Apr 11, 2010 10:34 pm Post subject: |
|
|
|
| The error message is saying that the database "charmer_mwtest1" does not have a "users" table in it. |
|
| Back to top |
|
|
AgentX
Joined: 11 Apr 2010
Posts: 3
|
| Posted: Mon Apr 12, 2010 3:43 am Post subject: |
|
|
|
Thanks.
My MediaWiki database contains tables called mw_test1user and mw_test1user_groups.
Do I need to create a table called mw_test1users or rename mw_test1user to mw_test1users?
I didn't see anything in the installation instructions about changing the MediaWiki tables. |
|
| Back to top |
|
|
root
Site Admin
Joined: 24 Jun 2005
Posts: 432
|
| Posted: Tue Apr 13, 2010 12:34 pm Post subject: |
|
|
|
Take at look at these setting in LocalSettings.php
| Code: | $wgAuth_Config['UserTB'] = 'phpbb3_users'; // Name of your PHPBB user table. (i.e. phpbb_users)
$wgAuth_Config['GroupsTB'] = 'phpbb3_groups'; // Name of your PHPBB groups table. (i.e. phpbb_groups)
$wgAuth_Config['User_GroupTB'] = 'phpbb3_user_group'; // Name of your PHPBB user_group table. (i.e. phpbb_user_group) |
|
|
| Back to top |
|
|
AgentX
Joined: 11 Apr 2010
Posts: 3
|
| Posted: Tue Apr 13, 2010 3:33 pm Post subject: |
|
|
|
AHA!
I realize now that I needed to make $wgAuth_Config['UseExtDatabase'] = true;
and
un-comment out the following four lines of code to define the phpBB database details. |
|
| Back to top |
|
|
