| Author |
 Topic  |
|
Shaggy
Support Moderator
Ireland
6780 Posts |
 Posted - 22 September 2005 : 06:21:38
|
CleanCode's working on the signature now; it was my first time editing my profile after registering so maybe it's something there that's causing it.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 22 September 2005 : 07:57:25
|
Just voted in that poll you're after posting, Marcel and I get the following error:Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'POLL_ID', table 'forumcode.dbo.FORUM_POLL_VOTES'; column does not allow nulls. INSERT fails.
/inc_func_common.asp, line 260 Voting for Snitz, of course! 
Also, after selecting my RSS feeds and hitting the submit button, the SQL is being written to screen on the confirmation page as well as the following error on the feeds page itself:Microsoft VBScript runtime error '800a0009'
Subscript out of range: 'a'
/inc_my_feeds.asp, line 150 This error occurs for me with all the ENT feeds selected.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
Edited by - Shaggy on 22 September 2005 10:50:36 |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 22 September 2005 : 13:24:38
|
quote:
Originally posted by Shaggy
Just voted in that poll you're after posting, Marcel and I get the following error:Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'POLL_ID', table 'forumcode.dbo.FORUM_POLL_VOTES'; column does not allow nulls. INSERT fails.
/inc_func_common.asp, line 260 Voting for Snitz, of course!
Also, after selecting my RSS feeds and hitting the submit button, the SQL is being written to screen on the confirmation page as well as the following error on the feeds page itself:Microsoft VBScript runtime error '800a0009'
Subscript out of range: 'a'
/inc_my_feeds.asp, line 150 This error occurs for me with all the ENT feeds selected.
Thanks for digging up all the bugs....
I found that first one too, and already asked sr_erick to have a look at it. It's most likely a MS SQL thing (oxle runs on access, forumcode on sql). He's our guru. 
The second one is a funny one. I haven't been able to build in any error handling in the members-feeds. Now it loops through the array of rss entries, for a fixed amount, let's say 5 times.
But when the feed has just 3 entries and no more, this error occurs... I'm not yet sure how to fix that. |
portfolio - linkshrinker - oxle - twitter |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 22 September 2005 : 15:34:04
|
| Try adding in an "On error resume next", then just checking the err.number. If it's what you're expecting (whatever the returned number is for the "Subscript out of range"), exit the loop. I used this method with a problem I was having with some other stuff. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 26 September 2005 : 07:49:50
|
Another hiccup is that the members list will not sort by descending post count, it instead defaults to sorting alphabetically by name.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 20 October 2005 : 07:39:08
|
Guys, here's a quick update;
I'm sorry to say this, but I'm afraid I'm going to step back from forumcode.com, due to the simple fact that I do not have any spare time left to invest in forumcode.com.
My work, and life @home will be consuming much of my time, along with Scouting & oxle, and I don't think it's fair to those who do invest effort into forumcode.com to have my name attached to it.
I've offered to transfer the domain to the current team members of forumcode.com (sr_erick & muzishun) so perhaps they will continue the development of the site. |
portfolio - linkshrinker - oxle - twitter |
|
|
|
Topic |
|
Topic Locked
