1 Reply Latest reply on Aug 1, 2004 6:35 PM by Thomas Heute

    Is MySQL 4.0.1 supported?

    Val Brodsky Newbie

      Hi

      I have tried to deplyed both 1.1 RC2 and 1.0 on MySQL 4.0 and could not deploy the bb component. Moreover, test.ddl that for the component fails too.

      Do we support MySQL 4.0?


      ==== more info ====

      When a table is created as CREATE TABLE `phpbb_forums` ( `forum_id` smallint(5) unsigned NOT NULL auto_increment, `cat_id` mediumint(8) unsigned NULL default NULL, etc. `forum_status` tinyint(4) NOT NULL default '0', etc.);

      This insert will fail:
      insert into phpbb_forums set forum_id=1,cat_id=1,forum_name='test-1',forum_desc='test forum 1',forum_order=10,forum_last_post_id=4,forum_posts=4,forum_topics=2;

      with an error that column counts do not match.

        • 1. Re: Is MySQL 4.0.1 supported?
          Thomas Heute Master

          Short answer: Yes

          Forget about the test.ddl if it doesn't work, it's not useful.

          If you still have troubles deploying BB can you show me the exact error message and if you can do in mysql a
          DESCRIBE phpbb_forums;
          or whatever the table is, that could be helpful to make sure your table is as it should be.

          As far as i know there is no reason why MySQL 4.0.1 shouldn't work. (i am using the 4.0.20)