Use of CLng with Null
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=23774
Printed Date: 07 April 2026 at 7:48am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Use of CLng with Null
Posted By: swrdfghtr
Subject: Use of CLng with Null
Date Posted: 14 July 2007 at 7:16am
After upgrading an 8.03 database and installing 9b1, default.asp dropped an exception around line 501. It seems it wasn't able to get the topic for any of the most recent posts. I wrapped lines 487-501 in an On Error Resume Next / On Error Goto 0 block, and got the same error again on line 583. Wrapping THOSE lines in On Error resolved the problem - the page displayed.
The problem goes away after posting a message in each forum using v9.
It seems the error just comes from v9 expecting something in the database which v8 doesn't put there; once v9 has a chance to put it there, all was well.
...
BTW, liking v9 verra much indeed. Excellent work on the File Manager, and quite a few things I'd had to hack in v8 are all fixed up. I do wish v9 would give me the OPTION of having case-sensitive passwords; we integrate with external authentication and as-is I have to go mod out all the LCase() functions around passwords.
FWIW, v9 is MUCH easier to integrate with our external user database, the way I have it (the external database) rigged; there's practically no modding of the code required apart from the LCase() thing. If you're interested, here's the current hack list:
- Remove FAQ button in status bar
- Change REGISTER button in status bar to go to MY reg page
- Removing LCase() in a few spots to permit case-sensitive passwords
Wow, that's it! I've got my user database (external) triggered to auto-create users, with passwords, in the WWF Authors table, so everything else works very snazzily.
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 14 July 2007 at 8:00am
This issue with CLng does happen with some database that are not populated correctly after the upgrade.
It's been reported with a solution at:-
http://forums.webwiz.net/forum_posts.asp?TID=23748
For the time being you just need to Resync Post and Topic Counts from the admin area first, but an improved solution to this has been worked out for the final release.
Web Wiz Forums did use case sensitive passwords back about 5 years ago, and you wouldn't imagine the problems it coursed so was eventually dropped. Not sure if users are now more savy and it's worth going back to case sensitive passwords.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
|