missing table

Sync your member list to Simple Machines Forum

Moderator: boyo

missing table

Postby johnec » Fri Dec 07, 2007 2:56 am

WoWRoster v1.9.9.1486
SMFSync v1.9.9.319

After adding SMFSync addon, when I try to edit the config, it tells me I'm missing a table...

1146: Table 'mysphere_wowroster.smf_membergroups' doesn't exist
SQL:
SELECT * FROM `smf_membergroups` WHERE `ID_GROUP` > 3 AND `minPosts` = '-1'
File: lib/dbal/mysql.php
Line: 207
Backtrace (most recent call last):
lib/functions.lib.php
Line: 240
Function Called: backtrace
lib/dbal/mysql.php
Line: 207
Function Called: die_quietly
Arguments:
1146: Table 'mysphere_wowroster.smf_membergroups' doesn't exist
Database Error
/home/mysphere/public_html/wow/wowroster/lib/dbal/mysql.php
207
SELECT * FROM `smf_membergroups` WHERE `ID_GROUP` > 3 AND `minPosts` = '-1'
addons/smfsync/admin/config.func.php
Line: 30
Function Called: query
Arguments:
SELECT * FROM `smf_membergroups` WHERE `ID_GROUP` > 3 AND `minPosts` = '-1'
lib/config.lib.php
Line: 390
Function Called: getgroups
Arguments:
Array ( [id] => 1302 [name] => guild_suspended_group [config_type] => smf_menu_guild [value] => 0 [form_type] => function{getGroups [description] => Select a group to put suspended members in [tooltip] =>

db name: guild_suspended_group )
lib/config.lib.php
Line: 169
Function Called: buildblock
Arguments:
smf_menu_guild
admin/addon_conf.php
Line: 93
Function Called: buildconfigpage
pages/rostercp.php
Line: 116
Function Called: require_once
Arguments:
/home/mysphere/public_html/wow/wowroster/admin/addon_conf.php
index.php
Line: 83
Function Called: require
Arguments:
/home/mysphere/public_html/wow/wowroster/pages/rostercp.php
johnec
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Wed Nov 28, 2007 12:02 pm

missing table

Postby zanix » Fri Dec 07, 2007 3:41 am

I think SMF and Roster need to be in the same database
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

missing table

Postby boyo » Sat Dec 08, 2007 1:00 pm

Your right Zanix, they need to be in the same database.
I thought I had mentioned that, but I may not have.
boyo
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 103
Joined: Wed Jan 24, 2007 7:37 am

Re: missing table

Postby master_sage » Thu Feb 28, 2008 10:36 am

Hi ;

How would you feel abouts someone editing your Config could and sql scripts to allow for an alternate dbconnection?

Ryan
master_sage
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Fri Feb 15, 2008 5:26 pm

Re: missing table

Postby master_sage » Thu Feb 28, 2008 8:26 pm

Thought I would share...

If your using a version of mysql that allows View creation and you have separate databases that run on the same server you can do the following.

In your roster Database

Create View smf_members as Select * from db.smf_members

You will also need to do this for smf_membergroups

I would note that permissions is looking for a table called

smf_menu_permissions. A table that does not exist in 1.1.4
so I have not gotten this to work yet. There are a couple other permission tables but not that one

Note some hosting companies create sub databases for their users so you must include your user prefix in the create view statement for example.. Lets say your host company user name is admin2

then your smf data base is likly admin2_smf even though you only see _smf

so your create view would look like this

go to your roster db

Create view smf_members as select * from admin2_smf.smf_members

this will create a view in your roster database of the other db's table. Thus allowing our most appreciated smfsync program to function. Thanks by the way :)

For those who don't know a view is a stored select statement that acts like a table.

On A side note I have not fully tested this yet. But It appear to be working


Lastly if your db’s are on separate servers, in theory server.db.tablename should work as well, so long as the db accounts are in sync see mysql docs for more information on this one.

Let me know your thoughts
Master_Sage
master_sage
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Fri Feb 15, 2008 5:26 pm

missing table

Postby Spennig » Tue Mar 04, 2008 10:27 pm

It -works- as far as the basics, but I can't access the permissions options, since updating... I get:

Hunter
Fatal error: Call to a member function getMessage() on a non-object in /home/.mariposa/awakened/www.guildawakened.net/roster2/addons/smfsync/admin/permissions.php on line 81

There's no smf_menu_permissions, as noted by the last poster. I can't recall the workaround that a friend made up for me on the last update I had.

Is there a different table it should look for?
User avatar
Spennig
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Wed Jul 12, 2006 1:55 am

Re: missing table

Postby Spennig » Tue Mar 04, 2008 10:52 pm

Spennig wrote:It -works- as far as the basics, but I can't access the permissions options, since updating... I get:

Hunter
Fatal error: Call to a member function getMessage() on a non-object in /home/.mariposa/awakened/www.guildawakened.net/roster2/addons/smfsync/admin/permissions.php on line 81

There's no smf_menu_permissions, as noted by the last poster. I can't recall the workaround that a friend made up for me on the last update I had.

Is there a different table it should look for?


Fixed it.

in \admin\permissions.php, I changed line 81 from:

$body = $roster_login>getMessage() . "<br />

to:

$body = $roster->auth->getMessage() . "<br />

it goes right to the permissions information then. <3
User avatar
Spennig
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Wed Jul 12, 2006 1:55 am


Return to SMFSync

Who is online

Users browsing this forum: No registered users and 0 guests

cron