Migrating from 2.0.17 to new host with 3.2.4

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by warmweer »

odsw wrote: Thu Dec 06, 2018 7:47 am Thanks alot!
I installed a virtual Windows server and:
I managed to install and restore the old forum with 2.0.17 and then upgraded it to 3.0.
However, now I'm stuck when I'm trying to upgrade to 3.2.4, since the php version easyPHP 1.8 is running is to old.

Any suggestions on how to proceed with the upgrade of php/phpBB?
The old versions of EasyPHP were just to make sure phpBB v2 and phpbb 3.0 would work.
Now you have a phpBB3 board and you need a virtual server on which phpBB 3.0 and phpBB 3.2 will work.

First, make a copy of your 3.0 database and config.php.
For a new webserver you could upgrade to a more recent version of EasyPHP but the highest php version is 5.3. From php 5.4 on it is called DevServer and is more complicated to set up (you can't just upgrade EasyPhp any further).

So I suggest you use USBWebserver which comes as a zipfile (use version 8.6) , and all you need to do is to unpack it to a directory (call it USBwebserver). That's it: you're ready to go.

Start USBwebserver, use your backup of the database to create the 3.0 database which you will upgrade.
Make your directory (forum or something) in the www directory (of USBWebserver). (use the same name as you did for phpBB2)
Download phpbb 3.1.12 and unpack into that directory.
edit the config.php (if necessary) so that it points to the correct database.
Then update database only.
When succesful, take a backup of the database just in case.
Next is upgrading to 3.2.4 (download the full package, unzip, and again update database only). Then apply the fixes mentioned in the sticky topic for 3.2.4.

Congratulations: you now have a 3.2.4 board.

edit: I just saw Mick's message when submitting.
Considering this is the first time you've used a personal webserver I would not do this with WAMP yet (it has to be configured properly). Use USBwebserver which comes preconfigured and ready to use. (and you might even decide to keep if because it's so simple to use)
Once your 3.2.4 board is fully functional, then you can install Wampserver. and switch between php versions, database engines, etc..
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
odsw
Registered User
Posts: 14
Joined: Mon Dec 03, 2018 5:46 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by odsw »

Thanks once again warmweer, you are my personal hero :)

However.. I still have some questions..

What is the best way to make a copy of my phpBB3 database? (If MyPhpAdmin, any settings I should be aware of?)

On the new virtual server running USBWebserver, do I have to create a new database and use phpdump to import the phpBB3 database?
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by janus_zonstraal »

https://www.phpbb.com/support/docs/en/3 ... or-domain/

everything is in that doc, I think.
Sorry! My English is bat ;) !!!
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by warmweer »

odsw wrote: Thu Dec 06, 2018 12:30 pm On the new virtual server running USBWebserver, do I have to create a new database and use phpdump to import the phpBB3 database?
If your database engine is MYSQL and your tables are MyISAM format then you could just copy the whole directory of your database (from EasyPHP) to USBWebserver/mysql/data/ (so in here this would result in a new subdirectory (forum/) with all the files in it). That ONLY works with mysql AND MyISAM!!!
The safest way is of course to dump and import.

I forgot (in my previous post) to mention that you should change config.php (mysql to mysqli)
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
odsw
Registered User
Posts: 14
Joined: Mon Dec 03, 2018 5:46 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by odsw »

