1.07 upgrade just hosed my forums!!!!!

kegobeer · March 30, 2006, 04:50:41 PM

On second thought, send me a PM with those lines but don't remove anything this time. I want to see exactly what you have in those lines.

MacGig · March 30, 2006, 04:54:16 PM

sent

MacGig · March 30, 2006, 07:11:17 PM

I installed a test forum, 106, and tried updating to 107 via the admin area. lots of areas on this newly installed test forums

Notice: Undefined index: common_stats in /home/httpd/vhosts/macgig.com/httpdocs/smf/Sources/Load.php(1040) : eval()'d code on line 251
Posts in
Notice: Undefined index: common_stats in /home/httpd/vhosts/macgig.com/httpdocs/smf/Sources/Load.php(1040) : eval()'d code on line 251
Topics by
Notice: Undefined index: common_stats in /home/httpd/vhosts/macgig.com/httpdocs/smf/Sources/Load.php(1040) : eval()'d code on line 251
Members
Latest Member:
Notice: Undefined index: common_stats in /home/httpd/vhosts/macgig.com/httpdocs/smf/Sources/Load.php(1040) : eval()'d code

and...

2: copy(/home/httpd/vhosts/macgig.com/httpdocs/smf/Sources/QueryString.php~): failed to open stream: Permission denied
File: /home/httpd/vhosts/macgig.com/httpdocs/smf/Sources/Subs-Package.php
Line: 1307

kegobeer · March 30, 2006, 09:23:28 PM

Try downloading the 1.0.7 update/upgrade package (depending on whether you have mods installed), unzipping and uploading the files, then running the upgrade script.

MacGig · March 31, 2006, 04:24:55 AM

for my test forum, the upgrade works fine.

I was just thinking, I think I did have one hack on my main forum.... mod I guess you call it?

I edited a file or two and changed some code so guests can see the categories but NOT the posts.

could that be the problem?

MacGig · March 31, 2006, 04:26:51 AM

is their a way to get the old database to work with the new test forum? so I dont lose users and posts???

the url would change, but I would not care, if I could get everything working again.

MacGig · March 31, 2006, 04:37:37 AM

spoke too soon. looked like test upgrade went fine. til I went to admin area and checked for errors in maint section. I get this.

Notice: Undefined index: common_stats in /home/httpd/vhosts/macgig.com/httpdocs/smf/Sources/Load.php(1040) : eval()'d code on line 251
Posts in
Notice: Undefined index: common_stats in /home/httpd/vhosts/macgig.com/httpdocs/smf/Sources/Load.php(1040) : eval()'d code on line 251
Topics by
Notice: Undefined index: common_stats in /home/httpd/vhosts/macgig.com/httpdocs/smf/Sources/Load.php(1040) : eval()'d code on line 251
Members
Latest Member:
Notice: Undefined index: common_stats in /home/httpd/vhosts/macgig.com/httpdocs/smf/Sources/Load.php(1040) : eval()'d code on line 252

MacGig · March 31, 2006, 05:02:45 AM

weird behavior in 107 test forum. lots of errors.

seems Im a guest, looking at the top, but on the bottom, my name is there as being logged in. go figure.

and it wont remember me on logins.... even though I chose that option.

H · March 31, 2006, 08:37:09 AM

It looks to me like it is a settings.php error.

If you would like me to have a look at it please PM me your MySQL and ftp details

kegobeer · March 31, 2006, 08:57:48 AM

@macgeek: Did you do as I recommended and restore the ########## Directories/Files ########## section to the original code and then upload that file?

MacGig · March 31, 2006, 09:26:45 AM

did that. no change.

H · March 31, 2006, 09:39:52 AM

Quote from: huwnet on March 31, 2006, 08:37:09 AM
It looks to me like it is a settings.php error.

If you would like me to have a look at it please PM me your MySQL and ftp details

?

Also can you post your settings.php with username, password etc removed

/edit: I see your new problem. Download repair_settings.php and fix your paths

MacGig · March 31, 2006, 10:09:12 AM

repair settings didnt seem to do a thing. now I get this.

Unknown column 'lb.ID_MSG' in 'field list'
File: /home/httpd/vhosts/macgig.com/httpdocs/forums/Sources/BoardIndex.php
Line: 83

