Error message: Load.php line 1981

Started by the twig, September 14, 2006, 03:59:03 AM

Previous topic - Next topic

the twig

I've been getting this error message on the front page that I see when I've tested my site live:

Database Error: Table 'database.sessions' doesn't exist
File: ...Load.php
Line: 1981
Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

So, I did a search on this forum, added the relavent php code to the bottom of my Joomla template, per one thread:

<?php mysql_select_db($GLOBALS['db_name']); ?>

Then I changed both Joomla and SMF admins to be the same (name, username, e-mail, password) per another thread.

Then I completely uninstalled the bridge and then reinstalled it.

Then I logged into the bridge.

Nothing worked, I'm still getting the error message, and Joomla sees "both" identical administrators as logged in separately, so I must not have made them exactly the same somehow, but name/display name, username, e-mail, and password are identical.

Here's my versions:

Joomla 1.0.11
SMF 1.1 RC3
Orstio's Bridge 1.1.6
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

Orstio

Does your Joomla database user have access to your SMF database?  Does your SMF database user have access to your Joomla database?

the twig

SMF and Joomla are in the same database.
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

the twig

#3
On edit—

I just checked the database permissions again for Joomla and SMF—they are (and always have been) the same—same database, same user name, same password. Both systems have database tables set up within the database with their system prefixes, respectively.

So what is going on?

And my identical users in Joomla and SMF are not synched up, not seeing each other as the same user. Should I give synchronization a try?
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

Orstio

Can I see a URL?

Do you have cPanel, or another control panel?

the twig

OK, I'll put the site online briefly, and PM you the URL.

It's not cPanel, I don't have options (that I can find) to set users. It's GoDaddy's default hosting manager.
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

Orstio

To test some things, I am going to need to register.  Can you please enable registration in Joomla?

the twig

OK, you should be able to register now.
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

the twig

#8
Registration doesn't seem to be working, either.

On edit- It still won't produce another image, but you can register on the wrapped site now in SMF registration. Don't ask me why. However, it then tells you "you are not allowed to moderate on this forum!"

If I weren't so exhausted, I would laugh hysterically.
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

Orstio

I think your caching engine is getting a little over-zealous, for starters.  For the sake of testing your site, you should leave caching off in both Joomla and SMF. 

the twig

I checked caching in Joomla and SMF, and they're both turned off.  ???

I'm still getting that error message, did you find anything that could be causing that?

Also, how do I redirect error messages so they don't appear on the front page?

Thanks.
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

Orstio

QuoteHowever, it then tells you "you are not allowed to moderate on this forum!"

Where is it redirecting you after you login?

I wasn't getting this at all when I logged in.

the twig

If you didn't get the "you are not allowed to moderate on this forum," then it's a secondary concern, at this point. It could just be me trying to create another user from the same IP address ???

The error message I'm concerned about is the original one that I started the thread with. What is causing that and how can I get rid of it? How can I move error messages off the front page, for future reference, so I can see them but a user doesn't?
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

Orstio


the twig

It's under function sessionWrite after the section, //First try to update an existing row...the code that starts on 1981 in the next section: // If that didn't work, try inserting a new one):

// If that didn't work, try inserting a new one.
if (db_affected_rows() == 0)
$result = db_query("
INSERT IGNORE INTO {$db_prefix}sessions
(session_id, data, last_update)
VALUES ('" . addslashes($session_id) . "', '" . addslashes($data) . "', " . time() . ")", __FILE__, __LINE__);

return $result;
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

the twig

I just checked again (by taking my site online) and the error message is gone! What the?!

Cool, I guess. But where can I redirect error messages off the front page for future reference?

The caching thing still seems to be happening—seemingly related to the changes I made because of this error message, since I didn't notice it happening before. Could it be a browser issue? The site is wierd when I log in as another user. It doesn't want to log me out. Also, the upshrink buttons won't work until I refresh the page now.
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

Orstio


the twig

I have your discussbot installed, and the Joomla Tag Cleanup package, which I just de-installed (it wasn't working anyway).

I still can't logout as the alias user.
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

Orstio

QuoteThe site is wierd when I log in as another user. It doesn't want to log me out.

That is usually caused by the wrong setting of subdomain independent cookies or local storage of cookies.

QuoteI have your discussbot installed

Ah.  Do you have the database name and prefix entered into the discussbot params?

the twig

Quote from: Orstio on September 17, 2006, 09:54:02 PM
QuoteThe site is wierd when I log in as another user. It doesn't want to log me out.

That is usually caused by the wrong setting of subdomain independent cookies or local storage of cookies.

How do I fix that?

Quote from: Orstio on September 17, 2006, 09:54:02 PM
QuoteI have your discussbot installed

Ah.  Do you have the database name and prefix entered into the discussbot params?

My bad, sorry. I guess it was that causing the error?
Joomla! 1.0.11
SMF 1.1 RC3
Bridge 1.1.6

Advertisement: