Extension talk:AuthJoomla/ja

Hi

Thanks for a very useful extension. However, it does not work when the MediaWiki tables are given a prefix. The problem is that that the SQL user authentication query tries to parse a table in the joomla database containing both the joomla prefix, example (jos_) and the MediaWiki prefix, example (mw_). The table which is searched has the form "joomla_db.mw_jos_users". This table does not exist and an error is returned. The correct table should have been joomla_db.jos_users which is what results without the mw_ prefix attached.

Has anyone managed to get the extension to work with the MediaWiki database tablenames prefixed.

I am running : Joomla 1.5.3 MediaWiki 1.12 (same result on 1.11.1) PHP 5.2.5 MySQL 5.0.45 Apache 2.2.6

Thanks

You can try to write yourself the queries: I made this: $query = 'SELECT password FROM jos_users WHERE username = \''. $username. '\' LIMIT 1'; $hash_password = mysql_fetch_object(mysql_query($query));

and this: $query = 'SELECT password FROM jos_users WHERE username = \''. $user->mName. '\' LIMIT 1'; $juser = mysql_fetch_object(mysql_query($query));