From 2.0.21 to plus?

phpBB2.de User Anmeldungsdatum: 31.08.2005 Beiträge: 41

I don't know where to post this question, but is there not any way to convert a usually phpBB forum to plus?
I really want to upgrade to plus.
On my phpBB forum i have a lot of mods installed that plus uses also, but still, i can't import simply my users or postings.
there must be a way.
there are a lot of converters to phpBB, from nuke etc... but i don't understand why i can't find one to plus.
Does that mean that i really must start from fresh again?Or are there things i can adjust in any way to make this work?
Perhaps removing all of the mods i did install on the other one?
I hope there is a way that i don't have to do it all manually.
That means hours of work

Look into the plus package.
You will find a Readme-File with all needed instructions to update.

phpBB2.de User Anmeldungsdatum: 31.08.2005 Beiträge: 41

thats what i did yesterday.

and i did print this part before i started..

Upgrade from existing phpBB 2.0.XX
If you are already using Mods in your Forums that required Database Changes, you may have problems installing this version. The included Database Update tool only creates fresh tables for the Mods and does NOT update any existing MODs you are using to the latest version. So what does that mean ? If you are running a phpBB 2.0.8-2.0.21 with for example SmartorAlbum 2.0.42 or Lower you first have to update your Database to the Album v2.0.53 that is included in phpBB2 plus. Check the Mods List at the beginning of this readme file for information on the versions that are used in phpBB2 plus. If you have no Mods in your Forum that required Database Changes, then just ignore this and go on to step 2.
Backup all your Data ! All Files from your FTP and also your SQL Database ! Don't cry if something goes wrong and you have no Backup !
You will need the Data of the following directories later in the new Forum so please BACK them up NOW!! : images/avatars, images/smiles, files, images/avatars/gallery, images/ranks!!!
Unzip the phpBB2 plus zip file to a directory on your local hard disk.
Only upload the directory update/ to your existing phpBB2 Directory on the webserver, do NOT COPY THE OTHER FILES !!!!
Login to your Forum as Administrator
Using your web browser, open the index.php File you uploaded (http://your.forums.com/phpBB2/update/index.php) and run all available updates.
You should see additional tables are created or updated (Added/Updated)
Download the file config.php from your existing phpBB2 Forum and put it in a secure place (You need it later !)
If you used the attachment mod before, you should backup your /files directory now. Also backup the users avatar directory which is images/avatars to use them later again.
Did you Backup your old Data already? If not, now it's the last chance to do it !
Delete all Files from your old forums now. If you have your own templates, images, or graphics, then back them up as well)
Copy all Files from the phpBB2 directory of the phpBB2 plus 1.53 package to your Webserver (including directory structure)
Copy all ranks from your old images/ranks up to templates/fisubsilversh/images/lang_***/ranks. Do this for all installed templates and languages as well.
Copy the file config.php that you backed up before to your phpBB2 Dir on the Webserver overwriting the existing one)
Delete or rename the directory /install
Change the ermissions for the directories and the files like "File- and directorypermissons on *NIX-Server"
Upload the "old" avatars and maybe files directory to your new Forum
Use the new Forum Wink

And for the following part, everything went ok

I did upgrade ct tracker, attachements, and some other.
but when i went to my phpmy admin, i still had 64 tables, and the additional tables were missing.
so, i figured out myself, i had to do also in the updates folder this one: update_phpbb_20xx_to_plus_153.php

and there is where it goes wrong!
( i did the chmod settings allright)

I had this errormessage.

phpBB : Critical Error

Could not query Plus-Config information

DEBUG MODE

SQL Error : 1146 Table 'hedima2006_nl_db.phpbb_plus' doesn't exist

SELECT * FROM phpbb_plus

Line : 281
File : common.php

now what? i'm stuck with it. Perhaps i'm overlooking something silly. I really hope so, because i don't know what to do next.
when i used google, all i found is this..

http://www.phpbb2.de/archive/o_t__t_36367__upgrade-von-2.019-auf-plus-1.53.html

in what i did understand i read that i must use that common file instead of the normal plus common file, in the process

all i did get was problems and errors

there is an answer that the update file must be run, and that whats was forgotten. But that person, and also me, have done that part allready, but the errormessage is still there.
there is no way, i still can get in the board. Crying or Very sad

all i get was these errormessages:

