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
 Events V2 SR1 Mysql Top Problem
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

wmcavoy
Starting Member

2 Posts

Posted - 19 June 2001 :  23:54:18  Show Profile
All,

I know the subject has been covered, but have spent the last hour and a half searching the site, trying to find it out.. anyways..

I am running MySQL on a Windows 2000 Advanced Server System, and have the forum up and running well. After installing the events code, and running the mod_dbsetup.asp file which creates the table, I try to run it. After which I receive the following error..

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[TCX][MyODBC]You have an error in your SQL syntax near '5 event_id, start_date, event_title, PRIVATE, M_NAME FROM FORUM_EVENTS Inner JOI' at line 1
/snitz/events_inc.asp, line 336

After reading several messages, it appears that MySQL doesnt like the TOP command.. Does anyone have a fix for this?

Thanks for anyone that can help..

Wayne

  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.87 seconds. Powered By: Snitz Forums 2000 Version 3.4.07