When I try to use bigdump on the new server I get the following error:
Error at the line 3001: INSERT INTO `phpbb3_posts` (`post_id`, `topic_id`, `forum_id`, `poster_id`, `icon_id`, `poster_ip`, `post_time`, `post_approved`, `post_reported`, `enable_bbcode`, `enable_smilies`, `enable_magic_url`, `enable_sig`, `post_username`, `post_subject`, `post_text`, `post_checksum`, `post_attachment`, `bbcode_bitfield`, `bbcode_uid`, `post_postcount`, `post_edit_time`, `post_edit_reason`, `post_edit_user`, `post_edit_count`, `post_edit_locked`) VALUES (264, 69, 31, 2, 0, 0x38312e3232372e3133322e313237, 1067264270, 1, 0, 1, 1, 1, 0, '', 'Bilåkande & dess betalning', 0x54c383c2a46e6b74652068c383c2b67261206c697465206875722064657420736b616c6c207661726120616e672e20c383c2a56b612062696c206f636820626574616c612e200a0a56692073616465206a752066c383c2b672766973736f206174742064656e20736f6d2066697861722062696c20696e746520736b616c6c20626574616c61206ec383c2a56765206d656e20646574206bc383c2a46e6e73206c6974652066616b6b74206f636b73c383c2a52e20536f6d2074657820692053c383c2b66e64616773206ec383c2a472206a6167206f6368204d617274696e206669786164652070c383c2a4726f6e62696c2e2044c383c2a520736b756c6c65203320706572732064656c612062656e73696e20697374c383c2a46c6c65742066c383c2b6722035202b206174742064657420626c6972206b6e6170707374206ec383c2a5676f7420736c6974616765206d6d20736f6d2076692066c383c2a572207374c383c2a52066c383c2b6722e2056616c646520697374c383c2a46c6c6574206174742064656c61206465742072616b742061762070c383c2a5203520706572732064c383c2a520646574206bc383c2a46e646573206d65722072c383c2a47474766973742e200a0a536564616e2066696e6e73206465742079747465726c696761726520656e20617370656b74206f63682064657420c383c2a472206a75206672c383c2a567616e206f6d206a6f6262657420736b616c6c207370656c6120696e20656c6c65722066616b7469736b61206b6f73746e6164656e2070c383c2a52062696c656e2e20546578206f6d20766920616e76c383c2a46e646572204d79676761686e73206d6f727361732062696c2e20502e672e612e20617474206d79676761686e20c383c2a47220656e206c6174206ac383c2a476656c20203c212d2d20733a50202d2d3e3c696d67207372633d227b534d494c4945535f504154487d2f69636f6e5f72617a7a2e6769662220616c743d223a5022207469746c653d2252617a7a22202f3e3c212d2d20733a50202d2d3e2073c383c2a5206861722068616e20696e7465206bc383c2b6726b6f7274206f6368206b616e206d616f20696e7465206bc383c2b672612e2044c383c2a52066c383c2a572206ec383c2a5676f6e20616e6e616e207461207369672075742074696c6c206d79676761686e206f63682068c383c2a46d74612062696c656e2e2044c383e280a620626c6972206672c383c2a567616e206f6d204d79676761686e20696e746520736b616c6c20626574616c6120736f6d2066697861742062696c20656c6c6572206f6d2064656e20736f6d2067c383c2b672206a6f62626574206f636820c383c2a56b657220627573732028736b616c6c206275737370656e6761726e61206f636b73c383c2a52064656c61733f29206f6368206bc383c2b6722062696c656e20696e746520736b616c6c20626574616c6120656c6c65722062c383c2a5646120656c6c657220696e67656e20656c6c65723f3f200a0a446f636b20686172206a616720696e67612070726f622e20617474207465782e204d61726b757320736f6d20686172206567656e2062696c20736f6d20c383c2a56b657220c383c2b6766572616c6c7420736c69707065722061747420626574616c612064c383c2a52064657420736c6974732070c383c2a52068616e73206567656e2062696c202b206174742068616e20686172202266697861742220656e206b6f6e7374616e742062696c2064c383c2a520696e67656e20616e6e616e206861722072c383c2a56420656c6c6572206f726b2e2020200a0a5661642073c383c2a4676572206e693f21, '', 0, 0x51413d3d, 0x6b63747271747271, 1, 0, '', 2, 0, 0);