SQL Error : 1054 Unknown column 'user_lastlogon' in 'field list'
SQL Error : 1054 Unknown column 'user_totalpages' in 'field list'

then i found this topic, becaus i do get the errormessages in users table.

a sortlike problem
http://www.phpbb2.de/ftopic13863.html

When that person in that specifical thread did ask ,what to do then? Nobody did answer.
It's very frustrating, that i don't find any answer that did help me out.

Sorry,but with all my searches, it brought my anywhere.
I have a backup from that board,but is there anyone that can help me out, to upgrade properly?
and i have my questions about the mods that a person has insrtalled before on his board before an upgrade.
OK, that mods will not work anymore afterwards. but indeed, that must bring some errormessages from tables, or files that do not match anymore, in the step before you have to empty your ftp to upload your plus files.
Isn't there a mod that makes from your phpBB a clean forum that deletes all the mods, before upgrading?

As this is the only supportforum phpBBplus has, i really hope someone that did make that upgrade from a modded board can guide me through this.

I don't get it only reading the update files from the packagge.
do i have to use this file update_phpbb_20xx_to_plus_153 ... at the end or not?
(i did do that and it gave me nothing)

I know that i have to do update ct tracker and update update_phpbb_20xx_to_plus_153

but what's next ?
I'm aware that the deutch part of this supportforum is much bigger then the english part, but i really don't understand the written language, only a couple of words.
Please, i'm working since a long time with phpBB, but upgrading, i did not do that before in that sence of the word. From phpBB to plus.
and i just don't want to make the same mistakes again, after uploading my tables in phpmyadmin, and uploading my phpBB 2.0.21 again, knowing i will make the same mistakes again.

Run these sql statements with phpmyadmin to fix the missing table and field:

Code:

CREATE TABLE phpbb_plus (
config_name varchar(255) NOT NULL default "",
config_value varchar(255) NOT NULL default "",
PRIMARY KEY (config_name)
);
INSERT INTO phpbb_plus VALUES ("show_quickreply", "1");
INSERT INTO phpbb_plus VALUES ("show_links", "1");
INSERT INTO phpbb_plus VALUES ("index_layout", "index_body_plus.tpl");
INSERT INTO phpbb_plus VALUES ("default_avatar", "0");
INSERT INTO phpbb_plus VALUES ("show_shoutbox", "1");
INSERT INTO phpbb_plus VALUES ("plus_version", "1.5.3a");
INSERT INTO phpbb_plus VALUES ("cols_per_page", "4");
INSERT INTO phpbb_plus VALUES ("show_last_visit", "1");
INSERT INTO phpbb_plus VALUES ("contact_email", "webmaster@yourdomain");
INSERT INTO phpbb_plus VALUES ("enable_shorturls", "0");
INSERT INTO phpbb_plus VALUES ("disable_sid", "0");
INSERT INTO phpbb_plus VALUES ("enable_antirobot", "1");

ALTER TABLE phpbb_users ADD user_lastlogon INT (11) DEFAULT "0" not null;

phpBB2.de User Anmeldungsdatum: 31.08.2005 Beiträge: 41

Sorry, i was editing in the meanwhile.
I was so sick of it this night, that i did stop my post, end i kept it as a txt file.
Now, a day after it isn't that easy to remember in what order the errors came. the first was the plus table that was missing,and the rest came afterwards.
i will try the thing all over again. if someone recognise the errors that came, and has a solution, please, be my guest to post them. i really would appreciate it, and also a lot of other users who try the upgrade, and are stuck in the middle.

Do you have not execute my posted SQL Statements and will you get again several errors?

phpBB2.de User Anmeldungsdatum: 31.08.2005 Beiträge: 41

i'm beginning all over again.
CT tracker update, ok,
version 2.0.21, ok

but there is no update file for attachements in the update folder.
i have the right version installed, but i think i have to update again.

there is no file however update_attach_to_latest.php .
does that mean, that this will not be processed then in my installation?
i have only the file in my zip file from attachements mod update_to_latest.php

when i process this one, it doesn't work off course.

where do i find the file that i need?

i don't think i will find it on the board from the author.

phpBB2.de User Anmeldungsdatum: 31.08.2005 Beiträge: 41

