| Author |
 Topic  |
|
jlaw
Junior Member
USA
120 Posts |
 Posted - 13 April 2001 : 00:12:00
|
I have it, but for some reason it keeps making errors on creating the tables.
"Creating table(s)...
CREATE TABLE FORUM_Site_Cats( CatID int COUNTER NOT NULL , ParentID#smallint## NOT NULL , IMG#varchar (100)#NULL# NOT NULL , Title#varchar (100)## NOT NULL , CatDesc#memo#NULL# NOT NULL , Hits#int##0 NOT NULL , Forum_ID#smallint#NULL# NOT NULL , Template#smallint#NULL# NOT NULL , Template#smallint#NULL# NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
CREATE TABLE FORUM_Site_Links( LinkID int COUNTER NOT NULL , CatID#smallint## NOT NULL , Name#varchar (100)## NOT NULL , URL#varchar (100)## NOT NULL , Author#varchar (100)#NULL# NOT NULL , IMG#varchar (100)#NULL# NOT NULL , IMG_Type#int#NULL# NOT NULL , LinkType#int#NULL# NOT NULL , LinkDesc#memo## NOT NULL , SubmittedBy#varchar (100)#NULL# NOT NULL , Added#varchar (100)#NULL# NOT NULL , Price#varchar (100)#NULL# NOT NULL , Hits#int##0 NOT NULL , Score#int##0 NOT NULL , Votes#int##0 NOT NULL , Validated#smallint##0 NOT NULL , Badlink#smallint##0 NOT NULL , Forum_Topic#smallint#NULL# NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 13 April 2001 : 02:37:51
|
Looks like you are using an older mod_dbsetup.asp with the .dbs file intended for the newer mod_dbsetup.asp
If you download any of HuwR's latest mods it should include the latest version. |
 |
|
|
jlaw
Junior Member
USA
120 Posts |
Posted - 13 April 2001 : 16:56:16
|
ok, I'll look for it.  b/c it does it to everything I use it for, hehe.
Thanks Richard
|
|
|
|
jlaw
Junior Member
USA
120 Posts |
Posted - 13 April 2001 : 17:00:19
|
btw, I have version 1.05 of the Database setup, would you know what version would be the current one?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
jlaw
Junior Member
USA
120 Posts |
Posted - 13 April 2001 : 18:27:12
|
yeah, I saw that a little while ago, I just downloaded it and I'm seeing if it will work
Thanks HuwR
|
|
|
|
jlaw
Junior Member
USA
120 Posts |
Posted - 13 April 2001 : 18:31:19
|
I'm not sure what is going on, but I downloaded the latest version of the bdsetup, and it's telling me that the tables are alread there, but then when I go to the calender it gives me this error:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_EVENTS'. Make sure it exists and that its name is spelled correctly."
What would be causing this?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 April 2001 : 18:32:59
|
can you check your db, does the table exist ?
|
|
|
|
jlaw
Junior Member
USA
120 Posts |
Posted - 13 April 2001 : 18:35:40
|
When I do the update this is all it says...
"Creating table(s)...
Table already exists"
it's not telling me what files it's updating, so it must not be putting anything in there.
and I don't have Microsoft Access yet. 
|
|
|
|
jlaw
Junior Member
USA
120 Posts |
Posted - 13 April 2001 : 18:43:25
|
This is what it does for the portal MOD:
"Creating table(s)...
Table already exists
--------------------------------------------------------------------------------
Creating table(s)...
Table already exists
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_SITE_CATS (ParentID,Title,CatDesc) VALUES (0,'Example Top Level Category','This category is a demo to give you an idea of what this script can do.')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_SITE_CATS'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_SITE_LINKS (CatID,Name,URL,LinkDesc,Author,SubmittedBy) VALUES (0,'Example Link','http://forum.snitz.com','This link is a demo to give you and idea of what this script can do.','admin','admin')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_SITE_LINKS'."
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 April 2001 : 19:18:01
|
could you mail me the dbs file I will check it
|
|
|
|
jlaw
Junior Member
USA
120 Posts |
Posted - 13 April 2001 : 23:17:56
|
I sent both portal and events .dbs files.
|
|
|
|
jlaw
Junior Member
USA
120 Posts |
Posted - 16 April 2001 : 16:30:24
|
HuwR, I just thought I would say that I changed the database connection from an access 97 to an access 2000, and it didn't come up with any errors and it said that the tables were made, but for some reason it still won't show up.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 April 2001 : 16:44:00
|
Has it created the tables in your DB
|
|
|
|
jlaw
Junior Member
USA
120 Posts |
Posted - 21 April 2001 : 00:44:48
|
Ah, sorry for the late reply, but I've been looking over this with Table editor. I see the tables for the Links Mod, but I don't see any of the tables for the Portal mod. So I don't think it added them.
|
|
|
|
jlaw
Junior Member
USA
120 Posts |
Posted - 21 April 2001 : 01:02:20
|
Actually, I found the tables, so I don't understand why it's not showing up.
|
|
|
|
Topic |
|
Topic Locked