Query: INSERT INTO `phpbb3_posts` (`post_id`, `topic_id`, `forum_id`, `poster_id`, `icon_id`, `poster_ip`, `post_time`, `post_approved`, `post_reported`, `enable_bbcode`, `enable_smilies`, `enable_magic_url`, `enable_sig`, `post_username`, `post_subject`, `post_text`, `post_checksum`, `post_attachment`, `bbcode_bitfield`, `bbcode_uid`, `post_postcount`, `post_edit_time`, `post_edit_reason`, `post_edit_user`, `post_edit_count`, `post_edit_locked`) VALUES (264, 69, 31, 2, 0, 0x38312e3232372e3133322e313237, 1067264270, 1, 0, 1, 1, 1, 0, '', 'Bilåkande & dess betalning', 0x54c383c2a46e6b74652068c383c2b67261206c697465206875722064657420736b616c6c207661726120616e672e20c383c2a56b612062696c206f636820626574616c612e200a0a56692073616465206a752066c383c2b672766973736f206174742064656e20736f6d2066697861722062696c20696e746520736b616c6c20626574616c61206ec383c2a56765206d656e20646574206bc383c2a46e6e73206c6974652066616b6b74206f636b73c383c2a52e20536f6d2074657820692053c383c2b66e64616773206ec383c2a472206a6167206f6368204d617274696e206669786164652070c383c2a4726f6e62696c2e2044c383c2a520736b756c6c65203320706572732064656c612062656e73696e20697374c383c2a46c6c65742066c383c2b6722035202b206174742064657420626c6972206b6e6170707374206ec383c2a5676f7420736c6974616765206d6d20736f6d2076692066c383c2a572207374c383c2a52066c383c2b6722e2056616c646520697374c383c2a46c6c6574206174742064656c61206465742072616b742061762070c383c2a5203520706572732064c383c2a520646574206bc383c2a46e646573206d65722072c383c2a47474766973742e200a0a536564616e2066696e6e73206465742079747465726c696761726520656e20617370656b74206f63682064657420c383c2a472206a75206672c383c2a567616e206f6d206a6f6262657420736b616c6c207370656c6120696e20656c6c65722066616b7469736b61206b6f73746e6164656e2070c383c2a52062696c656e2e20546578206f6d20766920616e76c383c2a46e646572204d79676761686e73206d6f727361732062696c2e20502e672e612e20617474206d79676761686e20c383c2a47220656e206c6174206ac383c2a476656c20203c212d2d20733a50202d2d3e3c696d67207372633d227b534d494c4945535f504154487d2f69636f6e5f72617a7a2e6769662220616c743d223a5022207469746c653d2252617a7a22202f3e3c212d2d20733a50202d2d3e2073c383c2a5206861722068616e20696e7465206bc383c2b6726b6f7274206f6368206b616e206d616f20696e7465206bc383c2b672612e2044c383c2a52066c383c2a572206ec383c2a5676f6e20616e6e616e207461207369672075742074696c6c206d79676761686e206f63682068c383c2a46d74612062696c656e2e2044c383e280a620626c6972206672c383c2a567616e206f6d204d79676761686e20696e746520736b616c6c20626574616c6120736f6d2066697861742062696c20656c6c6572206f6d2064656e20736f6d2067c383c2b672206a6f62626574206f636820c383c2a56b657220627573732028736b616c6c206275737370656e6761726e61206f636b73c383c2a52064656c61733f29206f6368206bc383c2b6722062696c656e20696e746520736b616c6c20626574616c6120656c6c65722062c383c2a5646120656c6c657220696e67656e20656c6c65723f3f200a0a446f636b20686172206a616720696e67612070726f622e20617474207465782e204d61726b757320736f6d20686172206567656e2062696c20736f6d20c383c2a56b657220c383c2b6766572616c6c7420736c69707065722061747420626574616c612064c383c2a52064657420736c6974732070c383c2a52068616e73206567656e2062696c202b206174742068616e20686172202266697861742220656e206b6f6e7374616e742062696c2064c383c2a520696e67656e20616e6e616e206861722072c383c2a56420656c6c6572206f726b2e2020200a0a5661642073c383c2a4676572206e693f21, '', 0, 0x51413d3d, 0x6b63747271747271, 1, 0, '', 2, 0, 0)

MySQL: Table 'sv01.phpbb3_posts' doesn't exist


Stopped on error
Any suggestions?
User avatar
canonknipser
Registered User
Posts: 2096
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by canonknipser »

Read the relevant part of the message
odsw wrote: Thu Dec 06, 2018 2:20 pm
MySQL: Table 'sv01.phpbb3_posts' doesn't exist
and check if the database name (sv01) and table prefix (phpbb3_) for the new board are correct
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB
odsw
Registered User
Posts: 14
Joined: Mon Dec 03, 2018 5:46 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by odsw »

