Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Simple Slash Mod & MySql		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jezmeister
Senior Member

United Kingdom
1141 Posts
Posted - 20 October 2004 :  16:37:26  Show Profile  Visit Jezmeister's Homepage
I'm trying to install the simple slash mod (w/3.4.05, mysql) but i keep getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

[MySQL][ODBC 3.51 Driver][mysqld-4.0.20-standard]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 '4 MYJEZ2TEST_TOPICS.TOPIC_ID, MYJEZ2TEST_TOPICS.T_SUBJECT, MYJE 

/community/inc_simple_slash.asp, line 41


Line 41 is the line in red:
Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnString
Set objRS = objConn.Execute(strSQL)


Any ideas?
Cheers!

laser
Advanced Member

Australia
3859 Posts
Posted - 20 October 2004 :  17:13:59  Show Profile
Yes ... what is teha value of strSql ?
Go to Top of Page

Jezmeister
Senior Member

United Kingdom
1141 Posts
Posted - 20 October 2004 :  17:57:59  Show Profile  Visit Jezmeister's Homepage
this?
strSql = "SELECT TOP " & intTopicCount & " "
strSql = strSql & strTablePrefix & "TOPICS.TOPIC_ID, "
strSql = strSql & strTablePrefix & "TOPICS.T_SUBJECT, "
strSql = strSql & strTablePrefix & "TOPICS.T_MESSAGE, "
strSql = strSql & strTablePrefix & "TOPICS.T_DATE, "	
strSql = strSql & strTablePrefix & "TOPICS.T_AUTHOR, "
strSql = strSql & strTablePrefix & "MEMBERS.MEMBER_ID, "
strSql = strSql & strTablePrefix & "MEMBERS.M_NAME "
strSql = strSql & " FROM ((" & strTablePrefix & "FORUM " 
strSql = strSql & "INNER JOIN " & strTablePrefix & "TOPICS ON " 
strSql = strSql & strTablePrefix & "FORUM.FORUM_ID = " 
strSql = strSql & strTablePrefix & "TOPICS.FORUM_ID) " 
strSql = strSql & "INNER JOIN " & strTablePrefix & "MEMBERS ON "
strSql = strSql & strTablePrefix & "TOPICS.T_AUTHOR = " 
strSql = strSql & strTablePrefix & "MEMBERS.MEMBER_ID) "
If ForumID <> "ANY" Then strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.FORUM_ID = " & ForumID
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_DATE DESC "
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 20 October 2004 :  19:48:46  Show Profile
MySQL doesn't use the TOP command.

Change this line:
strSql = "SELECT TOP " & intTopicCount & " "
to this:
strSql = "SELECT "
And then change this line:
Set objRS = objConn.Execute(strSQL)
to this:
Set objRS = objConn.Execute(TopSQL(strSQL,intTopicCount))
I think you will have more of this same problem in the file. Just fix them the say way as the show up.
Support Snitz Forums
Go to Top of Page

Jezmeister
Senior Member

United Kingdom
1141 Posts
Posted - 20 October 2004 :  20:13:17  Show Profile  Visit Jezmeister's Homepage
That fixed it! Cheers!
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 20 October 2004 :  21:01:11  Show Profile  Visit Gremlin's Homepage
If your running the correct version of the slash mod it should already have code in there to cater for this.
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07