They worrying thing is the thats the same version I'm using. I just looked at the vB install file and it had the equivelant line broken into
[sql]
PRIMARY KEY (modid)
)
[/sql]

Try that and maby it'll work :)

I tried the following but I got the same error:
and I also tried it this way:
I tired both ways via vBulletin and also in phpMyAdmin.

[sql]
CREATE TABLE modslog (
modid int(10) auto_increment,
name varchar(250),
description varchar(250),
authur varchar(250),
version varchar(250),
date int(10),
PRIMARY KEY(modid)
)
[/sql]

maby a comma after date int(10) may help =-/

That did it. Database was created without any errors. Thank you for all your help and patience.

No problem, happy to help :P

What about the comment field? *smile*

I get this error when I try to add in the info of the hacks..

That error is due to a bad SQL query in the install text. In the SQL query, "author" is misspelled as "authur".

To fix this:

In AdminCP, go to Execute SQL Query under Import & Maintenance.

First execute this query to delete the incorrect table:

DROP TABLE IF EXISTS modslog;

Then execute this query to create a corrected table;

CREATE TABLE modslog (
modid int(10) auto_increment,
name varchar(250),
description varchar(250),
author varchar(250),
version varchar(250),
date int(10),
PRIMARY KEY(modid))

Also, the instructions tell you to place the phrases under Control Panel Global. This is partially incorrect.

Place modslog_actions and modslog_name under Control Panel Global.

Place modslog_moddeleted, modslog_modedited, and modslog_modadded under Control Panel Stop Message.

There is another spelling error in modslog.php, where "author" is again misspelled "author". If you don't correct this, the author's name will not get added when you enter a new modification to the log.