https://bugzilla.wikimedia.org/show_bug.cgi?id=16794
--- Comment #3 from Brent G <[email protected]> 2008-12-26 03:13:18 UTC --- Ok, Ignore #2. Think I figured out why the editing is snafu. say we have 2 wikis, awesomewiki && poolwiki with matching schemas. Poolwiki has the shared usertable so $wgSharedDB = 'poolwiki'; User logs into awesomewiki. The search path gets set to "awesomewiki", public. Currently, it checks for $wgSharedDB, see's that user table is shared, and plops down the poolwiki schema before the queries. The lookup works since the schema is explicit. Next said logged in user goes to submit an edit. MW goes to insert a row into the revisions table with the user data. There is a foreign key constraint on rev_user to the mwuser table. However since we're sharing the poolwiki mwuser table & the searchpath is ("awesomewiki", public), it tries to lookup user in awesomewiki.mwuser which is empty and fails the foreign key constraint. So I'm stumped on what 'Best Practices' would say on how to move on from here. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