ok, i did find it in an older installation file from plus.
the 3 updates did work well.
I hope i have to run update_phpbb_20xx_to_plus_153.php now.
If not, i'm in problems.

phpBB2.de User Anmeldungsdatum: 31.08.2005 Beiträge: 41

Jeezes, it dit work very well. the board is fine, and there were many mods that i did already, before the upgrade.
there is just one problem. If you can call it a problem; It says i'm runnung 2.0.20, and not 2.0.21.

and before it said, that the version was right.
do i have to runn tha update to the latest file or not?
I did not had 1 error this time in upgrading.
I really did take my time this time

I left my arcade files where they were, on ftp. I will first have to install 2.1.2 . again.

phpBB2.de User Anmeldungsdatum: 11.02.2007 Beiträge: 1

Manuel666 hat folgendes geschrieben:

Jeezes, it dit work very well. the board is fine, and there were many mods that i did already, before the upgrade.
there is just one problem. If you can call it a problem; It says i'm runnung 2.0.20, and not 2.0.21.

and before it said, that the version was right.
do i have to runn tha update to the latest file or not?
I did not had 1 error this time in upgrading.
I really did take my time this time

I left my arcade files where they were, on ftp. I will first have to install 2.1.2 . again.

Hi,
I have the same problem and couldnt find the solution. Can you inform us more detailed how you fix the problem.

Best Regards

phpBB2.de User Anmeldungsdatum: 31.08.2005 Beiträge: 41

Where exactly does it goes wrong in your case?
( i can try to help, but it's almost 7 months since i did the upgrade.i had the advantage that i had EZ portal installed before, so i had a lot of mods already that plus uses also.)

Did you make a backup of your sql tables and the files on your ftp(all files from your old phpBB forum)?
Before you start upgrading, you must be sure that you are logged in as an administrator.
You set a default style in the admin panel, also for the users. This is important while you are upgrading that everyone is set with one style.
You can uninstall the other styles first when you have more styles installed

Unzip the phpBB2 plus zip file to a directory on your local hard disk.
Only upload the directory update/ to your existing phpBB2 Directory on the webserver, do NOT COPY THE OTHER FILES !!!!
It's very important that you do not delete everything before you did the updates in your /update folder.
Using your web browser, open the index.php File you uploaded (http://your.forums.com/phpBB2/update/index.php) and run all available updates or you do them manually in your webbrowser.

As i remember it installs the tables from the category hierarchy mod first,i'm not sure
http://your.forums.com/phpBB2/update/hierarchy_db_migrate.php
http://your.forums.com/phpBB2/update/update_attach_to_latest.php
http://your.forums.com/phpBB2/update/update_ct_to_latest.php
...

You should see additional tables are created or updated (Added/Updated)

If the update_attach_to_latest.php . isn't in the update folder, you can paste this one in a txt document, and rename it afterwards to .php instead.

Code:

<?php
/**
*
* @package attachment_mod
* @version $Id: update_to_latest.php,v 1.4 2005/12/14 13:34:06 acydburn Exp $
* @copyright (c) 2002 Meik Sievertsen
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*/
define('IN_LOGIN', true);
define('IN_PHPBB', true);
define('ATTACH_INSTALL', true);

$phpbb_root_path = './../';
include($phpbb_root_path.'extension.inc');
include($phpbb_root_path.'common.'.$phpEx);
include($phpbb_root_path.'includes/sql_parse.'.$phpEx);

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);

// Check DB Type
if (!isset($dbms) || $dbms == 'oracle' || $dbms == 'msaccess')
{
message_die(GENERAL_MESSAGE, 'This Mod does not support Oracle or MSAccess.');
}

if (!defined('ATTACH_CONFIG_TABLE'))
{
if (file_exists($phpbb_root_path . 'attach_mod/attachment_mod.'.$phpEx))
{
   include_once($phpbb_root_path . 'attach_mod/attachment_mod.'.$phpEx);
}
else
{
   message_die(GENERAL_MESSAGE, 'Please upload the attachment mod files before upgrading your installation.');
}
}

$attach_version = '';

$sql = 'SELECT config_value
FROM ' . ATTACH_CONFIG_TABLE . "
WHERE config_name = 'attach_version'";
$result = $db->sql_query($sql);

if ($result)
{
if ($db->sql_numrows($result) > 0)
{
   $row = $db->sql_fetchrow($result);
   $attach_version = trim($row['config_value']);
}
}
$db->sql_freeresult($result);

if ($attach_version == '')
{
$attach_version = ATTACH_VERSION;
$attach_version = trim($attach_version);
}

$version_fields = array();
$version_fields = explode('.', $attach_version);

if ((strpos($attach_version, '2.3.') === false && strpos($attach_version, '2.4.') === false) && !isset($HTTP_GET_VARS['force']))
{
message_die(GENERAL_MESSAGE, 'Wrong Attachment Version detected.<br />Please update your Attachment Mod (V' . $attach_version . ') to at least Version 2.2.1 before you update to the latest version.<br /><br />If you want to force the update (at your own risk), please add ?force=1 to the url.');
}

if (!function_exists('attach_mod_sql_escape'))
{
/**
* Escaping SQL
*/
function attach_mod_sql_escape($text)
{
   switch (SQL_LAYER)
   {
      case 'mysql':
      case 'mysql4':
         if (function_exists('mysql_escape_string'))
         {
            return mysql_escape_string($text);
         }
         else
         {
            return str_replace("'", "''", str_replace('\\', '\\\\', $text));
         }
      break;

      default:
         return str_replace("'", "''", str_replace('\\', '\\\\', $text));
      break;
   }
}
}

$available_dbms = array(
"mysql" => array(
   "SCHEMA" => "attach_mysql",
   "DELIM" => ";",
   "DELIM_BASIC" => ";",
   "COMMENTS" => "remove_remarks"
),
"mysql4" => array(
   "SCHEMA" => "attach_mysql",
   "DELIM" => ";",
   "DELIM_BASIC" => ";",
   "COMMENTS" => "remove_remarks"
),
);

$dbms_schema = 'schemas/' . $available_dbms[$dbms]['SCHEMA'] . '_schema.sql';
$dbms_basic = 'schemas/' . $available_dbms[$dbms]['SCHEMA'] . '_basic.sql';

$remove_remarks = $available_dbms[$dbms]['COMMENTS'];;
$delimiter = $available_dbms[$dbms]['DELIM'];
$delimiter_basic = $available_dbms[$dbms]['DELIM_BASIC'];

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);

