• Hello Guest, we are proud to now have our Wiki online that is completely compiled and written by our members. Feel free to browse our Jeep-CJ Wiki or click on any orange keyword when looking at posts in the forum.

Important Ooop errors and broken links

Important Ooop errors and broken links

CJ

Admin
Posts
23,079
Featured
5
Media
897
Resources
193
Solutions
48
Thanks
812
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. :chug: :dbanana:

LOL - Next time I'll "Just Click A Button"! :)
 
After reading that I need a beer.....


Sent from right here.......
 
Ah Bach.

Sent from my SM-G965U using Tapatalk
 
Ah Bach.

Sent from my SM-G965U using Tapatalk
Gotta be of a certain age and particular sense of humor to understand my post.

Sent from my SM-G965U using Tapatalk
 
Has to be a Radar O’reilly quote!!!
 
To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

4077 all the way... :)
 

Jeep-CJ Donation Drive

Help support Jeep-CJ.com by making a contribution.

Help support Jeep-CJ.com by making a contribution.
Goal
$200.00
Earned
$0.00
This donation drive ends in
0 hours, 0 minutes, 0 seconds
  0.0%
Back
Top Bottom