| Author |
 Topic  |
|
masterao
Senior Member
Sweden
1678 Posts |
 Posted - 01 November 2002 : 13:51:52
|
quote:
Originally posted by futre
hi masterao
i got the error on default page, there's no any special reason, and i just do nothing... :) open the page, that's all, anyway, as i said, the problem seems to be fixed, maybe number 1 is interpreted like a boolean and not as a string
Ok. As the fix works, I think we can drop it. 
Trickdad, there are two places from which you can download AU 4.0.17 now. You can find the download links here and here.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
 |
|
|
GM Prometheus
Starting Member
6 Posts |
Posted - 03 November 2002 : 00:04:16
|
Hello, I just installed snitz and started to add some of the mods and this was the first one that I tried.. I received the following error from MySQL side of the house... Any ideas?
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE varchar(1) NULL
Column added successfully
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
-2147467259 | SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'varchar(1) NULL' at line 1 |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 03 November 2002 : 08:18:55
|
Im not that well-versed with mysql as I would like to be, so Im unable to help you here. Hopefully someone else with greater knowledge about mysql than me can help you.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
GM Prometheus
Starting Member
6 Posts |
Posted - 03 November 2002 : 13:09:27
|
| I too hope someone can help me... I really like Snitz and want to get all the mods installed but I have been having a heck of a time... Seems almost everyone uses access as their DB's... |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 03 November 2002 : 18:56:19
|
Most are, but there are a lot who uses mysql too. Maybe you should post this in the mysql-forum instead, as the error you recieve seems to be with the core code and not the mod code.
Im sure that you can get a few pointers there, if not direct help.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 03 November 2002 : 22:05:38
|
| ummmm ... .it looks like MOD code to me - trying to run the dbs script I guess. But a post in the MySql area could be good. |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 07 November 2002 : 14:49:28
|
Great mod! I've got it working fine on my test forums but i've one very minor bug i'd like fixed.
I've added the bugfix for MSN/AOL/Yahoo but i've noticed it behaves slightly differently when you hover the mouse over the icons as to how it works on members.asp
On members.asp it shows (for instance, with ICQ) in the status bar the message "Send XXX an ICQ message" but on the status bar on active_users.asp it just shows the javascript code. How would I go about making active_users.asp behave in the same way as members.asp and show what is displayed in the alt code in the status bar? |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
Edited by - MarkJH on 07 November 2002 14:50:25 |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 07 November 2002 : 16:15:23
|
Another minor bug but with a fix.
When you select the active users panel to appear in a separate table, where it says "Board Statistics" on default.asp, it is using the Category font colour as opposed to the Header font colour. To fix this, make the following alteration to inc_activeusers.asp:
if strAUPIsland = "1" then
response.write " </table>" & VBNewLine & _
" </td>" & VBNewLine & _
" </tr>" & VBNewLine & _
" <tr>" & VBNewLine & _
" <td>" & VBNewLine & _
" <br />" & VBNewLine & _
" </td>" & VBNewLine & _
" </tr>" & VBNewLine & _
" <tr>" & VBNewLine & _
" <td bgcolor=""" & strTableBorderColor & """>" & vbNewline & _
" <table border=0 width=""100%"" cellspacing=1 cellpadding=4>" & VBNewLine & _
" <tr>" & VBNewLine & _
" <td bgcolor=""" & strHeadCellColor & """ colspan=""" & sGetColspan(7,6) & """ align=""center"">" & VBNewLine & _
" <font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """><b>" & fLang(strLangMOD_Ls3kAU_00001) & "</b></font>" & VBNewLine & _
" </td>" & VBNewLine & _
" </tr>" & VBNewLine
end if
 |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