//
// BEGIN Functions

/**
* Insert a 'new' value into the Attachment Configuration Table
*/
function insert_into_config($new_name, $default = 0)
{
global $db, $dbms;

$new_config_table = ATTACH_CONFIG_TABLE;

$sql = "SELECT config_name FROM " . $new_config_table . " WHERE config_name='" . attach_mod_sql_escape($new_name) . "'";
$result = $db->sql_query($sql);

if (!$result)
{
   return false;
}

if ($db->sql_numrows($result) != 0)
{
   $db->sql_freeresult($result);
   return false;
}
$db->sql_freeresult($result);

// Write new config variable
if ($dbms == 'mysql' || $dbms == 'mysql4')
{
   $sql = "INSERT INTO " . $new_config_table . " (config_name, config_value) VALUES ('" . attach_mod_sql_escape($new_name) . "', '" . attach_mod_sql_escape($default) . "');";
}

evaluate_statement($sql);

return true;
}

/*
* Check if table exist
*/
function table_exist($table)
{
global $db, $table_prefix;

$sql = "SELECT * FROM " . $table;
$sql = preg_replace('/phpbb_/', $table_prefix, $sql);

$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);

if ($result && $row)
{
   return true;
}
else
{
   return false;
}
}

/**
* Check if a given row is present in table $table
*/
function row_in_schema($table, $key)
{
global $db, $table_prefix;

$sql = "SELECT " . $key . " FROM " . $table;
$sql = preg_replace('/phpbb_/', $table_prefix, $sql);

$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);

if ($result && $row)
{
   return true;
}
else
{
   return false;
}
}

