Is it easy to convert my old Phpbb 2.0.22 to the latest 3.2.x

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
User avatar
JimA
Former Team Member
Posts: 7833
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Is it easy to convert my old Phpbb 2.0.22 to the latest 3.2.x

Post by JimA »

I see from your post frequency that you're concerned, but there's no immediate need for worry.

Even if the conversion process doesn't work, it won't harm the existing phpBB2 database. It only tries to copy (convert) the data towards to the new phpBB 3.x install. If it fails, you can just try again.

Additionally, could you please keep in mind that we have a six hour bumping rule on this website. If you have any new information within that time frame, please edit your older post. We won't forget about you.
Jim Mossing Holsteyn - Former Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.
Marz
Registered User
Posts: 108
Joined: Wed Sep 14, 2005 2:20 pm
Location: Malta
Contact:

Re: Is it easy to convert my old Phpbb 2.0.22 to the latest 3.2.x

Post by Marz »

Ok, so I guess this will not be considered as bumping as I am posting after you. Here's an update if someone here would be kind enough to investigate and follow my case.

After getting serious of 500 internal errors I gave up and started the conversion from scratch.... however i did not manage to reach again step 17/29 as in my previous post. Why this inconsistency???

The situation is that when I start a conversion, I advance page by page Filling table phpbb_attachments:
skip_rows = xxx: This advances by 250 skip_rows every page 250...502...758... etc

When the count arrives at around 2500 I get an internal error, then :

Code: Select all

Information
General Error:
SQL ERROR [ mysqli ]

Table 'marzmif4_mwpforum2017.phpbb_userconv' doesn't exist [1146]

SQL

SELECT username_clean FROM phpbb_userconv GROUP BY username_clean HAVING COUNT(user_id) > 1
in file /home/marzmif4/public_html/WildPlants/forum_new/phpbb/db/driver/driver.php on line 999

BACKTRACE


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

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

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

FILE: [ROOT]/install/convertors/functions_phpbb20.php
LINE: 1853
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/install/convert/convertor.php(539) : eval()'d code
LINE: 1
CALL: phpbb_check_username_collisions()

FILE: [ROOT]/install/convert/convertor.php
LINE: 539
CALL: eval()

FILE: [ROOT]/install/convert/controller/convertor.php
LINE: 370
CALL: phpbb\convert\convertor->convert_data()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\convert\controller\convertor->convert()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 144
CALL: call_user_func_array()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 64
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/install/app.php
LINE: 61
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()

The url is http://www.maltawildplants.com/forum_ne ... _rows=2593

If I refresh I get the same error all the time. I tried 3-4 times resume conversion and no luck. My old board is not very huge http://maltawildplants.com/forum/index. ... 88bcf8ed90
User avatar
rubencm
Development Team Member
Development Team Member
Posts: 104
Joined: Fri Oct 05, 2007 2:24 pm
Location: Spain

Re: Is it easy to convert my old Phpbb 2.0.22 to the latest 3.2.x

Post by rubencm »

If i dont remember wrong, the error you have is becuase mysql configuration.
The best you can do is doing the conversion offline in your computer using xampp or something.
Marz
Registered User
Posts: 108
Joined: Wed Sep 14, 2005 2:20 pm
Location: Malta
Contact:

Re: Is it easy to convert my old Phpbb 2.0.22 to the latest 3.2.x

Post by Marz »

Thanks for the tips but I have managed to convert it to 3.0.14 and it is running fine, however I have several Spam attacks, apparently on the same forum topic that I have disabled my board.

I guess I have to convert to 3.2.x although if there is a solution for blocking spam on the current 3.0.14, I would try it until I decide to convert when I am less busy. The spammers become members (without any email notification) and post on the same topic. I had some 10/day so Its quite nuiassance

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

Re: Is it easy to convert my old Phpbb 2.0.22 to the latest 3.2.x

Post by janus_zonstraal »

What permissions did you set for that topic?
Especial the "guest" permissions?
Sorry! My English is bat ;) !!!
Marz
Registered User
Posts: 108
Joined: Wed Sep 14, 2005 2:20 pm
Location: Malta
Contact:

Re: Is it easy to convert my old Phpbb 2.0.22 to the latest 3.2.x

Post by Marz »

I lost the touch of ACP but I think I have to check from Forum permissions.
I have this screensnapshot setting for the Forum.

I am having lot of users becoming members. Now I changed the setting that admin has to confirm new user registration, and maybe I blocked the spammers for a while but they are still are bypassing the spam countermeasure (3D grafic) and become inactive users. (unless they are human agents!)

what can I do :-(
Attachments
Clipboard11.jpg
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: Is it easy to convert my old Phpbb 2.0.22 to the latest 3.2.x

Post by janus_zonstraal »

Click on "guest" and than edit permissions.
Sorry! My English is bat ;) !!!
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53400
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Is it easy to convert my old Phpbb 2.0.22 to the latest 3.2.x

Post by Brf »

Marz wrote: Sun Sep 10, 2017 6:21 pm they are still are bypassing the spam countermeasure (3D grafic) and become inactive users. (unless they are human agents!)
The graphic captcha are not any good. You should be using a non-Googleable Q&A.
With Admin activation, those inactive spammers would not be able to post until they are activated, unless you are allowing Guests to post.
Post Reply

Return to “[3.2.x] Convertors”