[Crichton47]

Trying to install this on our test boards. Uploaded everything to root and when I go to install I get the error below. I'm not a coder and don't know much about php but this appears to be a problem with our server(?) and not with this mod but I figured I check with the experts around here just to make sure. Using vb 3.8.1 Patch Level 1.

PHP Code:

Database error in vBulletin 3.8.1:

Invalid SQL:
CREATE TABLE IF NOT EXISTS as_armor (
  id int(10) NOT NULL auto_increment,
  name varchar(100) NOT NULL default '',
  power int(10) NOT NULL default '0',
  cost int(10) NOT NULL default '0',
  sellpenalty int(10) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9;

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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=9' at line 8
Error Number  : 1064
Request Date  : Saturday, April 4th 2009 @ 01:00:56 AM
Error Date    : Saturday, April 4th 2009 @ 01:00:56 AM
Script        : http://www.circvsmaximvs.com/forum/admincp/plugin.php?do=productimport
Referrer      : http://www.circvsmaximvs.com/forum/admincp/plugin.php?do=productadd
IP Address    : 75.58.112.196
Username      : The Great JC
Classname     : vB_Database
MySQL Version : 4.0.23a 


We have a bunch of other mods on the forums as well that have installed without a hitch.