https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 07:57:19 +0000 Sat, 14 Jul 2007 08:00:44 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23774 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/use-of-clng-with-null_topic23774_post124749.html#124749 Author: WebWiz-Bruce
Subject: 23774
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.
]]> Sat, 14 Jul 2007 08:00:44 +0000 https://forums.webwiz.net/use-of-clng-with-null_topic23774_post124749.html#124749 https://forums.webwiz.net/use-of-clng-with-null_topic23774_post124744.html#124744 Author: swrdfghtr
Subject: 23774
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.
]]> Sat, 14 Jul 2007 07:16:57 +0000 https://forums.webwiz.net/use-of-clng-with-null_topic23774_post124744.html#124744