Database import to new installation - Error with Form submission

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Stratokrat
Registered User
Posts: 3
Joined: Tue Jan 07, 2020 7:41 pm

Database import to new installation - Error with Form submission

Post by Stratokrat »

Hello There!

I'm currently trying to revive a dead project from a database backup.
I installed phpBB-3.2.8, truncated all Tables and imported the database Backup into the database.
This process didn't run into any errors.

However neither the login nor the password recovery is working.
The following error message is shown in red letters after submitting data:
The submitted form was invalid. Try submitting again.
The Forum seemed to be working after installation, so I assume the problem is with the imported Data not being completely compatible with the installed version.
Is there a simple step I can make to get the forms working?

The best option for me would be getting this installation running, but I'm eager to recover that old Backups Data into some Setup somehow, so any other advice is welcome as well. I do not know the phpBB Version the Backup originated though.

Greetings!

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

Re: Database import to new installation - Error with Form submission

Post by warmweer »

Stratokrat wrote:
Tue Jan 07, 2020 8:14 pm
I'm currently trying to revive a dead project from a database backup.
I installed phpBB-3.2.8, truncated all Tables and imported the database Backup into the database.
...
I do not know the phpBB Version the Backup originated though.
That database backup? It's probably a lower version than 3.2.8 so you would need to run the database update.
Also: there's never any harm with clearing /cache (leaving index.htm and .htaccess in place). (and you may want to check you cookie_domain and change the cookie_name - and for good measure clear your browser cache).
We should embrace problems, without which there wouldn't be any solutions.

Stratokrat
Registered User
Posts: 3
Joined: Tue Jan 07, 2020 7:41 pm

Re: Database import to new installation - Error with Form submission

Post by Stratokrat »

warmweer wrote:
Tue Jan 07, 2020 9:29 pm
That database backup? It's probably a lower version than 3.2.8 so you would need to run the database update.
Yes, I assume it is, I'm not sure though, it might have been updated before it broke due to server / php problems (I believe that's what happened).
warmweer wrote:
Tue Jan 07, 2020 9:29 pm
Also: there's never any harm with clearing /cache (leaving index.htm and .htaccess in place). (and you may want to check you cookie_domain and change the cookie_name - and for good measure clear your browser cache).
Wow. I just tried a clean browser and it instantly worked. Can't believe recovering that data was so easy.

Shame on me for not trying that first, I thought it must be some issues there.

Thank you for the hint!

Stratokrat
Registered User
Posts: 3
Joined: Tue Jan 07, 2020 7:41 pm

Re: Database import to new installation - Error with Form submission

Post by Stratokrat »

OK there were some follow up problems, but it seems to run now.

I could log in and use the ACP, reading posts was all good, only posting or showing a preview would not work.

In the ACP I got the warning, that an update didn't work properly.
It said the following about the versions:
Files Version
3.2.8
Database version
3.1.5
I tried to Update the database but got this error:

Code: Select all

General Error:
SQL ERROR [ mysqli ]
Duplicate key name 'itm_usr_mthd' [1061]

SQL
ALTER TABLE forum_user_notifications ADD INDEX itm_usr_mthd (item_type, item_id, user_id, method) in file /users/stratokrat/www/minecraft/phpbb/db/driver/driver.php on line 997

BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: installer_msg_handler()

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

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

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

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1551
CALL: phpbb\db\tools\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 671
CALL: phpbb\db\tools\tools->sql_create_index()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()

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

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

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

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

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

FILE: [ROOT]/phpbb/install/module/update_database/task/update.php
LINE: 160
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/phpbb/install/module_base.php
LINE: 149
CALL: phpbb\install\module\update_database\task\update->run()

FILE: [ROOT]/phpbb/install/installer.php
LINE: 219
CALL: phpbb\install\module_base->run()

FILE: [ROOT]/phpbb/install/controller/update.php
LINE: 133
CALL: phpbb\install\installer->run()

FILE: [ROOT]/vendor/symfony/http-foundation/StreamedResponse.php
LINE: 111
CALL: phpbb\install\controller\update->phpbb\install\controller\{closure}()

FILE: [ROOT]/vendor/symfony/http-foundation/Response.php
LINE: 384
CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()

FILE: [ROOT]/install/app.php
LINE: 62
CALL: Symfony\Component\HttpFoundation\Response->send()
The attached steps were logged as successful.
updateSQL.log
(12.79 KiB) Downloaded 1 time
After this I can seemingly do anything, post, polls, attachments all seem to work, but I still have a version discrepancy:
Files Version
3.2.8
Database version
3.2.0

Post Reply

Return to “[3.2.x] Support Forum”