Re: Problem upgrade 3.2.4 3.3.0

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
intruder-pr
Registered User
Posts: 8
Joined: Thu Oct 25, 2018 1:14 pm

Re: Problem upgrade 3.2.4 3.3.0

Post by intruder-pr »

After updating 2 problems 1 appeared when trying to ban a user by ACP

Erro Geral
SQL ERROR [ mysqli ]

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

SQL

INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_type, forum_id, topic_id, post_id, log_data) VALUES ('104487', '179.181.166.232', 1580837964, 'LOG_BAN_USER', 1, 0, 0, 0, 'a:2:{i:0;s:56:\"Nome de usuário banido pelo gerenciamento de usuários.\";i:1;s:12:\"Loitzenbauer\";}')

BACKTRACE

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

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

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

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

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

FILE: [ROOT]/includes/functions_user.php
LINE: 1321
CALL: phpbb\log\log->add()

FILE: [ROOT]/includes/acp/acp_users.php
LINE: 331
CALL: user_ban()

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

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






2 ao tentar acessar a aba permissoes na ACP
Fatal error: Uncaught phpbb\language\exception\language_file_not_found: Language file ./../language/en/language/pt_br/acp/permissions_phpbb.php couldn't be opened. in /home/flyfi697/public_html/forumn/phpbb/language/language_file_loader.php:186 Stack trace: #0 /home/flyfi697/public_html/forumn/phpbb/language/language_file_loader.php(143): phpbb\language\language_file_loader->get_language_file_path('./../language/', 'language/pt_br/...', Array) #1 /home/flyfi697/public_html/forumn/phpbb/language/language_file_loader.php(77): phpbb\language\language_file_loader->load_file('./../language/', 'language/pt_br/...', Array, Array) #2 /home/flyfi697/public_html/forumn/phpbb/language/language.php(625): phpbb\language\language_file_loader->load('language/brazil...', Array, Array) #3 /home/flyfi697/public_html/forumn/phpbb/language/language.php(184): phpbb\language\language->load_core_file('language/brazil...') #4 /home/flyfi697/public_html/forumn/phpbb/user.php(574): phpbb\language\language->add_lang('language/brazil...', NULL) #5 / in /home/flyfi697/public_html/forumn/phpbb/language/language_file_loader.php on line 186

User avatar
warmweer
Jr. Extension Validator
Posts: 3903
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Problem upgrade 3.2.4 3.3.0

Post by warmweer »

intruder-pr wrote:
Tue Feb 04, 2020 5:53 pm
After updating 2 problems 1 appeared when trying to ban a user by ACP

Problem 2
2 ao tentar acessar a aba permissoes na ACP
Fatal error: Uncaught phpbb\language\exception\language_file_not_found: Language file ./../language/en/language/pt_br
Your Portuguese language files are not uploaded to the correct folder
you should have
...language/en
...language/pt_br
Make sure the Portuguese language pack is for 3.3.0, if not, either use British English only or edit the Portuguese language pack (compare with the British English for missing entries).
As to Problem 1, I have no idea yet, perhaps it will be solved together with problem 2 (I don't think so but I've been wrong before)
We should embrace problems, without which there wouldn't be any solutions.

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

Re: Problem upgrade 3.2.4 3.3.0

Post by Lumpy Burgertushie »

just FYI, you have posted this in the convertors forum.

upgrading your phpbb is not a convertor issue.
you should be in the support forum .


luck,
robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?

User avatar
warmweer
Jr. Extension Validator
Posts: 3903
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Problem upgrade 3.2.4 3.3.0

Post by warmweer »

About the Brazilian Portuguese language pack.
Currently there is no language pack for 3.3.0 available in the languages section on phpBB.com
However:
On https://github.com/phpbb-pt/phpbb_langu ... anguage/pt you could download the latest Portuguese language pack which is for 3.3.0. (Não é o pacote de idiomas brasileiro, mas é o melhor e o único disponível no momento) (I have no idea whether is is already 100% complete). Once the Brazilian language pack for 3.3.0 is available, you could change language versions.
Do NOT use a language pack for 3.2.9 - you will have errors on the board.
We should embrace problems, without which there wouldn't be any solutions.

intruder-pr
Registered User
Posts: 8
Joined: Thu Oct 25, 2018 1:14 pm

Re: Problem upgrade 3.2.4 3.3.0

Post by intruder-pr »

I tried to download this pack, but presented the same error ... I tried to change to En and the error remains ... I also tried to do an installation from scratch, I did a backup of the bank, but it does not restore the data ... If anyone has any more ideas I appreciate

