Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Editing group permissions
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Editing group permissions
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
semih1 View Drop Down
Newbie
Newbie


Joined: 10 August 2006
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote semih1 Quote  Post ReplyReply Direct Link To This Post Topic: Editing group permissions
    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 ?

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 07 September 2006 at 12:22pm
It could be a corrupted file, so first try reuploading the files again
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
semih1 View Drop Down
Newbie
Newbie


Joined: 10 August 2006
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote semih1 Quote  Post ReplyReply Direct Link To This Post 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


Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 07 September 2006 at 11:03pm
What version are you using?
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
semih1 View Drop Down
Newbie
Newbie


Joined: 10 August 2006
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote semih1 Quote  Post ReplyReply Direct Link To This Post Posted: 08 September 2006 at 5:34pm
8.0.4
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
semih1 View Drop Down
Newbie
Newbie


Joined: 10 August 2006
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote semih1 Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
semih1 View Drop Down
Newbie
Newbie


Joined: 10 August 2006
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote semih1 Quote  Post ReplyReply Direct Link To This Post Posted: 09 September 2006 at 11:59am
i have tried, i dropped the READ field, now forum working fine

thanks...
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.