vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Desperately seeking help on mysql error (https://vborg.vbsupport.ru/showthread.php?t=72137)

ChrisF79 11-24-2004 11:57 AM

Desperately seeking help on mysql error
 
Greetings,

I want to make the forum on my site simply sit in the main content area with the left and right columns surrounding it, much like the main page http://www.understandfinance.com/ . To accomplish this, I include the navbar and leftnav through the code:

ob_start();
require("../includes/navbar.php");
$navbar = ob_get_contents();
ob_end_clean();

ob_start();
include_once('../includes/leftnav.php');
$leftnav = ob_get_contents();
ob_end_clean();

So this all makes sense, the mysql query that sits in the leftnav is as follows:

<?php
$dbh=mysql_connect ("localhost", "username", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("understa_main", $dbh);
$query = "SELECT headline, newsstory, date_format(newsdate, '%M %D, %Y') FROM sitenews ORDER BY newsdate DESC LIMIT 3";
$result = mysql_query($query, $dbh);
while($query_data = mysql_fetch_row($result)) {
echo '<p><span class="bold">'.$query_data[0].'</span><br />'.$query_data[2].'</p>';
echo '<p class="story">'.$query_data[1].'</p>';
}
mysql_close($dbh);
?>

Then when I call the $leftnav in my header, I get an error from vbulletin that says:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM understa_session AS session
LEFT JOIN understa_user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1101255492
ORDER BY username ASC

mysql error: Table 'understa_main.understa_session' doesn't exist

mysql error number: 1146


Now, understa_main is my database for my site that includes the tutorials, articles, etc. understa_forum is the database for vbulletin. So it looks as though vbulletin gets "stuck" so to speak, trying to access it's sessions table in my main database instead of it's own. The good folks over at vbulletin.com told me that this is where the experts are so I'm hoping someone can help me.

Sorry for the long post but I wanted to give you the full story.

Thanks in advance for any help you could provide!


All times are GMT. The time now is 04:59 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01394 seconds
  • Memory Usage 1,710KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete