| Author |
 Topic  |
|
anotherwin95
Junior Member
USA
140 Posts |
 Posted - 17 December 2000 : 17:29:14
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Ok I fixed all the above errors, I HOPE! :O) I also added the how long they have been online. Thanks to huwr and richard for there help on that. I updated the zip file here....
http://www.freeaspcode.net/active_users.zip
Please let me know if you have any problems with this, or if you know a way to improve it.
Thanks
Brad
Brad
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I used the updated files and when I try to view messages I get this error - any ideas?
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression ''Viewing Message ' <a href="topic.asp?TOPIC_ID=27&FORUM_ID=57&CAT_ID=10&Topic_Title=New+category+suggestion&Forum_Title=Category+Suggestions">New category suggestion</a> '''.
/forum/inc_top.asp, line 190
Richard Hay
Webmaster
http://AnotherWin95.com
Edited by - anotherwin95 on 17 December 2000 17:31:29
Edited by - anotherwin95 on 17 December 2000 17:32:23
Edited by - anotherwin95 on 19 December 2000 17:36:26 |
 |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 17 December 2000 : 17:39:32
|
sorry about that, i updated the zip file. the problem you are having is in your inc_top.asp file when it is finding out what page you are on it adds a ' in the string. If you download the new zip file and update the inc_top code you should not get any errors.
Brad
Brad |
|
|
|
anotherwin95
Junior Member
USA
140 Posts |
Posted - 17 December 2000 : 18:10:26
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
sorry about that, i updated the zip file. the problem you are having is in your inc_top.asp file when it is finding out what page you are on it adds a ' in the string. If you download the new zip file and update the inc_top code you should not get any errors.
Brad
Brad
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
OK I used the updated code and here is a new error
-2147217833|The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
Also get this one:
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/forum/inc_top.asp, line 222
Any ideas? Appreciate your help :-) Also this does nto happen with every entry I try to read - just soem of them - not sure why that is.
Richard Hay
Webmaster
http://AnotherWin95.com
Edited by - anotherwin95 on 17 December 2000 18:15:43
Edited by - anotherwin95 on 19 December 2000 17:36:39 |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 17 December 2000 : 18:13:59
|
are you using access or sql? i know it has something to do with the length of the url that it is trying to put into the database, let me know so i can see what i need to do to fix this problem.
Brad |
|
|
|
anotherwin95
Junior Member
USA
140 Posts |
Posted - 17 December 2000 : 18:16:46
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
are you using access or sql? i know it has something to do with the length of the url that it is trying to put into the database, let me know so i can see what i need to do to fix this problem.
Brad
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I am using access - thanks again!
Richard Hay
Webmaster
http://AnotherWin95.com
Edited by - anotherwin95 on 19 December 2000 17:36:53 |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 17 December 2000 : 18:18:55
|
i will try and make a fix for this tommorow but for now, you will just need to make that field larger.
Brad |
|
|
|
anotherwin95
Junior Member
USA
140 Posts |
Posted - 17 December 2000 : 18:20:17
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
i will try and make a fix for this tommorow but for now, you will just need to make that field larger.
Brad
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
OK How do I do that and which field do you mean?
Rich Hay
Richard Hay
Webmaster
http://AnotherWin95.com
Edited by - anotherwin95 on 19 December 2000 17:37:07 |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 17 December 2000 : 18:36:36
|
you need to change the properties of the M_BROWSE table in your access database. if you change the desing, you should be able to put it at as a text field with the field size = 255, if that doesnt work just change it from a text field to a memo field
Brad |
|
|
|
anotherwin95
Junior Member
USA
140 Posts |
Posted - 17 December 2000 : 18:43:49
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
you need to change the properties of the M_BROWSE table in your access database. if you change the desing, you should be able to put it at as a text field with the field size = 255, if that doesnt work just change it from a text field to a memo field
Brad
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Brad,
Just looking at my database and do not have a M_BROWSE table. Is it another one or am I missing something?
Add on note: May have found it - changed it to memo and am uploading the database back up to see what happens.
Thanks again for the help!
Richard Hay
Webmaster
http://AnotherWin95.com
Edited by - anotherwin95 on 17 December 2000 18:46:51
Edited by - anotherwin95 on 19 December 2000 17:37:21 |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 17 December 2000 : 18:47:04
|
there should be a table call ONLINE something and in there it should be the M_BROWSE, if not there send me and email with your database attached and i will send it back to you with the correct stuff in it as soon as i can
Brad |
|
|
|
anotherwin95
Junior Member
USA
140 Posts |
Posted - 17 December 2000 : 18:50:50
|
I think I know what the problem is - if the subject has punctuation in it then it creates an error - if it does not then it works just fine - no more too small problems after changing the M_BROWSE to a memo field.
Specifically it looks liek if the subject has a " or ' in it it causes an error.
Any ideas about the punctuation thing?
Richard Hay
Webmaster
http://AnotherWin95.com
Edited by - anotherwin95 on 17 December 2000 18:53:32
Edited by - anotherwin95 on 19 December 2000 17:37:37 |
|
|
|
anotherwin95
Junior Member
USA
140 Posts |
Posted - 17 December 2000 : 19:09:55
|
OK - went trough and changed any subjects that had either " or ' in them and it works fine - guess there must be some whay to deal with that in the code but I am not the one to figure it out (as if you could not already tell that :-)
Thanks to Brad for the help thus far!
Richard Hay
Webmaster
http://AnotherWin95.com |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 17 December 2000 : 22:57:26
|
one way that i know you could get around that so you could have ' or " in the subjects, is search any string and replace ' with '' and " with "" then when you output them again switch them back. that is basically a work around for it though :O(
Brad |
|
|
|
anotherwin95
Junior Member
USA
140 Posts |
Posted - 17 December 2000 : 23:55:30
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
one way that i know you could get around that so you could have ' or " in the subjects, is search any string and replace ' with '' and " with "" then when you output them again switch them back. that is basically a work around for it though :O(
Brad
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I can also monitor the active posts and edit any out as I need to.
Also notice that it does not seem to be releasing and shows some guests connected for a long time!
Thanks for the help though!
Richard Hay
Webmaster
http://AnotherWin95.com
Edited by - anotherwin95 on 17 December 2000 23:57:21
Edited by - anotherwin95 on 19 December 2000 17:37:52 |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 18 December 2000 : 01:59:23
|
Ok I think I got the error fixed so you should be able to input all screen names and urls even if they have the ' or "" in them.
I also found another error where if you were the last one on the site, and you went back after you should of been loged out, it thought you were still loged in. FIXED THAT 2
Hopefully this is getting close to done with no errors. Please let me know of any problems and if you know of a fix, let me know that also.
Brad
oh yea the url
http://www.freeaspcode.net/active_users.zip
Edited by - redbrad0 on 18 December 2000 02:01:45 |
|
|
|
Topic |
|
Topic Locked
