| Author |
 Topic  |
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
 Posted - 29 June 2008 : 20:06:47
|
The TABLE being dropped is normal as it only looks for the TABLES to do witht he Classified MOD and not any other TABLES. You will find it with most MOD's as it makes them go through smoother.
If you are true OLD SCHOOL, then you would of tested on a development system and made sure that you would of had a back-up of the DB so you can roll back if need be before going to production.< |
Cheers,
David Greening |
 |
|
|
mdelcour2000
Junior Member
United States
133 Posts |
Posted - 29 June 2008 : 20:36:57
|
| any thoughts on my problem?< |
http://lacledeforum.com/
"Never get so busy doing the work of the kingdom that you forget who the King is" |
|
|
|
webdev
Starting Member
10 Posts |
Posted - 29 June 2008 : 21:54:22
|
David,
Thanks for the simple explanation. Yes, I not only backup the database but the entire website dir that this software is contained in. Running iis7 affords one the luxury of experiencing Murphy's Law, perhaps more than one would like.
The mod works very nice and I found the readme file had nice detail, including line numbers for the generic version of this forum. Good touch for us novices who are just starting out with snitz, as I am.
Thanks again,
Wayne< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 30 June 2008 : 02:34:39
|
Thank you so much for your replies, Wayne. I guess I know what old school means now. Must say I am a bit disappointed about your total lack of a sense of humor, specially since you were the one challenging the others about it.
Oh well, anyway, it was very enlightening to find such a fine and polite representative of the old school. I hope you thoroughly enjoy your Snitz ride. I'm sure there will be many people here, to carry you by the hand in any future difficulties with Snitz code and mods.
< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
webdev
Starting Member
10 Posts |
Posted - 30 June 2008 : 07:41:56
|
ruirib, I think you jump to false conclusions. Your response above, not the last post but the one above that, was perhaps humorous to some, but rather astounding too me in that I've never ran across a sysop - admin - that would act in such fashion. I choose not to respond rapidly because I wanted to sleep on the it. David's comment was simply easier to reply to.
If you were offended in some way then I apologize. When I wrote the comment that appears toward the top of the page, I was really replying to the one that appeared at the end of page 1. I did not immediately see that there was a page 2 to this - it was a "Quick Reply." Consequently, your comment on this page (page 2) had my comment following yours. It was not that I did not reply to you, it was that the comment was put out of order - my fault.
Then, your commentary to my first entry on this page, the third comment that appears, brought some confusion because on the previous page, you removed the very information you requested and even highlighted it in red. I made no mention to this but was happy to see that an admin would be willing to give a second look at something. Personally, I think that's great.
I usually try to add a little levity to things, especially when dealing with software fixes and bugs, simply to perhaps bring a smile to the viewer. Life is too short to get all flustered over trival matters such as these. Perhaps you misunderstood my humor when I said let me pull a rabbit out of my hat. I would venture to say that most people would not copy and paste the errors that appeared during the install of the mod and then have that information available a day later. As you can see, I did. I am very detailed just as you and if you care to see how detailed I can get then look over my website and see what I do - I do it because it's the right thing to do.
If I had foresight or perhaps insight into how you would have battered-to-death the "old school" thing, then I would have never used it to begin with. I did not intend to have it used as a spring-board for pejorative commentary, laced with ill-perceived notions and false conclusions.
As an administrator of a system you play an important role. You also set the lead for others. Usually such an individual has unique qualities about them such that they incorporate into their very being, not only knowledge but further understanding of what others may be experiencing on their end. They empathize with others experiences and never, ever, reach the point of becoming a demigod or an individual that just lashes out. Let me assure you I know many admins or sysops as they were once referred to, that think the same way. Those forums are highly successful and have individuals that help, beyond the call of "duty" because they have the same purpose and understanding. Please do not use that last statement as another springboard to jump to false conclusions, although judging from the last two posts, you probably will.
Finally, I challenged nobody but merely sought information which, by the way, is (or should be) one of the purposes of any forum. I am new to this forum and snitz software and being in that position, I somewhat lack understanding and thereby proceed with temperance. It takes a little time to learn what the software is suppose to do, as opposed to what it actually does. Also, by looking over some of the posts scattered throughout, many of the items are very old and apparently have not been updated in years. Some of them refer to mods. Am I or any end user new to this system, suppose to just accept blindly that a mod completely works? Some of these were written years ago and no doubt were run on various versions of windows. To place faith that a mod with work correctly on a version of windows I run, is blind faith. But be that as it may, I tried it and it worked so that was good. This doesn't imply all mods ever written will work under iis7. In fact, it might be the case that snitz needs to rethink something about the future, software wise. asp might eventually go a different path, as suggested by .net things and the more recent "Live" software. I've seen similar things happen in this business and it is something none of us really control. Just some food for thought.
I hope that in this writing you can get a better understanding of where I'm coming from in all this. If not, sorry. Further questions, please email me.
Hi, I'm Wayne and you are ....
Can we just start over and put this behind us?
< |
Edited by - webdev on 30 June 2008 09:01:16 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 30 June 2008 : 09:24:55
|
Hi Wayne, I'm Rui.
I am sorry, but even not wanting to have this as an obstacle to a normal relationship in the future, I do need to convey some points that I deem relevant.
1. I replied twice to your doubts about the mod, the reply at the top of this 2nd page made after the comment on your first post, which I think was already reassuring in terms of the results of your mod install. The reply at the top was an even more clear answer, in my understanding, to any lingering doubts you may still had about the results of your mod install.
2. Even after the 2nd reply, your replies seemed to ignore my own replies, by then spiced with the old school comment. Also, your replies seemed to blatantly ignore my request for you to clearly indicate which error messages were being output by the mod.
3. You are right, I am an admin here and I do take that position seriously enough to go as far as anyone would go while helping users of this forum software. A simple browsing or searching will show you that in much a stronger way than I can convey in a few lines. As an admin, my replies providing answers to the forum users usually don't go blatantly ignored, or even challenged (as your repost of the mod messages output could be easily understood). Everyone is free to ignore everyone else's posts... well except if asking for help, that help being provided and ignored and admin removed parts of previous posts find themselves back in new posts by the same user. That is a behavior blatantly disrespectful of a forum admin, and that, as much leeway as we like to give here, I am not so willing to tolerate.
Until your previous reply, you did seem to purposefully ignore my replies and my questions, while "jesting" with the old scholl comments. I could have simply taken administrative measures on the topic or you, but instead I chose to follow some leads from your own posts and deal with it with a bit of irony. I am sorry of you disagree, but it was a kind of a mild response, if we do consider my previous 3 points...
Anyway, I'm happy that I was not trigger happy with you and the topic. Your reply does make some things clear (even if you still haven't replied to my questions about error messages - the messages stating that tables didn't exist were not error messages  ), but the whole thing is a lot more clear now.
So, for me, the issue is over.
As a final remark, there is a Snitz.Net version in the making. To us, Snitz is not really a product. This forum is a place for providing support yes, and I do think we do it reasonably well, as I hope you will find if you stick around, but it is also a place that provides us all with continuous learning opportunities, as there are many users, with a lot of knowledged about databases and web technologies and they are willing to share it with this community. I do hope you stick around and share some of your knowlegde with us, too.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
webdev
Starting Member
10 Posts |
Posted - 30 June 2008 : 09:44:35
|
Hi Rui,
I appreciate the candor and share the concerns that all of us seek. I grew up in my youth as an individual who wrote code and gave it freely, just as snitz is doing. I have continued in that grain throughout my life and will continue to do so, probably until my final days.
I am truly sorry if there was any misunderstanding - words are sometimes not adequate enough to express feelings.
I'll be staying around for a while, if that's ok, and contribute whenever possible.
Thanks,
Wayne< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
webdev
Starting Member
10 Posts |
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
< |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
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< |
Cheers,
David Greening |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
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?
< |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
|
|
|
zakazn
New Member
58 Posts |
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.
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 21 April 2009 : 05:43:01
|
Try SnitzBitz.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
zakazn
New Member
58 Posts |
Posted - 21 April 2009 : 05:48:50
|
| Thanks Shaggy - will have a look now |
|
|
|
zakazn
New Member
58 Posts |
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'. |
|
|
|
Topic |
|
|
|
CLASSIFIEDS mod
