Migrating From Snitz - LETS WORK THIS OUT

Post Reply

Page <1 9 101112 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
benbramz Members Profile Find Members Posts Newbie Joined: 16 March 2006 Location: United Kingdom Status: Offline Points: 13	Post Options Post Reply Quote benbramz Report Post Thanks(0) Quote Reply 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.. Edited by benbramz - 11 April 2006 at 5:25pm

giangi Members Profile Find Members Posts Newbie Joined: 07 April 2006 Location: Italy Status: Offline Points: 11	Post Options Post Reply Quote giangi Report Post Thanks(0) Quote Reply 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 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 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 ? Seems that this files is only in the WWF 7.5 it' s right ? If yes where i download this version ? Thanks.

benbramz Members Profile Find Members Posts Newbie Joined: 16 March 2006 Location: United Kingdom Status: Offline Points: 13	Post Options Post Reply Quote benbramz Report Post Thanks(0) Quote Reply 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....

MortiOli Members Profile Find Members Posts Senior Member Joined: 26 May 2002 Location: United Kingdom Status: Offline Points: 514	Post Options Post Reply Quote MortiOli Report Post Thanks(0) Quote Reply Posted: 21 May 2006 at 11:18am
	For all those who are after the script, please find it below; Snitz To WWF This has only been tested on WWF version 7.x

Sumea Members Profile Find Members Posts Newbie Joined: 18 September 2006 Status: Offline Points: 30	Post Options Post Reply Quote Sumea Report Post Thanks(0) Quote Reply 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 :(

Sumea Members Profile Find Members Posts Newbie Joined: 18 September 2006 Status: Offline Points: 30	Post Options Post Reply Quote Sumea Report Post Thanks(0) Quote Reply 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.

Sumea Members Profile Find Members Posts Newbie Joined: 18 September 2006 Status: Offline Points: 30	Post Options Post Reply Quote Sumea Report Post Thanks(0) Quote Reply 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 :(

Sumea Members Profile Find Members Posts Newbie Joined: 18 September 2006 Status: Offline Points: 30	Post Options Post Reply Quote Sumea Report Post Thanks(0) Quote Reply 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??? Edited by Sumea - 19 September 2006 at 5:42pm

Post Reply	Page <1 9 101112 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum