| Author |
 Topic  |
|
Aznknight
Senior Member
USA
1373 Posts |
 Posted - 01 April 2001 : 01:20:39
|
Title: Snitz Classified Ads
Version: service release 1
Download: http://www.calvsa.net/snitz/
Demo: http://www.calvsa.net/snitz/classifieds.asp
Installation: read the included classifieds_readme.txt file for installation instructions.
Description: Integrated Classified Ads app for Snitz Forums
Sniz Forum Version: intended for snitz forums 3.1 sr 4
Author: Alan Le aka Aznknight
Support: Please post questions and problems with this MOD in the Help: MOD Implementation Forum.
Features:
- snitz look and feel
- different categories with description.
- extended poster info..email, zip code, address, ads photo url, etc..
- only members can place ad
- ad expiration.
Changes in sr1:
renamed pages (ie classViewAds.asp => classifieds_view_ads.asp)
added recent ads feature to classifieds page.
added categories navigation to classifieds_view_ads page.
other layout changes.
uses classifieds_mod_dbsetup.asp
There's a bunch of features that didn't make it into this release:
sub-categories
more admin features (edit/delete ads) instead of just letting it expire
forum admin can set expiration length
email the poster
ad view count
classified ads in category on forum default page
others...
I'm releasing this mod by the requests of it's users. Also I think the mod_dbsetup and recent ads function are worth releasing it. I hope to add some of the requested features and some that I have in mind in the future.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Edited by - aznknight on 01 April 2001 01:21:26 |
|
|
Aznknight
Senior Member
USA
1373 Posts |
|
|
Mike108
Starting Member
United Kingdom
29 Posts |
Posted - 10 April 2001 : 10:58:06
|
I just installed the classifieds everything seems fime but when i go to place an add i get this error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forums/inc_functions.asp, line 642
any ideas???
thanks
Mike
|
 |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 10 April 2001 : 13:20:20
