Web Wiz Support and Community Forums : Importing Members stops at 767 records https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 23:06:22 +0000 Mon, 20 Aug 2007 20:34:10 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24224 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Importing Members stops at 767 records : The import broke again on 2985,...]]> https://forums.webwiz.net/importing-members-stops-at-767-records_topic24224_post126730.html#126730 Author: dan74
Subject: 24224
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.
]]> Mon, 20 Aug 2007 20:34:10 +0000 https://forums.webwiz.net/importing-members-stops-at-767-records_topic24224_post126730.html#126730 <![CDATA[Importing Members stops at 767 records : Thanks David.Not really easy to...]]> https://forums.webwiz.net/importing-members-stops-at-767-records_topic24224_post126729.html#126729 Author: dan74
Subject: 24224
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.
]]> Mon, 20 Aug 2007 20:28:01 +0000 https://forums.webwiz.net/importing-members-stops-at-767-records_topic24224_post126729.html#126729 <![CDATA[Importing Members stops at 767 records : Check the record 767 or 768 for...]]> https://forums.webwiz.net/importing-members-stops-at-767-records_topic24224_post126727.html#126727 Author: dfrancis
Subject: 24224
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.]]> Mon, 20 Aug 2007 19:18:10 +0000 https://forums.webwiz.net/importing-members-stops-at-767-records_topic24224_post126727.html#126727 <![CDATA[Importing Members stops at 767 records : Hi,my first post...I&#039;m looking...]]> https://forums.webwiz.net/importing-members-stops-at-767-records_topic24224_post126720.html#126720 Author: dan74
Subject: 24224
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.


]]> Mon, 20 Aug 2007 17:15:41 +0000 https://forums.webwiz.net/importing-members-stops-at-767-records_topic24224_post126720.html#126720