Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Mambo Bridge Support => Topic started by: kengtay on August 31, 2005, 09:12:34 AM

Title: login error
Post by: kengtay on August 31, 2005, 09:12:34 AM
I am using mambo 4.5.2.3 Stable + SMF 1.1 Beta 3 & Bridge 3.19a
I got an error on the register page

Notice: Undefined variable: db_name in /home/httpd/vhosts/kengtay.com/httpdocs/components/com_smf_registration/smf_registration.html.php on line 186

Notice: Undefined variable: db_prefix in /home/httpd/vhosts/kengtay.com/httpdocs/components/com_smf_registration/smf_registration.html.php on line 186

Can someone help?
Title: Re: login error
Post by: Kindred on August 31, 2005, 09:54:17 AM
did you add the code into your mambo template?
Title: Re: login error
Post by: kengtay on August 31, 2005, 09:58:50 AM
Do you mean the code for the step 4?
Title: Re: login error
Post by: Kindred on August 31, 2005, 11:50:37 AM
yes...   but wait...    what version of the bridge did you install?

You should have installed MOS_SMF_BRIDGEv3.19a_SMF1.1b3.zip
Title: Re: login error
Post by: kengtay on August 31, 2005, 11:55:09 AM
I think I did that,
this is the version I installed

MOS_SMF_BRIDGEv3.19a_SMF1.1b3.zip

Title: Re: login error
Post by: Kindred on August 31, 2005, 12:30:35 PM
ok then...   give me a url to test?
Title: Re: login error
Post by: Kindred on September 01, 2005, 09:53:08 AM
Hmmmmmm......


try changing line 71 to read:
   global $boarddir, $agreement_required, $im, $db_name, $db_prefix;

(in other words, add $db_name and $db_prefix to the list of global variables....)
Title: Re: login error
Post by: kengtay on September 01, 2005, 10:16:27 AM
Do you mean in the template's index.php? Forgive me, I am kind of new in PHP.

Title: Re: login error
Post by: Kindred on September 01, 2005, 10:24:34 AM
no, I mean in the file mambo/modules/com_smf_registration/com_smf_registration.html.php
Title: Re: login error
Post by: kengtay on September 01, 2005, 10:44:13 AM
May be the version of my mambo is a little bit different, The file I have is locate in

components\com_smf_registration\smf_registration.html.php

I have it in the line of 70 instead of 71

Once I get it changed to    global $boarddir, $agreement_required, $im, $db_name, $db_prefix;
It did fix the 2 error before. But now the new error show up on the bottom.

Database Error: You have an error in your SQL syntax near '.smf_sessions
SET data = 'rand_code|s:32:\"33516237422b0bdded5a9d2a6cbfea07\";' at line 2
File: /home/httpd/vhosts/kengtay.com/httpdocs/forum/Sources/Load.php
Line: 1721
Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

Any idea of this?
Title: Re: login error
Post by: Orstio on September 02, 2005, 06:41:28 PM
QuoteDatabase Error: You have an error in your SQL syntax near '.smf_sessions
SET data = 'rand_code|s:32:\"33516237422b0bdded5a9d2a6cbfea07\";' at line 2
File: /home/httpd/vhosts/kengtay.com/httpdocs/forum/Sources/Load.php
Line: 1721
Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

This error appears when you use two databases, and fail to put this line of code just before the </body> tag of your Mambo template:

<?php mysql_select_db($db_name); ?>
Title: Re: login error
Post by: kengtay on September 03, 2005, 09:51:38 AM
I did add the <?php mysql_select_db($db_name); ?> in the index.php file for the particular templete, infact I have changed to diffferent template and try, it does the same thing. Can this be possible the hosting?
Title: Re: login error
Post by: Orstio on September 03, 2005, 10:00:12 AM
Can you post the contents of your template index.php?
Title: Re: login error
Post by: kengtay on September 03, 2005, 10:04:55 AM
This is the entire content, hope is not too long to post it here.

<?php
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );
// needed to seperate the ISO number from the language file constant _ISO
$iso = explode( '=', _ISO );
// xml prolog
echo '<?xml version="1.0" encoding="'. $iso[1] .'"?' .'>';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php mosShowHead(); ?>
<?php
if ( $my->id ) {
   initEditor();
}
$collspan_offset = ( mosCountModules( 'right' ) + mosCountModules( 'user2' ) ) ? 2 : 1;
//script to determine which div setup for layout to use based on module configuration
$user1 = 0;
$user2 = 0;
$colspan = 0;
$right = 0;
// banner combos

//user1 combos
if ( mosCountModules( 'user1' ) + mosCountModules( 'user2' ) == 2) {
   $user1 = 2;
   $user2 = 2;
   $colspan = 3;
} elseif ( mosCountModules( 'user1' ) == 1 ) {
   $user1 = 1;
   $colspan = 1;
} elseif ( mosCountModules( 'user2' ) == 1 ) {
   $user2 = 1;
   $colspan = 1;
}

//right based combos
if ( mosCountModules( 'right' ) and ( empty( $_REQUEST['task'] ) || $_REQUEST['task'] != 'edit' ) ) {
   $right = 1;
}
?>
<meta http-equiv="Content-Type" content="text/html; <?php echo _ISO; ?>" />
<link href="<?php echo $mosConfig_live_site;?>/templates/rhuk_solarflare_ii/css/template_css.css" rel="stylesheet" type="text/css"/>

<?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);
?>

</head>
<body>

