I did upgrade to 7 but it asked me to create a new DB. All my previous posts are lost. I have attempted a DTC but no luck. The tables are too different.

I also have another question: How do you put a small box on the main page showing the latest posts?

Otherwise I love the product.

hey borg...

SQL not access.

I'm about to run into the same situation.  I was just about to start writing a 6.34 -> 7 SQL converter (to be used in query analyzer).  But if you know of someone that has the scrips done up already, let me know.

I can't wait to test your script.

whoa there nick!

i wasn't planning on voluenteering for this undertaking just yet.

i was hoping some SQL monkey had done it already.

sooo... Since noone stepped up. 

Can i get a quick show of hands if you want this converter?

that is converting SQL V6.34 to SQL V7

if i dont get more than 10 people wanting it, or offers of sex I'm not even gonna bother.

Im interested :)

I would even send ya a few bucks if you made it work

I'm definately interested!! Would save my life. Would need it to be an ASP script that your run on the server though cos I dont have direct access to the server via Enterprise manager or anything.

Cheers

Kev

Hey, sounds great to me, too!!  Sorry, no sex offered. 

Jim

YES !!!  I need it also....

Thank  YOU    !!!!

AllenHarkleroad wrote: Yes a 6.x to 7 upgrade for SQL would be great!

Would be helpful to know what I am suppose to do in order to mod the DB for v7.  All I get is locked threads and telling me to search for info...and I do and all I find is more people asking the same question with no answers other than it has been covered.

I am NOT a SQL person.  I only have this software running on it that I control and can modify the DB however I want.  I just need to know how, what, procedures, info.  Anything at this point.

Hi there guys and gals.

I just have to comment on this issue.

If -boRg- don't have time to fix upgrades to existing users it is OK for me, cause I know he then uses valuable time coding new features and fixing bugs. (Or drink beer)

The making of SQL upgrades scripts should/could probably be done by ourself. The users of WWF.

That said....
I have been adding some of the newest changes to the v 7.01 .sql scripts initially posted by Str8Dog, but need someone to test if they are doing the _thing_ right.

So anyone interested in giving it a try? It follows the same procedure as the inital beta 4 scripts, but with one minor change. Creation of all the SP's are now done by one single script.

Run it in the SQL Query Analyzer in the numeric order.

Please test it and comment changes below as it is probably not 100% yet.

IMPORTANT:
DON'T DO THIS WITHOUT MAKING A BACKUP FIRST. We ran it on our servers without any hassle, but don't take any chances.

NOTES:
1.) Every user is placed in the _Newbie_ group and the Number of posts are also copied as well. This causes every user to _enter_ the right ladder group when he does his first posting after upgrade.

2.) The encryption .asp pages encrypts 100 password at a time, and its just to move back and click once more until you're done, even if the text tell you not to...

Thanks to Str8Dog for sharing his copyrighted material with all of us. He's my hero now....at least for some days to come...

PAYMENT
If someone feels that they wish to share some of their funding, please feel free to PM me, and I will tell you what to spend your money on. (besides donations to -boRg-) No point in spending money without getting something 'more' back - right....

Best regards - ronhof - admin MyWgi.com
http://www.mywgi.com - http://www.mywgi.com (Username: ronhof)

The zipfile can be downloaded from:
http://www.mywgi.com/WWF_Upgrade_6_34_to_7_01.zip - http://www.mywgi.com/WWF_Upgrade_6_34_to_7_01.zip

Don't forget to PM me then, ok?

Hi. I used this script (forum.securitylab.ru), and found 2 error.

1. Does'nt create table tblguest name

2. In table tbltopic Does'nt set default value for column Moved_ID

THANK YOU!

Aside from seemingly not converting the Private Messages, this modified set of scripts worked like a dream!

