| Author |
Topic Search Topic Options
|
MrMellie
Senior Member
Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
|
Post Options
Thanks(0)
Quote Reply
Topic: Wish me luck.... Posted: 13 May 2007 at 9:00pm |
Tonight I'm shutting down our old Snitz forum and running the conversion over to WWF!
I've already done a trial run, let's hope the real thing goes ok.
|
 |
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 May 2007 at 7:46pm |
Good luck, let us know it goes
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
 |
MrMellie
Senior Member
Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 May 2007 at 9:49pm |
Badly. :(
Have to have two swipes at it after I realised the script I was using was ommiting users who hadn't made any posts.
Now the default page and main forum pages are showing wrong topic starter and last poster username, but within the thread the usernames are correct. Aaargh! 
|
 |
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 May 2007 at 10:17pm |
Opps... now I hope you had everything backed up... or?
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
 |
MrMellie
Senior Member
Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 May 2007 at 11:17pm |
Oh yes, plenty of backups and I never work on the live system, it's all done locally and then put back to the server.
Just figuring out where it screwed up. It's ok on SQL, but not after downsizing to Access, which I need to use until I can sort out another host. 
|
 |
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 May 2007 at 11:32pm |
|
Downsizing from SQL to Access will mess things up. I've tried it before... it worked for existing users...but not new ones.
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
 |
MrMellie
Senior Member
Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 May 2007 at 1:25am |
How do you mean it won't work for new users?
Sorted my problem, it was dodgy indexs on the thread table. Instead of exporting from SQL, I had to import from Access so the ID field came through as an autonumber. So far it seems to be ok........
Edited by MrMellie - 15 May 2007 at 1:25am
|
 |
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 May 2007 at 9:54pm |
MrMellie wrote:
How do you mean it won't work for new users? |
new users could not register.
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
 |