Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 CLASSIFIEDS mod

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
Gizmo3 Posted - 25 February 2006 : 10:00:27
Has anyone installed the Classifieds mod that is available. I have but I am trying find out if there has been any changes to the upload part of the mod. I would like to make it a little mors user friendly for kids when it comes to uploading pics. The web address that is in the readme no longer works. I got the mod from SnitzBitz and it says go to Ryans site but it no longer works.

Hope ya can help<
15   L A T E S T    R E P L I E S    (Newest First)
gary b Posted - 23 April 2009 : 22:57:54
I would triple-check database/website permissions. If you do not have access permission, the table in effect does not exist.

If you modify the SQL to utilize an existing table -- such as append a record, does the SQL execute properly?

Just 2 thoughts... a penny a piece.
Carefree Posted - 21 April 2009 : 18:36:45
About the only alternative is to manually add the tables to the DBase. You should take the board off-line first. If you need help, just ask.
zakazn Posted - 21 April 2009 : 13:35:47
quote:
Originally posted by AnonJr

Not a clue. Its a bit confusing because its not dropping the tables as they don't exist, but its not creating the table due to the fact that it already exists - but it can't add the records because it doesn't exist. Your DB server may be schizophrenic...

Well I am no expert, but that is sort of what I thought.

Anyone else have any ideas on how to fix this?
AnonJr Posted - 21 April 2009 : 13:08:35
Not a clue. Its a bit confusing because its not dropping the tables as they don't exist, but its not creating the table due to the fact that it already exists - but it can't add the records because it doesn't exist. Your DB server may be schizophrenic...
zakazn Posted - 21 April 2009 : 11:51:53
Does anyone have an idea of why this is happening? Any help would be much appreciated.

Jill
zakazn Posted - 21 April 2009 : 07:32:00
Thanks for that Carefree - I have done that and now get the following:-


Snitz Classifieds Ads 3.4

Dropping Table..

Table does not exist
Dropping Table..

Table does not exist
Creating table(s)...
CREATE TABLE FORUM_ADS_CONTENT( ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , 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_ADS_CATEGORY( ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , CATEGORY_NAME varchar(50) NOT NULL , DESCRIPTION memo NULL )
Table already exists

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Antiques', 'Coins, Furniture, Instruments, Collectibles, more...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Antiques', 'Coins, Furniture, Instruments, Collectibles, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Computers', 'Accessories, Desktop, Laptop, more...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Computers', 'Accessories, Desktop, Laptop, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Real Estate', 'Apartments, Condos, more...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Real Estate', 'Apartments, Condos, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Automobiles', 'Cars, Imports, Motocycles, more...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Automobiles', 'Cars, Imports, Motocycles, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Wanted', 'Merchandise, Services, more...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Wanted', 'Merchandise, Services, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Relationships', 'Man seeking Woman, Woman seeking Man, etc...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Relationships', 'Man seeking Woman, Woman seeking Man, etc...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.
Carefree Posted - 21 April 2009 : 07:22:38
Replace your "dbs_classifieds.asp" with the following, then retry it.


Snitz Classifieds Ads 3.4
[DROP]
ADS_CONTENT
[END]
[DROP]
ADS_CATEGORY
[END]
[CREATE]
ADS_CONTENT
ID
TOPIC_ID#int##
NAME#varchar(75)#NULL#
EMAIL#varchar(50)##
DATE_POSTED#varchar (20)##
PRICE#varchar(20)#NULL#
AD_TITLE#varchar(100)##
CONTENT#memo##
ADDRESS#varchar(100)#NULL#
CITY#varchar(50)##
STATE#varchar(20)##
ZIP#varchar(12)#NULL#
LINK#varchar(100)#NULL#
IMAGE_URL#varchar(75)#NULL#
ADDED_BY#int##
[END]
[CREATE]
ADS_CATEGORY
ID
CATEGORY_NAME#varchar(50)##
DESCRIPTION#memo#NULL#
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Antiques', 'Coins, Furniture, Instruments, Collectibles, more...')
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Computers', 'Accessories, Desktop, Laptop, more...')
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Real Estate', 'Apartments, Condos, more...')
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Automobiles', 'Cars, Imports, Motocycles, more...')
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Wanted', 'Merchandise, Services,  more...')
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Relationships', 'Man seeking Woman, Woman seeking Man, etc...')
[END]
zakazn Posted - 21 April 2009 : 06:30:08
OK, I downloaded the files and the tried to implement. I get the following message - any ideas how I can fix?


Snitz Classifieds Ads 3.4

Creating table(s)...
CREATE TABLE FORUM_ADS_CONTENT( ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , 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_ADS_CATEGORY( ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , CATEGORY_NAME varchar(50) NOT NULL , DESCRIPTION memo NULL )
Table already exists

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Antiques', 'Coins, Furniture, Instruments, Collectibles, more...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Antiques', 'Coins, Furniture, Instruments, Collectibles, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Computers', 'Accessories, Desktop, Laptop, more...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Computers', 'Accessories, Desktop, Laptop, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Real Estate', 'Apartments, Condos, more...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Real Estate', 'Apartments, Condos, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Automobiles', 'Cars, Imports, Motocycles, more...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Automobiles', 'Cars, Imports, Motocycles, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Wanted', 'Merchandise, Services, more...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Wanted', 'Merchandise, Services, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.

Adding new records..
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Relationships', 'Man seeking Woman, Woman seeking man, etc...')
INSERT INTO FORUM_ADS_CATEGORY (category_name, description) VALUES ('Relationships', 'Man seeking Woman, Woman seeking man, etc...')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_ADS_CATEGORY'.
zakazn Posted - 21 April 2009 : 05:48:50
Thanks Shaggy - will have a look now
Shaggy Posted - 21 April 2009 : 05:43:01
Try SnitzBitz.
zakazn Posted - 21 April 2009 : 05:42:10
Hi, I have been searching the forum for a link to the classified mod, but the only link I can find no longer works. Is there a current version available for download? Many thanks.
modifichicci Posted - 01 July 2008 : 08:15:55
it is possible an overtreating of variables in ClassPlacead.asp ?

the variables from sName to sAdApproval will be sanitized in the declare part and also in the insert part, maybe one of them could be omitted?

I see you have included an inc_func_class file, with function that are in inc_func_secure, but you have sanitized the data
ChkString(fUser_Number, "SQLString")
as in inc_func_secure it is not, why? It needs the same in inc_func_secure and why don't use the inc_func_secure file?

The same, you have included inc_func_common and inc_header, but inc_func_common is included in inc_header, isn't that too much code?
<
Classicmotorcycling Posted - 01 July 2008 : 07:59:20
Now updated to be sanitised against SQL injection.

Classifieds Mod can be downloaded from: Classifieds Mod 3.6<
webdev Posted - 30 June 2008 : 20:42:07
Hi Rui,

Sorry but I had to leave and just got back a couple of minutes ago. I'll be returning as often as possible.

Thanks again.
Wayne
<
ruirib Posted - 30 June 2008 : 11:59:09
Hi Wayne,

I do hope you stay with us.

Thanks<

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000 Version 3.4.07