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.