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.
|
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< |
|
|