I made a backup of the 6.34 SQL database, but never needed it as the in-place upgrade worked beautifully!  For end users: remember to run the SQL files in the order listed by file/directory name, and then copy and run the two ASP files into the OLD 6.34 Admin directory *before* copying up the new 7.01 forum files.  (They might work after the fact, but why tempt fate?)  Also, remember to modify the SQL access file in the Admin directory of the new 7.01 forum and DELETE the SQL setup file from the root folder as that won't be necessary when using these upgrade scripts.

Thank you again! 

- James -

Nice job

Thanks

OK, I understand that there is an upgrade path that seems to work well....

I have a move coming up in a week or two, plus a vacation.  However, if this is still an issue for people after June, I offer...

2 things, in terms of what I can chip in:

1.  A test server to run someone else's scripts on.  In other words, I can tell you if it works for me.  I might also be convinced to run an update for someone else?

2.  ASP-izing the whole process, IF POSSIBLE.  I'll need to check the contents of the DTS packages, etc. 

I'm going to have to become fairly familiar with the whole structure in a few months ANYWAY, so might just as well dive in.

Hey - can anyone tell me off hand if the URLs are FORWARD compatible?  In other words, am I going to have a world of broken links when I do the upgrade?

If so, is there an "equivalency" script that I could use for search/replace within my site to accomodate the new URLs? 

The URLs are not compatible if you are asking if links between posts will still work....they won't but can be fixed.

The asp page names are different as are the parameter names and syntax. However, a careful handful of search and replace in the threads file seems to sort it out.

Ok, for anyone that is interested...

I have created two options for updating your SQL databases from v6.34 to v7.

1. If you have access to iSQL or some SQL execution agent, I can zip and send you the scripts and a short set of instructions on how to convert.

2. If not, I will finish a couple of pages by Sunday (7/6) that will also perform the conversion.

This conversion copies EVERYTHING over, no loss (that I have found), including user permissions for forum moderators!  (moderators currently assigned to moderate all forums are automatically assigned to the default Moderator group and permissions for the moderator group are assigned to all forums, any users with specific forum moderator access are added as individual permission overrides for that forum).

Also, the user groups are reassigned based on the default values in the groups file (40 and 100).  I haven't looked through the WWF code enough to see if users are automatically recalculated when you change them in the Groups listing.

There is an ASP script that must be run in order to fix all the passwords to the new encryption.

Basically, the procedure is...

1. Run the 'Save Current Data' procedure
2. Run the Web Wiz Forums SQL Setup page
3. Run the 'Convert Data' script or page
4. Run the 'Update Passwords' page
5. Go to the admin area and 'Update Post and Reply Counts'
6. Test everything, see that it works.  If everything is ok, run the 'Delete Saved Data' script or page.

If anyones interested, please email at mailto:rbrown@easylift.org - rbrown@easylift.org  and I will email you the scripts/pages.

If one of the moderators here want to post it all on the site for people to download, email me also and I'll send it to you.

Thx.. but we dit this..

Turend off Encryption and made some changes.. intigratet the forum to our own webside userdatabase and stuff :)

It apears that there are some problems with the password conversion scripts.  I have about 500 users on my forum and some of them the password after encrypted does not work.  I have not been able to nail down exactly what is causeing this but I know around 1/3 of users can not login now.  I have to  go and reset the password from the user edit page to get their account working again.  Not a big deal but I thought I would let you know.

cRusad3r

crusad3r, the password is completely case-sensitive now with the new version of Web Wiz Forums.  That *might* be the problem, unless you have used a coverter to move the forums to the new version and there is a specific problem with that.

I now have had 5 users request the conversion script/asp page I wrote and everyone says that it worked like a charm, moved everything over and have reported no problems.

I believe the password script works on batches of 100 users to get around a script timeout issue. Despite the warning message it needs running several times (depending how many users you have).

If you like, monitor the results by checking the relevant fields in the author table.

 ALL:

I want to get v6.34 to 7.01 database convert program(scripts/pages) ,thanks!

pls send mail to me .

mailto:shangg@vip.sina.com - shangg@vip.sina.com

