| Author |
 Topic  |
|
|
Aaron S.
Average Member
USA
985 Posts |
 Posted - 24 August 2002 : 12:38:06
|
When I added a dbs file, I got this message:
CREATE TABLE FORUM_SMILES( S_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , S_CODE varchar(15) NULL , S_URL varchar(250) NULL , S_DESC varchar(250) NULL , S_VISIBLE int NULL DEFAULT 1, S_ENABLED varchar(20) NULL , S_COLSPAN int NULL DEFAULT 1)
CREATE TABLE FORUM_SMILES( S_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , S_CODE varchar(15) NULL , S_URL varchar(250) NULL , S_DESC varchar(250) NULL , S_VISIBLE int NULL DEFAULT 1, S_ENABLED varchar(20) NULL , S_COLSPAN int NULL DEFAULT 1)
-2147217865 | Table 'FORUM_SMILES' does not exist.
It looks like it is running the sql stmt twice.
The dbs seemed to work fine... with all additions being made to the database.
--Aaron
|
DOWNLOAD GREAT NEW MODS HERE |
Edited by - Aaron S. on 24 August 2002 12:41:06 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 August 2002 : 16:13:49
|
can you post the contents of the DBS file? DBS files must conform to a very specific format, I bet I know what it is though:
for example, the varchar(15) should be: varchar (15)
there should be a space in between the datatype and the size in parenthesis |
 |
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 24 August 2002 : 17:00:21
|
Adding that space didn't seem to help... here is the dbs file contents:
------------------------------------------
Smile Manager 3.4
[DROP]
SMILES
[END]
[CREATE]
SMILES
S_ID
S_CODE#VARCHAR (15)#NULL#
S_URL#VARCHAR (250)#NULL#
S_DESC#VARCHAR (250)#NULL#
S_VISIBLE#int#NULL#1#
S_ENABLED#VARCHAR (20)#NULL#
S_COLSPAN#int#NULL#1#
[END]
[DROP]
SMILES2
[END]
[CREATE]
SMILES2
S2_ID
S2_ALLOWEDIT#int#NULL#1#
[END]
[INSERT]
Smiles2
(S2_ALLOWEDIT)#(1)
[END]
[CREATE]
MEMBERS_SMILES
MS_ID
MEMBER_ID#int#NULL#
S_ID#int#NULL#
[END]
------------------------------------------
Thanks for the help.
--Aaron |
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 24 August 2002 : 17:24:59
|
The error message probably comes from the fact that I do a DROP even though there is no table (clean install)... but I am confused why the list is duplicated.
--Aaron
|
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 August 2002 : 17:30:16
|
just go through and uncomment all of the:
'on error resume next
lines.
The error is being shown for the last operation, and is not being cleared for the next, so even though the next operation is successful, it's showing the error from the last operation. |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20580 Posts |
Posted - 24 August 2002 : 17:37:53
|
I think you'll find this lineis the culprit
S2_ALLOWEDIT#int#NULL#1#
it has an extra # at the end of the line which should not be there |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 August 2002 : 17:46:48
|
| Huw, it was something I did. I had commented out most of the on error resume next lines, but doing so was causing the err from the previous operation to still be reported. |
|
|
|
HuwR
Forum Admin
United Kingdom
20580 Posts |
Posted - 24 August 2002 : 18:31:26
|
| yes I know, but that line is what was throughing the error, putting back the on error resume next just lets it carry on after the error. |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 24 August 2002 : 18:59:45
|
I thought the error was being caused by dropping a table that doesn't exist.
--Aaron
|
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
HuwR
Forum Admin
United Kingdom
20580 Posts |
Posted - 24 August 2002 : 20:55:40
|
yes, but you're also getting an error because of the extra #.
the on error resume next statements are all there for a reason, they should not be commented out, the code traps the errors returned to find out what is going on, otherwise it does what it did for aaron and stops if there is an error. |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 24 August 2002 : 23:43:41
|
If I remove the DROP stmts, there are no errors.
So the extra # may be wrong, but it is not causing any problems.
--Aaron
|
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 August 2002 : 23:01:23
|
| this is fixed in v3.4.02 |
|
|
| |
Topic |
|
Forum Locked
Topic Locked