/**
* Run a complete SQL-Statement, this can be a array
*/
function evaluate_statement($sql_query, $hide = FALSE, $replace = FALSE, $hide_query = false)
{
global $table_prefix, $remove_remarks, $delimiter, $db;

$errored = FALSE;
if ($replace)
{
   $sql_query = preg_replace('/phpbb_/', $table_prefix, $sql_query);
}

$sql_query = $remove_remarks($sql_query);
$sql_query = split_sql_file($sql_query, $delimiter);

$sql_count = sizeof($sql_query);

for ($i = 0; $i < $sql_count; $i++)
{
   if (!$hide && !$hide_query)
   {
      echo "Running :: " . $sql_query[$i];
   }
   flush();

   $result = $db->sql_query($sql_query[$i]);

   if (!$result)
   {
      $errored = true;
      $error = $db->sql_error();
      if (!$hide)
      {
         echo " -> <b>FAILED</b> ---> <u>" . $error['message'] . "</u><br /><br />\n\n";
      }
   }
   else
   {
      if (!$hide)
      {
         echo " -> <b><span class=\"ok\">COMPLETED</span></b><br /><br />\n\n";
      }
   }
}

if ($errored)
{
   return false;
}
else
{
   return $result;
}
}

/**
* Fill new quota tables
*/
function fill_new_quota_table_data($dbms)
{
$data = '';

if ($dbms == 'mysql' || $dbms == 'mysql4')
{
   $data = '
CREATE TABLE phpbb_quota_limits (
quota_limit_id mediumint(8) unsigned NOT NULL auto_increment,
quota_desc varchar(20) NOT NULL default \'\',
quota_limit bigint(20) unsigned NOT NULL default \'0\',
PRIMARY KEY (quota_limit_id)
);

CREATE TABLE phpbb_attach_quota (
user_id mediumint(8) unsigned NOT NULL default \'0\',
group_id mediumint(8) unsigned NOT NULL default \'0\',
quota_type smallint(2) NOT NULL default \'0\',
quota_limit_id mediumint(8) unsigned NOT NULL default \'0\',
KEY quota_type (quota_type)
);

INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (1, \'Low\', 262144);
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (2, \'Medium\', 2097152);
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (3, \'High\', 5242880);

';
}

return $data;
}

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $lang['ENCODING']; ?>">
<meta http-equiv="Content-Style-Type" content="text/css">
<title><?php echo $lang['Welcome_install'];?></title>
<link rel="stylesheet" href="./fissh/fisubsilversh.css" type="text/css">
<style type="text/css">
</style>
</head>
<body bgcolor="#E5E5E5" text="#000000" link="#006699" vlink="#5584AA">
<table class="topbkg" width="100%" cellspacing="0" cellpadding="0" border="0">
<tr>
   <td><img src="./fissh/phpbb2_logo.jpg" border="0" width="240" height="110" /></td>
   <td><span class="maintitle">Updating from Attachment Mod Version <?php echo $attach_version; ?> to latest Release</span></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="10" align="center">
<tr>
   <td class="bodyline" width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="0">

      <tr>
         <td><br /><br /></td>
      </tr>
      <tr>
         <td colspan="2">
         <table width="90%" border="0" align="center" cellspacing="0" cellpadding="0">
            <tr>
               <td><br clear="all" />

<?php

/**
* Add new fields to the config table
*/

echo "<br /><h2>Add new fields to the config table...</h2><br /><br />";
insert_into_config('display_order', '0');
insert_into_config('img_imagick', '');
insert_into_config('show_apcp', '0');
insert_into_config('attach_version', '2.4.1');
insert_into_config('default_upload_quota', '0');
insert_into_config('default_pm_quota', '0');
insert_into_config('ftp_pasv_mode', '1');
insert_into_config('use_gd2', '0');

$sql = "UPDATE phpbb_attachments_config SET config_value = '2.4.1' WHERE config_name = 'attach_version';";
$result = evaluate_statement($sql, true, true);

if ($dbms == 'mysql' || $dbms == 'mysql4')
{
$sql = "SHOW INDEX FROM phpbb_attachments_desc;";
$result = evaluate_statement($sql, true, true);

$filetime_bool = false;
$physical_filename_bool = false;
$filesize_bool = false;

if ($result)
{
   $rows = $db->sql_fetchrowset($result);

   for ($i = 0; $i < sizeof($rows); $i++)
   {
      if (trim($rows[$i]['Key_name']) == 'filetime')
      {
         $filetime_bool = true;
      }

      if (trim($rows[$i]['Key_name']) == 'physical_filename')
      {
         $physical_filename_bool = true;
      }

      if (trim($rows[$i]['Key_name']) == 'filesize')
      {
         $filesize_bool = true;
      }
   }
}

if (!$filetime_bool)
{
   echo "<br /><h2>Add new INDEX to the Attachments Description Table...</h2><br /><br />";
   evaluate_statement("ALTER TABLE phpbb_attachments_desc ADD INDEX (filetime);", false, true);
}

if (!$physical_filename_bool)
{
   echo "<br /><h2>Add new INDEX to the Attachments Description Table...</h2><br /><br />";
   evaluate_statement("ALTER TABLE phpbb_attachments_desc ADD INDEX (physical_filename(10));", false, true);
}

if (!$filesize_bool)
{
   echo "<br /><h2>Add new INDEX to the Attachments Description Table...</h2><br /><br />";
   evaluate_statement("ALTER TABLE phpbb_attachments_desc ADD INDEX (filesize);", false, true);
}
}

if ($dbms == 'mysql' || $dbms == 'mysql4')
{
// Add INDEX to attachments table
$sql = "SHOW INDEX FROM phpbb_attachments;";
$result = evaluate_statement($sql, true, true);

$post_id_bool = false;
$privmsgs_id_bool = false;

if ($result)
{
   $rows = $db->sql_fetchrowset($result);
   $db->sql_freeresult($result);

   for ($i = 0; $i < sizeof($rows); $i++)
   {
      if (trim($rows[$i]['Key_name']) == 'post_id')
      {
         $post_id_bool = true;
      }

      if (trim($rows[$i]['Key_name']) == 'privmsgs_id')
      {
         $privmsgs_id_bool = true;
      }

   }
}

if (!$post_id_bool)
{
   echo "<br /><h2>Add new INDEX to the Attachments Table...</h2><br /><br />";
   evaluate_statement("ALTER TABLE phpbb_attachments ADD INDEX (post_id);", false, true);
}

if (!$privmsgs_id_bool)
{
   echo "<br /><h2>Add new INDEX to the Attachments Table...</h2><br /><br />";
   evaluate_statement("ALTER TABLE phpbb_attachments ADD INDEX (privmsgs_id);", false, true);
}
}

if (!row_in_schema('phpbb_extension_groups', 'forum_permissions'))
{
if ($dbms == 'mysql' || $dbms == 'mysql4')
{
   echo "<br /><h2>Add new row to the Extension Groups Table...</h2><br /><br />";
   $sql_query = "ALTER TABLE phpbb_extension_groups ADD forum_permissions VARCHAR(255) DEFAULT '' NOT NULL;";
}

evaluate_statement($sql_query, false, true);
}

if (!table_exist('phpbb_quota_limits'))
{
// Add two new Tables and the basic data for them
echo "<br /><h2>Add Quota Tables...</h2><br /><br />";
$sql_query = fill_new_quota_table_data($dbms);
evaluate_statement($sql_query, false, true);
}

// Check if we updated the table contents for the >2.4.x basic data yet...
$basic_data_updated = false;

$sql = 'SELECT config_value
FROM ' . ATTACH_CONFIG_TABLE . "
WHERE config_name = 'basic_data_updated'";
$result = $db->sql_query($sql);

if ($result)
{
if ($db->sql_numrows($result) > 0)
{
   $row = $db->sql_fetchrow($result);
   $basic_data_updated = (int) $row['config_value'];

   // Remove the config value because it is set to 0 (we will re-add it later)
   if (!$basic_data_updated)
   {
      $db->sql_query('DELETE FROM ' . ATTACH_CONFIG_TABLE . " WHERE config_name = 'basic_data_updated'");
   }
}
}
$db->sql_freeresult($result);

// Update basic data
if (!$basic_data_updated)
{
insert_into_config('basic_data_updated', 0);

echo "<br /><h2>Change attachment data to new format (this can take a bit, please do not stop this script)</h2><br /><br />";

$sql = 'SELECT attach_id, real_filename, comment
   FROM ' . ATTACHMENTS_DESC_TABLE . '
   ORDER BY attach_id ASC';
$result = $db->sql_query($sql);

if ($result)
{
   $num_rows = $db->sql_numrows($result);
   $i = 1;

   while ($row = $db->sql_fetchrow($result))
   {
      echo "Updating attachment number $i/$num_rows [id:{$row['attach_id']}] ";

      $sql = 'UPDATE ' . ATTACHMENTS_DESC_TABLE . " SET
         real_filename = '" . attach_mod_sql_escape(htmlspecialchars(stripslashes($row['real_filename']))) . "',
         comment = '" . attach_mod_sql_escape(htmlspecialchars(stripslashes($row['comment']))) . "'
         WHERE attach_id = " . $row['attach_id'];
      $res = $db->sql_query($sql);

      if (!$res)
      {
         $errored = true;
         $error = $db->sql_error();
         echo " -> <b>FAILED</b> ---> <u>" . $error['message'] . "</u><br />\n";
      }
      else
      {
         echo " -> <b><span class=\"ok\">COMPLETED</span></b><br />\n";
      }

      $i++;
   }
   $db->sql_freeresult($result);
}

$sql = "UPDATE phpbb_attachments_config SET config_value = '1' WHERE config_name = 'basic_data_updated';";
$result = evaluate_statement($sql, true, true);
}

/*
if ($attach_version != '2.3.7')
{
if ( ($dbms == "mysql") || ($dbms == "mysql4") )
{
   $sql_query = "ALTER TABLE phpbb_quota_limits CHANGE quota_limit quota_limit bigint(20) UNSIGNED DEFAULT '0' NOT NULL;";
   evaluate_statement($sql_query, FALSE, TRUE);
}
else if ( ($dbms == "mssql") || ($dbms == "mssql-odbc") )
{
   echo "CANT CHANGE MSSQL-TABLE. PLEASE DO THE FOLLOWING MANUALLY:<br />IN PHPBB_QUOTA_LIMITS, CHANGE QUOTA_LIMIT TO FROM INT TO BIGINT.<br />";
}
}
*/

$cache_dir = $phpbb_root_path . '/cache';
$cache_file = $cache_dir . '/attach_config.php';

if (@file_exists($cache_dir) && is_dir($cache_dir) && is_writable($cache_dir))
{
if (@file_exists($cache_file))
{
   @unlink($cache_file);
}
}

echo "<br /><br /><b>Finished... now remove the install and contrib directories.</b><br /><br />";

?>
               </td>
            </tr>
         </table>
         </td>
      </tr>
      <tr>
         <td><br /><br /></td>
      </tr>
   </table></td>
</tr>
</table>

</body>
</html>

You put it in the update folder, and chmod it right.

The last part are the files:
update_phpbb_20xx_to_plus_153.php
update_153_to_latest.php
(I think plus comes with phpBB 2.0.21) you also must do the update_to_the_latest.php file

You can login on your phpmyadmin to look if the tables are actually made)

when everething went fine, you can delete the update and install folder

I think when you come across problems like i had you will have to go to phpmyadmin, and do that missing table manually like oxpus posted.

You will need the Data of the following directories later in the new Forum so please BACK them up NOW!! : images/avatars, images/smiles, files, images/avatars/gallery, images/ranks!!!

Copy all Files from the phpBB2 directory of the phpBB2 plus 1.53 package to your Webserver (including directory structure)
Copy all ranks from your old images/ranks up to templates/fisubsilversh/images/lang_***/ranks. Do this for all installed templates and languages as well.

remeber that you need your original config.php file, so it's best to delete the one that is in the unzipped folder from your extracted zip file first.

phpBB2.de User Anmeldungsdatum: 31.08.2005 Beiträge: 41

You can keep me posted how your upgrade goes. but be sure you take the time to do it. This is not something that you do in a couple of minutes.
After i did it one time, i did it 4 times on my other boards without any problems.
but i had all my tables backupped, and a good one from my webserver /phpBB directory.
I could always put the old ones back in case it didn't work
good luck

don't forget to chmod everything right afterwards

Code:

#################################
#CHMOD to 777
#######
/album_mod/upload
/album_mod/upload/cache
/cache
/files
/files/thumbs
/images/avatars
/pafiledb/cache
/pafiledb/cache/templates
/pafiledb/images/screenshots
/pafiledb/uploads

#################################
#CHMOD to 666
#######
/includes/def_icons.php
/includes/def_themes.php
/includes/def_tree.php
/includes/def_words.php
/ctracker/logs/counter.txt
/ctracker/logs/logfile_flood.txt
/ctracker/logs/logfile_proxy.txt
/ctracker/logs/logfile_worms.txt

And to upgrade Ct Tracker, and phpBB to the latest version
http://www.phpbb2.de/dload.php?action=file&file_id=833