Note: It appears that your database may require an upgrade. Your forum files are currently at version SMF 1.0.6, whereas your database is at version SMF 1.0.7. It is recommended that you execute the latest version of upgrade.php.

MacGig · March 31, 2006, 10:10:01 AM

I went back to 106 forum files, but that didnt work. looks like the db is looking for 107??? do I have to upgrade to 107 again? that is what started all the problems.

H · March 31, 2006, 10:54:21 AM

Quote from: huwnet on March 31, 2006, 08:37:09 AM
It looks to me like it is a settings.php error.

If you would like me to have a look at it please PM me your MySQL and ftp details

Quote from: huwnet on March 31, 2006, 09:39:52 AM
Also can you post your settings.php with username, password etc removed

Please do one of the following.

If you dont it doesn't make it any easier for us to solve your problem

MacGig · March 31, 2006, 11:10:57 AM

I installed 106 again, seems to work this time. thanks for all your help up to this point. sorry for sounding mean in some posts, nothing personal, I was just stressing out.

heres the info you wanted.

Code Select

<?php
/******************************************************************************
* Settings.php                                                                *
*******************************************************************************
* SMF: Simple Machines Forum                                                  *
* Open-Source Project Inspired by Zef Hemel ([email protected])                *
* =========================================================================== *
* Software Version:           SMF 1.0                                         *
* Software by:                Simple Machines (http://www.simplemachines.org) *
* Copyright 2001-2005 by:     Lewis Media (http://www.lewismedia.com)         *
* Support, News, Updates at:  http://www.simplemachines.org                   *
*******************************************************************************
* This program is free software; you may redistribute it and/or modify it     *
* under the terms of the provided license as published by Lewis Media.        *
*                                                                             *
* This program is distributed in the hope that it is and will be useful,      *
* but WITHOUT ANY WARRANTIES; without even any implied warranty of            *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                        *
*                                                                             *
* See the "license.txt" file for details of the Simple Machines license.      *
* The latest version can always be found at http://www.simplemachines.org.    *
******************************************************************************/

########## Maintenance ##########
# Note: If $maintenance is set to 2, the forum will be unusable!  Change it to 0 to fix it.
$maintenance = 0;		# Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)
$mtitle = 'Maintenance Mode';		# Title for the Maintenance Mode message.
$mmessage = 'should be back online soon.... tidying things up. ;)';		# Description of why the forum is in maintenance mode.

########## Forum Info ##########
$mbname = 'MacGig.com :: Community Forums';		# The name of your forum.
$language = 'english';		# The default language file set for the forum.
$boardurl = 'http://www.macgig.com/forums';		# URL to your forum's folder. (without the trailing /!)
$webmaster_email = '[email protected]';		# Email address to send emails from. (like [email protected].)
$cookiename = 'SMFCookie10';		# Name of the cookie to set for authentication.

########## Database Info ##########
$db_server = 'localhost';
$db_name = 'smf';
$db_user = 'smf';
$db_passwd = 'removed';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;

########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = '/home/httpd/vhosts/macgig.com/httpdocs/forums';		# The absolute path to the forum's folder. (not just '.'!)
$sourcedir = '/home/httpd/vhosts/macgig.com/httpdocs/forums/Sources';		# Path to the Sources directory.

########## Error-Catching ##########
# Note: You shouldn't touch these settings.
$db_last_error = 0;

# Make sure the paths are correct... at least try to fix them.
if (!file_exists($boarddir) && file_exists(dirname(__FILE__) . '/agreement.txt'))
$boarddir = '/home/httpd/vhosts/macgig.com/httpdocs/forums';
if (!file_exists($sourcedir) && file_exists($boarddir . '/Sources'))
$sourcedir = '/home/httpd/vhosts/macgig.com/httpdocs/forums/Sources';

?>

H · March 31, 2006, 11:28:52 AM

Thanks for finally posting it. Your site is working fine for me ATM

MacGig · March 31, 2006, 11:31:26 AM

yes, going back to 106 did the trick.

not sure why the 107 update didnt work.

I have no clue. I wanted to update it.

H · March 31, 2006, 11:51:02 AM

Ah yes forgot to check the version number.

I will upgrade it for free if you want

MacGig · March 31, 2006, 11:56:14 AM

I have that hack that allows guests to see boards but not view contents. think it will work this time around?

News:

1.07 upgrade just hosed my forums!!!!!