|
Helena
Starting Member
Spain
21 Posts |
Posted - 30 November 2002 : 14:01:47
|
Hi ,
sorry if this question appeared before but i could'nt find what i'm looking for.
I've instaled active users 4.17 and everything work ok but a detail, i want to show users ip to moderators, but only can see ip's administrators.
Since 2 days ago, i was running active users 3.5 in snitz forums 3.03.3 and there moderators can view users ip's.
Yerterday I installed snitz forums 3.4.3 (not upgrade, a new installation, only upgrading DB) and this new version of active users. Now moderators can't see the ip's
any sugestions?
I've tried to find the solution by myself but i understand nothing 
Thanks and saludos |
Edited by - Helena on 30 November 2002 14:02:40 |
|
|
|
BamaHurricaneHunter
Starting Member
2 Posts |
Posted - 30 November 2002 : 16:07:39
|
I downloaded the active user mod from snitzbitz started installing it and I got this error:
selisoft Active Server Pages- Error 'ASP 0126 : 80004005'
Include file not found
audbsetup.asp, line 1421
The Include file 'C:\Program Files\Abyss Web Server\htdocs\inc_functions.asp' was not found
any ideas? |
|
|
|
NROforum
Starting Member
USA
6 Posts |
Posted - 30 November 2002 : 17:46:32
|
I'm using the serverhacker package of the latest Snitz.
For several minutes today, my active_users.asp page was displaying one of the tables blacked out with the errors:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_ID==2'.
/talk/active_users.asp, line 378
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_ID==8'.
/talk/active_users.asp, line 378
This occurred during a visit from
crawl12-public.alexa.com,
which looks like a robot crawler from Alexa.
Any idea how this messed up my page temporarily? |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 01 December 2002 : 02:27:28
|
quote:
Originally posted by Helena
Hi ,
sorry if this question appeared before but i could'nt find what i'm looking for.
I've instaled active users 4.17 and everything work ok but a detail, i want to show users ip to moderators, but only can see ip's administrators.
Since 2 days ago, i was running active users 3.5 in snitz forums 3.03.3 and there moderators can view users ip's.
Yerterday I installed snitz forums 3.4.3 (not upgrade, a new installation, only upgrading DB) and this new version of active users. Now moderators can't see the ip's
any sugestions?
I've tried to find the solution by myself but i understand nothing
Thanks and saludos
By default, only administrators can view ip addresses. If you want to allow moderators to view ip addresses, you need to modify admin_config_activeusers.asp.
Look for this from line 192 (clean file) in admin_config_activeusers.asp:
" <tr valign=""top"">" & VBNewLine & _
" <td bgColor=""" & strPopUpTableColor & """ align=""right""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b>" & fLang(strLangMOD_Ls3kAU_02290) & ":</b> </font></td>" & VBNewLine & _
" <td bgColor=""" & strPopUpTableColor & """>" & VBNewLine & _
" <font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & fLang(strLangMOD_Ls3kAU_02110) & ":</font> <input type=""radio"" class=""radio"" name=""strAUIP"" value=""1""" & checkRadio(strAUIP,"0",false) & ">" & VBNewLine & _
Change the red-marked 1 to a 2, and admins and moderators will be able to see ip addresses.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 01 December 2002 : 02:35:23
|
quote:
Originally posted by BamaHurricaneHunter
I downloaded the active user mod from snitzbitz started installing it and I got this error:
selisoft Active Server Pages- Error 'ASP 0126 : 80004005'
Include file not found
audbsetup.asp, line 1421
The Include file 'C:\Program Files\Abyss Web Server\htdocs\inc_functions.asp' was not found
any ideas?
IIRC, the mod at snitzbitz isn't the latest version (AU4.0.17), but download it from http://www.ls3k.com/snitz/no_snitzMods/Active%20Users%2040_17.zip and then apply the bugfixes reported in this topic.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 01 December 2002 : 02:38:53
|
quote:
Originally posted by NROforum
I'm using the serverhacker package of the latest Snitz.
For several minutes today, my active_users.asp page was displaying one of the tables blacked out with the errors:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_ID==2'.
/talk/active_users.asp, line 378
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_ID==8'.
/talk/active_users.asp, line 378
This occurred during a visit from
crawl12-public.alexa.com,
which looks like a robot crawler from Alexa.
Any idea how this messed up my page temporarily?
It sounds like the error mentioned in this topic. Apply the fix mentioned there.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
Topic |
|
Topic Locked
