vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=320344

phpbb3 to vb4 impex issues
by 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

Quote:

Originally Posted by Zachery (Post 2555713)
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

Quote:

Originally Posted by Dave (Post 2555736)
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 25 Sep 2015 at 14:25 ---------------

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

Quote:

Originally Posted by chikuru (Post 2555720)
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

Quote:

Originally Posted by Zachery (Post 2555822)
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

Quote:

Originally Posted by Dave (Post 2555799)
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


All times are GMT. The time now is 23:57.

Powered by vBulletin® Version 3.8.13
Copyright © 2019, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.