canonknipser wrote: Thu Dec 06, 2018 2:28 pm Read the relevant part of the message
odsw wrote: Thu Dec 06, 2018 2:20 pm
MySQL: Table 'sv01.phpbb3_posts' doesn't exist
and check if the database name (sv01) and table prefix (phpbb3_) for the new board are correct
Ah!
Didn't realise I had to install the forum first.
I installed the forum, couldn't use "phpbb3_" as prefix because of max string length.
Installed the forum with "bb_" as prefix. Used search and replace on the .sql file phpbb3_ > bb_

Now I'm getting this error:
Error at the line 3001: INSERT INTO `bb_posts` (`post_id`, `topic_id`, `forum_id`, `poster_id`, `icon_id`, `poster_ip`, `post_time`, `post_approved`, `post_reported`, `enable_bbcode`, `enable_smilies`, `enable_magic_url`, `enable_sig`, `post_username`, `post_subject`, `post_text`, `post_checksum`, `post_attachment`, `bbcode_bitfield`, `bbcode_uid`, `post_postcount`, `post_edit_time`, `post_edit_reason`, `post_edit_user`, `post_edit_count`, `post_edit_locked`) VALUES (264, 69, 31, 2, 0, 0x38312e3232372e3133322e313237, 1067264270, 1, 0, 1, 1, 1, 0, '', 'Bilåkande & dess betalning', 0x54c383c2a46e6b74652068c383c2b67261206c697465206875722064657420736b616c6c207661726120616e672e20c383c2a56b612062696c206f636820626574616c612e200a0a56692073616465206a752066c383c2b672766973736f206174742064656e20736f6d2066697861722062696c20696e746520736b616c6c20626574616c61206ec383c2a56765206d656e20646574206bc383c2a46e6e73206c6974652066616b6b74206f636b73c383c2a52e20536f6d2074657820692053c383c2b66e64616773206ec383c2a472206a6167206f6368204d617274696e206669786164652070c383c2a4726f6e62696c2e2044c383c2a520736b756c6c65203320706572732064656c612062656e73696e20697374c383c2a46c6c65742066c383c2b6722035202b206174742064657420626c6972206b6e6170707374206ec383c2a5676f7420736c6974616765206d6d20736f6d2076692066c383c2a572207374c383c2a52066c383c2b6722e2056616c646520697374c383c2a46c6c6574206174742064656c61206465742072616b742061762070c383c2a5203520706572732064c383c2a520646574206bc383c2a46e646573206d65722072c383c2a47474766973742e200a0a536564616e2066696e6e73206465742079747465726c696761726520656e20617370656b74206f63682064657420c383c2a472206a75206672c383c2a567616e206f6d206a6f6262657420736b616c6c207370656c6120696e20656c6c65722066616b7469736b61206b6f73746e6164656e2070c383c2a52062696c656e2e20546578206f6d20766920616e76c383c2a46e646572204d79676761686e73206d6f727361732062696c2e20502e672e612e20617474206d79676761686e20c383c2a47220656e206c6174206ac383c2a476656c20203c212d2d20733a50202d2d3e3c696d67207372633d227b534d494c4945535f504154487d2f69636f6e5f72617a7a2e6769662220616c743d223a5022207469746c653d2252617a7a22202f3e3c212d2d20733a50202d2d3e2073c383c2a5206861722068616e20696e7465206bc383c2b6726b6f7274206f6368206b616e206d616f20696e7465206bc383c2b672612e2044c383c2a52066c383c2a572206ec383c2a5676f6e20616e6e616e207461207369672075742074696c6c206d79676761686e206f63682068c383c2a46d74612062696c656e2e2044c383e280a620626c6972206672c383c2a567616e206f6d204d79676761686e20696e746520736b616c6c20626574616c6120736f6d2066697861742062696c20656c6c6572206f6d2064656e20736f6d2067c383c2b672206a6f62626574206f636820c383c2a56b657220627573732028736b616c6c206275737370656e6761726e61206f636b73c383c2a52064656c61733f29206f6368206bc383c2b6722062696c656e20696e746520736b616c6c20626574616c6120656c6c65722062c383c2a5646120656c6c657220696e67656e20656c6c65723f3f200a0a446f636b20686172206a616720696e67612070726f622e20617474207465782e204d61726b757320736f6d20686172206567656e2062696c20736f6d20c383c2a56b657220c383c2b6766572616c6c7420736c69707065722061747420626574616c612064c383c2a52064657420736c6974732070c383c2a52068616e73206567656e2062696c202b206174742068616e20686172202266697861742220656e206b6f6e7374616e742062696c2064c383c2a520696e67656e20616e6e616e206861722072c383c2a56420656c6c6572206f726b2e2020200a0a5661642073c383c2a4676572206e693f21, '', 0, 0x51413d3d, 0x6b63747271747271, 1, 0, '', 2, 0, 0);

