Migrating From Snitz - LETS WORK THIS OUT
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=16577
Printed Date: 29 March 2026 at 2:48am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Migrating From Snitz - LETS WORK THIS OUT
Posted By: MortiOli
Subject: Migrating From Snitz - LETS WORK THIS OUT
Date Posted: 16 September 2005 at 3:45pm
|
I know a lot of people are wanting to convert from Snitz to WWF, with me being one of them. We were so close to having a small program to convert everything over from db to db, but MichaelItaly suddenly vanished, and has never returned
Because of this, I thought I'd get down and dirty, and try the codes which people have posted, one being a piece which works for most, but not those who have deleted members - created by Satellite.
Now if we can put our heads together and work round the problem with deleted members (due to the code not liking missing Autonumber / Author_ID), we'll have a finished product to finally help convert people over!
Starting from where people left off, here's how to convert over, followed by the problem faced with deleted members;
<%
Server.ScriptTimeout = 500 'in seconds. many posts means higher number Set Conn = Server.CreateObject("ADODB.Connection")
Response.Write "Moving all the users...<br>" SQL = "SELECT M_NAME, M_EMAIL, M_SIG, M_PASSWORD, M_DATE, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_FIRSTNAME, M_LASTNAME, M_LASTHEREDATE, M_DOB, M_OCCUPATION, M_POSTS, MEMBER_ID FROM FORUM_MEMBERS ORDER BY MEMBER_ID ASC" Set rsIns = Server.CreateObject("ADODB.RecordSet") do until rs.eof |
Replies:
Posted By: dj air
Date Posted: 16 September 2005 at 6:42pm
|
so its something to do with this part do until rs.eof If(IDvalue = rs("MEMBER_ID")) Then rsIns.AddNew rsIns.Fields("Username") = rs("M_NAME") rsIns.Fields("Author_email") = rs("M_EMAIL") rsIns.Fields("Signature") = rs("M_SIG") rsIns.Fields("Password") = Left(rs("M_PASSWORD"),50) 'rsIns.Fields("Date_format") = "dd/mm/yy" rsIns.Fields("User_code") = rs("M_NAME") & UCase(Right(Left(rs("M_PASSWORD"),20),12)) rsIns.Fields("Time_offset") = "+" rsIns.Fields("Time_offset_hours") = "0" rsIns.Fields("Join_Date") = CDate(createDate(rs("M_Date"))) rsIns.Fields("MSN") = rs("M_MSN") rsIns.Fields("ICQ") = rs("M_ICQ") rsIns.Fields("AIM") = rs("M_AIM") rsIns.Fields("YAHOO") = rs("M_YAHOO") rsIns.Fields("Show_Email") = True rsIns.Fields("Real_Name") = rs("M_FIRSTNAME") & " " & rs("M_LASTNAME") rsIns.Fields("Last_visit") = CDate(createdate(rs("M_LASTHEREDATE"))) ' rsIns.Fields("DOB") = CDate(convertDOB(rs("M_DOB"))) rsIns.Fields("Occupation") = rs("M_OCCUPATION") rsIns.Fields("No_of_posts") = rs("M_POSTS") SQL = "SELECT Group_ID FROM tblGroup WHERE Minimum_posts <= " & rs("M_POSTS") & " ORDER BY Minimum_posts DESC" set rsGroup = conn.execute(SQL) rsIns.Fields("Group_ID") = rsGroup("Group_ID") rsIns.Update rs.moveNext idValue = idValue + 1 else rsIns.AddNew rsIns.Fields("Username") = idValue rsIns.Fields("Password") = idValue rsIns.Fields("User_code") = idValue SQL = "DELETE * FROM tblAuthor WHERE username = '" & idValue & "'" set rsDel = conn.execute(SQL) IDValue = IDValue + 1 End if Loop set rsGroup = nothing rsIns.Close what is on line 72 of the file can i guess its the part either where you get the group ID (marked in ref above) OR you are trying to insert a record without a group ID value, just guessing here |
Posted By: MortiOli
Date Posted: 17 September 2005 at 3:18am
|
Ah, I knew I'd forgotten something!
Line 72 is highlighted below;
do until rs.eof
If(IDvalue = rs("MEMBER_ID")) Then rsIns.AddNew rsIns.Fields("Username") = rs("M_NAME") rsIns.Fields("Author_email") = rs("M_EMAIL") rsIns.Fields("Signature") = rs("M_SIG") rsIns.Fields("Password") = Left(rs("M_PASSWORD"),50) 'rsIns.Fields("Date_format") = "dd/mm/yy" rsIns.Fields("User_code") = rs("M_NAME") & UCase(Right(Left(rs("M_PASSWORD"),20),12)) rsIns.Fields("Time_offset") = "+" rsIns.Fields("Time_offset_hours") = "0" rsIns.Fields("Join_Date") = CDate(createDate(rs("M_Date"))) rsIns.Fields("MSN") = rs("M_MSN") rsIns.Fields("ICQ") = rs("M_ICQ") rsIns.Fields("AIM") = rs("M_AIM") rsIns.Fields("YAHOO") = rs("M_YAHOO") rsIns.Fields("Show_Email") = True rsIns.Fields("Real_Name") = rs("M_FIRSTNAME") & " " & rs("M_LASTNAME") rsIns.Fields("Last_visit") = CDate(createdate(rs("M_LASTHEREDATE"))) ' rsIns.Fields("DOB") = CDate(convertDOB(rs("M_DOB"))) rsIns.Fields("Occupation") = rs("M_OCCUPATION") rsIns.Fields("No_of_posts") = rs("M_POSTS") SQL = "SELECT Group_ID FROM tblGroup WHERE Minimum_posts <= " & rs("M_POSTS") & " ORDER BY Minimum_posts DESC" set rsGroup = conn.execute(SQL) rsIns.Fields("Group_ID") = rsGroup("Group_ID") rsIns.Update rs.moveNext idValue = idValue + 1 else rsIns.AddNew rsIns.Fields("Username") = idValue rsIns.Fields("Password") = idValue rsIns.Fields("User_code") = idValue SQL = "DELETE * FROM tblAuthor WHERE username = '" & idValue & "'" set rsDel = conn.execute(SQL) IDValue = IDValue + 1 End if Loop set rsGroup = nothing rsIns.Close Sorry about that
 |
