Print Page | Close Window

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
 
Upload Images Attach Files
 
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
Originally posted by -boRg- -boRg- wrote:

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
 
It this v.8.03 and no modified admin_group_permissions.asp file
j


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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net