Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 11-24-2004, 11:57 AM
ChrisF79 ChrisF79 is offline
 
Join Date: Nov 2004
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:41 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02986 seconds
  • Memory Usage 2,184KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete