Host claims issue with viewstory.php

Doesn't that usually mean you should be getting an error message, usually a fatal one?  I thought they were caused by errors, generally, since they're used for debugging.  Does anything show up when you have debug on and are viewing a story or whatever?

I know this is a 'doh' thing, but have you tried re-uploading the original viewstory.php and some other core files just in case (I'm assuming you did already, but just in case...)

I know this is a 'doh' thing, but have you tried re-uploading the original viewstory.php and some other core files just in case (I'm assuming you did already, but just in case...)

Yes, I've uploaded from backup. Then I tried a clean file. Then I redownloaded the .zip and uploaded that one.

And I don't know if we're getting debug messages, because we're getting 500 errors and I can't see diddly.

We ran for... 8 days before this happened.

Unfortunately I don't know enough to be of any real assistance, but if I was in a similar situation I would probably go and delete everything in public_html and then wait a bit, and then upload the backups.  (Rather than uploading over files that are already there.)  It might maybe help kill whatever's going on?

I know this is a 'doh' thing, but have you tried re-uploading the original viewstory.php and some other core files just in case (I'm assuming you did already, but just in case...)

Yes, I've uploaded from backup. Then I tried a clean file. Then I redownloaded the .zip and uploaded that one.

And I don't know if we're getting debug messages, because we're getting 500 errors and I can't see diddly.

We ran for... 8 days before this happened.

Do you get an error_log? Try looking at that for instances of viewstory.php. It'd be more helpful than your quotation in the first post -- it should name whatever it is specifically.

Unfortunately I don't know enough to be of any real assistance, but if I was in a similar situation I would probably go and delete everything in public_html and then wait a bit, and then upload the backups.  (Rather than uploading over files that are already there.)  It might maybe help kill whatever's going on?

Been there, done that.

Our error_log is oh... 5GB. Oh course it's perfectly normal for a site that ran just fine for months to suddenly produce that many errors in the course of 8 hours, at least that's what our host tells us. I've been downloading the damn file for 3 hours now, so I'll be able to dig through it later.

O_O

Do you have an option in your cPanel to view the last 300 or something?

Our ingenius host deleted the file rather than renaming it so I couldn't even get a full download.

This is our latest error in the new log though.

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/homeloader.so' - /usr/local/lib/php/extensions/no-debug-zts-20060613/homeloader.so: cannot open shared object file: No such file or directory in Unknown on line 0

Which means jack to me.

ETA: Oh wait, ones I understand.

[07-Mar-2009 21:12:26] PHP Notice:  Undefined index:  randomblock in /home/jonasb7/public_html/includes/class.TemplatePower.inc.php on line 713
[07-Mar-2009 21:12:27] PHP Notice:  Undefined index:  recentblock in /home/jonasb7/public_html/includes/class.TemplatePower.inc.php on line 701
[07-Mar-2009 21:12:27] PHP Notice:  Undefined index:  recentblock in /home/jonasb7/public_html/includes/class.TemplatePower.inc.php on line 701
[07-Mar-2009 21:12:27] PHP Notice:  Undefined index:   in /home/jonasb7/public_html/includes/class.TemplatePower.inc.php on line 701
[07-Mar-2009 21:12:27] PHP Notice:  Undefined index:  recentblock in /home/jonasb7/public_html/includes/class.TemplatePower.inc.php on line 706
[07-Mar-2009 21:12:27] PHP Notice:  Undefined index:   in /home/jonasb7/public_html/includes/class.TemplatePower.inc.php on line 701
[07-Mar-2009 21:18:48] PHP Notice:  Undefined variable: ID_MEMBER in /home/jonasb7/public_html/includes/get_session_vars.php on line 27
[07-Mar-2009 21:18:48] PHP Notice:  Undefined variable: ID_MEMBER in /home/jonasb7/public_html/includes/get_session_vars.php on line 51
[07-Mar-2009 21:18:48] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/jonasb7/public_html/includes/get_session_vars.php:27) in /home/jonasb7/public_html/header.php on line 208
[07-Mar-2009 21:29:08] PHP Warning:  mysqli_connect() [<a href="'function.mysqli-connect'>function.mysqli-connect</a>"]: (42000/1203): User jonasb7 already has more than 'max_user_connections' active connections in /home/jonasb7/public_html/includes/mysqli_functions.php on line 7
[07-Mar-2009 21:29:12] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/jonasb7/public_html/includes/get_session_vars.php:27) in /home/jonasb7/public_html/header.php on line 208
[07-Mar-2009 21:33:18] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/jonasb7/public_html/includes/get_session_vars.php:27) in /home/jonasb7/public_html/header.php on line 208
[07-Mar-2009 21:33:55] PHP Warning:  mysqli_connect() [<a href="'function.mysqli-connect'>function.mysqli-connect</a>"]: (42000/1203): User jonasb7 already has more than 'max_user_connections' active connections in /home/jonasb7/public_html/includes/mysqli_functions.php on line 7
[07-Mar-2009 21:35:16] PHP Notice:  Undefined variable: ID_MEMBER in /home/jonasb7/public_html/includes/get_session_vars.php on line 27

