Yes, I'm aware it's a big step. That said, I'd like to forge ahead anyway but I've encountered three (and a two-third) problems
1. Somewhere in the middle of filling 'topics' (between rows 22000 and 22400) I see about a dozen lines like this.
In /home/www/public_html/phpBB3/includes/functions_convert.php on line 2357
All the lines are the same, and there is no other message. If I click 'continue conversion' the process seems to continue but I can't help but suspect something is not quite right.
2a. While filling the 'posts' table I got an out of memory error . I'm on a low-end web server so there is no expectation of high performance. I adjusted the swap file size and have been able to get past this (for now).
Note. I left the browser page open while I reconfigured the server. The url was like this...
Interestingly, it seemed I was able to continue without restarting the whole process.
2b. Noteworthy. Sometimes while filling the posts table I got a blank white page. Using browser/firefox refresh seemed to allow things to continue.
2c. The conversion process seems to be resource intensive. In addition to being out of memory, I got a notification from the host company that I had "exceeded the notification threshold (10000) for disk io rate by averaging 12892.21 for the last 2 hours." It's a bit of a concern because my effort to convert from phpbb 2 to 3 is to test the process. I am not using live data and if everything goes well I'll have to do this again. I don't particularly want to slow down the process - it takes long enough as it is - but it means I'll have to work out all the errors before attempting the final conversion.
3. "You have an error in your SQL syntax." I'll post the whole message.
Code: Select all
Error 3 http://example.com/install/app.php/convert/in_progress/phpbb20?current_table=19&skip_rows=860 Information General Error: SQL ERROR [ mysqli ] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups\x0AWHERE (groups.group_single_user = 0)\x0A LIMIT 2000' at line 2  SQL SELECT groups.group_id, groups.group_type, groups.group_name, groups.group_description FROM otr_groups groups WHERE (groups.group_single_user = 0) LIMIT 2000 in file /home/www/public_html/phpBB3/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: 193 CALL: phpbb\db\driver\driver->sql_error() FILE: [ROOT]/phpbb/db/driver/mysql_base.php LINE: 45 CALL: phpbb\db\driver\mysqli->sql_query() FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 270 CALL: phpbb\db\driver\mysql_base->_sql_query_limit() FILE: [ROOT]/install/convert/convertor.php LINE: 702 CALL: phpbb\db\driver\driver->sql_query_limit() FILE: [ROOT]/install/convert/controller/convertor.php LINE: 370 CALL: phpbb\convert\convertor->convert_data() FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php LINE: 135 CALL: phpbb\convert\controller\convertor->convert() FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php LINE: 57 CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw() FILE: [ROOT]/install/app.php LINE: 61 CALL: Symfony\Component\HttpKernel\HttpKernel->handle()
Thanks for making it this far in my post. I look forward to your insights.
[ edit ] unchecked the parse url checkbox, then added this note ;-)