Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database
query was:
(SQL query hidden)
from within function "User::addToDatabase". MySQL returned error "1062: Duplicate entry 'The_Spide' for key 2 (localhost)".
I'll put this on my ToDo list for the next weekend. But here is something you could try in the meanwhile: try logging out and logging in on the drupal site and try to visit the wiki page once again. Let me know if that helps.
Cheers!
Paul.
--
Paul.
/(bb|[^]b{2})/
seems so, yeah.
Currently we are using an cutting-edge (beta) SSO Plugin in order to bring the wiki and drupal authorization together. Perhaps your account was registered in the wiki database AND in the drupal database during the sign up process. Furthermore the wiki-user db will get updated each time you log in into the drupal site. I think this is where those two worlds collide.
I've altered the wiki database to remove the primary-key collsion, please try once again. If this works now for you, I have an idea where to look for the bug.
Cheers!
Paul.
--
Paul.
/(bb|[^]b{2})/
nah, nothing that fancy. Actually those are two plugins, one for drupal injecting user data into the wiki database when you log in over here, and a mediawiki counterpart acting as an authorization filter. Some sort of cookie sharing is also involved, did not look closer into it though.
Funny btw... right now I am implementing a X509 based SSO mechanism for an application i am currently developing for my daytime job :) I might have some articles about WCF's (Webservices on Steroids for .NET) authentication / authorization framework if you are interessted.
--
Paul.
/(bb|[^]b{2})/
--------------
MaiPhoenix
(aka KnitWitch)
Maaan, this was a nasty one - and it have me good headaches.
The Drupoal/MediaWiki SSO plugin had to be patched. I've already commited my fixes back to the plugin author so we won't run into this issue once again after we update our system.
For those who really want to know: It was a bug, more precisely an incompatibility between the drupal and mediawiki user handling.
Media-Wiki will replace the '_' (underscore char) in each users name by a space char. So each time you query the wiki database for the_mighty_user" the user get be reformatted to "the mighty user". This leads to serious problems during the registration process where users are added to the wiki database based on their drupal counterpart.
What the plugin basically does, is mirroring the drupal user in the wiki user database each time you go to the wiki site. Once it has been saved to the database, the wiki system will try to authenticate you based on your user name obtained from the session against its database. Unfortunately the session will contain the username with an underscore, while the local database will not. This lets the system assume that there is no such user in the wiki database so it will attempt to mirror the drupal user once again. BOOM.
The fix is rather stupid, but it will work. Your user names on the wiki site will contain an dot char instead of an underscore.
Cheers!
Paul.
--
Paul.
/(bb|[^]b{2})/