Our get_session_vars.php was slightly modded because of this issue: https://efiction.org/forums/index.php?topic=6176.0

Is ID_MEMBER something to do with SMF?

Could we see the get_session_vars.php file, please?

Voici:

<?php
// Get session variables from cookie data if not logged in.
// To bridge to another program replace (or add to) this information with the bridge to your other script.  See examples in the includes/bridges/ folder.
if(!defined("_CHARSET")) exit( );

if (!empty($_COOKIE[$sitekey."_useruid"])  && !isset($_SESSION[$sitekey."_useruid"])) {
$userdata = dbassoc(dbquery("SELECT "._UIDFIELD." as uid, "._PENNAMEFIELD." as penname, "._EMAILFIELD." as email, "._PASSWORDFIELD." as password, ap.* FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs as ap ON ap.uid = "._UIDFIELD." WHERE "._UIDFIELD." = '".$_COOKIE[$sitekey."_useruid"]."'"));
if($userdata && $userdata['level'] != -1 && $_COOKIE[$sitekey.'_pwd'] == md5($userdata['email']+$userdata['password'])) {
define("USERUID", $userdata['uid']);
define("USERPENNAME", $userdata['penname']);
if(!isset($_SESSION[$sitekey."_skin"]) && !empty($userdata['userskin'])) $siteskin = $userdata['userskin'];
else if(isset($_SESSION[$sitekey."_skin"])) $siteskin = $_SESSION[$sitekey."_skin"];
else $siteskin = $defaultskin;
define("uLEVEL", $userdata['level']);
define("isADMIN", uLEVEL > 0 ? true : false);
define("isMEMBER", true);
if(!isset($_SESSION[$sitekey."_agecontsent"])) $ageconsent = $userdata['ageconsent'];
else $ageconsent = $_SESSION[$sitekey."_agecontsent"];
}
}
$user_info = array( );
$eFicLang = $language;
require_once(_BASEDIR.PATHTOSMF."SSI.php");
$language = $eFicLang;
$_SESSION['USER_AGENT'] = $_SERVER['HTTP_USER_AGENT'];
// SMF has already loaded it's sessions in queries.php.  So we'll pull the data from the $user_info array from there.
if($ID_MEMBER) {
$eficdata = dbquery("SELECT "._UIDFIELD." as uid, "._PENNAMEFIELD." as penname, ap.level, ap.userskin, ap.ageconsent FROM ".TABLEPREFIX."fanfiction_authorprefs as ap RIGHT JOIN "._AUTHORTABLE." ON ap.uid = "._UIDFIELD." WHERE "._UIDFIELD." = '$ID_MEMBER'");
if(dbnumrows($eficdata)) {
$userdata = dbassoc($eficdata);
if($userdata['level'] != "-1") {
define("USERUID", $userdata['uid']);
define("USERPENNAME", $userdata['penname']);
if(!isset($_SESSION[$sitekey."_skin"]) && !empty($userdata['userskin'])) $siteskin = $userdata['userskin'];
else if(isset($_SESSION[$sitekey."_skin"])) $siteskin = $_SESSION[$sitekey."_skin"];
else $siteskin = $defaultskin;
define("uLEVEL", $userdata['level']);
define("isADMIN", uLEVEL > 0 ? true : false);
define("isMEMBER", true);
if(!isset($_SESSION[$sitekey."_agecontsent"])) $ageconsent = $userdata['ageconsent'];
else $ageconsent = $_SESSION[$sitekey."_agecontsent"];
}
}
}
if(!defined("USERUID")) define("USERUID", 0);
if(!defined("USERPENNAME")) define("USERPENNAME", false);
if(!defined("uLEVEL")) define("uLEVEL", 0);
if(!defined("isMEMBER")) define("isMEMBER", false);
if(!defined("isADMIN")) define("isADMIN", false);
if(empty($siteskin)) $siteskin = $defaultskin;
echo "<!-- USERUID ".USERUID." ".$ID_MEMBER." -->";
?>

And now members are getting this:

A fatal MySQL error was encountered.
Query: UPDATE smf_members as author SET password='d349537f80c598788c1ee400823c5baa' WHERE uid = '2965'
Error: (1054) Unknown column 'uid' in 'where clause'

Edit: So apparently our host has been "helping" without my knowledge (or consent for that matter). I think they might have reuploaded eFiction or mucked with the database without telling me what they've done. I just reuploaded the SMF bridge files, because I have the sinking feeling they were replaced with the wrong ones.

It looks like it's trying to change their password but failing.  It's definitely evidencing the fact that you've got a bridged site, but whether or not that's the problem...  It looks like it's saying there's no uid column.

I just reuploaded the bridge files because I think they were overwritten AGAIN after I uplaoded the correct ones.

I'd say you should look into getting a new host.  Didn't you just switch recently?