Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Wish me luck....
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Wish me luck....

 Post Reply Post Reply
Author
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post 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! Big%20smile
 
I've already done a trial run, let's hope the real thing goes ok.
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140
Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Posted: 14 May 2007 at 7:46pm
Good luck, let us know it goes Big%20smile
"When it gets dark enough, you can see the stars"
-Charles A. Beard
Back to Top
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post 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! Cry
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140
Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post 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. Confused
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140
Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140
Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Posted: 15 May 2007 at 9:54pm
Originally posted by MrMellie 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.