Posted By: dj air
Date Posted: 17 September 2005 at 12:49pm
|
iu would say the issue is that you are not adding a input ffor all the required fields like group_ID, active, email_show etc they are all required for an input, manually set |
Posted By: MortiOli
Date Posted: 17 September 2005 at 1:25pm
|
Any ideas what would fix that? I'm not clued up with ASP unfortunately I only know the very basics.
|
Posted By: dj air
Date Posted: 17 September 2005 at 3:24pm
|
each of the below requires a value rsIns.Fields("Username") = rs("M_NAME") rsIns.Fields("Author_email") = rs("M_EMAIL") rsIns.Fields("Signature") = rs("M_SIG") rsIns.Fields("Password") = Left(rs("M_PASSWORD"),50) 'rsIns.Fields("Date_format") = "dd/mm/yy" rsIns.Fields("User_code") = rs("M_NAME") & UCase(Right(Left(rs("M_PASSWORD"),20),12)) rsIns.Fields("Time_offset") = "+" rsIns.Fields("Time_offset_hours") = "0" rsIns.Fields("Join_Date") = CDate(createDate(rs("M_Date"))) rsIns.Fields("MSN") = rs("M_MSN") rsIns.Fields("ICQ") = rs("M_ICQ") rsIns.Fields("AIM") = rs("M_AIM") rsIns.Fields("YAHOO") = rs("M_YAHOO") rsIns.Fields("Show_Email") = True rsIns.Fields("Real_Name") = rs("M_FIRSTNAME") & " " & rs("M_LASTNAME") rsIns.Fields("Last_visit") = CDate(createdate(rs("M_LASTHEREDATE"))) ' rsIns.Fields("DOB") = CDate(convertDOB(rs("M_DOB"))) rsIns.Fields("Occupation") = rs("M_OCCUPATION") rsIns.Fields("No_of_posts") = rs("M_POSTS") note the rs(" is copied, you need ot set posts = 0 , show email = 0/false, time offset hours = 0 time offset = "+" you just need ot make sure that the list for else has the above fields with a value apart from the messengers |
Posted By: MortiOli
Date Posted: 18 September 2005 at 5:54am
|
Sorry, I'm not too sure I understand.
I realise that some of fields require something to be input into them, and not left blank. Do you mean that when it adds a blank record (to replace a deleted member), it needs to add something for all the required fields. Ie, this part needs a couple more things adding;
rsIns.AddNew
rsIns.Fields("Username") = idValue rsIns.Fields("Password") = idValue rsIns.Fields("User_code") = idValue SQL = "DELETE * FROM tblAuthor WHERE username = '" & idValue & "'" set rsDel = conn.execute(SQL) IDValue = IDValue + 1 End if |
Posted By: dj air
Date Posted: 18 September 2005 at 8:20am
|
that is correct all the felds in my perious post, need to be within the adding section (bit you stated), as they are required even if its 0, |
Posted By: MortiOli
Date Posted: 18 September 2005 at 8:51am
|
Okie doke.
I modified the code to the below;
else
rsIns.AddNew rsIns.Fields("Username") = idValue rsIns.Fields("Author_email") = idValue rsIns.Fields("Signature") = idValue rsIns.Fields("Password") = idValue rsIns.Fields("User_code") = idValue rsIns.Fields("Time_offset") = "+" rsIns.Fields("Time_offset_hours") = "0" rsIns.Fields("Join_Date") = idValue rsIns.Fields("MSN") = idValue rsIns.Fields("ICQ") = idValue rsIns.Fields("AIM") = idValue rsIns.Fields("YAHOO") = idValue rsIns.Fields("Show_Email") = False rsIns.Fields("Real_Name") = idValue rsIns.Fields("Last_visit") = idValue rsIns.Fields("Occupation") = idValue rsIns.Fields("No_of_posts") = idValue SQL = "SELECT Group_ID FROM tblGroup WHERE Minimum_posts <= " & rs("M_POSTS") & " ORDER BY Minimum_posts DESC" set rsGroup = conn.execute(SQL) rsIns.Fields("Group_ID") = rsGroup("Group_ID") rsIns.Update SQL = "DELETE * FROM tblAuthor WHERE username = '" & idValue & "'" set rsDel = conn.execute(SQL) IDValue = IDValue + 1 End if This will mean that it'll update each field with the idValue, like it was doing for the username etc - except time_offset and time_offset_hours, which have been set to update with '+' and '0', and show_email which has been set to 'false'.
However, when I run it, I get the following error;
ADODB.Recordset error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /wwf/forum/admin/database/convert.asp, line 92
Line 92 has been highlighted red in the code above. Is there something I'm doing wrong? I realise that in that part it's matching the post count to the relevant ranking group in tblGroup.
|
Posted By: dj air
Date Posted: 18 September 2005 at 8:57am
|
it means no record was returned, from the group table. if the member was deleted wouldn't their post count = 0 ? as M_Posts would not exist, |
Posted By: Duby
Date Posted: 22 September 2005 at 8:14am
|
Hi, I would like also to convert Snitz to WWW...
Thank you for trying
 ! I will help a little (I am new to all this so) but I ll try to learn fast.
Have you tried to write something in those empty (deleted users) fields in Access, manually,? Only to see if it works?
Or, can we change all the empty fields with query in Access to some value (for example if the value is empty then value = 3,14), then run a script and after that we should delete all the values in WWW database that we have manually entered in SF databese empty records (delete all the 3,14 values)?
Sorry if it is a stupid idea, but...
|
Posted By: Duby
Date Posted: 22 September 2005 at 9:25am
Does it work for those who have never deleted a member? Or you still don“t know?
|
MortiOli wrote:Posted By: dj air
Date Posted: 22 September 2005 at 11:23am
|
i have worked on this with MortiOli and we have managed to get a script that will do so. we also have added the feature where all existing passwords will work.. i have left it with MortiOli, he has a fully working version |
Posted By: Duby
Date Posted: 23 September 2005 at 4:06am
You did??? Oh...
I would realy like to see how did you do that!
Thank you very much! |
Posted By: Duby
Date Posted: 23 September 2005 at 1:41pm
I have sent MartiOli PM, but nothing from him...So, I“ll have to do it...
|
Posted By: Duby
Date Posted: 24 September 2005 at 2:05pm
|
OK, no replay, no help from experts... So, I am searching for someone who wants to help me with this script...?
Somehow it looks like all the persons that have managed to migrate from snitz to wwf disappeared. Is this a story for X-files?  ------------- Duby |
Posted By: dj air
Date Posted: 24 September 2005 at 3:33pm
|
i will have a look within the server but i can't be sure i still have it. |
Posted By: Duby
Date Posted: 24 September 2005 at 4:48pm
Thank you! ------------- Duby |
Posted By: dj air
Date Posted: 24 September 2005 at 7:39pm
|
i have found this zip, i am not 100% its ok but think it is just uplaod to the forum root folder and insert the file within the includes folder please convert.asp in the database folder and then go ot the url that will then do the converstion. make sure you have both da6abases tables the wwf tables and snitz tables then run that file and it will move them into the wwf tables. please use at your own risk http://www.emaginehosts.com/files.zip - download |
Posted By: Duby
Date Posted: 25 September 2005 at 7:58am
|
Thank you!
Is that all I need to do, or should I do and what has MortiOli written in his first post also? ------------- Duby |
Posted By: dj air
Date Posted: 25 September 2005 at 12:14pm
|
you should only eed to make sure that both forum database tables are in the same DB, and run the convert file you then just need to uplaod the other 2 files to allow for Snitz password encryption to work |
Posted By: MortiOli
Date Posted: 26 September 2005 at 2:36am
| Sorry for not posting the script sooner (been a bit busy etc). I've got to go to work in a couple of mins, but tonight I'll check the files that dj air has uploaded, to make sure they were the final versions. |
Posted By: Duby
Date Posted: 26 September 2005 at 5:15am
|
Moving all the users... Moved all the users... Moving Categorķes... Moved all Categorķes... Moving all Forums... ADODB.Recordset error '800a0cc1'Item cannot be found in the collection corresponding to the requested name or ordinal. /testforum/convert.asp, line 191 Any ideas what is wrong? I have both tables in the same database...------------- Duby |
Posted By: Duby
Date Posted: 26 September 2005 at 5:18am
Ok! Thank you... ------------- Duby |
Posted By: Duby
Date Posted: 26 September 2005 at 6:24am
|
I have database folder in a different folder then /forum/admin/database...But I have changed database url in convert.asp.
But, could that be a problem? ------------- Duby |
Posted By: dj air
Date Posted: 26 September 2005 at 12:42pm
|
can you paste whats on that line please. it is because a field you are tring to use doesn't exist or within the query |
Posted By: Duby
Date Posted: 26 September 2005 at 1:15pm
|
'we must also check for missing sequence numbers.. hence the IF rsIns.Fields("Forum_name") = rs("F_SUBJECT")
rsIns.Fields("Forum_descriptio n") = rs("F_DESCRIPTION")
rsIns.Fields("No_of_topics") = rs("F_TOPICS") rsIns.Fields("No_of_posts") = rs("F_COUNT") rsIns.Fields("Cat_ID") = CInt(rs("CAT_ID")) rsIns.Update rs.MoveNext IDValue = IDValue + 1 Else This is the problem...Hmmm...
 ------------- Duby |
Posted By: dj air
Date Posted: 26 September 2005 at 1:43pm
| ok either forum_name is not within the table but should be, or the F_Subject doesn't exist |
Posted By: Duby
Date Posted: 26 September 2005 at 2:05pm
|
rsIns.Fields("Forum_descriptio n") = rs("F_DESCRIPTION") Or this is line 191 and there is a space between o and n...?? ------------- Duby |
Posted By: dj air
Date Posted: 26 September 2005 at 2:16pm
that would be the issue...lol
|
Posted By: MortiOli
Date Posted: 26 September 2005 at 2:22pm
|
Here are the full and finished files;
http://www.emotive-designs.co.uk/Snitz_WWF.zip - Snitz To WWF
Please read the comments at the top of convert.asp for instructions;
' ' Originally written by Satellite ' ' Edited and finalised by OJM (Oli Mortimer) and dj air (Aaron Hockaday) ' ' *** PLEASE NOTE THAT WE DO NOT TAKE ANY RESPONSIBILTY FOR ANY LOSS OR CORRUPTION OF DATA *** ' ' Download and install WWF and login as Admin ' Set up the ranking groups in the Admin panel, for what title / stars people receive for X number of posts, to match those in your Snitz db ' Open up your WWF db in Access, and import the following tables from your Snitz db, by going to 'File / Get External Data / Import'; ' forum_category ' forum_forum ' forum_members ' forum_reply ' forum_topics ' Open up 'tblAuthor' and delete the 2 records ' Compact the db to reset the Autonumber in 'tblAuthor' by going to 'Tools / Database Utilities / Compact and Repair Database...' ' - this saves you having to copy the structure and relationships etc ' ' *** Backup the database so you don't have to do the above again! *** ' ' Config the db location on line 43, and run the following script in an .asp page ' Upload inc_sha256.asp into the /includes folder (to allow old Snitz pwords to work) ' Upload and replace login_user.asp and register.asp into the root forum folder (to allow old Snitz pwords to work) ' ' There you have it, complete! ' '**************************************************** |
Posted By: Duby
Date Posted: 26 September 2005 at 2:48pm
|
Moving all the users... Moved all the users... Moving Categorśs... Moved all Categorśs... Moving all Forums... Moved all Forums... Moving all Topics... Moved all Topics... Moving all Posts... Microsoft JET Database Engine error '80040e21'You cannot add or change a record because a related record is required in table 'tblAuthor'. /testforum/convert.asp, line 270 Code:
Do Until rs.EOF
rsIns.AddNew rsIns.Fields("Topic_ID") = rs("TOPIC_ID") rsIns.Fields("Author_ID") = rs("T_AUTHOR") rsIns.Fields("Message") = rs("T_MESSAGE") rsIns.Fields("Message_date") = CDate(createDate(rs("T_DATE"))) rsIns.Fields("IP_addr") = rs("T_IP") rsIns.Update rs.MoveNext Loop Another problem...Hm...
------------- Duby |
Posted By: dj air
Date Posted: 26 September 2005 at 3:06pm
|
not sure why there would be an issue with that line as its not referanced to any other field you sure its not the author line as that is refranced within that one. oli are you sure that compacting resets it to 0, i didn't think it did. that could be the issue where the Author_ID doesn't exsit within the authopr table as its offset buy the first to orginal accounts |
Posted By: Duby
Date Posted: 26 September 2005 at 3:13pm
|
Thank you MortiOli...I have the same problem again... Moving all the users...
Moved all the users... Moving Categorķes... Moved all Categorķes... Moving all Forums... Moved all Forums... Moving all Topics... Moved all Topics... Moving all Posts... Microsoft JET Database Engine error '80040e21'You cannot add or change a record because a related record is required in table 'tblAuthor'. /testforum/convert.asp, line 270 I ll try it tomorow...I must do this step by step from the begining...I really don“t know what could be wrong...  ------------- Duby |
Posted By: dj air
Date Posted: 26 September 2005 at 4:01pm
|
can you use the back up database that has not been touched and 1. delete the 2 records within the Author table 2. Compact the database and then try adding a new record manually and let us know what ID that record has. if motoli is right it should be 1 or 3 if that fails try using a database with those two records and start from there... without deleting those 2 records. i believe the issue is that a record doesn't exist within the author table where it should do. |
Posted By: MortiOli
Date Posted: 26 September 2005 at 4:07pm
|
We've overlooked something though...it's not a problem with the tblAuthor table, it's to do with the posts table;
Moving all the users...
Moved all the users... Moving Categorķes... Moved all Categorķes... Moving all Forums... Moved all Forums... Moving all Topics... Moved all Topics... Moving all Posts... ERROR
It looks like it's getting to a post which doesn't have an IP address set against it. Have a look in your post table, and see what the last ID is. Then go into your Snitz db, into the post table, then look at the next ID (the last one which was attempted to be imported into the WWF db).
|
Posted By: dj air
Date Posted: 26 September 2005 at 4:26pm
|
actually it is the author table ------------------- Microsoft JET Database Engine error '80040e21' You cannot add or change a record because a related record is required in table 'tblAuthor'. /testforum/convert.asp, line 270
i would say it is because as i said an author ID is not relating with the author table., and therefore returns an error this is because a record needs to be within the author table for the relationship to work else you get the above error. |
Posted By: MortiOli
Date Posted: 26 September 2005 at 4:33pm
|
Hmm, good point, I see what you mean. A post is trying to be added to a topic, but it can't see the link to an author that exists in tblAuthor? That's weird, because when you delete a member (in Snitz), who has posts, the author is kept but changed to 'n/a' so the posts can still relate to someone. Thinking along the lines of the above, and asking Duby to test the ID numbers; They could all be out by 2 (if the compacting hasn't reset the ID's), so the post is relating to nothing...if that makes sense. I'm just thinking out loud at the moment
 |
Posted By: Duby
Date Posted: 27 September 2005 at 4:28am
|
Good morning...
1. I have followed MortiOli“s instructions and:
Moving all the users...
Moved all the users... Moving Categorķes... Moved all Categorķes... Moving all Forums... Microsoft JET Database Engine error '80040e21'Field 'tblForum.Forum_description' cannot be a zero-length string. /testforum/convert.asp, line 193 ------------- Duby |
Posted By: Duby
Date Posted: 27 September 2005 at 4:39am
|
So, there were no problems with tblAuthor, with or without two records it was the same.
Another thing...My topics are now in inversed order...First at SnitzF is last at WWF...
But, Field 'tblForum.Forum_description' cannot be a zero-length string. ?? I ll try to set Allow zero lenght = "Yes"... ------------- Duby |
Posted By: Duby
Date Posted: 27 September 2005 at 4:41am
|
Now...
Moving all the users...
Moved all the users... Moving Categorķes... Moved all Categorķes... Moving all Forums... Moved all Forums... Moving all Topics... Moved all Topics... Moving all Posts... Microsoft JET Database Engine error '80040e21'You cannot add or change a record because a related record is required in table 'tblAuthor'. /testforum/convert.asp, line 268 I saw that somewhere... ------------- Duby |
Posted By: Duby
Date Posted: 27 September 2005 at 4:46am
|
Ok, interesting thing...When I converted database (I have deleted two records) in tblAuthor first Author_ID = 3 ??? ------------- Duby |
Posted By: Duby
Date Posted: 27 September 2005 at 4:56am
|
Sorry for so many posts, but...
Ok, final post:
This happend when I didn“t delete two members in tblAuthor (now Author_ID is ok) and when I changed Allow zero lenght to Yes in tblForum_Forum_description:
Moving all the users...
Moved all the users... Moving Categorķes... Moved all Categorķes... Moving all Forums... Moved all Forums... Moving all Topics... Moved all Topics... Moving all Posts... Microsoft JET Database Engine error '80040e21'You cannot add or change a record because a related record is required in table 'tblAuthor'. /testforum/convert.asp, line 268 Line 268:
rsIns.Fields("IP_addr") = rs("T_IP")
rsIns.Update
rs.MoveNext
------------- Duby |
Posted By: Duby
Date Posted: 27 September 2005 at 7:12am
Another post??? Oh no!!! 
Now I have another problem:
Moving all the users...
Moved all the users... Moving Categorķes... Moved all Categorķes... Moving all Forums... Moved all Forums... Moving all Topics... Moved all Topics... Moving all Posts... Moved all Posts... Finished! What I did?
1. Download and install WWF and login as Admin
2. Set up the ranking groups in the Admin panel, for what title / stars people receive for X number of posts, to match those in your Snitz db 3. Open up 'tblAuthor' and delete the 2 records
4. Compact the db to reset the Autonumber in 'tblAuthor' by going to Tools / Database Utilities / Compact and Repair Database... - this saves you having to copy the structure and relationships etc 5. Open up your WWF db in Access, and import the following tables from your Snitz db, by going to 'File / Get External Data / Import'; forum_category forum_forum forum_members forum_reply forum_topics 5. Backup the database so you don't have to do the above again! 6. Config the db location on line 43, and run the following script in an .asp page 7. Upload inc_sha256.asp into the /includes folder (to allow old Snitz pwords to work) 8. Upload and replace login_user.asp and register.asp into the root forum folder (to allow old Snitz pwords to work) Because there was a problem with ID autonumbers, I have deleted two members in tblAuthor, compacted and repaired database and then I have imported tables from Snitz database...).
Thank you dj air and MortiOli for your time!
I“ll buy you a drink (or two, or three, or four...) when I come to England.
 ------------- Duby |
Posted By: Duby
Date Posted: 27 September 2005 at 1:24pm
|
I have two more problems...
1. Somehow I can“t control guest“s permissions.
I can set them up in the admin menu, but it looks like the settings have no effect on guest users. For example, I give a guest user permission only to view the forums, but when I try to see forums as guest I can“t see the forums, guest have no rights.
Could it be because I have changed the Guest Group name to Guest only?
2. One user did“t receive his email (I didn“t set up mail account yet, and he did“t receive that email) and now when he wants to login everything is ok but he can“t login. He is logged as guest with no rights of course...Is it because he didn“t receive his email? Or something else...
If you have time to share...? ------------- Duby |
Posted By: dj air
Date Posted: 27 September 2005 at 2:15pm
|
the guest accout should be in group 2 1. check to make sure the guest account is within this group 2. this is probbabbly bnecause they have not recieved an activation email. is the account suspended (check the account status). |
Posted By: Duby
Date Posted: 27 September 2005 at 3:59pm
|
I have three groups of accounts:
1.Administrator: 5 stars, Non Ladder Group, can“t delete
2.Guest: 0 stars, Non Ladder Group, can“t delete
3.Starting Member: 1 star, starting group
Guests can (should) only access to forum, but they can“t...
Why did I have to
Sorry, I have searched and...How can I check the account status?
Membership admin area? I can“t find that nowhere...
And, how can I unsuspend account? (is unsuspend the wright word?) ------------- Duby |
Posted By: Duby
Date Posted: 27 September 2005 at 4:12pm
|
Sorry dj air...
Account Status for this member is set to Active... ------------- Duby |
Posted By: dj air
Date Posted: 27 September 2005 at 6:19pm
|
ok, make sure they are in a group with access priveleges to the forums. and also get them to clear their cookies. when they login does it look like they didn't try or does it say that account is logged in. |
Posted By: Duby
Date Posted: 28 September 2005 at 2:36am
|
Yes, this member is in starting member group. The cookies are cleared.
Yes, it says that account is logged in, but when it goes back to forum it isn“t.
I“ll try to reinstall whole thing and... ------------- Duby |
Posted By: MortiOli
Date Posted: 28 September 2005 at 3:27am
| I think you may need to set all the access permissions for each forum again. Even if they say the access is ok, go into each one and click 'submit'. I think I had this problem on my forum, and just had to re-submit them. |
Posted By: Duby
Date Posted: 28 September 2005 at 4:29am
|
Ok, I have reinstalled Forum (converted database etc.), and now it works fine...
Well, I hope it works fine...
 Gues it was something with converting groups from Snitz to WWF...
Thanks again for Your help dj air!  ------------- Duby |
Posted By: Duby
Date Posted: 28 September 2005 at 2:51pm
|
Hope it works fine?
No, again I have the same problem with the same user account. When he tries to login this is the message:
Successful Login
Your login was successful, please wait while you are returned to the Forum http://humnasutli.inet.hr/forum2/forum_topics.asp?FID=14 - Return to the Discussion Forum And, when he returnes to the Forum it lookes like he is not logged (there is no logoff option).
This user can send posts with any name he wants and the most interesting is that even it lookes like he is not logged and he can post to the Forum with any other name the Forum is displaying wright members name in the Last post section (Last post by: wright member“s name).
I am very confused...This user is like goust, something between logged user and guest...
This user was admin in the Snitz Forum, now he isn“t...Could that be some kind of problem? ------------- Duby |
Posted By: Duby
Date Posted: 28 September 2005 at 2:59pm
|
One more thing...
Now I see why did I have problems yesterday. When I go to to members profile I can“t see all the settings in admins area:
This is all I can see...
That“s the reason why I didn“t find if member is active or not yesterday...Only in the database. ------------- Duby |
||||||
Posted By: dj air
Date Posted: 28 September 2005 at 3:45pm
| it maybe becase his accounts post number dont fit within any of the brackets/groups you set, you will need to edit the database and change the group_ID to 1 |
Posted By: MortiOli
Date Posted: 28 September 2005 at 4:15pm
|
If dj air's idea doesn't work, try the below;
Is it the same member that's having the problems? Try asking some other members, to see if they're having the same problem or not.
If it only seems to be the one person, it might have something to do with the eye and no entry sign at the bottom right of the IE window. Get them to double click that, and set it to allow cookies to your site - this might help http://www.bandt.com.au/cookies/win_ie_6.asp - http://www.bandt.com.au/cookies/win_ie_6.asp
|
Posted By: Duby
Date Posted: 28 September 2005 at 5:26pm
|
I have changed the group_ID number but it is the same.
There are some other users which where at Snitz“s forum admins and I don“t have problems with them...so...
This is for x-files...serious... ------------- Duby |
Posted By: Duby
Date Posted: 28 September 2005 at 5:36pm
|
Yes MortiOli. It is the same member that“s having the problems.
Yes, we have tried everything with cookies, trusted site options etc. and also I have his password and the same thing happend to me when I tried to login as this member.
So it isn“t problem with member“s computer or IE settings.
This is the only member that I can“t delete or change his group etc. It is something between admin, guest, and member... ------------- Duby |
Posted By: dj air
Date Posted: 28 September 2005 at 6:04pm
| ok what group ID is he got. is it 2 or is his user _ID = 2 |
Posted By: Duby
Date Posted: 28 September 2005 at 6:38pm
|
Author_ID = 2
User_ID = 1 (changed from 8) ------------- Duby |
Posted By: dj air
Date Posted: 28 September 2005 at 6:48pm
|
aghh thats why author_id = 2 is the built in guest account this is the issue.. any account with author _ID = 2 is /has guest permissioons and see as a guest, just like if not logged in your account you use is the guest account. you need ot change his account to another author ID |
Posted By: Duby
Date Posted: 28 September 2005 at 6:57pm
|
OK, so I need to copy this member and paste it to the new author_ID?
And, what with author_ID = 2? I need to set its fields to guest? Like in original wwf file? ------------- Duby |
Posted By: dj air
Date Posted: 28 September 2005 at 7:17pm
| yes thats correct |
Posted By: Duby
Date Posted: 28 September 2005 at 7:39pm
|
This will be interesting...
If I copy this member then I can“t paste it because it will create duplicate values...And if I create new user then he won“t be related to the posts, replys etc...Guest will be related to all the posts... ------------- Duby |
Posted By: dj air
Date Posted: 28 September 2005 at 7:47pm
| add the values within a text file temporary change the guest account and then add the new account |
Posted By: Duby
Date Posted: 28 September 2005 at 7:55pm
|
But will then the posts from this member be the posts of the guest?
Sorry on my English...
 ------------- Duby |
Posted By: MortiOli
Date Posted: 29 September 2005 at 3:27am
| Wouldn't it be best to somehow change the actual forum files to look at another author_id to be the guest account? If you change the ID of this particular person, then his posts won't be connected to him, like Duby said. |
Posted By: dj air
Date Posted: 29 September 2005 at 10:59am
| you could do a update SQL to update any post from Author_ID = 2 to the new author ID for the account. |
Posted By: Duby
Date Posted: 29 September 2005 at 1:47pm
|
This is what I did (dj air allready knows):
1. Copy memeber and past it to new record (temp. change some values because of primary key)
2. Copy guest account from original database and paste it to user_id= 2
3. Delete member“s account changes
4. Replace all values = 2 in the related tables with value = new record id value (= 149)
It should work fine...And it works fine...  ------------- Duby |
Posted By: johan204
Date Posted: 27 January 2006 at 8:39am
|
Hi,
When i try to import the required tables into the wwf database, i got the following error:
" Record is deleted "
Although i am sure nothing is deleted, it's only a large database (100mb+)
Anybody has any ideas?
Thanks
|
Posted By: callipygous
Date Posted: 06 March 2006 at 10:47pm
|
Having just read through this big thread - and not managed to download the ZIP files (probably moved off server by now) - is there a definitive script to help with this migration out there? Personally I am looking to move Snitz MSSQL to WWF MSSQL - but any scripts would be appreciated. |
Posted By: johan204
Date Posted: 07 March 2006 at 6:41am
|
Hi callipygous,
I have the script and will send it to you later today (when i'm at work).
One suggestion though...
My snitz database was over 100mb's long and was very buggy, 'cause snitz didn't delete all entry's when trying to delete old topics...
I added one table to tblThread and called it REPLY_ID...
Changed the file so the Reply id from snitz' Forum_Reply was copied into this new table...
When stopping on an error, you directly have the thing that causes the error... Found it very usefull to have so.
With version 7.9x of WWF it's working great...
Now i am playing to manage it into WWF version 8b2....
This worked out great in access, but when i am trying to get it into SQL i still got some errors... Hopefully i can work this out so when WWF 8 RC1 is released, i can move to WWF finally...
I think it has something to do with the stored procedures.
But when it works i will reply my notes here... so maybe more snitz users can switch to wwf... with many many many thanks of all those guys who did a hell of a job creating the conversionfile |
Posted By: benbramz
Date Posted: 18 March 2006 at 1:52am
is there actually a solution avaliable? if so could it be posted? --- edit ---- its buried in this thread, just read the posts... |
Posted By: giangi
Date Posted: 07 April 2006 at 11:15am
|
Hi anybody can send me or upload the asp file for migration ?
It's' very important !!!
Send to : webmaster[at]sysadmin.it
Thanks in advance
|
Posted By: benbramz
Date Posted: 09 April 2006 at 1:36pm
|
look through this topic. its attached on here. use that! it needs some editing, not much tho. i got it to work flawlessly.. |
Posted By: giangi
Date Posted: 10 April 2006 at 2:35pm
|
Hi ,
i have already downloaded this version but not working... :-(
I think that this is not the last version how tell dj_air ... can you send me or post here the last work version ??!?
thanks in advance.
|
Posted By: benbramz
Date Posted: 10 April 2006 at 3:36pm
|
ahhh yeah i remember now. your right but with a few simple modoifiactions to get rid of the bugs it works fine..do you havbe knowledge of asp? i might have to try and dig up my old script or work with the one on this forum... |
Posted By: giangi
Date Posted: 11 April 2006 at 12:02pm
|
I try the script on WWF 7.9.7 for import form sntiz 3.5.7 it' s right, can work ?
I have imported all date but i have lose the password , why ?
I have copied also the *inc_sha256.asp, login_user.asp and register.asp
Ohh Thanks can you send me your old script ?
|
Posted By: benbramz
Date Posted: 11 April 2006 at 2:32pm
|
you loose the passwords as it is one way encrypted. make sure you changed the files to use sha256 properly...but ive never used that. i used wwf encryption. but cleverly, i made a mod to snitz to make everyone reset their passwords, using the encryption on wwf :p left it running a month (i might leave it a bit longer) to have a seamless conversion... haha ill try dig up my script...doubtfull i have it mind. |
Posted By: giangi
Date Posted: 11 April 2006 at 3:29pm
|
Hi,
thanks for your reply! I have also copy a new files (*inc_sha256.asp, login_user.asp and register.asp) but not work!
After that i have changed this files how i can force wwf to use sha256 encryption ?
Thanks in advance.
|
Posted By: benbramz
Date Posted: 11 April 2006 at 5:23pm
|
i think this topic needs *revisiting* ill dig up the script, i might aswell see if i can get the conversion to work from snits to wwf 8.x but changing those files will use make wwf use sha256. ive not looked at them though. but i presume so. a way to check its working would be to make an asp file, include inc_sha256.asp (think thats the filename) and then go <% testenctryption = "this_is_a_test" response.write sha256(testenctryption) %> when i get home ill look into this properly.. |
Posted By: giangi
Date Posted: 11 April 2006 at 9:41pm
|
Hi, we have try to test sha256 encryption and it seems to work! Try it : http://forum.sysadmin.it/test.asp - http://forum.sysadmin.it/test.asp But however i have a problem to login into wwwf with the old user imported from sntiz 3.5.7 with a convert.asp tool; the problem is that the security GIF code not displayed ... You can see this error at : http://forum.sysadmin.it/login_user.asp - http://forum.sysadmin.it/login_user.asp The problem is that files security_image.asp not exist in the 7.9.7 version it's right ? You have make a migration from snitz to which version of WWF ? |
Posted By: benbramz
Date Posted: 12 April 2006 at 4:54pm
|
i think we should look at building an import tool to push the wwf into 8.x then we can cut these bugs out...and get the forums right into the versiopns properly.... |
Posted By: MortiOli
Date Posted: 21 May 2006 at 11:18am
|
For all those who are after the script, please find it below;
http://www.emotive-designs.co.uk/Snitz_WWF.zip - Snitz To WWF This has only been tested on WWF version 7.x |
Posted By: Sumea
Date Posted: 18 September 2006 at 5:10pm
|
Hi all, I am also a recent convert to WWF from Snitz. I've used the script above and have hit a major hitch. Moving all the users... Moved all the users... Moving Categorķes... Moved all Categorķes... Moving all Forums... Moved all Forums... Moving all Topics... Microsoft JET Database Engine error '80004005' The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. database/convert.asp, line 219 I've made a query to make sure there were no duplicates in the forum_topics table (the snitz table which is getting converted to tblTopic). After running the script, I had a look to see which record the tblTopic stopped at, and it only shows one record, so it didn't get very far. I even removed all the records from forum_topics except for one, and it still has the same problem. I've removed all the relationships between the tables just to see if it will work, but it didn't. I'm all out of ideas, and I need some help :( I do think there may be a possible problem with the database which I'm using (v8 of WWF, whereas the script only works with a v7.x database? Anyone know? If that's the case, is there any place I can download a v7.x database???)Any suggestions would be *greatly* appreciated. My site's forum is on hiatus and it's not a good feeling when your thousands of users are wondering when the forum is going to get back up :( |
Posted By: Sumea
Date Posted: 19 September 2006 at 12:01pm
|
Ok, for anyone migrating from Snitz to WWF using the Snitz to WWF script above, you HAVE to use version 7 of the WWF database, not the current 8, or else you will get the problem I have above.. You can find a copy of a fresh v7 database at : http://forums.webwiz.net/forum_posts.asp?TID=21338 Anyway, I've come up to another point : Moving all the users... Moved all the users... Moving Categorķes... Moved all Categorķes... Moving all Forums... Moved all Forums... Moving all Topics... Moved all Topics... Moving all Posts... Microsoft JET Database Engine error '80040e21' You cannot add or change a record because a related record is required in table 'tblAuthor'. database/convert.asp, line 268 I've re-read the past posts on this particular problem (page 4 of this thread), and it seems to come from not removing the two records in the author table and then compacting which should reset the id's in there back to 0. This is what I have done already, so at this point I am stuck again. :( Any help would be greatly appreciated. |
Posted By: Sumea
Date Posted: 19 September 2006 at 3:22pm
|
Ok, another update :) I've successfully migrated the database. The problem above was due to a member missing from the member list, but his posts were still in replies and topics. Pretty odd. Anyway, I've removed his posts, and it all went well. I used the tools to update the database to v8, and the forum appears to work so far (the forum categories are a bit messed up, but that can be fixed with a bit of forum administering). Now, I've come onto a new problem. When I try to log in, I get this error: Error Type: Microsoft VBScript runtime (0x800A01F4) Variable is undefined: 'blnLongSecurityCode' forum/login_user.asp, line 119 Now, I'm sure this is due to the login_user.asp that I had to replace with MortiOli's version of login_user.asp which only works on V7, but I'm on V8. So I have to either try and update it myself, or hopefully someone can look into it :( |
Posted By: Sumea
Date Posted: 19 September 2006 at 5:40pm
|
login_user.asp register.asp includes/inc_sha256.asp Replacing these 3 files (from MortiOli's snitz --> WWF zip file attached previously) are the final steps in getting your Snitz -> WWF forum to work, however the first two files only work for v7 of WWF and I don't have the expertise in updating it to v8, unfortunately :( However, if they were updated, there'd be another problem when the WWF gets updated and the login_user.asp, register.asp files could possibly need adjustments with every update. The most ideal solution would be for someone to make a script to batch convert all the member's Snitz passwords in the database to WWF's way of storing passwords. Once that's done, there'd be no need for those modified login files or a check for Snitz passwords ever again. Would anyone be up to doing this? *hopes* If not, would anyone care to update the previously mentioned files for WWF 8 for us migrating from Snitz forums??? |
Posted By: Sumea
Date Posted: 22 September 2006 at 8:33am
|
Hi there. Ok this will be my final post on migrating from Snitz to WWF v8, hopefully it will help others coming from Snitz from writing about my experience. My transition is complete, and it's working fine (with a tiny modification required - see the link at the end of this post) Ignore the previous post. Those files don't need to be updated. Basically, when you convert the database over to WWF, the members passwords are still encrypted with Snitz's way of encryption. So for members to log in with their snitz passwords, those files help out in decrypting it everytime they log in. So rather than providing them this for them, just make them reset their password by get them to click the forgotten password link and enter their username and email, and a new password will be sent to them. Easy. So for me to migrate from Snitz to WWF v8 required that I download MortiOli's script (see above), and a fresh v7 database ( http://download.webwiz.net/webwizforums/ww7migrator.zip - http://download.webwiz.net/webwizforums/ww7migrator.zip ). You do the adjustments required *exactly* in the readme text from MortiOli's script, and all should go fine. However, if like me you had "archived" posts in your snitz forum, things become a bit more difficult. When you archive posts in snitz, the topics and threads get put into an archived topic and archived thread table, and they're slightly different to the original tables they came from. What you need to do is remove all the relationships in the snitz forum (so no more database integrity checks), remove all the primary keys / autonumbering etc details in the table designs, adjust those "archived" tables to the same format as the normal ones, and then move all the records across. When you run MortiOli's script again, you might run into a few errors. These are likely to be database integrity errors. Maybe you have duplicate entries, or posts made by a user but he's no longer in the memberlist etc. You have to hunt them down. How did you get these? Well, here's what happened when I archived posts on my Snitz forum from what I remember. It was a dodgy process. It didn't move all posts across, so I had duplicate entries. Sometimes when there are too many posts to move across, the script will timeout because it takes too long, and then that you'd try it again and maybe it worked the second time. Behind the scenes however, it probably didn't happen so cleanly, leaving behind more duplicate entries. You can easily make query's on the database tables to find duplicate entries and remove them yourself. To pinpoint where the problem exactly is, you can adjust MortiOli's script so that it displays the records it updates and then when an error occurs so you can see the last record that was updated. Examine the next record in the database for the exact problem (for me it was a missing member, but his posts were there). Once this is done, the database conversion should be done. *However*, there are two more problems I found. Because I moved across archived topics and threads back to their original tables, the order was messed up. So when I ran MortiOli's script, it wasn't putting ordering my id's in an ascending order in the new database. So old posts were showing up with a higher id in the database. To fix these, I made some simple adjustments to MortiOli's script. --- line 166 of convert.asp: 'make sure the autonumbers will be correct for forums SQL = "SELECT FORUM_ID, F_SUBJECT, FORUM_FORUM.F_DESCRIPTION, FORUM_FORUM.F_TOPICS, FORUM_FORUM.F_COUNT, FORUM_FORUM.CAT_ID FROM FORUM_FORUM ORDER BY FORUM_ID ASC" --- line 211 of convert.asp: 'make sure the autonumbers will be correct for topics '********note:added viewcount SQL = "SELECT TOPIC_ID, FORUM_ID, FORUM_TOPICS.T_VIEW_COUNT, FORUM_TOPICS.T_SUBJECT FROM FORUM_TOPICS ORDER BY TOPIC_ID ASC" Ok, there's a comment there that I added the viewcount information to the sql query. What MortiOli's script misses is that it doesn't add the number of views every post gets to the new database. So we do that here. --- line 229 'we must also check for missing sequence numbers.. hence the IF do until rs.EOF If(IDvalue = rs("TOPIC_ID")) Then rsIns.AddNew rsIns.Fields("Subject") = rs("T_SUBJECT") rsIns.Fields("Forum_ID") = rs("FORUM_ID") rsIns.Fields("No_of_views") = rs("T_VIEW_COUNT") '********note:added viewcount rsIns.Update rs.MoveNext IDValue = IDValue + 1 Ok, now once your Snitz database is converted to WWF (v7), download and run the 7.x to 8.x Upgrade Tool found on the webwiz site and all should be fine! Except for two more problems. Members will have to reset their passwords themselves, and all the posts in the forum will look wrong. The first one is no problem really, and I've posted a solution to the latter problem at: http://forums.webwiz.net/forum_posts.asp?TID=21361 |