Query: INSERT INTO `bb_posts` (`post_id`, `topic_id`, `forum_id`, `poster_id`, `icon_id`, `poster_ip`, `post_time`, `post_approved`, `post_reported`, `enable_bbcode`, `enable_smilies`, `enable_magic_url`, `enable_sig`, `post_username`, `post_subject`, `post_text`, `post_checksum`, `post_attachment`, `bbcode_bitfield`, `bbcode_uid`, `post_postcount`, `post_edit_time`, `post_edit_reason`, `post_edit_user`, `post_edit_count`, `post_edit_locked`) VALUES (264, 69, 31, 2, 0, 0x38312e3232372e3133322e313237, 1067264270, 1, 0, 1, 1, 1, 0, '', 'Bilåkande & dess betalning', 0x54c383c2a46e6b74652068c383c2b67261206c697465206875722064657420736b616c6c207661726120616e672e20c383c2a56b612062696c206f636820626574616c612e200a0a56692073616465206a752066c383c2b672766973736f206174742064656e20736f6d2066697861722062696c20696e746520736b616c6c20626574616c61206ec383c2a56765206d656e20646574206bc383c2a46e6e73206c6974652066616b6b74206f636b73c383c2a52e20536f6d2074657820692053c383c2b66e64616773206ec383c2a472206a6167206f6368204d617274696e206669786164652070c383c2a4726f6e62696c2e2044c383c2a520736b756c6c65203320706572732064656c612062656e73696e20697374c383c2a46c6c65742066c383c2b6722035202b206174742064657420626c6972206b6e6170707374206ec383c2a5676f7420736c6974616765206d6d20736f6d2076692066c383c2a572207374c383c2a52066c383c2b6722e2056616c646520697374c383c2a46c6c6574206174742064656c61206465742072616b742061762070c383c2a5203520706572732064c383c2a520646574206bc383c2a46e646573206d65722072c383c2a47474766973742e200a0a536564616e2066696e6e73206465742079747465726c696761726520656e20617370656b74206f63682064657420c383c2a472206a75206672c383c2a567616e206f6d206a6f6262657420736b616c6c207370656c6120696e20656c6c65722066616b7469736b61206b6f73746e6164656e2070c383c2a52062696c656e2e20546578206f6d20766920616e76c383c2a46e646572204d79676761686e73206d6f727361732062696c2e20502e672e612e20617474206d79676761686e20c383c2a47220656e206c6174206ac383c2a476656c20203c212d2d20733a50202d2d3e3c696d67207372633d227b534d494c4945535f504154487d2f69636f6e5f72617a7a2e6769662220616c743d223a5022207469746c653d2252617a7a22202f3e3c212d2d20733a50202d2d3e2073c383c2a5206861722068616e20696e7465206bc383c2b6726b6f7274206f6368206b616e206d616f20696e7465206bc383c2b672612e2044c383c2a52066c383c2a572206ec383c2a5676f6e20616e6e616e207461207369672075742074696c6c206d79676761686e206f63682068c383c2a46d74612062696c656e2e2044c383e280a620626c6972206672c383c2a567616e206f6d204d79676761686e20696e746520736b616c6c20626574616c6120736f6d2066697861742062696c20656c6c6572206f6d2064656e20736f6d2067c383c2b672206a6f62626574206f636820c383c2a56b657220627573732028736b616c6c206275737370656e6761726e61206f636b73c383c2a52064656c61733f29206f6368206bc383c2b6722062696c656e20696e746520736b616c6c20626574616c6120656c6c65722062c383c2a5646120656c6c657220696e67656e20656c6c65723f3f200a0a446f636b20686172206a616720696e67612070726f622e20617474207465782e204d61726b757320736f6d20686172206567656e2062696c20736f6d20c383c2a56b657220c383c2b6766572616c6c7420736c69707065722061747420626574616c612064c383c2a52064657420736c6974732070c383c2a52068616e73206567656e2062696c202b206174742068616e20686172202266697861742220656e206b6f6e7374616e742062696c2064c383c2a520696e67656e20616e6e616e206861722072c383c2a56420656c6c6572206f726b2e2020200a0a5661642073c383c2a4676572206e693f21, '', 0, 0x51413d3d, 0x6b63747271747271, 1, 0, '', 2, 0, 0)

