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 2357All 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 [1041]. 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...
http://example.com/install/app.php/convert/in_progress/phpbb20?current_table=16&skip_rows=913349Interestingly, 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 [1064]
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 ;-)
