Error during Install

[InterFX]

I'm getting this error during installation? Any ideas on how to fix??? Thanks for any URGENT advice out there...


Database error in vBulletin 3.6.7:

Invalid SQL:
CREATE TABLE ppgal_posts (
postid int(10) NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
userid int(10) NOT NULL default '0',
username varchar(50) NOT NULL default '',
dateline int(10) NOT NULL default '0',
pagetext text NOT NULL,
imageid int(10) NOT NULL default '0',
visible smallint(3) unsigned NOT NULL default '0',
allowsmilie smallint(3) NOT NULL default '0',
iconid smallint(3) unsigned NOT NULL default '0',
showsignature smallint(3) NOT NULL default '0',
ipaddress varchar(15) NOT NULL default '',
PRIMARY KEY (postid),
KEY imageid (imageid),
KEY userid (userid),
KEY iconid (iconid),
) TYPE=MyISAM;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 18
Error Number : 1064
Date : Sunday, June 10th 2007 @ 12:27:17 PM
Script : http://www.domain.com/forums/admincp...ry_install.php
Referrer : http://www.domain.com/forums/admincp...ry_install.php
IP Address : 24.x.x.x
Username :
Classname : vb_database

[InterFX]

I found one of the errors, (extra comma) - but now what to do?

MySQL Error : Table 'ppgal_categories' already exists
Error Number : 1050

How can I easily get this working?

[Zachariah]

Originally Posted by InterFX

I found one of the errors, (extra comma) - but now what to do?

MySQL Error : Table 'ppgal_categories' already exists
Error Number : 1050

How can I easily get this working?

Run the uninstaller to remove the database edits. Run reinstall again, and all should be good.

[InterFX]

That did it... Might want to update the build download, so others do not have this issue...

[clothahump]

Could you point me at the extra Comma please?