URL to your eFiction: http://www.mickiclark.com/efiction33
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: SMF
Version of PHP:
Version of MySQL: MySQL 4.1.14
Have you searched for your problem: yes
If so, what terms did you try: I ound a thread w/this exact error pasted, but it was on a different topic.
State the nature of your problem: On logout:
A fatal MySQL error was encountered.
Query: SELECT stories.*, author.realName as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM (smf_members as author, TABLEPREFIXfanfiction_stories as stories) WHERE author.ID_MEMBER = stories.uid AND stories.validated > 0 AND stories.featured = '1'
Error: (1146) Table 'efic.TABLEPREFIXfanfiction_stories' doesn't exist
Do you have a test account for us?tester, pass test
URL to your eFiction: http://www.mickiclark.com/efiction33
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: SMF
Version of PHP:
Version of MySQL: MySQL 4.1.14
Check out the SMF bridge logout.php file. You're missing the TABLEPREFIX define in there somewhere.
This is the logout.php. I tried
define("_TABLEPREFIX", "");
but that didn't work. Sorry...I'm PHP deficient.
<?php
// Generally, you should be able to leave this alone. This logout function will unset all session variables and cookie variables of the same name that begin with the site's sitekey.
if(!defined("_LOGOUTCHECK")) exit( );
define("_BASEDIR", "");
define("_TABLEPREFIX", "");
include("config.php");
include_once("includes/queries.php");
session_start( );
require_once(PATHTOSMF."SSI.php");
$_SESSION['USER_AGENT'] = $_SERVER['HTTP_USER_AGENT'];
loadUserSettings( );
include_once(PATHTOSMF."Sources/Subs-Auth.php");
// If you log out, you aren't online anymore :P.
dbquery("DELETE FROM smf_log_online WHERE ID_MEMBER = $ID_MEMBER LIMIT 1");
$_SESSION['log_time'] = 0;
// Empty the cookie! (set it in the past, and for ID_MEMBER = 0)
setLoginCookie(-3600, 0);
foreach ($_SESSION as $VarName => $Value) {
if(substr($VarName, 0, strlen($sitekey)) == $sitekey) {
if(strpos($VarName, "skin")) continue;
unset($$VarName);
$_SESSION[$VarName] = "";
setcookie($VarName, '0');
}
}
require_once("header.php");
//make a new TemplatePower object
if(file_exists("$skindir/default.tpl")) $tpl = new TemplatePower( "$skindir/default.tpl" );
else $tpl = new TemplatePower("default_tpls/default.tpl");
if(file_exists("$skindir/listings.tpl")) $tpl->assignInclude( "listings", "./$skindir/listings.tpl" );
else $tpl->assignInclude( "listings", "./default_tpls/listings.tpl" );
include("includes/pagesetup.php");
$output .= write_message(_ACTIONSUCCESSFUL);
$tpl->assign("output", $output);
$tpl->printToScreen( );
?>
URL to your eFiction: http://www.mickiclark.com/efiction33
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: SMF
Version of PHP:
Version of MySQL: MySQL 4.1.14
