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 #4186 is a reply to message #4185]

Wed, 17 July 2002 19:58

Ilia

Messages: 13241
Registered: January 2002

Karma:

Senior Member
Administrator
Core Developer

The problem is clearly lack of ALTER TABLE privelege to the user. It could be that while your setting permit you to run ALTER queries while connecting localy, the user may not have permissions to do so.
You can do a simple test via the following script:
*place the script inside the FORUM's main dir*

<?php
include_once "GLOBALS.php";
fud_use('err.inc');
fud_use('db.inc');

q("ALTER TABLE fud2_pmsg ADD INDEX(offset)");
?>

If you get a query failure then recheck your permissions, otherwise let me know and I'll try to replicate the problem

FUDforum Core Developer

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:13:29 GMT 2024

Total time taken to generate the page: 0.04430 seconds