Web Wiz Forums - MySql syntax?

Print Page | Close Window

MySql syntax?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24728
Printed Date: 06 April 2026 at 10:20am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MySql syntax?

Posted By: stonecutter
Subject: MySql syntax?
Date Posted: 31 October 2007 at 3:21pm

I'm pretty sure this is the last bug for me to work out after converting to the MySql version.
I'm having trouble setting custom permissions for users that i want to assign Mod privileges to specific forums without making them a full moderator. When submitting the change, I'm getting this error code:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]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 'Read=0 AND Post=1 AND Reply_posts=1 AND Edit_posts=1 AND Delete_posts=0 AND Prio' at line 1

/admin_user_permissions.asp, line 135

Follow up:

Thanks -boRg-! You were correct and it fixed the problem.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 31 October 2007 at 4:20pm

The field type Read can not be used in mySQL. This is a legacy field name form previous versions before mySQL was supported so can be safely deleted from the tblPermissions table.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting