FUDforum: FUDforum Installation Issues » ALTER Error Compacting Messages

Home » FUDforum » FUDforum Installation Issues » ALTER Error Compacting Messages

Show: Today's Messages :: Polls :: Message Navigator

Re: ALTER Error Compacting Messages [message #4187 is a reply to message #4186]

Wed, 17 July 2002 20:36

Juanisan

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.

Report message to a moderator

[Message index]

		ALTER Error Compacting Messages By: Juanisan on Wed, 17 July 2002 19:52
		Re: ALTER Error Compacting Messages By: Ilia on Wed, 17 July 2002 19:58
		Re: ALTER Error Compacting Messages By: Juanisan on Wed, 17 July 2002 20:36
		Re: ALTER Error Compacting Messages By: Ilia on Wed, 17 July 2002 21:00
		Re: ALTER Error Compacting Messages By: Juanisan on Wed, 17 July 2002 22:48
		Re: ALTER Error Compacting Messages By: Ilia on Wed, 17 July 2002 22:57
		Re: ALTER Error Compacting Messages By: Juanisan on Tue, 23 July 2002 23:49

Previous Topic:	Install issue
Next Topic:	Where do I find my forum?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 02:56:04 GMT 2024

Total time taken to generate the page: 0.04831 seconds