<div align="center">
   <table border="0" cellpadding="0" cellspacing="0" width="808">
      <tr>
         <td class="outline">
              <div id="pathway_outer">
                <div id="pathway_inner">
                   <div id="pathway_text">
                   <?php mosPathWay(); ?>
                   </div>
                   <div id="buttons">
                   <?php mosLoadModules ( 'user3', -1); ?>
                   </div>
                </div>
              </div>
              <div id="search_outer">
                <div id="search_inner">
                <?php mosLoadModules ( 'user4', -1 ); ?>
                </div>
              </div>
              <div class="clr"></div>
              <div id="header_outer">
                 <div id="header">
                 &nbsp;
                 </div>
                 <div id="top_outer">
                   <div id="top_inner">
                   <?php
                     if ( mosCountModules( 'top' ) ) {
                        mosLoadModules ( 'top' );
                     } else {
                        ?>
                        <span class="error">Top Module Empty</span>
                        <?php
                     }
                     ?>
                    </div>
               </div>
              </div>
              <div id="left_outer">
                 <div id="left_inner">
                 <?php mosLoadModules ( 'left' ); ?>
                 </div>
              </div>
              <div id="content_outer">
                  <div id="content_inner">
                  <?php
                 if ( mosCountModules ('banner') ) {
                    ?>
                    <table border="0" cellpadding="0" cellspacing="0" width="100%" class="content_table">
                     <tr>
                        <td>
                           <div id="banner_inner">
                           <img src="<?php echo $mosConfig_live_site;?>/templates/rhuk_solarflare_ii/images/advertisement.png" alt="advertisement.png, 0 kB" title="advertisement" border="0" height="8" width="468"/><br />
                          <?php mosLoadModules( 'banner', -1 ); ?><br />
                           </div>
                           <div id="poweredby_inner">
                              <img src="<?php echo $mosConfig_live_site;?>/templates/rhuk_solarflare_ii/images/powered_by.png" alt="powered_by.png, 1 kB" title="powered_by" border="0" height="68" width="165"/><br />   
                           </div>
                        </td>
                     </tr>
                     </table>
                     <?php
                 }
                 ?>
                 <table border="0" cellpadding="0" cellspacing="0" width="100%" class="content_table">
                  <tr valign="top">
                     <td width="99%">
                        <table border="0" cellpadding="0" cellspacing="0" width="100%" class="content_table">
                        
                        <?php
                        if ($colspan > 0) {
                        ?>
                           <tr valign="top">
                              <?php
                             if ( $user1 > 0 ) {
                                ?>
                                <td width="50%">
                                   <div class="user1_inner">
                                   <?php mosLoadModules ( 'user1' ); ?>
                                   </div>
                                </td>
                                <?php
                             }   
                             if ( $colspan == 3) {
                               ?>
                                 <td width="2">
                                    <img src="<?php echo $mosConfig_live_site;?>/templates/rhuk_solarflare_ii/images/spacer.png" alt="" title="spacer" border="0" height="10" width="2"/>   
                                 </td>
                              <?php
                              }
                             if ( $user2 > 0 ) {
                                ?>
                                <td width="50%">
                                   <div class="user2_inner">
                                   <?php mosLoadModules ( 'user2' ); ?>
                                   </div>
                                </td>
                                <?php
                             }   
                              ?>
                           </tr>
                           <tr>
                              <td colspan="<?php echo $colspan; ?>">
                                 <img src="<?php echo $mosConfig_live_site;?>/templates/rhuk_solarflare_ii/images/spacer.png" alt="" title="spacer" border="0" height="2" width="100"/><br />   
                              </td>
                           </tr>
                           <?php
                           }
                        ?>
                        <tr>
                           <td colspan="<?php echo $colspan; ?>" class="body_outer">
                              <?php mosMainBody(); ?>
                           </td>
                        </tr>
                        </table>
                     
                     
                     </td>
                     <?php
                     if ( $right > 0 ) {
                    ?>
                    <td>
                       <div id="right_outer">
                          <div id="right_inner">
                          <?php mosLoadModules ( 'right' ); ?>
                          </div>
                       </div>
                    </td>
                    <?php
                 }
                 ?>
                              
                  </tr>
                  </table>
              </div>
           </div>
        </td>
     </tr>
  </table>
</div>
<?php include_once( $GLOBALS['mosConfig_absolute_path'] . '/includes/footer.php' ); ?>
<?php mosLoadModules( 'debug', -1 );?>
<?php mysql_select_db($db_name); ?>
</body>
</html>
Title: Re: login error
Post by: Orstio on September 03, 2005, 10:09:12 AM
OK, try changing that line I mentioned earlier to this:

<?php mysql_select_db($GLOBALS['db_name']); ?>
Title: Re: login error
Post by: kengtay on September 03, 2005, 10:15:23 AM
Same thing. Here is what I changed.

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


Title: Re: login error
Post by: Orstio on September 03, 2005, 10:18:54 AM
OK ,and how about changing this line:

global $sc, $context;

to this:

global $sc, $context, $db_name, $db_prefix;

And a question:  Have you installed the SMF Searchbot in Mambo?
Title: Re: login error
Post by: kengtay on September 03, 2005, 10:21:44 AM
No, not yet, So far I have only install from Step 1 to Step 4.
Title: Re: login error
Post by: kengtay on September 03, 2005, 10:34:38 AM
Problem still exist.
Title: Re: login error
Post by: dan1dyoung on September 11, 2005, 08:03:26 AM
Kengtay,

Is there any chance you could email me the bridge file as mamboforge is still down, and i am trying to link mambo and SMF (same versions as yourself)

dy1 at ntlworld.com

or is there somewhere else to get it???

using mambo 4.5.2.3 and SMF 1.1 bete 3 public