Note: The configuration and execution of the conversion process itself are actually quite simple.
In my case, the data specification of the database is quite messy, which resulted in continuous errors during the conversion (phpbb & discuz) process.
The reason is that the content of the database fails the "isValidXML" check.
I tried replacing obvious syntax errors in the database, such as "</br>" and "<br/>" as mentioned earlier.
However, dealing with these issues in over 50K articles proved to be too difficult. The variety of non-compliant code drove me crazy.
Another consideration is that after modifying the database, many older articles will lose their distinctive bbcode？ features (which are still presented uniquely on Flarum).
Approximately 99.99% of the entire database consists of articles in this peculiar format, and there are very few newly generated articles after migrating to Flarum. So, I decided to try skipping the check and directly import all the data.
After the import was completed, I discovered that most of the articles only had titles in their first posts, losing the main content. It was then that I realized that due to the conversion from phpbb & discuz to Flarum, there might be some differences in the formatting of the old conversion program. As a result, all my discussions were missing the "first_post_id," which is crucial for the new style of display in Waterhole. However, it appears normal in Flarum because the hero title is present, followed by the posts.
Just when I was about to give up, ChatGPT suggested that I try rebuilding the "first_post_id":
After several hours of hardship, various attempts, and encountering errors, I have achieved some results that I hope won't pose major issues. Now, I can start verifying the other functionalities.
中文測試需求< -- pointless, just to test the UTF8 search ability
You don't have permission to do this.
You're going a bit too fast! Take a break and try again in a moment.
Something went wrong! Please reload the page and try again.
Note: The configuration and execution of the conversion process itself are actually quite simple.
In my case, the data specification of the database is quite messy, which resulted in continuous errors during the conversion (phpbb & discuz) process.
The reason is that the content of the database fails the "isValidXML" check.
I tried replacing obvious syntax errors in the database, such as "</br>" and "<br/>" as mentioned earlier.
However, dealing with these issues in over 50K articles proved to be too difficult. The variety of non-compliant code drove me crazy.
Another consideration is that after modifying the database, many older articles will lose their distinctive bbcode？ features (which are still presented uniquely on Flarum).
Approximately 99.99% of the entire database consists of articles in this peculiar format, and there are very few newly generated articles after migrating to Flarum. So, I decided to try skipping the check and directly import all the data.
After the import was completed, I discovered that most of the articles only had titles in their first posts, losing the main content. It was then that I realized that due to the conversion from phpbb & discuz to Flarum, there might be some differences in the formatting of the old conversion program. As a result, all my discussions were missing the "first_post_id," which is crucial for the new style of display in Waterhole. However, it appears normal in Flarum because the hero title is present, followed by the posts.
Just when I was about to give up, ChatGPT suggested that I try rebuilding the "first_post_id":
After several hours of hardship, various attempts, and encountering errors, I have achieved some results that I hope won't pose major issues. Now, I can start verifying the other functionalities.
中文測試需求< -- pointless, just to test the UTF8 search ability