wwf and mysql
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=20855
Printed Date: 11 April 2026 at 10:23am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: wwf and mysql
Posted By: dr_who
Subject: wwf and mysql
Date Posted: 29 July 2006 at 1:09pm
|
hi
Forum permissions trying to set in
can't
if i trying on Member group permissions
got this error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-4.1.20-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=1 AND Prio' at line 1 /admin_group_permissions.asp, line 141 is this only me ??? |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 29 July 2006 at 4:49pm
|
The field 'Read' which is coursing the error was removed somtime ago and chnaged to 'View_forum' for compatibility with mySQL. Please ensure you are running the latest 8.03 version and you don't have a modified admin_group_permissions.asp file ------------- 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 |
Posted By: dr_who
Date Posted: 29 July 2006 at 9:44pm
It this v.8.03 and no modified admin_group_permissions.asp file
j
|
-boRg- wrote:Posted By: dr_who
Date Posted: 30 July 2006 at 7:53am
|
it is a old database, i have from 7.xx
i have upgrade it to Access 8.03 to mysql 8.03.
|
Posted By: dr_who
Date Posted: 30 July 2006 at 9:52am
| No errors on my access database with v. 8.03 |
Posted By: dr_who
Date Posted: 30 July 2006 at 10:17am
|
in Tblpermissions in
Field Read and View_Forum can i delete Read
in the Read i got a lot 0
in the View_Forum i got a lot 0, -1 and some 1 |
Posted By: WebWiz-Bruce
Date Posted: 31 July 2006 at 11:53am
|
It looks like that is the problem, because you moved from 7.x Access to 8.x and then moved to mySQL the old 'Read' column has been left in the tblPermissions table in the database. If you drop the Read column from this table it should fix this problem that you are getting. ------------- 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 |
Posted By: dr_who
Date Posted: 31 July 2006 at 7:19pm
| it did'n fix the problem |
Posted By: WebWiz-Bruce
Date Posted: 31 July 2006 at 7:30pm
|
Please see the other topic that I have replied to you in as both are related.
------------- 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 |