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

  New Posts New Posts RSS Feed - wwf and mysql
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

wwf and mysql
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
dr_who View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Location: Denmark
Status: Offline
Points: 26 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dr_who Quote  Post ReplyReply Direct Link To This Post Topic: wwf and mysql
    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 ???
 
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: 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
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
dr_who View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Location: Denmark
Status: Offline
Points: 26 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dr_who Quote  Post ReplyReply Direct Link To This Post 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


Edited by dr_who - 30 July 2006 at 7:51am
Back to Top
dr_who View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Location: Denmark
Status: Offline
Points: 26 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dr_who Quote  Post ReplyReply Direct Link To This Post 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.
 
Back to Top
dr_who View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Location: Denmark
Status: Offline
Points: 26 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dr_who Quote  Post ReplyReply Direct Link To This Post Posted: 30 July 2006 at 9:52am
No errors on my access database with v. 8.03
Back to Top
dr_who View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Location: Denmark
Status: Offline
Points: 26 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dr_who Quote  Post ReplyReply Direct Link To This Post 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
 
 
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: 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.


Edited by -boRg- - 31 July 2006 at 11:54am
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
dr_who View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Location: Denmark
Status: Offline
Points: 26 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dr_who Quote  Post ReplyReply Direct Link To This Post Posted: 31 July 2006 at 7:19pm
it did'n fix the problem
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.