Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Changed username but srange happenings...
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Changed username but srange happenings...
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
bims View Drop Down
Groupie
Groupie
Avatar

Joined: 03 May 2004
Location: United Kingdom
Status: Offline
Points: 115 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bims Quote  Post ReplyReply Direct Link To This Post Topic: Changed username but srange happenings...
    Posted: 17 February 2005 at 5:42am
Right, greetings to all!

I changed a username this morning and now it's playing up on my. Bascially the new username starts with a C but when the member list is arranged in alphabetical order it comes on top, and when i run a search for the username it cannot be found even though it appears on the memberlist.

I've tried putting a space in front of the username when searching but that has not helped. So i can see it but cannot make changes to it.

Anyone experienced this before?

TIA

Bims
Back to Top
bims View Drop Down
Groupie
Groupie
Avatar

Joined: 03 May 2004
Location: United Kingdom
Status: Offline
Points: 115 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bims Quote  Post ReplyReply Direct Link To This Post Posted: 17 February 2005 at 8:33am
I downloaded the db and the username field for that person appeared blank.

I typed in the new username and uploaded the database. Now it's showing the username twice eg "username username".

If i search for 'use' for eg it brings up "username username" which i select from the dropdown box and it changes back to "username" Then it tells me that it cannot find any such user.
???
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 17 February 2005 at 8:50am
Sounds like a corrupted database which is common with Acess.

Hopefully you can save it using the compact and repair tool in Acess, better still use SQL Server
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
bims View Drop Down
Groupie
Groupie
Avatar

Joined: 03 May 2004
Location: United Kingdom
Status: Offline
Points: 115 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bims Quote  Post ReplyReply Direct Link To This Post Posted: 17 February 2005 at 9:02am
Hmm, ok I'll try the compact and repair. Regarding SQL, i do have access to SQL server as part of my hosting but i'm not quite sure how it works...plus i'm using three of your applications (news, guestbook and forum) and ideally i'd like all apps to be SQLed. I'm not  sure how this would work... 1 SQL database hold many databases apps? sorry - i've never worked with SQL before Confused

Are there straightforward tutorials regarding migration? I saw a thread that on this form where someone attempted to draw up the steps but it seems a few people where having errors.
Back to Top
bims View Drop Down
Groupie
Groupie
Avatar

Joined: 03 May 2004
Location: United Kingdom
Status: Offline
Points: 115 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bims Quote  Post ReplyReply Direct Link To This Post Posted: 17 February 2005 at 12:01pm
Compact and Repair worked.

any tips on migrating to SQL?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 17 February 2005 at 12:07pm
See the sticky topic in this forum.
Web Wiz Forums Hosting
ASP.NET Web Hosting
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.