Web Wiz Support and Community Forums : MySql syntax? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 10:23:58 +0000 Wed, 31 Oct 2007 16:20:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24728 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MySql syntax? : The field type Read can not be...]]> https://forums.webwiz.net/mysql-syntax_topic24728_post128855.html#128855 Author: WebWiz-Bruce
Subject: 24728
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.]]> Wed, 31 Oct 2007 16:20:54 +0000 https://forums.webwiz.net/mysql-syntax_topic24728_post128855.html#128855 <![CDATA[MySql syntax? : I&#039;m pretty sure this is...]]> https://forums.webwiz.net/mysql-syntax_topic24728_post128853.html#128853 Author: stonecutter
Subject: 24728
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.51Driver][mysqld-5.0.45-community-nt]You have an error in your SQLsyntax; check the manual that corresponds to your MySQL server versionfor the right syntax to use near 'Read=0 AND Post=1 AND Reply_posts=1AND 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.




Edited by stonecutter - 01 November 2007 at 4:03am]]> Wed, 31 Oct 2007 15:21:34 +0000 https://forums.webwiz.net/mysql-syntax_topic24728_post128853.html#128853