| Author |
 Topic  |
|
|
blackinwhite
Average Member
Turkey
657 Posts |
 Posted - 18 April 2001 : 10:22:01
|
I got this error while I was trying to create tables.:
---
Snitz Events Calendar v2 sr1
Creating table(s)...
CREATE TABLE FORUM_EVENTS( EVENT_ID int IDENTITY (1, 1) NOT NULL , DATE_ADDED text (20) NOT NULL , START_DATE text (20) NOT NULL , END_DATE text (20) NOT NULL , EVENT_TITLE text (100) NOT NULL , EVENT_DETAILS memo NOT NULL , ADDED_BY int NOT NULL , PRIVATE int NOT NULL DEFAULT 0)
-2147217900 | Table 'FORUM_EVENTS' already exists.
--------------------------------------------------------------------------------
There were errors please post a question in the MOD Implementation Forum at
Snitz Forums
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 April 2001 : 11:25:31
|
it says you already have an events table, have you already installed this mod before ?
|
 |
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 19 April 2001 : 01:26:49
|
I have Snitz Calendar v1 installed, then I tried to create tables for v2, I got that message.
Edited by - blackinwhite on 19 April 2001 01:27:58 |
|
|
|
chinh10
Junior Member
125 Posts |
Posted - 19 April 2001 : 18:37:31
|
Please help, I have a problem:
I using MS ACCESS 97, Snitz SR4
I got this message after run the mod_dbsetup.asp:
Snitz Events Calendar v2 sr1
Creating table(s)...
CREATE TABLE FORUM_EVENTS( EVENT_ID int COUNTER NOT NULL , DATE_ADDED text (20) NOT NULL , START_DATE text (20) NOT NULL , END_DATE text (20) NOT NULL , EVENT_TITLE text (100) NOT NULL , EVENT_DETAILS memo NOT NULL , ADDED_BY int NOT NULL , PRIVATE int NOT NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 19 April 2001 : 19:55:55
|
In config.asp, use the access 2000 connection string. It works for access 97 database and will probably fix your problem.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
chinh10
Junior Member
125 Posts |
Posted - 20 April 2001 : 02:26:09
|
Thanks, I will try it tomorrow
|
|
|
| |
Topic |
|
Topic Locked
