upgrade from 3.1 to 3.3

[BF79]

Hello my friend
I just followed the instruction of

Make a backup of the original files

Make a backup of the database

Deactivate all styles except for prosilver

Deactivate any extensions which are not compatible with phpBB 3.3. Check with the extension author to find out if an extension is compatible or not.

Set British English as the only language pack

Download the phpBB 3.3 Full Package archive

Extract the contents of the archive to your computer and open the phpBB3 directory

Delete the following files from the package:

The config.php file

The images/ directory

The files/ directory

The store/ directory

On your website, delete all files from your board EXCEPT for:

The config.php file

The ext/ directory

The images/ directory

The files/ directory

The store/ directory
--------------------
at the end
I got error
You are running an unsupported PHP version (5.6.37). Please upgrade to PHP 7.2.0 or higher before trying to install or update to phpBB 3.3
I got support from admin server.. he upgraded the php to 7.2.xx
now I have this error
General Error
SQL ERROR [ mysqli ]

Unknown column 'user_last_active' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.



need help guys girls !!

[janus_zonstraal]

I got support from admin server.. he upgraded the php to 7.2.xx

Go to php8.x
7.2 is very old and not safe to use.

[BF79]

I got support from admin server.. he upgraded the php to 7.2.xx

Go to php8.x
7.2 is very old and not safe to use.

ok..I will do
but what about

General Error
SQL ERROR [ mysqli ]

Unknown column 'user_last_active' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

[janus_zonstraal]

Go to php8.x first and than update the database, maybe the error is gone at that time.

[BF79]

Go to php8.x first and than update the database, maybe the error is gone at that time.

can you tell me where or how to upgrade..

[Mick]

Upgrading from 3.1 to 3.3 or are you just wanting to upgrade the database?

If it’s just the database and you have up to date files upload the /install folder from the upgrade package then browse to it and run update database.

[BF79]

Upgrading from 3.1 to 3.3 or are you just wanting to upgrade the database?

If it’s just the database and you have up to date files upload the /install folder from the upgrade package then browse to it and run update database.

I upgraded my files..
now to install I have this msg

The installer detected a timeout
The installer has detected a timeout, you may try to refresh the page, which may lead to data corruption. We suggest that you either increase your timeout settings or try to use the CLI.

[thecoalman]

Look in your hosting control panel for anything related to php.ini, if it's cpanel find MultiPHP INI Editor. On the basic tab select the location and find the entry for max_execution_time and Increase it.

Restore your DB backup and after completing the update go back to hosting control panel and edit in the default max_execution_time. This should be low for normal operations, it's there for a reason.

If you don't have this in your hosting control panel consult hosts documentation or contact them.

[BF79]

I got support from server host admin.. and my forum is ok from 3.1 to 3.3
now I cleared cache..... and I wanted to upload backup.. when I click i got this msg

Code: Select all

General Error
SQL ERROR [ mysqli ]

Table './ftsiempr_bb318/phpbb_statistics_online' is marked as crashed and last (automatic?) repair failed [144]

SQL

SHOW CREATE TABLE phpbb_statistics_online

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 211
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/extractor/mysql_extractor.php
LINE: 190
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/extractor/mysql_extractor.php
LINE: 64
CALL: phpbb\db\extractor\mysql_extractor->new_write_table()

FILE: [ROOT]/includes/acp/acp_database.php
LINE: 90
CALL: phpbb\db\extractor\mysql_extractor->write_table()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_database->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

[warmweer]

I got support from server host admin.. and my forum is ok from 3.1 to 3.3
now I cleared cache..... and I wanted to upload backup.. when I click i got this msg

General Error
SQL ERROR [ mysqli ]

Table './ftsiempr_bb318/phpbb_statistics_online' is marked as crashed and last (automatic?) repair failed [144]

If your board was successfully upgraded from 3.1 to 3.3, then why would you restore a backup (either files or database)?

Also... where is that table phpbb_statistics_online coming from? It's not a default phpBB 3.1 nor 3.3 table.

[janus_zonstraal]

[ got support from server host admin.. and my forum is ok from 3.1 to 3.3
now I cleared cache..... and I wanted to upload backup.. when I click i got this msg/quote]
So your files are 3.3.12 and you want to restore your 3.1 database

[BF79]

no no .. I wanted just to save backup not restore

[BF79]

I got support from server host admin.. and my forum is ok from 3.1 to 3.3
now I cleared cache..... and I wanted to upload backup.. when I click i got this msg

General Error
SQL ERROR [ mysqli ]

Table './ftsiempr_bb318/phpbb_statistics_online' is marked as crashed and last (automatic?) repair failed [144]

Also... where is that table phpbb_statistics_online coming from? It's not a default phpBB 3.1 nor 3.3 table.

lol I dont know !!
maybe extension.. but I delete al ext

[warmweer]

Also... where is that table phpbb_statistics_online coming from? It's not a default phpBB 3.1 nor 3.3 table.

lol I dont know !!
maybe extension.. but I delete al ext

Did you disable and delete extension data before removing the files?
As mentioned in the 3.1 to 3.3 upgrade instructions:

5. Deactivate any extensions which are not compatible with phpBB 3.3. Check with the extension author to find out if an extension is compatible or not.

[BF79]

lol I dont know !!
maybe extension.. but I delete al ext

Did you disable and delete extension data before removing the files?
As mentioned in the 3.1 to 3.3 upgrade instructions:

5. Deactivate any extensions which are not compatible with phpBB 3.3. Check with the extension author to find out if an extension is compatible or not.

I just disable not deleted..
I just deleted data when I am now 3.3 and also remove totaly