ronhof wrote: Hi everybody. 1.) The tblGuest name .sql query is included in the .zip file so i guess there was some error on the first release, maybe. 2.) The default (0) for column Moved_ID has now been updated. Download here: http://www.mywgi.com/WWF_Upgrade_6_34_to_7_01.zip" target=z9z16_blank>http://www.mywgi.com/WWF_Upgrade_6_34_to_7_01.zip

Thanks ronhof. Your a Genius. Made my job of updating my 6.34 forum to 7.01 almost seamless.

Could I take a WWF 6.11. Access driven forum and convert it SQL using DTS, and then copy the 6.11 SQL db using the procedures I have read in previous post?

Thank you.

Phaderus

 I it looks like I am close to doing something I doubted "I" could do. I transfered a WWF 6.11 forum that used Access as it datbase, and transfered it to 7.11 using our SQL server. We will now be able to have more users at one time and will enjoy some of the new functions in 7.11 The Scripts from str8dog where priceless in this endeavour. Every thing worked fine with the exception of the "2_StoredProcedures.sql" script. The last few linew returned back back to querry analyzer after it ran the script was

Updating dbo.wwfSpModerator
Updating dbo.wwfSpLastAllForumsAuthorAndDate
Updating dbo.wwfSpCheckUserIsModerator
The database update failed

The code that produced this was

PRINT 'Updating dbo.wwfSpCheckUserIsModerator'
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
if exists (select * from sysobjects where id=object_id('[dbo].[wwfSpCheckUserIsModerator]') and OBJECTPROPERTY(id, 'IsProcedure')=1)
  drop procedure [dbo].[wwfSpCheckUserIsModerator]
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO

IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT>0 BEGIN
PRINT 'The database update succeeded'
COMMIT TRANSACTION
END
ELSE PRINT 'The database update failed'
GO
DROP TABLE #tmpErrors

I followed his instructions, with the exception of not using VS.net. Instead I ran the queries in query analyzer. So far everything works. My question is did that one message "The database update failed" is that indicative a error that will show up after I go live to the public with the updated forum?

To copy from Access I used DTS in Enterprise server Manager and imported my Access file to a new SQL databse.

If anyone want to look at the forum and or test it for bugs they can get to it at

http://www.intermatwrestle.com/forumsql/ - http://www.intermatwrestle.com/forumsql/

Phaderus

I've been testing this script on my forum for an upgrade and it's looks like its working prety good (thnx!), But I've got one problem when 'upgrading' the author table, the following error occours:

(10959 row(s) affected)

Creating Table tblAuthor
Populating New Category and Dropping Table backup_tblAuthor
Server: Msg 8152, Level 16, State 6, Line 6
String or binary data would be truncated.

Can someone give me some clue's?

Thanks in advance, Marvin

DaFool wrote: i can't find the WWFSharp.sln file? Am I missing something here?

Bump

Fantastic work RONHOF......upgraded with no dramas...

Not that this has anything to do with the upgrade but....

I see the avatars are now bigger than how I had them set in V6.34 - is there a way to resize back to 35 x 35 pixels???.

no worries....I see it in skin_file.asp

I KNOW THIS TOPIC IS OLD, BUT...

MarvinBess wrote: I've been testing this script on my forum for an upgrade and it's looks like its working prety good (thnx!), But I've got one problem when 'upgrading' the author table, the following error occours: (10959 row(s) affected) Creating Table tblAuthor Populating New Category and Dropping Table backup_tblAuthor Server: Msg 8152, Level 16, State 6, Line 6 String or binary data would be truncated. Can someone give me some clue's? Thanks in advance, Marvin

Yes, the problem here is that the upgrade script makes the tblAuthor fields too small.

To correct this problem, COMMENT OUT the line that has the

"SELECT * INTO backup_tblAuthor FROM tblAuthor"

Then, correct the sizes of the fields, in the script.  I've modified my forum, your EXACT results may vary.

User Code needs to be 70 characters.

Home page needs to be 1000 characters.