| Author |
 Topic  |
|
spyordie007
Junior Member
USA
408 Posts |
 Posted - 17 April 2003 : 16:37:26
|
I know your probably tired of working on this project and ready to move onto something else, but I've got another problem that I'm hoping you can help me out with 
When I try to do a search for "All non-archived topics read by user (any user)" I get the follwing error:
quote:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[TCX][MyODBC]You have an error in your SQL syntax near '(FORUM_FORUM F RIGHT JOIN FORUM_TOPICS T ON F.FORUM_ID = T.FORUM_ID) ON C.CAT_ID' at line 1
/forum/who_read.asp, line 384
-Spy |
Power - The only narcotic controlled by the SEC, not the FDA.
Prosperity without pollution! The American Hydrogen Association - http://www.ahanw.org
Questions about Hydrogen? Post them on our forum - http://www.ahanw.org/forum |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
spyordie007
Junior Member
USA
408 Posts |
Posted - 17 April 2003 : 17:16:48
|
quote:
Originally posted by Nikkol
Okay, well I wrote it to work with Access and I don't know MySQL that well. Do you know if MySQL supports right joins?
I'm sorry I dont, however if it would help your development process I would be willing to host a test/development forum for you with a MySQL DB.
No offense intended Kat, but I like Nikkol's "who's read this mod" quite a bit better, it has a much more professional look and feel to it.
-Spy |
Power - The only narcotic controlled by the SEC, not the FDA.
Prosperity without pollution! The American Hydrogen Association - http://www.ahanw.org
Questions about Hydrogen? Post them on our forum - http://www.ahanw.org/forum |
Edited by - spyordie007 on 17 April 2003 17:17:26 |
|
|
|
altisdesign
Junior Member
United Kingdom
357 Posts |
Posted - 12 July 2003 : 09:49:59
|
Nikkol,
Do you have a copy of this mod somewhere else  cos I would be very interested in installing it, but I get a File Not Found when I try to download, so I guess it must have been deleted or moved.
-Altis |
Altis Design offers all manner of web design services to a variety of commercial and personal clients |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Kal Corp
Average Member
USA
878 Posts |
|
|
altisdesign
Junior Member
United Kingdom
357 Posts |
Posted - 13 July 2003 : 08:50:56
|
Thx Nikkol, That works fine now I'll be installing later today...
Kal, I just chose this mod cos it was the first one I saw in the MOD Add-On Forum (W/Code) forum. I'll try installing this mod, and if I get issues, then i'll look at the other one, i didn't know it existed
|
Altis Design offers all manner of web design services to a variety of commercial and personal clients |
|
|
|
altisdesign
Junior Member
United Kingdom
357 Posts |
Posted - 13 July 2003 : 12:10:27
|
| Nikkol, I just installed, all is working great Many Thx for an excellent mod! |
Altis Design offers all manner of web design services to a variety of commercial and personal clients |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
homeacademy
Junior Member
USA
163 Posts |
Posted - 14 July 2003 : 08:35:24
|
When testing this before implementation, on your test site, and at URL http://www.nikkol.net/forum/who_read.asp?method=bytopic&FORUM_ID=1&TOPIC_ID=1 I get this when trying to view the who_read.asp on a topic in the archives:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forum/who_read.asp, line 110
Thoughts? Since everything works on regular, locked topics in obviously has something to do with the topics being in the archive table? TIA |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
homeacademy
Junior Member
USA
163 Posts |
Posted - 14 July 2003 : 09:42:34
|
quote:
Originally posted by Nikkol
I thought I fixed the archive problem. Have you tested it on your own forum? I'll have to look into it later.
No, just on your test site. I'll implement later, and let you know how it works on my forum. |
|
|
|
Faizan
Average Member
United Kingdom
592 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
homeacademy
Junior Member
USA
163 Posts |
Posted - 16 July 2003 : 08:56:23
|
Thanx! I've implemented on my forum and it works great. Another great mod!  |
|
|
|
Topic |
|
Topic Locked
