Print Page | Close Window

Importing Members stops at 767 records

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24224
Printed Date: 06 April 2026 at 10:58pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Importing Members stops at 767 records
Posted By: dan74
Subject: Importing Members stops at 767 records
Date Posted: 20 August 2007 at 5:15pm
Hi,

my first post...

I'm looking at upgrading a very old version of webwiz forums (around about version 5 or 4) to version 9. Not actually upgrading - I don't think that would be possible but we do want to preserve all the usernames and passwords.

Trying to use the import tool to copy username, password, author_email and no_of_posts from the really old tblAuthor to the new database.

It consistently stops after 767 records though (there are 84,000 in my database). I was using 9.0.0, but just upgraded to 9.0.3 - it still does the same thing. Doesn't report an error, just gets to 767 members processed and stops.

If I try the import again (without deleting the imported records) it simply skips the first 767 records then stops at the same place. I can delete the imported records and I get the same thing.

There are 5 users already in the database. The databases are on the same server.

But also, when I try to log in with one of the imported user's username and password, that doesn't work Cry. The email addresses are imported ok (in version 9.0.3 - not in 9.0.0).

Any ideas welcome!
Thanks.




-------------
---
Danny



Replies:
Posted By: dfrancis
Date Posted: 20 August 2007 at 7:18pm
Check the record 767 or 768 for anomalies that may be breaking the import. Sometimes there is a null field or erroneous quote that screws things up.

-------------
“If you want things to be different, you must be willing to do different things!” http://www.DavidFrancis.org/?wwf=signature" rel="nofollow - David Francis





Posted By: dan74
Date Posted: 20 August 2007 at 8:28pm
Thanks David.

Not really easy to tell what the 768th record is but it's processing past that now.

Has anyone any suggestions about the passwords not working? The password column looks like it's populated ok, just when I try logging in with any of the old usernames and password always fail.


-------------
---
Danny


Posted By: dan74
Date Posted: 20 August 2007 at 8:34pm
The import broke again on 2985, but I have just noticed right at the very bottom of the page a little error code:

error '80020009'

/testarea/forum/admin_import_members.asp, line 461

So I'll investigate around there but I suspect it will only indicate another record with unexpected content.


-------------
---
Danny



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net