| Author |
 Topic  |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
 Posted - 04 March 2008 : 12:57:45
|
Hi I have added the PM mod and the pop up toaster addition, the PM mod works fine but when I have added the pop up toaster I get this error
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.22-log]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 '[pmcount] FROM FORUM_MEMBERS , FORUM_PM WHERE FORUM_MEMBERS.M_NAME = 'thelodge' at line 1
/inc_footer.asp, line 119
Line 119 in inc footer asp is
Set rsPM = my_Conn.Execute(strSql)
Can anyone help? |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 04 March 2008 : 13:06:03
|
What does the SQL that its trying to run look like?
right before line 119 add:
Response.Write(strSql)
Response.End
Copy the SQL statement, post it here, and then remove the two lines you just added in the step above. |
 |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 04 March 2008 : 13:25:45
|
lines 105 to 120
MessengerTitle = "Webforumz Messenger"
toastSpeed = 20 'how fast the toasts animate... a smaller number = faster
toastActive = 4 'number of seconds to show toast
if strDBType = "mysql" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSqL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS , " & strTablePrefix & "PM "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME = '" & strDBNTUserName & "'"
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "PM.M_TO "
strSql = strSql & " AND " & strTablePrefix & "PM.M_READ = 0 "
Set rsPM = my_Conn.Execute(strSql)
pmcount = rsPM("pmcount") |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 04 March 2008 : 13:33:28
|
| Oops I can see the problem now, thanks guys silly me was messing about last week with it and swapped the access to mysql, not sure why. |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 04 March 2008 : 16:04:16
|
| Unless pmcount is a reserved word, you shouldn't need the [] in access either... but I'd double check first. |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 11 March 2008 : 12:24:11
|
There appears to be a slight typo on the readme instructions that comes with the PM AddOn- MESSENGER STYLE TOAST NOTIFICATIONs, it prevents the mail.jpg image displaying in the top left hand corner of the pop-up toaster
Follow all the installation instructions which are very easy. After replacing all the lines as suggested, look for line 153
<img src="<%=strImageUrl%>/mail.jpg" border=0>
amend to remove the /
<img src="<%=strImageUrl%>mail.jpg" border=0>
Otherwise its all fairly straight forward
|
Edited by - Andy Humm on 11 March 2008 12:27:29 |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 11 April 2008 : 16:45:28
|
That line is exactly what I have and I do not get the synax error
This is the code Ihave for that line:
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "PM.M_ID, " & strTablePrefix & "PM.M_TO, " & strTablePrefix & "PM.M_SUBJECT, " & strTablePrefix & "PM.M_SENT, " & strTablePrefix & "PM.M_FROM, " & strTablePrefix & "PM.M_READ " |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 11 April 2008 : 16:52:03
|
Same here, my line is
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "PM.M_ID, " & strTablePrefix & "PM.M_TO, " & strTablePrefix & "PM.M_SUBJECT, " & strTablePrefix & "PM.M_SENT, " & strTablePrefix & "PM.M_FROM, " & strTablePrefix & "PM.M_READ "
and my toaster is working great |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
| |
Topic |
|
Topic Locked
