Missing a table on clean install

[thonolan jones]

Help I just installed the latest release (2.0.2r7) and it seems to install fine, but as soon as anyone tries to save thier picks I get the following error.

select * from accounting_participants where participant_id='2' and week='4' and season='regular' and year='2008' and pool_type='pool'Table 'magicmike.accounting_participants' doesn't exist

I check the MYSQL database and sure enough the table was never created.

Can you tell me the structure so I can build it?

[John]

Here is the SQL output from the accounting participants table. The install worked just fine for me.

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

-- Table structure for table `accounting_participants`
--

CREATE TABLE IF NOT EXISTS `accounting_participants` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `participant_id` int(10) unsigned NOT NULL default '0',
  `week` int(10) unsigned NOT NULL default '0',
  `season` enum('pre','regular','post') NOT NULL default 'regular',
  `year` int(4) NOT NULL default '0',
  `credit` decimal(6,2) NOT NULL default '0.00',
  `debit` decimal(6,2) NOT NULL default '0.00',
  `status` enum('collected','pending','withdrawal','winnings paid') NOT NULL default 'pending',
  `pool_type` enum('pool','survivor') default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Participant Accounting' AUTO_INCREMENT=11 ;

[thonolan jones]

I found several tables that were not built. Then I opened the setup.pnp and examined the table create commands.

Thte tables that were created all had the
TYPE=MyISAM

where the tables that did not work all had the
ENGINE=MyISAM

After i changed all of the Engine  to Type the software installed correctly