Login not working from Mambo

[mrpotato]

Hey, I have started a website at hxxp:mrpotato.helphousehosting.info [nonactive] using both mambo 4.5.1 and SMF 1.0.3 (in separate databases)(oh, and I know about the template being inferior, I'll switch to another one later). However, I have trouble logging in through the mambo interface, with the error "mysql_fetch_array(): supplied argument is not a valid MySQL result resource".

I'm not experienced with either MySQL or PHP, so I searched these forums and found a similar topic here.

I have followed these instructions (uploading a clean subs.php, then installing etc. and manually uploading MOS_SMF.php), but I still have the same issue.

It is possible to login from the forum itself, but not through Mambo, but registration IS possible from both.
Any Ideas?

Thanks,

Rich


EDIT: There also seems to be some kind of issue with mod_smf_login.php

[Orstio]

What is the code you put in the Mambo template?

[mrpotato]

Whatever was in the readme, I think it was

<?php
global $sc, $context;

if (!defined('SMF')){
  require ("administrator/components/com_smf/config.smf.php");
  require ($smf_path."/SSI.php");
}

$sc = &$context['session_id'];
$_SESSION['USER_AGENT'] = $_SERVER['HTTP_USER_AGENT'];

mysql_select_db($mosConfig_db);
?>

before the </head>, and

<?php include_once( $GLOBALS['mosConfig_absolute_path'] . '/includes/footer.php' ); ?>
<?php mosLoadModules( 'debug', -1 );?>
<?php mysql_select_db($db_name); ?>

before the </body>

[Orstio]

If you go to your database management in cPanel, does your SMF user have access to your Mambo database?

[mrpotato]

That appears to have solved a couple of things, but I still cant login, now with the error message

8: Undefined property: login
File: /home/mrpotato/public_html/forum/Sources/MOS_SMF.php
Line: 45

Your help in this matter is greatly appreciated, as I have limited knowledge with MySQL, and even less with PHP. I always stuck with HTML and C++

[mrpotato]

Okay, just to rub salt into the wound, I now get a

Fatal error: session_start(): Failed to initialize storage module: user (path: /tmp) in /home/mrpotato/public_html/home/administrator/index2.php on line 34

error when administering Mambo...

EDIT: Yeah, so I fixed this one myself

[Orstio]

That appears to have solved a couple of things, but I still cant login, now with the error message

8: Undefined property: login
File: /home/mrpotato/public_html/forum/Sources/MOS_SMF.php
Line: 45

Your help in this matter is greatly appreciated, as I have limited knowledge with MySQL, and even less with PHP. I always stuck with HTML and C++

In your Mambo admin panel, go to your modules menu, and edit the login form.  Make sure the params are as you want them, and make sure to save once.  This should get rid of your error.

[mrpotato]

Yeah, that fixed it

Thanks for your support Orstio, and congratulations to the dev team on developing this fantastic bridge and forum.

Regards,

Rich aka LEO

[legolas]

Thats it, everything is working now. xenovanis, you da man!! Goodbye PHPBB, Hello SMF!! 

[xenovanis]

da man? 

You're welcome! 

[rjoe_brandon]

In your Mambo admin panel, go to your modules menu, and edit the login form.  Make sure the params are as you want them, and make sure to save once.  This should get rid of your error.

Thanks!  I was having troubles with e-mail notifications of topic replies giving me the error " The topic or board you are looking for appears to be either missing or off limits to you."  I followed your tips and went to my mod and changed

Login Redirection URL:     Back to the Mambo Homepage Back to the SMF Main Page Back to the page from which the user logged in

So that the option was set to "Back to the page from which the user logged in".  Now when SMF sends a notice of reply out it provides a link that looks like:

site.com/index.php?option=com_smf&Itemid=42&?topic=9.new;topicseen#new


Instead of:


site.com/forum/index.php?topic=9.new;topicseen#new

and allows logged in users to jump right to the message.

Thanks again for the tip!

Best,

R. Joe