I am getting this error:
Please help. Thanks. :)

any final release ?

I just had the most horrible time trying to install this hack, even though it probably should have been fairly easy. I'm using vBulletin v 1.1.3 B3 and followed the "first time installation" instructions which were included in the zip file.

I edited all of the files, then uploaded the makeprivtables.php file to my server. When I ran it, I got a database error, and the following message was sent to me:

I clicked 'refresh' and tried to run makeprivtables.php again. This time I got a new error:

I went ahead and uploaded the modified files, changed the PM settings in options.php, and tried to access my board. When I tried to load my forums, I got a parse error:

About an hour later, I gave up and restored my backup copies of the files which were edited. Everything appears to be working like before now, thankfully. I'm not sure if the problems were because of the Database errors, or maybe the instructions for modifying the code (I noticed that in the instructions for global.php it mentioned versions 1.1.2 and 1.1.1, but not 1.1.3).

I don't know a whole lot about MySQL, and vBulletin is the first PHP program I've used with my site. I have used plenty of Perl and CGI scripts before though, and have never really had a problem. Does anyone have an idea of what I might be doing wrong here, or what could be causing all of the problems? Any help is appreciated... thanks.

-Tom

Tom -

in makeprivtables.php uncomment this line:
//$DB_site->query("ALTER TABLE usergroup DROP canusepm"); (remove the //)

Then rerun it. If you get an error with it finding a duplicate column, uncomment the corresponding line. (look in the file - you'll see)

As for your parse error, then you messed up in editing the file.

This thing just doesn't want to work... I tried what you said, and still received an error:

I ran it again after that, and got a new error:

According to that error, it can't find 'canusepm' so it can drop it... so I commented out the command in makeprivtables.php that drops that table and tried again...

Just to clear up a few little things that could be causing this... lemme make sure I've done everything right here....

I uploaded makeprivtables.php to my /forums/ directory, and that's the ONLY file I have uploaded for this hack. In the php file it includes "global.php", which would mean it's including the global.php from the /forums/ directory and not the /forums/admin/ directory... is all of this correct? If so, I have NO clue why it's having so much trouble modifying the tables. It seems like it loses the MySQL connection ever time it's creating "canusepm", then runs into an error if I try again because it's trying to add a duplicate column... and this happens over and over. I hope somebody can help, I'd really like to get this hack working :( Thanks.

-Tom

[Edited by Tomeeboy on 09-16-2000 at 12:29 PM]

Being that that's the first ALTER command, I think your host isn't giving you full permissions. Talk to them about letting you have ALTER table permissions.

(Anyone else have any other ideas?)

No ALTER permission will clearly state "Access Denied" so it isn't that.

Man.. this is really bugging me now... hehe. I can usually figure out why stuff like this is happening, but this just doesn't make any sense at all. I have full permissions to everything, and I haven't had any other problems with MySQL or PHP on my server (except for the magic_quotes thing, but that was easy to fix). If anyone else has any more suggestions, keep 'em coming... I apprecitate the help.

-Tom

Okay... apparently, since I'm hosted by VServers, user authenticated access to the database via http is not possible... go figure... "virtual server" my rear.

Is there some way around this? perhaps through telnet or something? If not... can somebody recommend a good hosting company? lol.

-Tom

Another update!

Okay, I figured the ALTER command was the cause of the problem (thinking that I didn't have permission to use that command via HTTP), so I attempted to send the first few commands to MySQL while logged in through telnet. BAM! Same errors that I got while trying via HTTP. So I emailed tech support at VServers and asked what the deal was, and they responded saying that there are segmentation faults in the MySQL daemon! (the plot thickens...) So I guess that is what was causing the problem all along... not permissions. They're having a "senior programmer" work on it now... and hopefully it will get fixed sometime soon.

All of this trouble, just to add a hack to the message board. This private messaging thing better be damn good Ed! Hehehe.

Anyway.. just thought I'd let everyone know so you're not thinking up workarounds and stuff for me. I'll let everyone know how it turns out :)

-Tom