MySQL: Unknown column 'post_approved' in 'field list'


Stopped on error
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by warmweer »

I have a feeling you've only dumped the data.
You need to export the original database with create table statements.

But just as a test, try this first

You have a directory Easyphp/mysql/data/forum (or something like that)
You also have a directory USBWebserver/mysql/data

Copy the /forum (with everything inside) to USBwebserver/mysql/data/ so that you end up with USBwebserver/mysql/data/forum/
and then use phpMyAdmin to test if everything is readable.


BTW you do not have to install the forum first. You only need the database from your 3.0. Once the database is in place, then put the 3.1.12 files in
USBWebserver/root/forum/
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
odsw
Registered User
Posts: 14
Joined: Mon Dec 03, 2018 5:46 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by odsw »

I've copied the folder containing the database and I can browse it in phpMyAdmin on the new server.
I've copied the config.php from my old server and updated it with the new database password and changed from mysql to mysqli.

When i visit http://localhost:8080/phpBB3 I get the following message:
General Error

SQL ERROR [ mysqli ]

Table 'test02.phpbb3_ext' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
odsw
Registered User
Posts: 14
Joined: Mon Dec 03, 2018 5:46 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by odsw »

I exported the database with the following settings:

Image
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by janus_zonstraal »

I've copied the folder containing the database and I can browse it in phpMyAdmin on the new server.
A database is a file not a container?

And if you see your database in phpmyadmin are the tables there?
Screen print maybe?
Sorry! My English is bat ;) !!!
odsw
Registered User
Posts: 14
Joined: Mon Dec 03, 2018 5:46 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by odsw »

janus_zonstraal wrote: Thu Dec 06, 2018 3:22 pm
I've copied the folder containing the database and I can browse it in phpMyAdmin on the new server.
A database is a file not a container?

And if you see your database in phpmyadmin are the tables there?
Screen print maybe?
http://www.bilddump.se/bilder/201812061 ... 64.100.JPG
There is a screendump of the database i phpmyadmin
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by janus_zonstraal »

Did you go to the /install/ folder to update the database?
Sorry! My English is bat ;) !!!
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by warmweer »

odsw wrote: Thu Dec 06, 2018 3:14 pm Table 'test02.phpbb3_ext' doesn't exist [1146]
table _ext ??
phpbb 3.0 doesn't have that table. That was introduced in 3.1 for the extensions and shouldn't be present in your 3.0 database

Just to have a method for comparison;
make a new empty database (call it 3014 for clarity) and then install a new 3.0.14 board. Compare that database to the one you want to upgrade for 3.1.12

your config should look contain something like this
$dbhost = 'localhost';
$dbport = '';
$dbname = 'your databasename';
$dbuser = 'root';
$dbpasswd = 'usbw';
$table_prefix = 'your tableprefix'

You should actually go to http://localhost:8080/phpBB3/install/app.php
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
odsw
Registered User
Posts: 14
Joined: Mon Dec 03, 2018 5:46 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by odsw »

There is no option to update the database:
http://www.bilddump.se/bilder/201812061 ... 64.100.JPG
Post Reply

Return to “[3.2.x] Support Forum”