| Author |
 Topic  |
|
|
Cinram
Starting Member
1 Posts |
 Posted - 09 March 2009 : 23:57:57
|
Once I create either a new category or forum people get a runtime error and blocks all the other exisitng categories and forums.
What should I do? What am I doing wrong?
The version that I have is 3.XX
Regards. |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 March 2009 : 01:37:35
|
| 3.XX is not a version, so what version do you have, and what is the exact error, both these things may help us determine the problem, but your post will not. |
 |
|
|
evaldescuriel
Starting Member
6 Posts |
Posted - 10 March 2009 : 13:18:37
|
The version that is runing is the following:
[Snitz Forums 2000 Version 3.4.06]
Also if it helps you the runtime error is:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'cLng'
/html/custom/forum/inc_func_secure.asp, line 133
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 March 2009 : 14:36:53
|
| what database are you using ? looks like the privateforum flag is not defaulting to the correct value |
|
|
|
evaldescuriel
Starting Member
6 Posts |
Posted - 10 March 2009 : 18:31:29
|
| the database runing is sql server, if it is the privateforum flag how do I correct this issue. |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 10 March 2009 : 18:42:50
|
Was this "upgraded" from Access? Or was it installed on SQL Server from the beginning?
I ask because if it is an upgrade, and the upgrade wasn't done properly, you're likely to have a host of issues with missing indexes and incorrect defaults.
Also, have you installed any MODs or made any changes to the code outside of editing config.asp as per the readme?
Just trying to help narrow down where the problem is. |
Edited by - AnonJr on 10 March 2009 18:44:39 |
|
|
|
evaldescuriel
Starting Member
6 Posts |
Posted - 10 March 2009 : 19:38:20
|
| You are right it was upgraded from acccess as it can be seen in a back up of the configuration file. Regarding to the MODs how can I check if any change was made. |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 10 March 2009 : 22:51:52
|
I'm guessing you're not the person who originally set this up...
Short answer first: If there are no notes one way or the other, one way to find out if its been changed is to use a program like WinMerge (free, used it for years and love it) or Beyond Compare (30-day trial, heard it is absolutely wonderful) to compare your files with a fresh download.
If its an un-modified forum, you should only see minor edits in config.asp, and hopefully some changes for the few security updates and bug fixes. If its a modified forum, you'll probably see extensive edits and more likely than not some extra files.
As to the problem at hand: It sounds a lot like whoever did the upgrade from Access to SQL Server did not let the Snitz code create the tables, and therefore the defaults have not been properly set. More likely than not its not being indexed properly either which can cause some performance issues.
I don't know where your skill level is at, but if you're good with SQL you can look at inc_create_forum_mssql.asp and see what the defaults and indexes are supposed to be. I seem to think that there was a more detailed post for fixing problems like this floating around here, but I can't seem to find it at the moment. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 March 2009 : 01:45:00
|
| your problem is because of the upgrade, you will find that it is not the only problem you have as many more default values will be missing. |
|
|
| |
Topic |
|
Topic Locked
