| Author |
 Topic  |
|
Ryan
Average Member
USA
858 Posts |
 Posted - 01 September 2003 : 19:20:51
|
| Try running the MOD setup again. Make sure it creates the FORUM_ADS_CONTENT tables. |
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help |
 |
|
|
Jeff V
Starting Member
23 Posts |
Posted - 01 September 2003 : 19:23:02
|
This maybe long but this is what it said:
Snitz Classifieds Ads 3.4
Creating table(s)...
CREATE TABLE FORUM_FORUM_ADS_CONTENT( ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , TOPIC_ID int NOT NULL , NAME varchar(75) NULL , EMAIL varchar(50) NOT NULL , DATE_POSTED text (20) NOT NULL , PRICE varchar(20) NULL , AD_TITLE varchar(100) NOT NULL , CONTENT memo NOT NULL , ADDRESS varchar(100) NULL , CITY varchar(50) NOT NULL , STATE varchar(20) NOT NULL , ZIP varchar(12) NULL , LINK varchar(100) NULL , IMAGE_URL varchar(75) NULL , ADDED_BY int NOT NULL )
Table already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_FORUM_ADS_CATEGORY( ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , CATEGORY_NAME varchar(50) NOT NULL , DESCRIPTION memo NULL )
Table already exists
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_FORUM_ADS_CATEGORY (category_name, description) VALUES ('Antiques', 'Coins, Furniture, Instruments, Collectibles, more...')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_FORUM_ADS_CATEGORY (category_name, description) VALUES ('Computers', 'Accessories, Desktop, Laptop, more...')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_FORUM_ADS_CATEGORY (category_name, description) VALUES ('Real Estate', 'Apartments, Condos, more...')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_FORUM_ADS_CATEGORY (category_name, description) VALUES ('Automobiles', 'Cars, Imports, Motocycles, more...')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_FORUM_ADS_CATEGORY (category_name, description) VALUES ('Wanted', 'Merchandise, Services, more...')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_FORUM_ADS_CATEGORY (category_name, description) VALUES ('Relationships', 'Man seeking Woman, Woman seeking man, etc...')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Database setup finished
Jeff |
|
|
|
jnkml
Starting Member
10 Posts |
Posted - 01 September 2003 : 20:21:58
|
I'm having the exact same problem as Jeff V. I've uploaded all the files to my forum folder (except the readme). I've run the Mod set-up and confirmed that the tables and records are there by downloading my database. But I get the same error message when I go to classifieds.asp.
Did we miss a step? Does this not work in Access? Any help would be appreciated.
Jackie |
Edited by - jnkml on 01 September 2003 20:29:26 |
|
|
|
lsakizada
New Member
USA
90 Posts |
Posted - 01 September 2003 : 20:41:14
|
Hi guys, there is a problem when creating the the tables.
You should fix/ workaround that by renaming the two tables names.
They are created as FORUM_FORUM_ADS_CONTENT and FORUM_FORUM_ADS_CATEGORY |
Edited by - lsakizada on 01 September 2003 20:43:26 |
|
|
|
Jeff V
Starting Member
23 Posts |
Posted - 01 September 2003 : 20:47:34
|
Ok, I opened the mdb file in access and renamed those two tables and it comes up fine now.
Jeff |
Edited by - Jeff V on 01 September 2003 21:08:57 |
|
|
|
Ryan
Average Member
USA
858 Posts |
Posted - 01 September 2003 : 21:36:59
|
| What did you rename the tables? |
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help |
|
|
|
Jeff V
Starting Member
23 Posts |
Posted - 01 September 2003 : 21:54:57
|
Is there a way to reduce the 60 day ad length to 30 days?
Jeff |
|
|
|
Jeff V
Starting Member
23 Posts |
Posted - 02 September 2003 : 16:37:47
|
The tables were created as: FORUM_FORUM_ADS_CONTENT and FORUM_FORUM_ADS_CATEGORY
All I did was drop the first word forum from each table. They now read as:
FORUM_ADS_CONTENT and FORUM_ADS_CATEGORY
Jeff
|
|
|
|
Ryan
Average Member
USA
858 Posts |
Posted - 03 September 2003 : 12:01:11
|
| Thanks. I'll go to the db file and see if that is what it says. If so I will update it. |
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help |
|
|
|
lsakizada
New Member
USA
90 Posts |
Posted - 03 September 2003 : 18:26:37
|
Jeff,
Yes it is possible to reduce the number of days.
There are three places to modify.
1. The main page (I guess its called classifieds.asp)
Search on '60' and you will find two places, one for display to the end user, and one is the actual parameter.
2. The third place to modify is in viewclassified.asp (I do not
remember the actual file name  ).
Search for 60 and you will find one more parameter to modify.
Hope its help you |
|
|
|
Ryan
Average Member
USA
858 Posts |
Posted - 03 September 2003 : 18:49:26
|
The tables in the db file say:
FORUM_ADS_CONTENT
By having the FORUM in the front does it make it end up saying:
FORUM_FORUM_ADS_CONTENT? Is the FORUM automatically inserted? I am assuming it is but I want to confirm that. |
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 03 September 2003 : 20:12:39
|
One quick question - When submitting an Ad you have an email field but then below that it says you must use the email that you registered with. If that is the case then why even allow the user to enter an email? Maybe I am missing something?
It might be a good idea to allow the user to enter a different email to get questions about the posting. Sometimes the user registers with an email that they do not check often.
Good Work. |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 03 September 2003 : 20:16:55
|
| Oh and to answer your question on the dbs file, remove the FORUM_ from all the table references and it will create the tables correctly. That is what I did on mine. |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
Ryan
Average Member
USA
858 Posts |
|
|
AWD_ENVY
Junior Member
103 Posts |
Posted - 10 September 2003 : 11:06:53
|
Has anyone else writtin the Classifieds with sub categories & changeable ad run time ?
I have mine done for the most, but I'm looking for an effecient way to exclude expired ads. Because the ad's runnning time is stored in the database with the ad, Id like to figure out a SQL statment that will have SQL only pull the records I want(Apposed to returning the recordset and sorting there).
http://216.15.220.121/forum/classifieds.asp
Anyone solved this issue/obstical yet ? Anyone have any ideas ?
|
Edited by - AWD_ENVY on 10 September 2003 11:09:59 |
|
|
|
Topic |
|
Topic Locked
