| Author |
 Topic  |
|
Davio
Development Team Member
Jamaica
12217 Posts |
 Posted - 15 December 2008 : 17:21:25
|
Carefree, Etymon makes a good point. Your DBS file should be using CONFIG_NEW.
Required Reading v1.0
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#("TPID","0")
[END]
< |
Support Snitz Forums
|
Edited by - Davio on 15 December 2008 17:21:48 |
 |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 15 December 2008 : 21:20:45
|
Hey Davio, I just tried using alternative mod setup:
Required Reading v1.0
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#("TPID","0")
[END]
and got this error:
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The name 'TPID' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
I am using Snitz 3.4.03 unfortunately and I do have the table FORUM_CONFIG_NEW in there.< |
coaster crazy |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 16 December 2008 : 03:11:52
|
weeweeslap,
try this:
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('TPID','0')
[END]
Notice that the quotes are now apostrophes.
Also, I have seen it coded this way as well:
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('TPID',0)
[END]
Notice that the 0 has no apostrophes around it.< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 16 December 2008 : 11:56:42
|
| Wow, was almost certain that would have worked. This looks like it having us stumped.< |
Support Snitz Forums
|
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 16 December 2008 : 12:18:13
|
Etymon, the apopstrophes did the trick!
Database Update
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('TPID','0')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Database setup finished
Now I'll continue on installing the rest of the script. Many thanks to everyone!< |
coaster crazy |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 16 December 2008 : 15:59:36
|
| OK - Learned something new about SQL Server's scripts. I'll put a second dbs file in future releases for those using it. I updated the file at SnitzBitz for future downloaders who use Sql.< |
Edited by - Carefree on 16 December 2008 16:18:34 |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 16 December 2008 : 18:51:44
|
I was reading the install file and noticed this where you indicate the changes to inc_header.asp:
%>
<!--#INCLUDE FILE="inc_required.asp"-->
</form>
<%
However, in the highlighted portion below you only show:
%>
<!--#INCLUDE FILE="inc_required.asp"-->
<%
No closing form tag. I figured that should be updated in case others run into trouble with that.
Thanks again for this mod 
<edit 1>
and uhmm for some reason it's not working for me. I made a topic, added the topic number into the admin panel and doesn't seem to be redirecting / forcing people to view said topic. Login here: http://www.coastercrazy.com/
username: snitztest
pwd: snitzsnitz
Thanks
<edit 2>
I decided to check members who viewed and I get this message:
No required topic set.Refreshing
So I am thinking it is not updating the database after adding a topic number.< |
coaster crazy |
Edited by - weeweeslap on 16 December 2008 19:19:47 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 16 December 2008 : 20:14:16
|
I fixed that line error (the /form didn't belong there), thanks.
I'm just guessing, but I suppose you have data mixed from one version to the next.
If you don't mind, download the last version and see if it fixes it for you.< |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 16 December 2008 : 22:06:13
|
Active Server Pages error 'ASP 0126'
Include file not found
/forum/admin_required.asp, line 36
The include file 'CONFIG_NEW.asp' was not found.
Mind posting a dl link for your config_new.asp file? I don't have one in my forum folder < |
coaster crazy |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 17 December 2008 : 00:23:06
|
| delete that "_new" (search/replace did it to me).< |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 17 December 2008 : 00:57:57
|
| Hmm ok I got it. Went to the mod admin page, added a topic number, now my site wont load up. Check it out: http://www.coastercrazy.com/ I'll remove the db entry and mod once you take a look. Thanks.< |
coaster crazy |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 17 December 2008 : 01:44:00
|
It shows that it's trying to load topic 19403. Is that the number you used?
I sent you EMail to show how it is supposed to be working (works on my site).< |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 17 December 2008 : 11:53:16
|
| That is the correct number. I replied to your email!< |
coaster crazy |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 18 December 2008 : 17:10:18
|
| See your email. There was an error in your inc_header.< |
|
|
|
Topic |
|
Topic Locked
