Wrong version in ACP after i tried to upgrade from 3.0.12 to 3.1.9

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Ideas Centre
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Buu
Registered User
Posts: 105
Joined: Wed Oct 16, 2013 5:50 pm

Re: Wrong version in ACP after i tried to upgrade from 3.0.12 to 3.1.9

Post by Buu »

anyone?
Buu
Registered User
Posts: 105
Joined: Wed Oct 16, 2013 5:50 pm

Re: Wrong version in ACP after i tried to upgrade from 3.0.12 to 3.1.9

Post by Buu »

ok, someone to help me here please?
Buu
Registered User
Posts: 105
Joined: Wed Oct 16, 2013 5:50 pm

Re: Wrong version in ACP after i tried to upgrade from 3.0.12 to 3.1.9

Post by Buu »

reminder!
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Wrong version in ACP after i tried to upgrade from 3.0.12 to 3.1.9

Post by Lumpy Burgertushie »

ok, I see that you have gone back to 3.0.12

if you want to upgrade follow this exactly and in order:
Upgrading from phpbb 3.0.x to phpbb 3.1.x
  • Your server must be running at least PHP 5.3.3 and less than PHP 7
  • Most MODs for 3.0.x are incompatible with 3.1.x and their functionality will be removed in the update process.
  • Styles for 3.0.x cannot be installed or used on 3.1.x.
  1. Backup up your board's files and database
  2. Download the Support Toolkit. Install it and run the database cleaner to remove all old MODs from the database.
  3. Deactivate all styles except for prosilver
  4. Ensure that the activated spambot countermeasure is one of the standard phpBB plugins (Simple image, GD image, GD 3D image, Q&A, reCaptacha).
  5. Set British English as the only language pack
  6. Delete all of your phpBB 3.0.x files EXCEPT for the following:
    • The config.php file
    • The /images/ directory
    • The /files/ directory
  7. Upload the contents of the phpBB3 directory from the uncompressed 3.1.x Full Package (EXCEPT for config.php) into your forum's directory (Note: you don't want to overwrite your original config.php file)
  8. Browse to yourdomain.com/yourphpbb/install/database_update.php and keep clicking the continue button until it says it is finished. This will take a long time on a large board, maybe hours. Dont give up.
  9. Delete the folder named /install/
  10. Hold one foot in the air and spin around in a circle three times saying "I am a phpbb guru".
be sure that when you delete the old files that the cache folder is completely deleted.

right now, you have permissions on your server directories set so that I can not access any of the phpbb folders directly. when trying to access http://www.snowrippers.ro/styles/prosilver/ I get a 403 error. etc.


robert
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
Buu
Registered User
Posts: 105
Joined: Wed Oct 16, 2013 5:50 pm

Re: Wrong version in ACP after i tried to upgrade from 3.0.12 to 3.1.9

Post by Buu »

Hi,
After i intalled the stk and run the database cleaner, this error come
LE: After database clean, this error appear when i try to acces the forum ...

Code: Select all

General Error
SQL ERROR [ mysqli ]

Table 'snowripp_phpbb.phpbb_ads_in_positions' doesn't exist [1146]

SQL

SELECT ad_id, position_id, ad_priority FROM phpbb_ads_in_positions WHERE ad_enabled = 1 ORDER BY ad_priority DESC

BACKTRACE

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

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 189
CALL: dbal->sql_error()

FILE: [ROOT]/ads/functions.php
LINE: 157
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/ads/functions.php
LINE: 61
CALL: get_ads()

FILE: [ROOT]/includes/functions.php
LINE: 4606
CALL: setup_ads()

FILE: [ROOT]/stk/includes/database_cleaner/database_cleaner_views.php
LINE: 169
CALL: page_header()

FILE: [ROOT]/stk/tools/support/database_cleaner.php
LINE: 158
CALL: database_cleaner_views->display()

FILE: [ROOT]/stk/index.php
LINE: 293
CALL: database_cleaner->display_options()
sceptre
Registered User
Posts: 134
Joined: Mon Feb 22, 2010 5:01 pm
Location: Alba

Re: Wrong version in ACP after i tried to upgrade from 3.0.12 to 3.1.9

Post by sceptre »

That error is because you've put the modded 3.0.12 files back in and the stk has removed the relevent table from the DB .
Options : replace with clean 3.0.12 files or try the 3.1.9 update again

Mind not to overwrite the config file etc.
Buu
Registered User
Posts: 105
Joined: Wed Oct 16, 2013 5:50 pm

Re: Wrong version in ACP after i tried to upgrade from 3.0.12 to 3.1.9

Post by Buu »

tried to update to 3.1.9, run the update data base, this error appear

Code: Select all

SQL ERROR [ mysqli ]

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

SQL

INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_profile, field_hide, field_no_view, field_active, field_order) VALUES ('phpbb_interests', 'profilefields.type.text', 'phpbb_interests', '3|30', '2', '500', '', '', '.*', 0, 0, 0, 0, 0, 1, 0, 0, 1, 2)

BACKTRACE

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

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

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

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

FILE: [ROOT]/phpbb/db/migration/profilefield_base_migration.php
LINE: 98
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\migration\profilefield_base_migration->create_custom_field()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 550
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 496
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 322
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 202
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 185
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/install/database_update.php
LINE: 205
CALL: phpbb\db\migrator->update()
UPDATE:
Now it works, but i can`t acces the MCP or the ACP.

Code: Select all

General Error
Cannot find module ./../includes/acp/main.php

BACKTRACE

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

FILE: [ROOT]/includes/functions_module.php
LINE: 571
CALL: trigger_error()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Buu
Registered User
Posts: 105
Joined: Wed Oct 16, 2013 5:50 pm

Re: Wrong version in ACP after i tried to upgrade from 3.0.12 to 3.1.9

Post by Buu »

sceptre wrote:That error is because you've put the modded 3.0.12 files back in and the stk has removed the relevent table from the DB .
Options : replace with clean 3.0.12 files or try the 3.1.9 update again

Mind not to overwrite the config file etc.
This solved the case.
Thanks!
Locked

Return to “[3.1.x] Support Forum”