| Author |
 Topic  |
|
gor
Retired Admin
Netherlands
5511 Posts |
 Posted - 12 September 2000 : 08:17:36
|
Download it here.
For online testing go here
Thanks to some quick bugchecking (thanks guys ! <img src=icon_smile.gif border=0 align=middle>) and some spare time during my lunchbreak, I put together a new Beta 4 with the (now closed) bugs fixed...
No database updates needed since Beta 4, for updates since Version 3 RC 1 use the setup.asp!
<b>Pierre Gorissen </b><img src="http://www.homepages.hetnet.nl/~pgoris01/burnout.gif" border=0>
<font color=purple><font size=1>A fool learns from experience... a wise man learns from others...</font id=size1></font id=purple> |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 12 September 2000 : 08:40:11
|
Just thought I'd mention that the new .zip file for beta4b isn't compressed so it's over 1 meg in size instead of the normal 250K or so.
Thanks for the quick fixes! <img src=icon_smile.gif border=0 align=middle>
They are much appreciated! <img src=icon_smile.gif border=0 align=middle>
Edited by - Richard Kinser on 12 September 2000 08:42:00 |
 |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 12 September 2000 : 08:47:49
|
Thanks Richard !
Fixed and re-uploaded... (277 Kb again)
<b>Pierre Gorissen </b><img src="http://www.homepages.hetnet.nl/~pgoris01/burnout.gif" border=0>
<font color=purple><font size=1>A fool learns from experience... a wise man learns from others...</font id=size1></font id=purple> |
|
|
|
blkrogue
New Member
USA
79 Posts |
Posted - 12 September 2000 : 10:00:37
|
Well only differences between databases with the snitz member profile and with the slemieux member profile are:
<ul>
<li>Snitz uses M_FIRSTNAME, slemieux uses Firstname</li>
<li>Snitz uses M_LASTNAME, slemieux uses Lastname</li>
<li>Snitz uses M_PHOTO_URL, slemieux uses PhotoUrl</li>
</ul>
And differences is field definitions:
<ul>
<li>Snitz uses a length of 10 for M_AGE, slemieux uses a length of 50</li>
<li>Snitz uses a length of 255 for M_OCCUPATION, slemieux uses a length of 100</li>
</ul>
I was working on a changing script, but somehow I can't seem to get the asp to work properly down here, so can't fix it till tomorrow.
Blkrogue
In the darkness of my soul a sparkling light has appeared |
|
|
|
KenDude
New Member
USA
87 Posts |
Posted - 12 September 2000 : 10:53:11
|
Continued from the previous thread...
How do I go about upgrading my RC2 to this beta 4? Obviously I can't copy the config.asp or the database that comes with beta 4 over my existing RC2 or I'd lose everything.
Should I
A) Create a new directory on my server and unzip the beta 4 files there then copy my config.asp from my RC2 dir into this dir and run the setupasp?
or
B) Copy all of the files from the beta 4 zip into my RC2 directory except the config.asp and the database? Are there others I should not copy?
I think I may still have to go back and fix the CDONTS in this beta version.
A question about the extended user information in this version. Can't we just have some Admin configurable fields please??
For example I run my forum for a car club, as such, I'd like to know their make, model, year and modifications to their cars. In my old ASP-DEV forum I simply hacked the code to include these new fields. I've not yet done so in my Snitz forum because it seems that the user record keeps growing. Could we not get say 5-10 Admin configurable user fields that we could label whatever we want and use for our custom purposes?
For example, M_USER_XFIELD1, 2, 3, ... etc. The config.asp or a setup would allow us to create our own text label for these fields and whether or not these fields are used. Or I guess it would be easier if they were always used but didn't show up unless data was in them.
I could make the fields "Make" "Model" "Year", etc. someone else could make the fields "Weapon Type", "Caliber", "Year" whatever was of use in their forum.
Admin configurable user fields PLEASE! <img src=icon_smile.gif border=0 align=middle>
Thanks, and if I am an idiot by suggesting this, just shoot me...
KenDude was Here! |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 12 September 2000 : 11:04:57
|
Ken -
I'm not going to shoot you, but please try to post things at the propper forums, requests for features posted here might get lost when we move to the next version and thus to a new thread (please post this as a Design Request W/O Code!),
Requests for help should go into the help-forum.
To answer that upgrade-question:
<li>Backup the database</li>
<li>Just copy everything except the database.</li>
<li>Edit the new config.asp so the <b>strConnString</b> and <b>strDBType</b> are set for your specific situation again.</li>
<li>Run <b>setup.asp</b></li>
<li>Have it upgrade your database with the new fields</li>
Done. <img src=icon_smile.gif border=0 align=middle>
This way your coloursettings, posts, users etc. are kept with the upgrade. Any extra code-changes not in the downloaded version have to be re-applied ofcourse.
<b>Pierre Gorissen </b><img src="http://www.homepages.hetnet.nl/~pgoris01/burnout.gif" border=0>
<font color=purple><font size=1>A fool learns from experience... a wise man learns from others...</font id=size1></font id=purple> |
|
|
|
KenDude
New Member
USA
87 Posts |
Posted - 12 September 2000 : 12:08:03
|
Thanks,
I'll get on the upgrade then.
BTW, I loaded up the beta 4b forum in another directory and I couldn't find the "Mark All Read" feature. Where is it?
KenDude was Here! |
|
|
|
KenDude
New Member
USA
87 Posts |
Posted - 12 September 2000 : 12:09:13
|
Also a quick bug report on this version.
When you load up the profile it doesn't save your link to your image, or at least it doesn't display it in the form, so I feel like I have to re-enter that every time or else I will lose the link. Maybe I really won't lose the link to the photo, but it doesn't show up. Just a small bug fyi...
Thanks!
KenDude was Here! |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 12 September 2000 : 16:37:53
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
BTW, I loaded up the beta 4b forum in another directory and I couldn't find the "Mark All Read" feature. Where is it?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Goto Active.asp
If there are any active topics you'll see an extra folder icon (half pink, half yellow) in the header row.
That resets the active topics...
<b>Pierre Gorissen </b><img src="http://www.homepages.hetnet.nl/~pgoris01/burnout.gif" border=0>
<font color=purple><font size=1>A fool learns from experience... a wise man learns from others...</font id=size1></font id=purple> |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 12 September 2000 : 17:00:49
|
did you make an online testing site for this beta like you did for beta 3?
- Alan <img src="http://smilecwm.tripod.com/net3/smileJap.gif" border=0>
|
|
|
|
Ofsmoke
Starting Member
USA
2 Posts |
Posted - 12 September 2000 : 22:34:47
|
If there isn't one up I could always set one up:)
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 13 September 2000 : 03:07:39
|
Added a link to the online version of the beta in the original post (it wasn't online yet).
<b>Pierre Gorissen </b><img src="http://www.homepages.hetnet.nl/~pgoris01/burnout.gif" border=0>
<font color=purple><font size=1>A fool learns from experience... a wise man learns from others...</font id=size1></font id=purple> |
|
|
|
spib
Starting Member
United Kingdom
6 Posts |
Posted - 13 September 2000 : 04:43:19
|
I get the following errors when I run Setup.asp: -
Critical error: Can't add default values for new fields in CONFIG table!
Critical error: code: -2147217904 while trying to add default values to the CONFIG table
Which username should I be using? My Access 97 database doesn't have an admin password. I have tried using the admin password for the forums but the same error occurs.
I am upgrading from 3.0 SR2
James Spibey
Web Developer
Siemens IPS Airport Solutions |
|
|
|
blkrogue
New Member
USA
79 Posts |
Posted - 13 September 2000 : 05:07:42
|
Gor, with getting into the ALTER TABLE commands for Access (97) I came across this message from Microsoft MSDN:
'When the Microsoft Access, dBASE, or Paradox driver is used, the ALTER TABLE statement is supported with add and drop table constraint definition clauses.'
This means an 'ALTER TABLE tablename RENAME fieldname TO fieldname2' cannot be used with Access 97.
I'm not sure yet why the critical errors occure for an Access 97 upgrade (using setup.asp) from 3.0 SR2 though .... but am trying to figure it out <img src=icon_smile.gif border=0 align=middle>
For the slemieux to beta 4b upgrade all I can think of is first dropping the tables added with slemieux (ALTER TABLE tablename DROP fieldname) and then just doing the upgrade from the setup.asp.
Blkrogue
In the darkness of my soul a sparkling light has appeared |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 13 September 2000 : 07:07:50
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I get the following errors when I run Setup.asp: -
Critical error: Can't add default values for new fields in CONFIG table!
Critical error: code: -2147217904 while trying to add default values to the CONFIG table
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
See this discussion: http://forum.snitz.com/forum/link.asp?TOPIC_ID=730
<b>Pierre Gorissen </b><img src="http://www.homepages.hetnet.nl/~pgoris01/burnout.gif" border=0>
<font color=purple><font size=1>A fool learns from experience... a wise man learns from others...</font id=size1></font id=purple> |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 13 September 2000 : 07:11:26
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
For the slemieux to beta 4b upgrade all I can think of is first dropping the tables added with slemieux (ALTER TABLE tablename DROP fieldname) and then just doing the upgrade from the setup.asp.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I don't think the error is related to the other field allready being there (see the other topic for a possible fix).
I think it's best to first run the update and then do something like:
strSQL = "UPDATE FORUM_MEMBERS "
strSQL = strSql & "SET M_FIRSTNAME = Firstname "
and then drop the old column.
I haven't checked this myself, but shouldn't that work ?
<b>Pierre Gorissen </b><img src="http://www.homepages.hetnet.nl/~pgoris01/burnout.gif" border=0>
<font color=purple><font size=1>A fool learns from experience... a wise man learns from others...</font id=size1></font id=purple> |
|
|
|
Topic |
|
Topic Locked
