| Author |
 Topic  |
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
|
gelliott
Junior Member
USA
268 Posts |
 Posted - 03 July 2005 : 21:33:40
|
NiteOwl - you are not meant to do anything - the line you quoted was from marcel's origional mod, and I was simply trying to note what it was I had changed. The next line is my line, which uses that string...
Marcel - Thanks for updating it to 2.0. It's not quite working on my site - if I get some time tomorrow I'll try to figure out what's giving it trouble, then upload the revised copy to SnitzBitz.< |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized.  |
 |
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 04 July 2005 : 01:09:43
|
Hi Gelliot, just to be clear, I run a private forum, if I use the rss.asp you provided, all I should be mofifying is the information in the rssinfo.asp file and the line in the rss.asp file that refers to my time zone and thats it?
< |
-=NiteOwl=-
|
|
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 04 July 2005 : 18:10:00
|
NiteOwl, Yes, that's it - the other two files are just functions.
Of course, you'll probably want to modify your inc_header.asp file as well to include the rssinfo.asp file in the user menu. However, before you do that, I suggest you create test logins with various levels of access and verify it hides what you want it too - you may have mods I didn't that change it's behavior... unlikely, but possible.< |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 04 July 2005 : 19:02:48
|
Thanks Gelliott, I will keep an eye out for your updated rss.asp file when you upload it to the snitsBIZ.
< |
-=NiteOwl=-
|
|
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 05 July 2005 : 13:12:40
|
Marcel, The error I was getting was that your file was missing a quote in front of the </webmaster> tag. After that, it seems to work fine. Thanks for updating me to RSS 2.0! I've updated the SnitzBitz file.
Everyone else - what do you think? do the private forum add-ons do what you wanted? Does the rssinfo.asp file make it more user friendly?< |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 05 July 2005 : 16:02:56
|
HI Gelliott - Ok, I have updated my site with your 1b code, I was unable to validate though as I was getting an error due to this string:
'xml = xml & "<author>" & Topic_Last_Post_Author & "</author>"
I REMmed out the line and now it seems to work ok. I have inspected Marcel's code and do not see the reference to author, was this something specific to your site, am I ok removing it?
< |
-=NiteOwl=-
|
Edited by - NiteOwl on 05 July 2005 16:08:01 |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 05 July 2005 : 18:28:24
|
Hi again Gelliot - as I mentioned before, I have two forums, one is without any private area, the other is only private. I have uploaded the rss version 1b (minus the "author line" and the validator says I am ok, yet nothing shows. Would somone mind having a go at this link?
http://www.monkoly.com/bcfmwu_dev_snitz/forumnew/rss.asp
I have a demo account setup demo / demo
< |
-=NiteOwl=-
|
Edited by - NiteOwl on 07 July 2005 22:35:10 |
|
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 05 July 2005 : 18:50:24
|
NiteOwl - yes, you can remark out that line - I was trying to provide more data in the absence of an abstract of the posting (since I removed it for security purposes).
I'll try to look at your other link tonight...< |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 05 July 2005 : 22:53:26
|
| NiteOwl, can you post a zip of all 4 of the files you have used, right off the server, and can you email me a admin-level account username and password? I can't tell from the link by itself what is going wrong. The code clearly reverts back to Macrel's original F.F_PRIVATEFORUMS = 0 in the absence of a successful match between userid and key, so in the case of a requested link without any querystring (like you provided above) it should return public forums only (just as you wanted). So I'm a little confused as to why it doesn't. Perhaps if I can see to verify everything is set right, I might find something...< |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 07 July 2005 : 00:27:07
|
Hi gelliott, I have all the items ready, I just need an email adress or the file attachments.
< |
-=NiteOwl=-
|
|
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 07 July 2005 : 21:03:05
|
NiteOwl, I misunderstood part of your question. Your rss.asp link above shows nothing because it is missing the member id and key to go with it. This is your private forum site, so rss.asp with nothing else will show nothing. This is proof that it is protecting your data. Go to the rssinfo.asp page when you are logged in, and THAT is the link you should click on. This is a custom link for each user.
Having said that, when I click on that custom link I get an error that leads me to believe MySQL is having trouble with the strSQL string we build after passing it to the TopSQL function I copied out of inc_func_common.asp. The error I'm getting is: quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.15-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND T.T_STATUS = 1 ORDER BY T_LAST_POST DESC LIMIT 10' at lin
/bcfmwu_dev_snitz/forumNEW/rss.asp, line 79
Thus, if you can insert a Response.Write strsql line at line 77 and post the results, we can troubleshoot why the SQL syntax we are using is incorrect. The function seems to work fine elsewhere, but since your manual modification of the SQL string before we used TopSQL had changed the "order by" clause, I'm wondering if TopSQL doesn't quite change everything necessary to make it MySQL compatible (or, more accurately, the assumptions about the formatting of the sql statement passed to TopSQL, as formulated by the original Snitz developers, are not being adhered to in our mod). In other words, Marcel and I may have deviated from the syntax normally followed by the primary Snitz developers when they wrote a sql statement they knew would pass through TopSQL.
Regardless, the solution is to post what is currently being generated, and let the MySQL experts weigh in as to what is amiss so we can program a fix for it.< |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 08 July 2005 : 00:09:00
|
OK all you MySQL experts - what's wrong with the following SQL string's syntax? It's generating the error you see two posts above this one... potentially around the last few keywords and/or the LIMIT keyword... quote:
SELECT T.T_REPLIES, T.T_SUBJECT, T.TOPIC_ID, T.T_LAST_POST, T.T_LAST_POST_AUTHOR, T.T_LAST_POST_REPLY_ID, T.T_MESSAGE FROM FORUM_TOPICS T,FORUM_FORUM F WHERE T.FORUM_ID = F.FORUM_ID AND F.FORUM_ID IN (1,3,4,5,6,8,9,10,11,12,14,15,17,19,32,40,47,49,57,58,60,61,62,63,) AND T.T_STATUS = 1 ORDER BY T_LAST_POST DESC LIMIT 10
< |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 08 July 2005 : 00:27:46
|
This link below seems to indicate the above string is correct. I'm not getting very far Googling for the error number...
http://dev.mysql.com/doc/mysql/en/select.html< |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
Topic |
|
RSS Feed (by forum & by cat)
