7 beta 3 to 7 beta 4 the dummy’s guide
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=1713
Printed Date: 30 March 2026 at 11:01pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: 7 beta 3 to 7 beta 4 the dummy’s guide
Posted By: taffy
Subject: 7 beta 3 to 7 beta 4 the dummy’s guide
Date Posted: 09 April 2003 at 10:05am
|
Ha ha meant for me..
1) Make a copy of your beta 3 mdb file. 2) open the beta3 mdb file with access Things need to add tblAuthor 1) Change Username length from 20 to 25 2)Add a column between Username and User_code Rename it Real_name , Details : Datatype=text , Length=40 3) Add a column between Avatar and Last_visit Rename it Avatar_title, Details: Datatype =text , length =40
2) tblConfiguration 1)Add 4 columns between Upload_files_size and Upload_component Rename it respectively Upload_avatar , Details : Datatype=Yes/No , Format=True/False Upload_avatar_path , Details : Datatype=text , Length=50 Upload_avatar_types , Details : Datatype=text , Length=50 Upload_avatar_size , Details : Datatype=number , Field Size=integer Key in 5 in the upload_avatar_size column 2)Delete Mass_mailier 3)Insert 1 column at the end Rename it Reg_closed, Details : Datatype=yes/no , Format , True/False
3)tblGroup 1) Insert column between Stars and Starting_group Rename it Custom_stars , Details: Datatype=text, length=80
4) Insert a new table called : tblGuestName 1)Insert 3 columns Rename respectively Guest_ID , Details : Datatype=AutoNumber , Field Size=Long Integer Thread_ID , Details : Datatype=Number , Field Size=Long Integer Name , Details : Datatype=text , Length=40
5)tblPoll 1) Rename Last_vote_IP to Author_ID 2)Delete all data in this column Details : Datatype =number fieldsize=long integer
6) tblTopic 1)Insert column between Poll_ID and Subject Rename it Moved_ID , Details : Datatype =number Filedsize =long integer Key 0 in this column for all the data(rows) you have
INstall the new v 7 beta 4 files use this new mdb file.
This is as it is.. please backup your mdb before your try.
|
Replies:
Posted By: jfontaine
Date Posted: 09 April 2003 at 3:51pm
excellent...nice work 
|
Posted By: adawg
Date Posted: 09 April 2003 at 4:53pm
I followed those directions to a tee...and triple checked my work...even compared the new fields, tables, datatype, fieldsize and length, as well as table relationships with a brand new Beta 4 database side by side and disabled all extra forum functions. I also compacted and repaired the database & I still get this error every time I try to make a new post no matter what I do! Microsoft VBScript runtime (0x800A005E) Invalid use of Null: 'CInt' /testforum/forum_topics.asp, line 377 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) GET /testforum/forum_topics.asp Can anyone tell me what gives? I knw Null means Amounting to nothing; absent or nonexistent so am I missing a value in one of the fields or what? This frusterates me!
|
taffy wrote:
Posted By: Blade-
Date Posted: 09 April 2003 at 10:34pm
|
Adawg: one of the new fields you created in the database doesnt have a value in it. The Cint function cant handle nulls, hence the error. Check over the fields and make sure you added the necessary values. Easiest way to upgrade (other than simply not running the Beta versions on a live site) is to copy the tables themselves from one database to the next. Blade |
Posted By: adawg
Date Posted: 10 April 2003 at 2:41am
| Thanks for the response blade, I guess I'll look over it again, I'm probably overlooking some minute detail. |
Posted By: taffy
Date Posted: 10 April 2003 at 7:38am
|
ok in the tbltopic where you created the new column moved_id
Make sure you added 0 for all the rows under this column That should do the trick
As blade mentioned, this column cannot have any blank data.
cheers |
Posted By: adawg
Date Posted: 10 April 2003 at 3:02pm
Thanks for all your help guys. I finally decided to dump the database I was working on and start with the original beta3 database again, and this time it worked,though I can't tell you what I did differently, but I'm not complaining 
|
Posted By: boyohboy
Date Posted: 10 April 2003 at 3:22pm
|
I don't get it. If you don't save any data, why bother to do the upgrading when you could just download the whole thing new and clean. boyohboy ------------- Visit my community website @ http://www.everythingviet.com - EverythingVIET.com |
Posted By: adawg
Date Posted: 10 April 2003 at 5:44pm
I should clarify..by original Beta3 DB I meant a fresh backup of my existing beta3 DB for my forum in which I had not attempted to add or modify the fields and tables to make it compatible with the beta4 forum. |