RE: 'Invalid schema object version' error

[Jesse Erlbaum]

Hi Jon --

> That last line looks like it could be the problem right there -- TYPE 
> and ENGINE mean the same thing. TYPE is being 
> deprecated/phased out. Try 
> using just ENGINE=NDBCLUSTER without using TYPE and see if 
> that doesn't 
> take of the error.


I just ran into this same problem:


mysql> SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id FROM
phpbb_categories c, phpbb_forums f WHERE f.cat_id = c.cat_id ORDER BY
c.cat_id, f.forum_order  ;
ERROR 1296 (HY000): Got error 241 'Invalid schema object version' from
ndbcluster


As you can see from the DDL which follows, I am not setting TYPE -- only
ENGINE:

----START---->
CREATE TABLE phpbb_categories (
  cat_id mediumint(8) unsigned NOT NULL auto_increment,
  cat_title varchar(100) default NULL,
  cat_order mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (cat_id),
  KEY cat_order (cat_order)
) ENGINE=ndbcluster;


CREATE TABLE phpbb_forums (
  forum_id smallint(5) unsigned NOT NULL default '0',
  cat_id mediumint(8) unsigned NOT NULL default '0',
  forum_name varchar(150) default NULL,
  forum_desc text,
  forum_status tinyint(4) NOT NULL default '0',
  forum_order mediumint(8) unsigned NOT NULL default '1',
  forum_posts mediumint(8) unsigned NOT NULL default '0',
  forum_topics mediumint(8) unsigned NOT NULL default '0',
  forum_last_post_id mediumint(8) unsigned NOT NULL default '0',
  prune_next int(11) default NULL,
  prune_enable tinyint(1) NOT NULL default '0',
  auth_view tinyint(2) NOT NULL default '0',
  auth_read tinyint(2) NOT NULL default '0',
  auth_post tinyint(2) NOT NULL default '0',
  auth_reply tinyint(2) NOT NULL default '0',
  auth_edit tinyint(2) NOT NULL default '0',
  auth_delete tinyint(2) NOT NULL default '0',
  auth_sticky tinyint(2) NOT NULL default '0',
  auth_announce tinyint(2) NOT NULL default '0',
  auth_vote tinyint(2) NOT NULL default '0',
  auth_pollcreate tinyint(2) NOT NULL default '0',
  auth_attachments tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (forum_id),
  KEY forums_order (forum_order),
  KEY cat_id (cat_id),
  KEY forum_last_post_id (forum_last_post_id)
) ENGINE=ndbcluster;
<----END----


Any ideas?


Thanks,

-Jesse-



--

  Jesse Erlbaum
  The Erlbaum Group
  jesse@stripped
  Phone: [phone]
  Fax: [phone]