Author |
Topic |
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 10 August 2013 : 15:08:55
|
I occasionally get the following error displaying when viewing active users with the active users mod (http://www.snitzbitz.com/mods/details.asp?Version=All&mid=318)
quote: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]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 '==3' at line 1
/forum/active_users.asp, line 558
Line 558 is in red below:
case "forum.asp"
strQuery = fQuery
fForum_ID = analyzeQuery(strQuery, "FORUM_ID")
if fForum_ID = "" then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
strSql = "SELECT F_SUBJECT FROM " & strTablePrefix & "FORUM WHERE FORUM_ID=" & fForum_ID
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("F_SUBJECT")
rst.close
set rst = nothing
It is a MySql database
Anyone have any clues?
Many thanks |
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 10 August 2013 : 16:10:11
|
In "active_users.asp":
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 11 August 2013 : 04:16:55
|
Amazing Carefree, works perfectly, I don't know how you do it
Many thanks |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 11 August 2013 : 05:24:24
|
I just edit original files as fixes are found and then later compare them (because I forget so wonderfully well). |
|
|
pierretopping
Junior Member
United Kingdom
224 Posts |
Posted - 14 August 2013 : 05:54:20
|
Hi Carefree,
Wonder if you can put some light on a similar error I sometimes get when running on MS-SQL with Active_Users
Microsoft SQL Server Native Client 10.0 error '80040e14' Incorrect syntax near '='. /forum/active_users.asp, line 457
Only get it sometimes, and its bugging the hell out of me :o) |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 14 August 2013 : 17:00:22
|
Try the same fix, it sounds like it's the same problem, just from another location. I know that issue cropped up in several places in the file: lines 378, 413, 457, 558, etc. |
|
|
pierretopping
Junior Member
United Kingdom
224 Posts |
Posted - 15 August 2013 : 17:37:23
|
Will do, thanks :-) |
|
|
pierretopping
Junior Member
United Kingdom
224 Posts |
Posted - 13 January 2014 : 04:56:57
|
Hi Carefree/All
Sorry, I'm still a bit confused with this, not sure what I'm looking at.
A text version of my active_users can be seen on this link:
http://www.tredegar.co.uk/misc/active_users.txt
Any guidance will be great thanks
Pierre
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 14 January 2014 : 00:37:51
|
The change was made correctly, are you still experiencing the random errors? |
|
|
pierretopping
Junior Member
United Kingdom
224 Posts |
Posted - 14 January 2014 : 07:48:26
|
Hi Carfree,
Yes, about 20%-30% of the time it stops with that error, all very strange. It always seams to to somebody who is an "Active Guest" as well.
Its got me stumped, don't mind telling you
Pierre |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 14 January 2014 : 20:55:54
|
Well, let's replace the whole topic.asp section (lines 445-477) and see what happens. Save your original file.
|
Edited by - Carefree on 16 January 2014 08:13:28 |
|
|
pierretopping
Junior Member
United Kingdom
224 Posts |
Posted - 15 January 2014 : 16:48:54
|
Thanks carefree , will give it a try :-) |
|
|
pierretopping
Junior Member
United Kingdom
224 Posts |
Posted - 16 January 2014 : 05:25:05
|
You fixed it :o)
Thanks so much :o) |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 16 January 2014 : 08:09:02
|
You're welcome. |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 06 March 2014 : 23:35:09
|
FYI, I found what seems (so far, anyway) like a good replacement site for checking IP addresses (and domain names too for that matter)
I replaced the code for IP checks (two places) with this:
response.write " <td bgcolor=""" & CColor & """ align=center valign=middle><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strDefaultFontColor & """><a href=""http://www.plotip.com/ip/" & ChkString(rsAM("AU_IP"), "display") & """ target=""_blank"">" & ChkString(rsAM("AU_IP"), "display") & "</a></font></td>" & "</font></td>" & VBNewLine
www.plotip.com
You may like it. I do. Fastest YET in all these years |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 07 March 2014 : 00:25:35
|
quote: Originally posted by golfmann
FYI, I found what seems (so far, anyway) like a good replacement site for checking IP addresses (and domain names too for that matter)
I replaced the code for IP checks (two places) with this:
www.plotip.com
You may like it. I do. Fastest YET in all these years
The problem is that it's inaccurate. It put me in Australia - while I am in Oceania, the Philippines is a good distance from Aussie country. |
Edited by - Carefree on 09 October 2014 08:50:04 |
|
|
Topic |
|