phpBB 2.0.11 update help

[faltered]

I downloaded the changed files only update for 2.0.11. I'm currently running 2.0.10 on a site.

I've read the instructions dozens of times and can't for the life of me figure out what the heck I'm supposed to do! Is there anywhere I can go that would explain it to me in plain english? Basically, a "for dummies" version?

Thanks all.

[kodaks]

Greetings,

In your forum's directory, find viewtopic.php, and open it up. Inside, find the following code (using your text editor's edit>find feature):

//
// Was a highlight request part of the URI?
//
$highlight_match = $highlight = '';
if (isset($HTTP_GET_VARS['highlight']))
{
// Split words and phrases
$words = explode(' ', trim(htmlspecialchars(urldecode($HTTP_GET_VARS['highlight']))));

for($i = 0; $i < sizeof($words); $i++)
{

Replace the above EXACT text with:

//
// Was a highlight request part of the URI?
//
$highlight_match = $highlight = '';
if (isset($HTTP_GET_VARS['highlight']))
{
// Split words and phrases
$words = explode(' ', trim(htmlspecialchars($HTTP_GET_VARS['highlight'])));

for($i = 0; $i < sizeof($words); $i++)
{

Is there something else that you don't understand?

[faltered]

kodaks: Thank you for the reply. I have already done the viewtopic patch. But there are quite a few other files that have been changed.

I went to the phpBB website, downloaded the 2.0.11 changed files only pack, and unzipped it. I've read the instructions included in that zip file as well as the instructions on the phpBB website and cannot for the life of me figure out how to UPDATE my forum to 2.0.11 from 2.0.10.

I'm just interested in learning how to update my forum, that's all.

[benevolent001]

Hello faltered
Have you installed any mods?
or styles?

If not this is what you need to do

7.ii. Changed files only
This package contains a number of archives, each contains the files changed from a given release to 2.0.11. You should select the appropriate archive for your current version, e.g. if you currently have 2.0.10 you should select the phpBB-2.0.10_to_2.0.11.zip/tar.gz file.

The directory structure has been preserved enabling you (if you wish) to simply upload the contents of the archive to the appropriate location on your server, i.e. simply overwrite the existing files with the new versions. Do not forget that if you have installed any Mods these files will overwrite the originals possibly destroying them in the process. You will need to re-add Mods to any affected file before uploading.

As for the other upgrade procedures you should run install/update_to_210.php after you have finished updating the files. This will update your database schema and data (if appropriate) and increment the version number.

Just upload the files in corresponding directories and update the databse thats it...it will hardly take 10 minutes
hope this helps

[faltered]

Benevolent:

Ok, thanks. I can just upload the files to my directory that I downloaded? That sounds simple enough. I have installed a few mods/hacks and will have to tweek those before uploading.

And the last part-updating the database? How do I go about that part? Just upload the install/update_to_210.php file (or whatever it's called) into my directory? Or is it a tad more complicated than that?

Thanks so much.

[vkaryl]

faltered: DON'T just upload the changed files folders entire! You'll have to open each folder and upload only the FILES to the same folders on your server.... otherwise you'll overwrite the "real deal" folders with JUST the changed files, which will make your forum non-operational.

As to the update of the version: create on your server in the phpBB folder a folder named install. Upload the update_to_2011.php file (you'll have to extract the 2.010 to 2.011 file from the archive) to the install folder. Then input into a browser addy field [myforumaddress...] and it does it for you....

Alternatively, you can simply open the overall_footer.tpl file for each template you use, and either change the version number, or delete it as suggested by webwit in another post....

[faltered]

ahhhhh that makes much more sense! Thank you.

I hope to get it updated tonight.

[faltered]

vkaryl: I just completed the update. Thank you for your clear and direct instructions. They were exactly what I was looking for.

The update wasn't complicated at all, I was just having issues understanding the instructions. Thanks for the help!

[vkaryl]

Glad it went well, faltered!

[philbish]

What if we do have a zillion mods on the forum?

[benevolent001]

you will have 2 follow same insructions
but u might have reinstall the mod if the files which you have edited are changed in the new version

just have a look at the files in the folders

[faltered]

Phil: I just went through my mods and looked at which files I changed for those. Then went to see which files were changed for the update, and applied any mod to them. It didn't take much longer.

[buksida]

I find it easier to update the whole lot, ie backup all forum files and database, delete the forum folder, then upload the entire package. Trouble is, as said above, its starting to take longer and longer with the more mods I keep adding ...

[zollerwagner]

I'm trying to use the patch file to upgrade a heavily modded forum. I've got SSH/command line access, I've uploaded the patch file to /forumTEST, the directory that holds the forum.

The instructions say to type this:

patch -cl -d [PHPBB DIRECTORY] -p1 < [PATCH NAME]

Here's one command line I've tried:

patch -cl -d /home/MyUserName/public_html/forumTEST/ -p1 < phpBB-2.0.6_to_2.0.11.patch

I keep getting this message:

phpBB-2.0.6_to_2.0.11.patch: No such file or directory

I assume that this could be either my mistyping the file name, or using the wrong directory.

Do you see anything wrong? Thanks!

[vkaryl]

I also have SSH access. I have NEVER been able to get the patch file system to work. I tried a couple of years back getting help on the phpBB fora - the only thing I appeared to be doing wrong was putting a lower case letter l where there should have been a numeral 1. The font is hard to read sometimes. However, making that change still didn't fix the situation....

Don't know what to tell you zollerwagner - what you're doing looks exactly right to me, and is exactly what I was doing, and I never got anything other than the message you're getting. Sorry!

[zollerwagner]

Thanks for the response! Just a few minutes ago, my web host suggested the following method.

When you log into your shell type:

cd /home/MyUserName/public_html/forumTEST

Then type the patch line you have below

patch -cl -d /home/MyUserName/public_html/forumTEST -p1 < phpBB-2.0.6_to_2.0.11.patch

The .patch file resides in /home/MyUserName/public_html/forumTEST so you will need to be in that directory to access the file.

That worked, sort of.

Lots of hunks failed, especially the lines like:
* $Id: bbcode.php,v 1.36.2.32 2004/07/11 16:46:19 acydburn Exp $

I suppose it could have been worse....

[vkaryl]

Well, you got farther than I did at any rate!

For the "lots of hunks failed" situation, there's some info on the phpBB fora. I think it's mostly saying that you have to patch by hand, if you get tons of hunk failures.

[dontbee]

I have updated my phpbb to 2.0.11. But I am stuck on one thing, at least.

When I submit a link such as www.mydomain/phpbb/index.php, I get the following message :

DEBUG MODE

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('a76fcf3ba28053cbf6f50bca56c628a5', 2, 1103889164, 1103889164, '4610ac54', 0, 1)

Line : 158
File : D:\inetpub\mydomain\phpBB2\includes\sessions.php

Now there seems to be a fix for this. In another forum I found this replacement code for sessions.php file :

$error = TRUE;
if (SQL_LAYER == "mysql" ¦¦ SQL_LAYER == "mysql4")
{
$sql_error = $db->sql_error($result);
if ($sql_error["code"] == 1114)
{
$result = $db->sql_query('SHOW TABLE STATUS LIKE "'.SESSIONS_TABLE.'"');
$row = $db->sql_fetchrow($result);
if ($row["Type"] == "HEAP")
{
if ($row["Rows"] > 2500)
{
$delete_order = (SQL_LAYER=="mysql4")? " ORDER BY session_time ASC" : "";
$db->sql_query("DELETE QUICK FROM ".SESSIONS_TABLE."$delete_order LIMIT 50");
}
else
{
$db->sql_query("ALTER TABLE ".SESSIONS_TABLE." MAX_ROWS=".($row["Rows"]+50));
}
if ($db->sql_query($sql))
{
$error = FALSE;
}
}
}
}
if ($error)
{
message_die(CRITICAL_ERROR, "Error creating new session", "", __LINE__, __FILE__, $sql);
}

But I have an SQL 2000 db and the second line of the code in the fix refers to mysql. Can I try replacing this code with this text without risking any harm to my db?

Thanks and have a good holiday.

[zollerwagner]

Oh, boy.

Actually, I'm just finishing up debugging mine. I've never used that specific db, so I'm not sure, but I'd guess that you can't address it with mysql terms.

I'd try to use the same terms that are in your current file. Doesn't it have examples of how it addresses your db already? You could probably substitute that for the mysql lingo.

I'd bet that the php.net site has some references on this, too.

One thing I'm sometimes tempted to to do is just change things. Afterall, it will only take a second! I usually stop myself and make a backup of the current one first. That's saved my butt many times. I also usually do my changes in a test forum first just to be sure. Had I not done that this time, the forum would have been down for days.

Good luck!

[dontbee]

Thanks for the response. That site for the phpbb has been awful to get any response from. I ask politely enough. And there are tons of people online. Perhaps they just don't know.

I think if I can just empty the table, I may have a shot. Am working on that.
Thanks again.

[zollerwagner]

You're right about not getting any help at phpbb. Most of the help I've received has been from others who are struggling, too. It's odd. The folks here at WebMasterWorld are a lot more helpful.

If you can't find the code for your database, let me know. I may have some basic stuff in one of my books.

[dontbee]

My host has sent me the following.

<
PHP has released information showing issues with the latest version of PHP 4.3.10, mainly with MS SQL and Sessions. PHP has been working hard in releasing a newer production version of 4.3.10 with possible fixes to the above issues, which we are testing at this time.

PHP 4.3.10 was released to fix security vulnerabilities found in PHP 4.3.9 which is why we took an active stance in quickly upgrading our Network to the latest PHP 4.3.10, but PHP found shortly after, issues with MS SQL and Sessions.

As soon as PHP has a working / stable production version of PHP 4.3.10 released, we will work quickly to have it rolled out across our network.

We thank you for your patience and understanding while we work to resolve this issue as quickly as possible for you all.

>
Is there a way to transfer MS SQL tables to MySQL tables? My hosting plan gives me both.
Thanks.

[zollerwagner]

Yes, there is.

I searched google using:
change ms sql mysql
and got some decent answers.

I noticed that MSSQL-to-MySQL is a free download, but I've never had to do this, so I don't know how well it works.

[dontbee]

Thanks old buddy. Merry Christmas. You didn't happen to remember the link for the free download you had in mind? I did a search also, and there are tons of results. One requires Word and believe it or not, I don't have that.