Database Error

[Bogie]

Everything seems to be working fine but I get the following error when I go to sign out.  Here's a screenshot:



Thanks in advance.

[tentronik]

Hi,
do you have phpmyadmin to login to your database and check if the smf_session table is in place?
Also can you checkout your forum error log - if there are relevant error messages?

And i guess you need this http://www.simplemachines.org/community/index.php?topic=18096.15
a tool to repair settings and more.

[Bogie]

do you have phpmyadmin to login to your database and check if the smf_session table is in place?

Nope there is no smf_session table in my database. 

And i guess you need this http://www.simplemachines.org/community/index.php?topic=18096.15 a tool to repair settings and more.

My settings don't need any repair.  Everything is functioning fine until I try to log out, then I get the error.  Which of the mambo bridge files installs the smf_session table?

[tentronik]

The smf_session table is a core table i guess.
So i would suggest checking the repair_settings.php to see if the script can create the missing database table.

Oh and your smf prefix is smf_ or otherwise it would be yourPrefix_session table.

[xenovanis]

Nope there is no smf_session table in my database. 

My settings don't need any repair.  Everything is functioning fine until I try to log out, then I get the error.  Which of the mambo bridge files installs the smf_session table?

Just ignore me 

[Orstio]

There seems to be some confusion here.....

Two databases, correct?

You won't have a smf_session table in your Mambo database.  Please do not create one -- It will get rid of your error, but not fix your actual problem.

Let's start from the beginning, shall we?

What version of the bridge are you using?

[Bogie]

I'm using Version 1.0, my admin panel says its the current version.

[Orstio]

1.0?

The current version of the bridge is 3.19a.

What is the code you put in the header of your template?

[Bogie]

It said 1.0 in the admin panel but now that I think about it I think its 3.18 which is what I was told needed to be used with SMF 1.0.5.

Here's the code it instructed to put in the header:

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

[Orstio]

Have you upgraded from a previous version of the bridge?

[Bogie]

Nope.  I just converted my site over from phpbb a week or so ago.

[Orstio]

Did you add this to the end of your Mambo template:

Code Select Expand

<?php mysql_select_db($db_name); ?>

[Bogie]

Yes, just before the

Code Select Expand

</body> tag.

[Orstio]

OK, I'm going to suggest then that you download version 3.19a of the bridge, and unzip step 1.  Upload the file MOS_SMF.php from the zip file to overwrite the one you have in your SMF Sources directory.