PDA

View Full Version : phpbb3 to vb4 impex issues


chikuru
24 Sep 2015, 22:14
I am getting these issues after migrated from phpbb3:
- incorrect date in forumdisplay
- incorrect poster in forum display

https://www.vbulletin.org/forum/external/2015/09/5.png

I did the post impex steps and repeat for few times but didnt work..

Any help?

Zachery
25 Sep 2015, 01:23
Did you run the after the import steps?

chikuru
25 Sep 2015, 03:15
Did you run the after the import steps?

I did the post impex steps and repeat for few times but didnt fix the issue.. :confused:

I can PM you the admin access to the vbulletin.

Its only small import from phpbb.

RichieBoy67
25 Sep 2015, 05:57
You updated counters? Cleared cache?

chikuru
25 Sep 2015, 06:36
Rebuild Thread Information
Rebuild Forum Information
Rebuild Search Index
Rebuild Post Cache
Cleared cache

What can you suggest?

Dave
25 Sep 2015, 09:53
Looks more like blank dates were imported. Check the thread/post tables in the database and see if the dates are indeed set to NULL or 00-00-0000.

chikuru
25 Sep 2015, 12:16
Looks more like blank dates were imported. Check the thread/post tables in the database and see if the dates are indeed set to NULL or 00-00-0000.

Only the date in forumdisplay is incorrect. When you open the thread, the dates inside thread are correct..

--------------- Added 1443187551 at 1443187551 ---------------

I checked the "thread" table, and here is what I found:
https://www.vbulletin.org/forum/external/2015/09/4.png

The dateline and lastposter show 0

TheLastSuperman
26 Sep 2015, 03:30
I did the post impex steps and repeat for few times but didnt fix the issue.. :confused:

I can PM you the admin access to the vbulletin.

Its only small import from phpbb.

You're not supposed to run the modules more than once unless it simply didn't run properly for some odd reason and even then you would stop, address the issue then continue - this might be your issue i.e. running modules multiple times. I would start from scratch and when running Impex ensure you don't run the modules multiple times, finish the import then update counters and such from within vBulletin ;).

chikuru
26 Sep 2015, 05:35
I also deleted the cache and deleted the imported data from /impex/help.php and start reimport but same result..

---
This has been fixed already by Dave. He had to create queries to get the missing data..

RichieBoy67
26 Sep 2015, 06:43
Glad you got it going. Dave is good people and one of the most knowledgeable people here.

Dave
26 Sep 2015, 09:27
Impex didn't import the firstpostid, lastpostid, lastpost, postuserid and lastposter for some reason so I had to manually create some queries to port it over from the post table.
Also in the post table, the visible column was all set to 0 which means only administrators were able to see threads.

^ May be of use to someone else in the future.

Zachery
26 Sep 2015, 20:58
I suspect a problem with the source data, that or you re-ran a module without re-running the other subsequent modules.

Can you let me know which version of PHPBB you were importing from?

chikuru
27 Sep 2015, 12:56
I suspect a problem with the source data, that or you re-ran a module without re-running the other subsequent modules.

Can you let me know which version of PHPBB you were importing from?

phpBB3. I tried re creating the test site and ran the modules IN ORDER but still getting same issue..

Zachery
29 Sep 2015, 01:18
which specific version of PHPBB3?

Gavo34
15 Jul 2016, 18:57
Impex didn't import the firstpostid, lastpostid, lastpost, postuserid and lastposter for some reason so I had to manually create some queries to port it over from the post table.
Also in the post table, the visible column was all set to 0 which means only administrators were able to see threads.

^ May be of use to someone else in the future.


Hi, What queries did you need to run to add missing data?

I'm running a test convert and have the same problem, Strange such a expensive CMS doesn't maintain converters.

https://www.vbulletin.org/forum/external/2016/07/9.png



Thanks

Dave
15 Jul 2016, 19:43
Hi, What queries did you need to run to add missing data?

I'm running a test convert and have the same problem, Strange such a expensive CMS doesn't maintain converters.

https://www.vbulletin.org/forum/external/2016/07/9.png



Thanks

If you have some knowledge of SQL queries, take a look at the thread and post table, some data in the post table can be used in the thread table and vice versa. You can create some basic queries based on those 2 tables.

TheLastSuperman
20 Jul 2016, 05:38
Hi, What queries did you need to run to add missing data?

I'm running a test convert and have the same problem, Strange such a expensive CMS doesn't maintain converters.

https://www.vbulletin.org/forum/external/2016/07/9.png



Thanks

If you still have copies of your database and have not finalized this import i.e. made it public yet (test environment I'm assuming) then you should start over IF you went from phpBB3 to vB4 that is. Basically vB3 is more similar and closer in nature to phpBB3, so you have access to your vB5 Connect license, which also allows download and use of vB3 and vB4 (only one at a time per domain though i.e. you can run vB3, 4, or 5 but only one not all on one domain etc etc) and can import into vB3 then upgrade to vB4.

- Install vB3, import from phpBB3 to vB3 using impex.
- Now with your data imported to vB3, you simply upgrade to vB4 ;).

*Anytime someone is coming from an older software, it would be best to follow this method i.e. import from older software using impex into a vB3 instance, then once data is in, simply upgrade to vB4 = less issues.

Ds3Sport
28 Apr 2017, 19:58
That only works if your importing a version of phpbb that is below 3.1

The move to 3.1 changed many things and these do not get brought across by impex because the phpbb importer within it has not been updated since phpbb 3.0.3

benFF
11 Feb 2019, 16:20
The solution is a lot simpler than this, change line 120 in the file "systems/phpBB3/008.php" from


$try->set_value('nonmandatory', 'visible', $data["post_approved"]);


to


$try->set_value('nonmandatory', 'visible', $data["post_visibility"]);

Impex doesn't update the firstpostid, lastpostid, lastpost and lastposter fields - this is done when you run the "Rebuild Thread Information" update counter.

But because that field wasn't correct, all the posts were being imported as hidden - therefore the thread counter update was ignoring them :)