Important Ooop errors and broken links
CJ
Admin
- Posts
- 21,684
- Thanks
- 617
- Location
- Central FL
- Vehicle(s)
- '72 CJ5, 401, T18, D20, D44, D30
'82 CJ8, 258, D300, AMC20, D30
Well, I did a lot of checking, db browsing and writing code to dump missing threads and posts. I found all the broken threads and posts in the old vBulletin data base.
I have to continue to write code and clean up the sql import files.
This is what I need to do (I think.)
I chose to write some code in VB mainly because I was just looking to do some quick text manipulation and VB can run undeclared variables as well as full variant variables (sloppy code but I wasn't ready to spend days on this.)
1) As in post #14 - item #3, extracted thread id's from SQL file of xf_thread but use criteria of A=0 first post id's, B=0 last post id's and C=0 first and last post id's.
2) Removed from the array any duplicate id's that satisfied multiple criteria of #1.
3) Deleted entries in xf_thread sql file that were saved from #2. (don't need this but already had data handy)
4) Parsed vb thread sql file and found all thread id's from #2.
5) Verified all had non 0 or null first and last post id's.
6) Extracted all vb thread rows that matched #4.
7) Created new sql file and put all vb thread rows from # into the new sql file.
8) Extracted all vb post rows that matched threadid from #4.
9) Created new sql file and put all vb post rows from #8 into the new sql file.
I think my next step is to:
1) Get the 2 sql file(s) setup for import (formatted correctly)
2) Remove xf_thread rows from db that match #4 (if needed.)
3) Remove xf_post rows from db that match #4 (i needed.)
4) Import 2 sql files for new thread and post tables but format for xf from vb.
So, I know it to much info but I am working on it.
LOL - Next time I'll "Just Click A Button"!
I have to continue to write code and clean up the sql import files.
This is what I need to do (I think.)
I chose to write some code in VB mainly because I was just looking to do some quick text manipulation and VB can run undeclared variables as well as full variant variables (sloppy code but I wasn't ready to spend days on this.)
1) As in post #14 - item #3, extracted thread id's from SQL file of xf_thread but use criteria of A=0 first post id's, B=0 last post id's and C=0 first and last post id's.
2) Removed from the array any duplicate id's that satisfied multiple criteria of #1.
3) Deleted entries in xf_thread sql file that were saved from #2. (don't need this but already had data handy)
4) Parsed vb thread sql file and found all thread id's from #2.
5) Verified all had non 0 or null first and last post id's.
6) Extracted all vb thread rows that matched #4.
7) Created new sql file and put all vb thread rows from # into the new sql file.
8) Extracted all vb post rows that matched threadid from #4.
9) Created new sql file and put all vb post rows from #8 into the new sql file.
I think my next step is to:
1) Get the 2 sql file(s) setup for import (formatted correctly)
2) Remove xf_thread rows from db that match #4 (if needed.)
3) Remove xf_post rows from db that match #4 (i needed.)
4) Import 2 sql files for new thread and post tables but format for xf from vb.
So, I know it to much info but I am working on it.
LOL - Next time I'll "Just Click A Button"!
