Editing group permissions
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=21243
Printed Date: 09 April 2026 at 4:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Editing group permissions
Posted By: semih1
Subject: Editing group permissions
Date Posted: 07 September 2006 at 12:07pm
|
when i'm trying to edit group permissions, i chencked the boxes than try to submit, i receive this error : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 3.51 Driver][mysqld-4.1.18-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 ' at line 1 /forum/admin_group_permissions.asp, line 141 what can i do to solve this problem ? |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 07 September 2006 at 12:22pm
|
It could be a corrupted file, so first try reuploading the files again
------------- 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: semih1
Date Posted: 07 September 2006 at 3:00pm
|
i tryied but i have taken the same error. i was using access db, i have converted to mysql, and the forum working normally but admin area gives errors. the other error is : when i tring to edit group details, Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 3.51 Driver][mysqld-4.1.18-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 ' at line 1 /forum/admin_group_details.asp, line 215 |
Posted By: WebWiz-Bruce
Date Posted: 07 September 2006 at 11:03pm
|
What version are you using?
------------- 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: semih1
Date Posted: 08 September 2006 at 5:34pm
| 8.0.4 |
Posted By: WebWiz-Bruce
Date Posted: 09 September 2006 at 8:57am
|
I've been scratching my head trying to workout why you would get this error then it suddenly occurred to me. I see that you have gone from Access to mySQL and I'm guessing because of the error that the Access database once used to be a version 7.x database. Because of this you have an old version 7 field in your database that is not compatible with mySQL, to fix the problem you need to open the table tblPermissions and remove the field called 'Read' from the table. Once you do this the forum will run fine. ------------- 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: semih1
Date Posted: 09 September 2006 at 11:48am
|
yes i was using 7.8 with access db. after i changed the database, i have controled the database and i saw the extra field called READ in tblpermissions. But i didn't delete it. I'll try it now... after i examined the mysql db (which i converted from access), i have found extra fields. I want to report it you: in tblconfiguration: upload_img_path upload_avatar_path in tblpoll: AuthorID in tblforum: there are many extra fields |
Posted By: semih1
Date Posted: 09 September 2006 at 11:59am
|
i have tried, i dropped the READ field, now forum working fine thanks... |
Posted By: WebWiz-Bruce
Date Posted: 11 September 2006 at 8:33am
These fields are meant to be there, they are new fields required for version 8 ------------- 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 |
semih1 wrote: