FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Install help
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Install help [message #29433] Tue, 20 December 2005 16:31 Go to next message
Cliff is currently offline  Cliff   United States
Messages: 3
Registered: December 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I'm getting the following while running the install script:

FATAL ERROR: your MySQL account does not have permissions to run LOCK queries on existing MySQL tables
Enable this functionality and restart the script.

I used phpMyAdmin to create the database and user account, and granted all priviledges to the user. I don't see anything in the phpMyAdmin menus that deals with this.

Suggestions?

Thanks in advance,

Cliff

[Updated on: Tue, 20 December 2005 16:39]

Report message to a moderator

Re: Install help [message #29439 is a reply to message #29433] Wed, 21 December 2005 00:06 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
In MySQL there is a LOCK permission you can grant or revoke from the user. You need to make sure that this setting is enabled for the user/database you are using with the forum.

FUDforum Core Developer
Re: Install help [message #29456 is a reply to message #29439] Wed, 21 December 2005 13:32 Go to previous messageGo to next message
Cliff is currently offline  Cliff   United States
Messages: 3
Registered: December 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thank you.

I ran the MySQL update permissions script and that enabled this additional permissions choice in phpMyAdmin.

That did the trick and the forums are up and running.

Much appreciated!
Re: Install help [message #29840 is a reply to message #29456] Wed, 18 January 2006 12:37 Go to previous messageGo to next message
BayouBill is currently offline  BayouBill   United States
Messages: 3
Registered: January 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I am an experienced developer, but a newbie to FUDforum, MySQL, and phpMyAdmin. I'm trying a first-time install on a site hosted by GoDaddy using MySQL. I'm getting the same error. Could you provide details of how to grant the necessary privilege in MySQL using phpMyAdmin? What is the correct "GRANT" syntax once in phpMyAdmin, and/or where is the "script" you refer to? Thanks.
Re: Install help [message #29846 is a reply to message #29840] Wed, 18 January 2006 22:14 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Here are the docs
http://dev.mysql.com/doc/refman/5.0/en/grant.html


FUDforum Core Developer
Re: Install help [message #31085 is a reply to message #29846] Thu, 30 March 2006 17:36 Go to previous messageGo to next message
DanielMD is currently offline  DanielMD   Portugal
Messages: 5
Registered: March 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Specially since i am using a Godaddy host and don't have full control of the system.

What do i do if they don't allow me to change this? Can i change the code in FUDforum or is it a very intensive feature (used many times if not used would break the forum)?

[Updated on: Thu, 30 March 2006 18:22]

Report message to a moderator

Re: Install help [message #31099 is a reply to message #31085] Sat, 01 April 2006 13:03 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
The locking of table is a required function, used by the forum to ensure data consistency. You need to ask your server admin or database admin to grant your database account the LOCK privilege.

FUDforum Core Developer
Re: Install help [message #31106 is a reply to message #31099] Sat, 01 April 2006 13:57 Go to previous message
DanielMD is currently offline  DanielMD   Portugal
Messages: 5
Registered: March 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Godaddy does not do that. They claim security reasons

WARNING Do not use godaddy for hosting.

[Updated on: Sat, 01 April 2006 13:57]

Report message to a moderator

Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Godaddy MySQL problem
Next Topic: Mysql charset changer ( admin control panel)
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 26 02:56:35 EDT 2018

Total time taken to generate the page: 0.00754 seconds