User avatar
Mick
Support Team Member
Support Team Member
Posts: 22061
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket.

Re: Problem upgrade 3.2.4 3.3.0

Post by Mick »

Please fill out the Support Request Template and post it back here to enable us to assist you better.
"The more connected we get the more alone we become" - Kyle Broflovski

Please read: “Am I In The Right Place?” before posting.

User avatar
warmweer
Jr. Extension Validator
Posts: 3903
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Problem upgrade 3.2.4 3.3.0

Post by warmweer »

intruder-pr wrote:
Wed Feb 05, 2020 2:28 pm
I tried to download this pack, but presented the same error ... I tried to change to En and the error remains ... I also tried to do an installation from scratch, I did a backup of the bank, but it does not restore the data ... If anyone has any more ideas I appreciate
what do you mean with "backup of the bank"? if that is a backup of your broken board - it has no use. If you have a backup from before the upgrade, that would be fine. You could then re-install that (files + database) and then upgrade following Upgrading from 3.2 to 3.3
But post the SRT first (as KevC asked), with as much information as possible.
We should embrace problems, without which there wouldn't be any solutions.

intruder-pr
Registered User
Posts: 8
Joined: Thu Oct 25, 2018 1:14 pm

Re: Problem upgrade 3.2.4 3.3.0

Post by intruder-pr »

Mick wrote:
Wed Feb 05, 2020 3:18 pm
Please fill out the Support Request Template and post it back here to enable us to assist you better.
Support Request Template
What version of phpBB are you using? phpBB 3.3.0
What is your board's URL? www.flyfishingbrasil.com.br/forum2020
Who do you host your board with? hostgator
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Please select your answer
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
Do you have any extensions installed? No
What styles do you currently have installed? No answer given
What language(s) is your board currently using? en
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP and phpBB
What username can be used to view this issue? No answer given
What password can be used to view this issue? No answer given
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? in version 3.2.4 the same error occurred when banning a user, it was updated to version 3.3.0 is without mod and without translation.
Please describe your problem. I did a reinstallation, and updated again, I am currently without the translation, (since the official has not yet been released,) I am also without a template to avoid any problems until everything is running 100%. Some bugs have been resolved, but the banning user bug persists.
Error follows
General Error
SQL ERROR [mysqli]

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

SQL

INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_type, forum_id, topic_id, post_id, log_data) VALUES ('104487', '177.157.24.136', 1581008282, 'LOG_BAN_USER', 1, 0, 0, 0, ', a, 0 : 2: {i: 0; s: 0: \ "\"; i: 1; s: 13: \ "joaozinho2021 \";} ')

BACKTRACE

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

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

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

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

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

FILE: [ROOT] /includes/functions_user.php
LINE: 1321
CALL: phpbb \ log \ log-> add ()

FILE: [ROOT] /includes/mcp/mcp_ban.php
LINE: 111
CALL: user_ban ()

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

FILE: [ROOT] /mcp.php
LINE: 317
CALL: p_master-> load_active ()
Generated by SRT Generator

intruder-pr
Registered User
Posts: 8
Joined: Thu Oct 25, 2018 1:14 pm

Re: Problem upgrade 3.2.4 3.3.0

Post by intruder-pr »

The support staff at discord helped me discover the problem, the post_id column was missing

User avatar
warmweer
Jr. Extension Validator
Posts: 3903
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Problem upgrade 3.2.4 3.3.0

Post by warmweer »

intruder-pr wrote:
Thu Feb 06, 2020 6:10 pm
The support staff at discord helped me discover the problem, the post_id column was missing
That was clear from the beginning.
The question is why? How was that caused (which could point to possible other (as yet undiscovered) problems.

Code: Select all

Unknown column 'post_id' in 'field list' [1054]
SQL
INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_type, forum_id, topic_id, post_id, log_data) VALUES ('104487', '177.157.24.136', 1581008282, 'LOG_BAN_USER', 1, 0, 0, 0, ', a, 0 : 2: {i: 0; s: 0: \ "\"; i: 1; s: 13: \ "joaozinho2021 \";} ')
you mentioned:
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? in version 3.2.4 the same error occurred when banning a user, it was updated to version 3.3.0 is without mod and without translation.

Yet you mentioned there were no modifications.
Just in case : keep your 324 database backup (and perhaps install it on a personal webserver and compare it to a clean 324 database o find out if there are other things missing)
We should embrace problems, without which there wouldn't be any solutions.

Post Reply

Return to “[3.3.x] Support Forum”