| Author |
 Topic  |
|
Rigger82
Junior Member
USA
311 Posts |
 Posted - 18 August 2002 : 20:01:38
|
I put it on the link but since I know nobody was using subscriptions... I deleted the info in the subscriptions table.
If you had old data and you dont want to go that drastic look at the ALL SUBCRIPTIONS page and only delete the subscriptions in forums/topics that show that they are NOT ALLOWED and this will clear the conflict but keep the subcriptions for users who are subscribed to topics that ARE allowed.
Got that? |
Mark Christianson
Gulf War Veteran (82nd Airborne Division)
Owner/Operator of www.paratrooper.net
Rigger@paratrooper.net
"If freedom was shareware, soldiers are the ones who pay for it." |
 |
|
|
Chinners
Starting Member
United Kingdom
42 Posts |
Posted - 19 August 2002 : 09:08:27
|
I'll try and play with the subscriptions.
Now have a similar error when trying to post a reply using the reply to message link - not the quick reply -
Microsoft VBScript runtime error '800a000d'
Type mismatch
/forum/inc_func_common.asp, line 1429
This is the same message I was getting at the beginning of this thread. Waassup? |
Wibble, said Zebedee |
|
|
|
Chinners
Starting Member
United Kingdom
42 Posts |
Posted - 19 August 2002 : 09:12:21
|
| OK - when I disable subscriptions, the message goes away - does this help? Should I delete all subscriptions and start from scratch, or is there a change I can make to the subs code? Strange little problem... |
Wibble, said Zebedee |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Chinners
Starting Member
United Kingdom
42 Posts |
Posted - 19 August 2002 : 09:34:30
|
| No, not yet, I have simply disabled subscriptions. Should I just delete all old subscriptions? |
Wibble, said Zebedee |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Chinners
Starting Member
United Kingdom
42 Posts |
Posted - 19 August 2002 : 10:01:15
|
| Have deleted old subscriptions via Snitz 'View all subscriptions'. The message does not appear when I have subscriptions disabled. The message does not appear when I re-enable subscriptions. However, as soon as I subscribe to a topic, and then try the Reply to Message link again, the message comes back. Any ideas most welcome...thanks. |
Wibble, said Zebedee |
Edited by - Chinners on 19 August 2002 10:02:40 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 19 August 2002 : 10:25:04
|
I am getting the same error:
quote:
Microsoft VBScript runtime error '800a0006'
Overflow: 'cLng'
/forumup/inc_func_common.asp, line 1432
My first attempt at upgrading my db resulted in the following errors:
quote:
Error: 80040E37 Table 'FORUM_MEMBERS_PENDING' does not exist.
strUpdateSql: DROP TABLE FORUM_MEMBERS_PENDING
Tried it a second time and got this:
quote:
Noncritical error: M_MSN already existed in the MEMBERS table
Noncritical error: M_KEY already existed in the MEMBERS table
Noncritical error: M_NEWEMAIL already existed in the MEMBERS table
Noncritical error: M_SHA256 already existed in the MEMBERS table
Noncritical error: M_PWKEY already existed in the MEMBERS table
Noncritical error: T_STICKY already existed in the TOPICS table
Noncritical error: T_STICKY already existed in the A_TOPICS table
Noncritical error: T_LAST_EDIT already existed in the TOPICS table
Noncritical error: T_LAST_EDIT already existed in the A_TOPICS table
Noncritical error: T_LAST_EDITBY already existed in the TOPICS table
Noncritical error: T_LAST_EDITBY already existed in the A_TOPICS table
Noncritical error: R_LAST_EDIT already existed in the REPLY table
Noncritical error: R_LAST_EDIT already existed in the A_REPLY table
Noncritical error: R_LAST_EDITBY already existed in the REPLY table
Noncritical error: R_LAST_EDITBY already existed in the A_REPLY table
Noncritical error: T_SIG already existed in the TOPICS table
Noncritical error: T_SIG already existed in the A_TOPICS table
Noncritical error: R_SIG already existed in the REPLY table
Noncritical error: R_SIG already existed in the A_REPLY table
Noncritical error: M_VIEW_SIG already existed in the MEMBERS table
Noncritical error: F_DEFAULTDAYS already existed in the FORUM table
Noncritical error: F_COUNT_M_POSTS already existed in the FORUM table
Noncritical error: M_DOB already existed in the MEMBERS table
Noncritical error: F_LAST_POST_TOPIC_ID already existed in the FORUM table
Noncritical error: F_LAST_POST_REPLY_ID already existed in the FORUM table
Noncritical error: T_LAST_POST_REPLY_ID already existed in the TOPICS table
Noncritical error: T_LAST_POST_REPLY_ID already existed in the A_TOPICS table
Noncritical error: T_UREPLIES already existed in the TOPICS table
Noncritical error: T_UREPLIES already existed in the A_TOPICS table
Noncritical error: M_SIG_DEFAULT already existed in the MEMBERS table
Upgraded: F_DEFAULTDAYS field value updated in the FORUM table
Upgraded: F_COUNT_M_POSTS field value updated in the FORUM table
Upgraded: T_STICKY field value updated in the TOPICS table
Upgraded: T_STICKY field value updated in the A_TOPICS table
Upgraded: T_LAST_POST_REPLY_ID field value updated in the MEMBERS table
Upgraded: T_SIG field value updated in the TOPICS table
Upgraded: T_SIG field value updated in the A_TOPICS table
Upgraded: R_SIG field value updated in the REPLY table
Upgraded: R_SIG field value updated in the A_REPLY table
Upgraded: M_VIEW_SIG field value updated in the MEMBERS table
Upgraded: M_SIG_DEFAULT field value updated in the MEMBERS table
Upgraded: M_KEY Field Size has been changed
Upgraded: M_PWKEY Field Size has been changed
Upgraded: M_SIG Field has been changed
Upgraded: M_COUNTRY Field Size has been changed
Upgraded: M_HOMEPAGE Field Size has been changed
Upgraded: M_PASSWORD Field Size has been changed
Upgraded: F_DESCRIPTION Field has been changed
Upgraded: Table MEMBERS_PENDING has been dropped
Upgraded: Table MEMBERS_PENDING created
Error: 80040E14 Table 'FORUM_GROUP_NAMES' already exists.
strUpdateSql: CREATE TABLE FORUM_GROUP_NAMES ( GROUP_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , GROUP_NAME text (50) NULL , GROUP_DESCRIPTION text (255) NULL , GROUP_ICON text (255) NULL , GROUP_IMAGE text (255) NULL )
Error: 80040E14 Table 'FORUM_GROUPS' already exists.
strUpdateSql: CREATE TABLE FORUM_GROUPS ( GROUP_KEY COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , GROUP_ID int NULL , GROUP_CATID int NULL )
Error: 80040E14 Table 'FORUM_NAMEFILTER' already exists.
strUpdateSql: CREATE TABLE FORUM_NAMEFILTER ( N_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , N_NAME text (75) NULL )
Error: 80040E14 Table 'FORUM_BADWORDS' already exists.
strUpdateSql: CREATE TABLE FORUM_BADWORDS ( B_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , B_BADWORD text (50) NULL , B_REPLACE text (50) NULL )
Upgraded: Added default values for new fields in CONFIG table
The Upgrade has been completed without errors !
Everything seemed fine. I was browsing around, but as soon as I logged in as Admin, I got the run time error on the default page and it appears all other pages.
I do not have a copy of Access so I cannot manually adjust the fields. Seems like Chinners is still having this problem, so I'll sit tight. Don't know if you my db update info helps at all.
AKW |
Edited by - taropatch on 19 August 2002 10:27:21 |
|
|
|
Chinners
Starting Member
United Kingdom
42 Posts |
Posted - 19 August 2002 : 10:25:08
|
Using Access 2000:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\domains\blootoon.com\user\private\snitz_forums_2000.mdb" '## MS Access 2000 |
Wibble, said Zebedee |
|
|
|
Chinners
Starting Member
United Kingdom
42 Posts |
Posted - 19 August 2002 : 10:27:11
|
AKW's post above seems identical - I've enabled subscriptions on the board if you want to take a look - www.blootoon.com/forum/
|
Wibble, said Zebedee |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Chinners
Starting Member
United Kingdom
42 Posts |
Posted - 19 August 2002 : 11:05:15
|
| Will disable subs for now - thanks for your consideration, realise you must be very busy. |
Wibble, said Zebedee |
|
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 19 August 2002 : 11:21:19
|
Yes, no rush. I am just testing 3.4 right now. Appreciate any help when available.
AKW |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
