[Mr Peabody]

Originally Posted by Pyrix

For some reason the product's install code drops the vbspell table as soon as it's created it, unless you have a table prefix!

$db->hide_errors();
// Create vB Spell Table
$db->query_write("CREATE TABLE IF NOT EXISTS vbspell (
  word varchar(30) NOT NULL,
  sound varchar(10) NOT NULL,
  UNIQUE KEY word (word),
  KEY sound (sound)
) TYPE=MyISAM");

// Remove Old vB Spell Table
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "vbspell");

I can only assume the coder was asleep when he wrote it

The product file needs to be editted and reattached here. The above code would work well if it was...

$db->hide_errors();

// Remove Old vB Spell Table
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "vbspell");

// Create vB Spell Table
$db->query_write("CREATE TABLE IF NOT EXISTS vbspell (
  word varchar(30) NOT NULL,
  sound varchar(10) NOT NULL,
  UNIQUE KEY word (word),
  KEY sound (sound)
) TYPE=MyISAM");

This way the table is cleared, but a new one is created! Previously it would create a new table, then delete it straight away so your dictionary words had nowhere to go?!?!?!?

Bizarre

Ollie

Cheers mate this worked great for me. I run 2 forums and for some reason it installed great on one the other it kept dropping the table like you said