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

Home » FUDforum » FUDforum Installation Issues » ALTER Error Compacting Messages
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: ALTER Error Compacting Messages [message #4187 is a reply to message #4186] Wed, 17 July 2002 20:36 Go to previous messageGo to previous message
Juanisan is currently offline  Juanisan   United States
Messages: 24
Registered: July 2002
Location: Conshohocken, PA
Karma:
Junior Member
I ran the test....
Called it test.php. This is what I got:

test.php output


--------------------------------------
Error in function/script: db.inc
has caused the following error: query failed: %( ALTER TABLE fud2_pmsg ADD INDEX(offset) )% because %( Access denied for user: 'badmin@localhost' to database 'barforum' )%
while processing script name: /var/www/htdocs-bar/chat/test.php
the error occured at: 17/07/2002 20:37:12 GMT
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.1a) Gecko/20020610
User Ip: 10.10.9.1
Script Accessed: /var/www/htdocs-bar/chat/test.php

Query Failed: ALTER TABLE fud2_pmsg ADD INDEX(offset)
Reason: Access denied for user: 'badmin@localhost' to database 'barforum'
From: /var/www/htdocs-bar/chat/test.php
Server Version: 3.23.51



Mysql Privileges


root@juanisan:~# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7772 to server version: 3.23.51

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select Host,User,Alter_Priv from user;
+-----------+--------+------------+
| Host      | User   | Alter_Priv |
+-----------+--------+------------+
| localhost | root   | Y          |
| juanisan  | root   | Y          |
| localhost |        | N          |
| juanisan  |        | N          |
| %         | badmin | Y          |
| localhost | badmin | Y          |
+-----------+--------+------------+
6 rows in set (0.00 sec)

mysql>



Never ask a geek why, just nod your head and slowly back away.
[Message index]
 
Read Message icon5.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Install issue
Next Topic: Where do I find my forum?
Goto Forum:
  

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

Current Time: Fri Nov 01 08:12:17 GMT 2024

Total time taken to generate the page: 0.03690 seconds