| Author |
 Topic  |
|
blkrogue
New Member
USA
79 Posts |
 Posted - 13 September 2000 : 07:20:07
|
Gor, I'm not sure (I'm no Access expert), but there might be some datatype mismatches for the access 97 db upgrade conventions within setup.asp. Even though the upgrade returns a message saying the database fields are already inserted (CONFIG table) I cannot find any of the field names in the database.
Might be related to the fact you use INT and smallint as field types for access as well, though within the help file (only access 2000 available at work) there's a document on 'Type property (MDB)' which states that the following query parameter settings are supported:
legend : Constant (Query Parameter setting)
- dbBoolean (Yes/No)
- dbByte (Byte)
- dbInteger (Integer)
- dbLong (Long Integer)
- dbMemo (Memo)
- dbText (Text)
- ...
Anyways, just my ponderings on the errors.
-
Blkrogue
In the darkness of my soul a sparkling light has appeared |
 |
|
|
blkrogue
New Member
USA
79 Posts |
Posted - 13 September 2000 : 07:22:58
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
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>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I'm not sure as so far I don't seem to be able to do a rename of columns with access databases.
Blkrogue
In the darkness of my soul a sparkling light has appeared |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 13 September 2000 : 07:32:02
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I'm not sure as so far I don't seem to be able to do a rename of columns with access databases.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<b>Set</b> doesn't rename the field but just assign the value of the one field to the other.
<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:34:38
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Gor, I'm not sure (I'm no Access expert), but there might be some datatype mismatches for the access 97 db upgrade conventions within setup.asp. Even though the upgrade returns a message saying the database fields are already inserted (CONFIG table) I cannot find any of the field names in the database.
Might be related to the fact you use INT and smallint as field types for access as well
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Hmm, just used it to upgrade a Beta 3 Access database to Beta 4 without problems, though I do aggree that Byte might be the better choise for the config fields (could you check to see it it works/makes any difference in your case ?)
<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 - 13 September 2000 : 08:16:36
|
Hmmm, this is too weird (can this acting up for forum upgrades be related to the use of application variables?)
Gor,
- I downloaded my database all over again,
- Made changes to iis (4.0) to have a shorter timeout for the application settings for the directory hosting and made it run in a seperate memory space.
- then upgraded with version 3.1 beta 3 scripts the downloaded database (which is a RC 2 database with extra mods (extended profile and the last post by fields')
- this gave no errors anywhere.
- next I used the version 3.1 beta 4b scripts to open the database again (which gave me the normal forum as the application variables are probably still active) went to the admin tools, used the option there to check the database .... ran the upgrade from beta 3 to beta 4b and except for the errors related to the already existing fields for the extended profile got no errors whatsoever.
Do you have any idea whether it's an application variables setting which acts up if you try to upgrade to fast (after an error or something like that) or just the twilight zone computer I'm using here <img src=icon_smile_question.gif border=0 align=middle>
Blkrogue
In the darkness of my soul a sparkling light has appeared
<font color=blue>P.S. This even prevents the active.asp error, without any changes to the original beta 4b code I can open active topics without any errors (using an acces 97 database) ...... might be related to the application settings/running in seperate memory space option?
</font id=blue>
Edited by - blkrogue on 13 September 2000 08:26:16 |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 13 September 2000 : 08:27:02
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Do you have any idea whether it's an application variables setting which acts up if you try to upgrade to fast (after an error or something like that) or just the twilight zone computer I'm using here <img src=icon_smile_question.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
As far as I know the only thing stored config-variables used in setup.asp are strConnString and strDBType and those are very constant.
So I don't expect any problem there. One thing I realise now though is that you don't reset the Application(strCookieURL & "ConfigLoaded") to "" if you go directly to the upgrade part of the script. That causes the new application variables not to be loaded until you go into the admin screens and save any of the options.
But it could also be a Twilight Zone type of problem <img src=icon_smile_tongue.gif border=0 align=middle>
<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> |
|
|
|
TommyBALL
Starting Member
Norway
20 Posts |
Posted - 13 September 2000 : 08:40:31
|
May have stumbeled onto a bug...
Any Forum with <b>Auth Type:</b> using <b>Allowed Member List</b>, <b>Allowed Member List & Password Protected</b> or <b>Allowed Member List (Hidden)</b> fails when you try to enter it.
Same thing happens on both Access 97/2000, and MS Sqlserver 7 SP2.
Can anyone else deny, or (preferably <img src=icon_smile_wink.gif border=0 align=middle>) confirm this?
Regards
- TommyBALL
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 13 September 2000 : 08:49:58
|
TommyBALL -
You can find all the different private forums at the online version.
Did you make sure you were on the memberlist?
Could you describe what error you got?
<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> |
|
|
|
TommyBALL
Starting Member
Norway
20 Posts |
Posted - 13 September 2000 : 09:14:58
|
<b>gor:</b> Yes, I'm sure I'm on the list...
Here's the errormessage<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'my_Conn'
/snitz/inc_functions.asp, line 1725
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Page:
GET /snitz/FORUM.asp?FORUM_ID=15&CAT_ID=3&Forum_Title=Internt<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 13 September 2000 : 09:32:25
|
TommyBALL -
I just checked the Beta 4b: I get this error (only) when I use the jump to selectbox to jump to a members only etc. forum.
Could you post this as a bug in Bug Reports (Open) ?
<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> |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 13 September 2000 : 15:52:14
|
There are a lot of bugs in the smilies. Some of the smilies don't show up and some times the only part of the img src tag is missing. And i have been using the smilies popup window to insert the smilies.
-----------------
ASPTools
!Spice up your site!
www.asptools.co.uk
----------------- |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 13 September 2000 : 15:56:32
|
There is an error in active.asp.
-----------------
ASPTools
!Spice up your site!
www.asptools.co.uk
----------------- |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 13 September 2000 : 16:43:51
|
I'm Getting Errors All Over. ( not to many ) I get error with the smilies and active.asp. Could someone check this out??
Matt
-----------------
ASPTools
!Spice up your site!
www.asptools.co.uk
----------------- |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 13 September 2000 : 16:58:25
|
Matt - you can check to see if they are specific to your site at the online testing site (see first post).
<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