|
quote:
Hi Alan,
You might want to fix line 133 in classifieds_view_adsyou have it linking to the old admin page.
(classadmin.asp)
Guess I missed this one...fixed in zip now.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 10 April 2001 : 13:23:19
|
quote:
I just installed the classifieds everything seems fime but when i go to place an add i get this error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forums/inc_functions.asp, line 642
any ideas???
thanks
Mike
What's on line 642 of your inc_functions?
On my inc_functions, it's part of the ReadLastHereDate function which is not called in the classifieds_place_add.asp page.
also do you have a link to your site?
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
Mike108
Starting Member
United Kingdom
29 Posts |
Posted - 10 April 2001 : 13:30:02
|
Hi
yes the link i2 www.healthypages.net/forums/
but i have just realised that i am using version 3.1 and not 3.1 SR4
would this be the problem??
thanks
Mike
|
|
|
|
Mike108
Starting Member
United Kingdom
29 Posts |
Posted - 10 April 2001 : 16:46:27
|
the zip code when posting ad ad only allows 6 digits in the uk we can sometime have 8
|
|
|
|
Mike108
Starting Member
United Kingdom
29 Posts |
Posted - 10 April 2001 : 19:11:52
|
All done, i upgraded to SR4 and it works fine
Thanks for this it's excellent
Mike
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
|
|
sumo
Junior Member
USA
121 Posts |
Posted - 10 April 2001 : 23:17:22
|
Why am I getting this error whenever it tries to disply an ad?
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/forum/inc_functions.asp, line 1136
For some reason, if I add the line
if not rsAds.EOF then why=rsAds("added_by")
it can at least get the added_by variable from the query, but it is still missing other information from the query. Seems really goofy..
You can see it in action at: http://www.sumovw.com/forum/
Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/ |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 April 2001 : 01:19:40
|
quote:
Why am I getting this error whenever it tries to disply an ad?
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/forum/inc_functions.asp, line 1136
For some reason, if I add the line
if not rsAds.EOF then why=rsAds("added_by")
it can at least get the added_by variable from the query, but it is still missing other information from the query. Seems really goofy..
You can see it in action at: http://www.sumovw.com/forum/
Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/
Yeah something is wierd going on with classifieds at your forum. I can't reproduce it on mines but I can on yours.
What you can do is check to see if the add_by fields contain member ids and get to me on that.
Also you can try changing this in line 141 of classifieds_detail.asp for debug purposes.
<%=getMemberName(rs("Added_By"))%>
to just
<%= rs("Added_By")%>
and see what happens.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 11 April 2001 : 23:34:54
|
quote:
quote:
Why am I getting this error whenever it tries to disply an ad?
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/forum/inc_functions.asp, line 1136
For some reason, if I add the line
if not rsAds.EOF then why=rsAds("added_by")
it can at least get the added_by variable from the query, but it is still missing other information from the query. Seems really goofy..
You can see it in action at: http://www.sumovw.com/forum/
Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/
Yeah something is wierd going on with classifieds at your forum. I can't reproduce it on mines but I can on yours.
What you can do is check to see if the add_by fields contain member ids and get to me on that.
Also you can try changing this in line 141 of classifieds_detail.asp for debug purposes.
<%=getMemberName(rs("Added_By"))%>
to just
<%= rs("Added_By")%>
and see what happens.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Yes, I'm getting the same error, I'll be interested in your findings.
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 12 April 2001 : 02:54:12
|
quote:
Yes, I'm getting the same error, I'll be interested in your findings.
It would be very odd that you have same error as the error shouldn't be in inc_functions.asp now that that function is not called!? wierd. did you do the change and then upload? unless that function is called somewhere else, I have no idea on what your situation is.
Also can you post up the stuff that is around the line number of the error?
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 12 April 2001 : 09:36:22
|
OK - I'll see if I can clarify a little.
Here is there error text.
---------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/forum/inc_functions.asp, line 1135
-------------------------------------
Here is the syntax around line 1135 = <1135>, of inc_functions.asp
-------------------------------------
function getMemberName(fUser_Number)
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE MEMBER_ID = " & fUser_Number
<1135> set rsGetMemberID = my_Conn.Execute(strSql)
if rsGetMemberID.EOF or rsGetMemberID.BOF then
getMemberName = ""
else
getMemberName = rsGetMemberID("M_NAME")
end if
end function
-----------------------------------------
I have had trouble previously with EOF error, and have been playing with it for a while now. I thought I had a Database problem, so I recreated my SQL7 dbase, loaded the sr2 for classifieds, and it seemed to fix it, now this problem is showing.
I tried the change suggested earlier after I had loaded sr2 and noticed the problem, but same result.
If you want to have a look, http://www.cyberd.nq.nu/forum/classifieds.asp
Thanks for your time. I think the MOD is great and would really love it to be part of the site.
Thanks Again
Edited by - cyberd on 12 April 2001 09:43:05 |
|
|
|
sumo
Junior Member
USA
121 Posts |
Posted - 12 April 2001 : 12:45:33
|
quote:
It would be very odd that you have same error as the error shouldn't be in inc_functions.asp now that that function is not called!? wierd. did you do the change and then upload? unless that function is called somewhere else, I have no idea on what your situation is.
Also can you post up the stuff that is around the line number of the error?
The error isn't in inc_functions.asp, but because your code calls a function in there to get the full name of the user based on the userid, then it will fail there. In my forums, if I see what is in the recordset for the added_by field, right before it calls getMemberName, it is empty. If I set a temporary variable to the added_by field in the recordset right after it executes the SQL statement, added_by has the correct ID in it.
It is very weird. My forum is running on a Windows 2000 machine with SQL Server 2000 as the database. I wonder if there's something messed up with ASP from IIS5?
Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/ |
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 13 April 2001 : 05:43:05
|
My machine is also a Windows 2000, but running SQL 7.
The rsGetMemberID was also a problem before.
|
|
|
|
Topic |
|
Topic Locked
