| Author |
 Topic  |
|
the3dstudio
Starting Member
6 Posts |
 Posted - 19 August 2002 : 10:02:13
|
I upgraded from 3.1 SR4 to 3.4 just now and after the install it gave an error on the DB upgrade page (SQL 2K) so I ran it again and it said that it was fine.
So I updated the counts which I could see 1-3 seemed to have an error but it went by too quick.
When I try the forum I get an error on line 100 of the inc_moderation.asp file saying R_STATUS column does not exist. I checks the FORUM_REPLY table and did not see that column in there.
I went back and tried setup again and even ran it for several other versions to see if the other version upgrades added anything else but no luck still.
Anyone know why it won't make this field for me in the DB? I have had issues upgrading every version and had to stick with 3.1 SR4 because I could never get it to upgrade and I was told the fix would be in the next major release.
I am clearly much closer than I was before, but not quite there...ideas? |
Thanks,
Matt Anderson
http://www.the3dstudio.com |
|
|
the3dstudio
Starting Member
6 Posts |
Posted - 19 August 2002 : 10:19:14
|
| I checked again and added a R_STATUS column to the FORUM_REPLY, that was the table it was missing from....since I did that it "seems" to be working. I haven't really played with it a lot but am now wondering if that is all I need to do when I upgrade my real forums....as this was done on a backup copy. |
Thanks,
Matt Anderson
http://www.the3dstudio.com |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 August 2002 : 10:27:25
|
Well I haven't been able to understand why the R_STATUS column was not created, since it seems to be in the upgrade SQL in setup.asp (I only gave it a quick look, but it seemed to be there).
Are you sure you specified version 3.1.SR4 as the version you wanted to upgrade from, during the setup process? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 19 August 2002 10:31:05 |
|
|
|
the3dstudio
Starting Member
6 Posts |
Posted - 19 August 2002 : 10:34:45
|
Yup, I selected 3.1 SR4 for sure, tried it two times in a row with a fresh DB backup each time.
I also noticed that when I try the archive feature I get an error in the admin_forums.asp file on line 490, I added in the debug code to see what the SQL string was and here it is...
INSERT INTO FORUM_A_REPLY (CAT_ID, FORUM_ID, TOPIC_ID, REPLY_ID, R_AUTHOR, R_MESSAGE, R_DATE, R_IP, R_STATUS, R_LAST_EDIT, R_LAST_EDITBY, R_SIG) VALUES (3, 5, 5, 10, 8, 'should be great once we start using it Jamst@', '20000829172738', '210.9.41.194', , '', NULL, 0 )
...and the error was "error near "," on line 3" so I am guessing it is the two commas after the IP with nothing in them...aka, the r_status field again:(
I made sure the r_status field I added was nullable too...not sure if it is just this one message it has issues with or if they will all error out like that.
I did update the forums counts and all that as well and still no luck. |
Thanks,
Matt Anderson
http://www.the3dstudio.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 August 2002 : 10:41:25
|
Well I can try a 3.1 SR4 upgrade later on to see if I can reproduce that. In the meantime, you may try an intermediate upgrade path, maybe. First upgrade from 3.1.SR4 to 3.3.05 and then from 3.3.05 to 3.4 That's how I've done mine (although I had upgrade from 3.1 to 3.3. a while ago) and I had no problems.
Maybe do that with a copy of your live DB and no on the real one. You can just create another copy of it and try.
This is what I can suggest now. As I said, I will try a 3.1 upgrade later on, when I get some time. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
the3dstudio
Starting Member
6 Posts |
Posted - 19 August 2002 : 10:49:15
|
I tried the 3.3.05 when it first came out, spent days on it actually....could never get it to work right and I was told to hold off until the next major release as some of the bugs causing my problems would be fixed.
I will keep at the 3.4 release and see what happens...is there a certain "status" I can set the R_STATUS field to...just so there is a value and not a null in there maybe? |
Thanks,
Matt Anderson
http://www.the3dstudio.com |
|
|
|
the3dstudio
Starting Member
6 Posts |
Posted - 19 August 2002 : 11:08:46
|
Oh crap, I noticed another HUGE issue...just like what I upgraded to all versions before 3.4 I can see all of my topics but when I open one there are no replies.
Crap....I thought I was so close this time...****! |
Thanks,
Matt Anderson
http://www.the3dstudio.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 19 August 2002 : 11:22:18
|
Just Guessing.
Check your sql database for unwanted triggers. In some cases long ago, upgrading from Access to SQL Server created triggers to enforce the relationships in the Access db, and subsequent changes to the db structure caused problems.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
James
Average Member
USA
539 Posts |
Posted - 19 August 2002 : 20:54:44
|
quote:
Originally posted by the3dstudio
Oh crap, I noticed another HUGE issue...just like what I upgraded to all versions before 3.4 I can see all of my topics but when I open one there are no replies.
Crap....I thought I was so close this time...****!
Have you tried the Update Forum Counts in the Admin section?
|
*Interested in Radio Control*
*The RC Web Board - http://www.rcwebboard.com/* |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 21:40:21
|
You can use the "Alternate MOD Setup" in the Admin options to update the field value.
First you have to fix a bug in the admin_mod_dbsetup2.asp file (same bug exists in admin_mod_dbsetup.asp as well, might as well fix it too).
in those 2 files, replace every instance of:
if Instr(strTableName,"MEMBER",1) > 0 then
with this:
if Instr(1,strTableName,"MEMBER",1) > 0 then
There should be 5 instances of it in each file.
Then, in the textarea on the "Alternate MOD Setup" page, enter the following:
Update R_STATUS field
[UPDATE]
REPLY
R_STATUS#1#(R_STATUS IS NULL)
[END]
(make sure it looks EXACTLY like it does above, if it doesn't you'll get an error.)
Then just click on the Submit button |
|
|
|
eernstbmi
Junior Member
Denmark
113 Posts |
Posted - 20 August 2002 : 03:21:10
|
I too got a similar problem with the Archive function, but in my case it's obvious that it's the topic status that's giving the problem.
Where can I find documentation for the Alternate MOD setup page so that I can make the same update for the topics? |
Best regards,
Erik P. Ernst
Microsoft Business Solutions User Group, webmaster,
Microsoft MVP - Navision
|
|
|
|
eernstbmi
Junior Member
Denmark
113 Posts |
Posted - 20 August 2002 : 03:35:34
|
| Correction! It's the T_LAST_POSTER that is giving my problems! |
Best regards,
Erik P. Ernst
Microsoft Business Solutions User Group, webmaster,
Microsoft MVP - Navision
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
eernstbmi
Junior Member
Denmark
113 Posts |
Posted - 20 August 2002 : 05:52:47
|
| Thanks, but I was actually more looking for the syntax of the DBS files then... |
|
|
|
eernstbmi
Junior Member
Denmark
113 Posts |
|
|
Topic |
|
Topic Locked
