| Author |
 Topic  |
|
weeweeslap
Senior Member
USA
1077 Posts |
 Posted - 14 December 2008 : 19:12:15
|
Required Reading v1.0
Adding new records..
INSERT INTO FORUM_CONFIG (C_VARIABLE,C_VALUE) VALUES ("TPID","0")
INSERT INTO FORUM_CONFIG (C_VARIABLE,C_VALUE) VALUES ("TPID","0")
-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.
--------------------------------------------------------------------------------
Adding Column M_REQUIRED...
ALTER TABLE FORUM_MEMBERS ADD M_REQUIRED int NULL DEFAULT 0
Column added successfully
UPDATE FORUM_MEMBERS SET M_REQUIRED=0
Populating Current Records with new Default value
Table(s) updated
I am on SQl server and obtained that error message when running the dbs file. Hmm should the mod work after that? I did not proceed with adding it after running the dbs file.< |
coaster crazy |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 14 December 2008 : 19:18:24
|
| Actually, that file worked fine with Access. Let me see if I can figure out what the problem is with Sql Server.< |
Edited by - Carefree on 14 December 2008 19:20:16 |
 |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 14 December 2008 : 19:25:09
|
I looked at the reserved keywords for Sql Server 2005 and TPID isn't anywhere to be found.
Does anyone have any idea on why this won't work with SQL?< |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 14 December 2008 : 19:26:21
|
| The mod will NOT work without that field, no. Let's see if someone who's a SQL expert can help.< |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 14 December 2008 : 20:34:36
|
I wonder if it'll work from the Alternative Mod Setup option ... it's worth a try.
Click the Alternative Mod Setup link and paste these few lines in and try that:
Let me know if it works that way.< |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 14 December 2008 : 20:35:06
|
| Forgot to mention I am mssql server 2000/< |
coaster crazy |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 14 December 2008 : 20:50:13
|
Well according to a file I read on Sql Server 2000, you can trick it into accepting a word it's interpreting as reserved. To do so, the word must be enclosed in brackets.
Thus, the alternative mod text would be:
If it doesn't work the way I posted a couple replies ago, try this one.< |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 14 December 2008 : 20:53:59
|
hmm it did not trick it  Here's a copy and paste of the output:
There were 3 lines of code
Database Update
Adding new records..
INSERT INTO FORUM_CONFIG (C_VARIABLE,C_VALUE) VALUES ("[TPID]","0")
INSERT INTO FORUM_CONFIG (C_VARIABLE,C_VALUE) VALUES ("[TPID]","0")
-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.
--------------------------------------------------------------------------------
If there were errors please post a question in the MOD Implementation Forum at
Snitz Forums
< |
coaster crazy |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 14 December 2008 : 23:47:21
|
What a pain. I'll rewrite the bits which use that variable and we can try a different name.
OK - rewrote those pages, uploaded back to SnitzBitz.< |
Edited by - Carefree on 14 December 2008 23:52:27 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 15 December 2008 : 01:14:11
|
| Maybe he has another column in his database that is called TPID?< |
Support Snitz Forums
|
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 15 December 2008 : 01:50:22
|
| Possibly. I changed the variable in all the pages to eliminate the problem.< |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 15 December 2008 : 14:43:24
|
hmmm I tried 1.1 and here's the error message:
quote:
Required Reading v1.0
Adding new records..
INSERT INTO FORUM_CONFIG (C_VARIABLE,C_VALUE) VALUES ("Top_Iden","0")
INSERT INTO FORUM_CONFIG (C_VARIABLE,C_VALUE) VALUES ("Top_Iden","0")
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The name 'Top_Iden' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
--------------------------------------------------------------------------------
Adding Column M_REQUIRED...
ALTER TABLE FORUM_MEMBERS ADD M_REQUIRED int NULL DEFAULT 0
ALTER TABLE FORUM_MEMBERS ADD M_REQUIRED int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'M_REQUIRED' in table 'FORUM_MEMBERS' is specified more than once.
I know the second indicates I already have that table due to running the dbs the firs ntime but the first error message is a new one for me, I think?< |
coaster crazy |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 15 December 2008 : 15:24:42
|
| Shouldn't that be FORUM_CONFIG_NEW ? How old is your forum? ... What version of Snitz?< |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 15 December 2008 : 15:47:31
|
| I used the forum_config table, not the new one. I wonder if possibly he doesn't have the forum_config table in his database. I'll write it to use the new config table and see if that resolves it.< |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 15 December 2008 : 16:04:16
|
OK - I changed it to use the config_new table instead of the config table. It' back out on SnitzBitz.
Don't worry about the error report on forum members table, it already installed the first time you ran it. We just have to solve the first half.< |
|
|
|
Topic |
|
Topic Locked
