| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 21 August 2002 : 07:32:39
|
Roger,
The database needs upgrading. So I'd advise you to use a new folder to setup the forum and do it over a copy of the database. Once you've tested it and confirm everything works, just change config.asp to point to your live database, after backing it up again, and run setup again.
It's likely there are some small issues with the new version code. You may want to wait for version 3.4.01, which should be out in a day or two. Try the test upgrade then.
I haven't looked at the files to find out how this issue is handled now. It should be simple to reproduce what I've done before. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 22 August 2002 : 09:35:00
|
ruirib
I tried to upgrade and when I run setup.asp and
upgrade to 3.4 there was some error.
Error: 0
SQLState: S0002
Native Error Code: -1305
[INTERSOLV][ODBC SequeLink driver][ACCESS][Microsoft][ODBC Microsoft Access Driver] Table 'FORUM_MEMBERS_PENDING'
does not exist.
strUpdateSql: DROP TABLE
FORUM_MEMBERS_PENDING
and after that the forum messed up so I did get back 3.3.05 files and mdb-file.
Can I see inside the mdb file if it is older than 3.3.05?
/Roger |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 August 2002 : 10:12:03
|
That error is expected, since you do not have FORUM_MEMBERS_PENDING table. Why do you say the forum messed up after that?
If you check Admin Options, Main Feature Configuration, it will show you your version number. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 22 August 2002 : 12:38:17
|
You can look at my page now www.razon.se
the error is
ADODB.Recordset.1 error '80020009'
Unsupported Lock Type.
/forum34/default.asp, line 112
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 22 August 2002 : 13:04:38
|
Like this:
rsChk.open strSql, my_Conn, adOpenForwardOnly, adLockOptimistic, adCmdText
still donīt work... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 22 August 2002 : 13:20:16
|
OK.
next thing:ADODB.Recordset.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum34/default.asp, line 117
the line is:
allModeratorData = rsChk.GetRows(adGetRowsRest)
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 22 August 2002 : 13:39:34
|
Ok.
next thing: ADODB.Recordset.1 error '80020009'
Unsupported Lock Type.
/forum34/default.asp, line 167 I fixed that one to rsChk.open strSql, my_Conn
Next
ADODB.Recordset.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum34/default.asp, line 173
ADODB.Recordset.1 error '80020009'
Unsupported Lock Type.
/forum34/default.asp, line 242
ADODB.Recordset.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum34/default.asp, line 248
Ok I have changed all the lines. and itīs working...:) but I think itīs the same problem in topic.asp...:( I canīt pick up any topic.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 August 2002 : 13:44:42
|
| Probably you'll have that with other pages too. I think that has been done throughout the forum. I wonder if this is a problem with Chili!ASP or just Chili with Access. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 22 August 2002 : 14:18:20
|
I have fixed the topic.asp and inc_func_common.asp
My problem now is that I canīt login |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 August 2002 : 14:22:34
|
| Were your passwords converted? I can't register at your forum. Fix the problem there, by setting the allow Zero length string properties of the needed fields to yes, to see if the login problem applies to new users. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 22 August 2002 14:26:20 |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 22 August 2002 : 14:51:38
|
| where do I fix that one? I canīt login. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
