I'm trying to install the Private Messaging hack. I run .php3 and have changed all extenstions of, and in the coding of all the files of the hack from .php to .php3

I edited all the coding and tried to install it on a test forum.

I know get an error when I attempt to run the makeprivtables.php3

The error is this:

Editing <i>usergroup</i> table ...
<!-- Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup ADD canusepm TINYINT (4) DEFAULT '1' not null
mysql error: Duplicate column name 'canusepm'
mysql error number: 1060
Date: Tuesday 29th of August 2000 01:33:54 AM
Script: /newforum/makeprivtables.php3
Referer:
-->//

Any idea what I've done wrong ?

Thanks in advance

Umm... looks like the script already found the column. Look in the templates page - are all the templates there?

If not, look in makeprivtables.php3 and uncomment the line(s) that deal with removing the canusepm column.

(Isn't that error usually "column XYZ already exists"? Hmm... different version?)

These are currently the only lines of code in the makeprivtables.php3 which are not working:

$DB_site->query("CREATE TABLE privatercvd (msgid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null AUTO_INCREMENT, toid SMALLINT (5) UNSIGNED DEFAULT '0' not null , fromid SMALLINT (5) UNSIGNED DEFAULT '0' not null , title VARCHAR (100) not null , text MEDIUMTEXT not null , datetime DATETIME not null , signature TINYINT (4) DEFAULT '0' not null , iconid SMALLINT (5) DEFAULT '0' not null , repliedto TINYINT (4) DEFAULT '0' not null, folder TINYINT (4) DEFAULT '0' not null , PRIMARY KEY (msgid))");
echo "&nbsp;&nbsp;&nbsp;<i><b>privatercvd</b></i> created...<BR>";
$DB_site->query("CREATE TABLE privatesent (msgid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null AUTO_INCREMENT, toid SMALLINT (5) UNSIGNED DEFAULT '0' not null , fromid SMALLINT (5) UNSIGNED DEFAULT '0' not null , title VARCHAR (100) not null , text MEDIUMTEXT not null , datetime DATETIME not null , signature TINYINT (4) DEFAULT '0' not null , iconid SMALLINT (5) DEFAULT '0' not null , PRIMARY KEY (msgid))");
echo "&nbsp;&nbsp;&nbsp;<I><B>privatesent</b></I> created...<br>";
$DB_site->query("CREATE TABLE pmstats (id MEDIUMINT (8) UNSIGNED DEFAULT '0' not null AUTO_INCREMENT, toid SMALLINT (5) UNSIGNED DEFAULT '0' not null , fromid SMALLINT (5) UNSIGNED DEFAULT '0' not null , datetime DATETIME not null, PRIMARY KEY (id))");
echo "&nbsp;&nbsp;&nbsp;<i><b>pmstats</b></i> created...<P>";

The alter tables worked, that's why I was getting the canusepm error when I tried to run it again. The templates worked fine when I blanked out the above lines so they didn't process.

I've checked my database and everything is perfect except for the added tables, any ideas ?

Thanks again.

Can you please help ?

..

If you can't help me, can you let me know :)