FUDforum: FUDforum Installation Issues » ALTER Error Compacting Messages

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

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

ALTER Error Compacting Messages [message #4185]

Wed, 17 July 2002 19:52

Juanisan

Messages: 24
Registered: July 2002
Location: Conshohocken, PA

Karma:

Junior Member

I have FUD 2.0.2 installed for weeks now for a private UT clan forum and it works BEAUTIFULLY! Although on an AMD 386/40 Slackware box I had to boost up the PHP timeout for a process to run just for installation Very Happy

Everything works great. Except one day I wanted to, for kicks, try compacting the messages. This is what I got:

Disabling the forum for the duration of maintenance run

Please wait while forum is being compacted.
This may take a while depending on the size of your forum.
Compacting normal messages...
10% done
20% done
30% done
40% done
50% done
60% done
70% done
80% done
90% done
100% done
100% Done
Compacting private messages...

--------------------------------------
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/adm/compact.php
the error occured at: 17/07/2002 19:28:58 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/adm/compact.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/adm/compact.php
Server Version: 3.23.51

Now everything works ok - I just re-enable the forums and it works again. I made sure in MySQL that badmin has ALTER priveleges. I cant interpret this error any other way. Any suggestions?

TIA
Juanisan

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: Fri Nov 01 08:14:06 GMT 2024

Total time taken to generate the page: 0.03743 seconds